biuan SAP® BUSINESS ONE SDK
DTW DNF Code
API DNF Code Setup Service / DNF Code Setup
ODNF - DNF Code Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
NCMEntry KEY UNIQUENCM CodeInt
11ONCM
NCM Code
NCM_DNFYes
DNFCodeDNF CodenVarChar
5
DNFUoMDNF UoMnVarChar
10
DNFFactorDNF FactorNum
20
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT ODNF.AbsEntry AS 'Internal Key', ODNF.NCMEntry AS 'NCM Code', ODNF.DNFCode AS 'DNF Code', ODNF.DNFUoM AS 'DNF UoM', ODNF.DNFFactor AS 'DNF Factor', ODNF.LogInstanc AS 'Log Instance', ODNF.UserSign2 AS 'Updating User', ODNF.UpdateDate AS 'Update Date' FROM ODNF AS ODNF

Related information


DNF Code Setup DNFCodeSetup Object· Table: ODNF
Represents a DNF code that can be assigned to an item. Source table: ODNF Mandatory properties: DNFCode, NCMCode
   Parent: DNF Code Setup Service DNFCodeSetupService Service· Table: ODNF

DNF Code Setup Service DNFCodeSetupService Service· Table: ODNF
The DNFCodeSetupService service enables you to add, look up and remove DNF codes in the DNF codes master data table. NCM codes are assigned to items, and then DNF codes can be assigned to that NCM code for that item. To see the list of DNF...

ODNF SQL Table

NCM Code ONCM SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates