D

296 Fields

D is an SAP database table in S/4HANA. It contains 296 fields.

Fields (296)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY ausbk ausbk 3
KEY belnr belnr 3
KEY bukrs bukrs 3
KEY bwart Valuationtype 1
KEY bzkey bzkey 3
KEY CABPItemNumber CABPItemNumber 1
KEY CADocument CADocument 1
KEY CAItemIsDoubtful CAItemIsDoubtful 1
KEY CAItemIsOffsetting CAItemIsOffsetting 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY dc_name data_controller 1
KEY fieldname fieldname 1
KEY FiscalYear FiscalYear 1
KEY gjahr gjahr 3
adisc adisc 3
aedat aedat 3
anbwa anbwa 3
anln1 anln1 3
anln2 anln2 3
arcid arcid 3
aufnr aufnr 3
aufpl aufpl 3
awkey awkey 3
aworg_rev aworg_rev 3
awref_rev awref_rev 3
awsys awsys 3
awtyp awtyp 3
BankGroupBP BankGroupBP 1
BankGroupName BankGroupName 1
basw2 basw2 3
basw3 basw3 3
belnr_sender belnr_sender 3
bktxt bktxt 3
blart blart 3
bldat bldat 3
blnpz blnpz 3
brnch brnch 3
bschl bschl 3
bstat bstat 3
btype btype 3
budat budat 3
bukrs_sender bukrs_sender 3
bupla bupla 3
buzei buzei 3
bvorg bvorg 3
bvtyp bvtyp 3
bwkey bwkey 3
bwtar bwtar 3
cash_alloc cash_alloc 3
cc_ktext cc_ktext 3
cc_ltext cc_ltext 3
co_alebn co_alebn 3
co_belnr_sender co_belnr_sender 3
co_refbt co_refbt 3
co_valdt co_valdt 3
co_vrgng co_vrgng 3
CommodityName CommodityName 1
counter counter 3
cpudt cpudt 3
cputm cputm 3
ctxkrs ctxkrs 3
currkey_0d currkey_0d 3
currkey_10 currkey_10 3
currkey_11 currkey_11 3
currkey_12 currkey_12 3
currkey_30 currkey_30 3
currkey_31 currkey_31 3
currkey_32 currkey_32 3
currkey_40 currkey_40 3
currkey_50 currkey_50 3
currkey_60 currkey_60 3
currval_0d currval_0d 3
currval_10 currval_10 3
currval_11 currval_11 3
currval_12 currval_12 3
currval_30 currval_30 3
currval_31 currval_31 3
currval_32 currval_32 3
currval_40 currval_40 3
currval_50 currval_50 3
currval_60 currval_60 3
curt2 curt2 3
curt3 curt3 3
dabrz dabrz 3
datatype datatype 1
dbblg dbblg 3
ddtext ddtext 1
diekz diekz 3
doccat doccat 3
dokid dokid 3
dtpaName dtpaName 1
duefl duefl 3
ebeln ebeln 3
ebelp ebelp 3
egrup egrup 3
empfb empfb 3
esrnr esrnr 3
esrpz esrpz 3
esrre esrre 3
etype etype 3
fdgrp fdgrp 3
fdlev fdlev 3
fdtag fdtag 3
fikrs fikrs 3
filkd filkd 3
fipos fipos 3
fiscper fiscper 3
fistl fistl 3
fkber fkber 3
follow_on follow_on 3
frath frath 3
ga_txt20 ga_txt20 3
ga_txt50 ga_txt50 3
geber geber 3
gjahr_sender gjahr_sender 3
glbtgrp glbtgrp 3
glvor glvor 3
grant_nbr grant_nbr 3
grpid grpid 3
gsber gsber 3
hbkid hbkid 3
hkont hkont 3
hrkft hrkft 3
hwae2 hwae2 3
hwae3 hwae3 3
hwaer hwaer 3
hwmet hwmet 3
hzuon hzuon 3
iblar iblar 3
idxsp idxsp 3
imkey imkey 3
intsubid intsubid 3
kblnr kblnr 3
kblpos kblpos 3
koart koart 3
kokrs kokrs 3
kokrs_sender kokrs_sender 3
kostl kostl 3
kstrg kstrg 3
ktopl ktopl 3
kunnr kunnr 3
kur2x kur2x 3
kur3x kur3x 3
kurs2 kurs2 3
kurs3 kurs3 3
kursf kursf 3
kursr kursr 3
kurst kurst 3
kursx kursx 3
kuty2 kuty2 3
kuty3 kuty3 3
kzkrs kzkrs 3
kzwrs kzwrs 3
landl landl 3
ldgrp ldgrp 3
leng leng 1
lifnr lifnr 3
logsystem_sender logsystem_sender 3
lotkz lotkz 3
lzbkz lzbkz 3
maber maber 3
madat madat 3
maint_type maint_type 1
mansp mansp 3
manst manst 3
matnr matnr 3
max_instances max_instances 1
method Method 1
mm_maktx mm_maktx 3
monat monat 3
mschl mschl 3
mwart mwart 3
mwskz mwskz 3
name1 rcomp_unitName 1
netdt netdt 3
nplnr nplnr 3
numpg numpg 3
object_type_id ranking_factor_obj_type 1
or_ktext or_ktext 3
pargb pargb 3
peinh peinh 3
pernr pernr 3
ppdat ppdat 3
ppnam ppnam 3
pprct pprct 3
pptcod pptcod 3
pptme pptme 3
prctr prctr 3
projk projk 3
propmano propmano 3
ps_provider ps_provider 1
pyamt pyamt 3
pycur pycur 3
quantity quantity 3
quanunit quanunit 3
rcomp rcomp 1
rdim ranking_factor 1
rdim_guid ranking_factor_id 1
rebzg rebzg 3
rebzj rebzj 3
rebzt rebzt 3
rebzz rebzz 3
recid recid 3
reindat reindat 3
reprocessing_status_code reprocessing_status_code 3
resubmission resubmission 3
rf_fkbtx rf_fkbtx 3
rldnr rldnr 3
rp_ktext rp_ktext 3
rp_ltext rp_ltext 3
rstgr rstgr 3
sgtxt sgtxt 3
shkzg shkzg 3
skfbt skfbt 3
sknto sknto 3
sp_ktext sp_ktext 3
sp_ltext sp_ltext 3
srcObj srcObj 1
srcTlogo srcTlogo 1
stblg stblg 3
stceg stceg 3
stgrd stgrd 3
stjah stjah 3
stodt stodt 3
subset subset 3
tbtkz tbtkz 3
tcode tcode 3
tgtObj tgtObj 1
tgtTlogo tgtTlogo 1
txkrs txkrs 3
umrd2 umrd2 3
umrd3 umrd3 3
umsks umsks 3
umskz umskz 3
upddt upddt 3
UserID UserID 5
usnam usnam 3
uzawe uzawe 3
valut valut 3
vatdate vatdate 3
vbewa vbewa 3
vbund vbund 3
vertn vertn 3
vertt vertt 3
vname vname 3
vprsv vprsv 3
vptnr vptnr 3
vrsdt vrsdt 3
vrskz vrskz 3
werks werks 3
wwert wwert 3
xblnr xblnr 3
xblnr_alt xblnr_alt 3
xcpdd xcpdd 3
xegdr xegdr 3
xhkom xhkom 3
xinve xinve 3
xmca xmca 3
xmwst xmwst 3
xnegp xnegp 3
xnetb xnetb 3
xref1 xref1 3
xref1_hd xref1_hd 3
xref2 xref2 3
xref2_hd xref2_hd 3
xref3 xref3 3
xreorg xreorg 3
xreversal xreversal 3
xreversed xreversed 3
xreversing xreversing 3
xrueb xrueb 3
xskrl xskrl 3
xsnet xsnet 3
xsplit xsplit 3
xstov xstov 3
xumsw xumsw 3
xusvr xusvr 3
xwvof xwvof 3
zbd1p zbd1p 3
zbd1t zbd1t 3
zbd2p zbd2p 3
zbd2t zbd2t 3
zbd3t zbd3t 3
zbfix zbfix 3
zekkn zekkn 3
zfbdt zfbdt 3
zinkz zinkz 3
zlsch zlsch 3
zlspr zlspr 3
zolld zolld 3
zollt zollt 3
zterm zterm 3
zuonr zuonr 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE D (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    AUSBK,
    BELNR,
    BUKRS,
    BWART,
    BZKEY,
    CABPITEMNUMBER,
    CADOCUMENT,
    CAITEMISDOUBTFUL,
    CAITEMISOFFSETTING,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    DC_NAME,
    FIELDNAME,
    FISCALYEAR,
    GJAHR,
    ADISC,
    AEDAT,
    ANBWA,
    ANLN1,
    ANLN2,
    ARCID,
    AUFNR,
    AUFPL,
    AWKEY,
    AWORG_REV,
    AWREF_REV,
    AWSYS,
    AWTYP,
    BANKGROUPBP,
    BANKGROUPNAME,
    BASW2,
    BASW3,
    BELNR_SENDER,
    BKTXT,
    BLART,
    BLDAT,
    BLNPZ,
    BRNCH,
    BSCHL,
    BSTAT,
    BTYPE,
    BUDAT,
    BUKRS_SENDER,
    BUPLA,
    BUZEI,
    BVORG,
    BVTYP,
    BWKEY,
    BWTAR,
    CASH_ALLOC,
    CC_KTEXT,
    CC_LTEXT,
    CO_ALEBN,
    CO_BELNR_SENDER,
    CO_REFBT,
    CO_VALDT,
    CO_VRGNG,
    COMMODITYNAME,
    COUNTER,
    CPUDT,
    CPUTM,
    CTXKRS,
    CURRKEY_0D,
    CURRKEY_10,
    CURRKEY_11,
    CURRKEY_12,
    CURRKEY_30,
    CURRKEY_31,
    CURRKEY_32,
    CURRKEY_40,
    CURRKEY_50,
    CURRKEY_60,
    CURRVAL_0D,
    CURRVAL_10,
    CURRVAL_11,
    CURRVAL_12,
    CURRVAL_30,
    CURRVAL_31,
    CURRVAL_32,
    CURRVAL_40,
    CURRVAL_50,
    CURRVAL_60,
    CURT2,
    CURT3,
    DABRZ,
    DATATYPE,
    DBBLG,
    DDTEXT,
    DIEKZ,
    DOCCAT,
    DOKID,
    DTPANAME,
    DUEFL,
    EBELN,
    EBELP,
    EGRUP,
    EMPFB,
    ESRNR,
    ESRPZ,
    ESRRE,
    ETYPE,
    FDGRP,
    FDLEV,
    FDTAG,
    FIKRS,
    FILKD,
    FIPOS,
    FISCPER,
    FISTL,
    FKBER,
    FOLLOW_ON,
    FRATH,
    GA_TXT20,
    GA_TXT50,
    GEBER,
    GJAHR_SENDER,
    GLBTGRP,
    GLVOR,
    GRANT_NBR,
    GRPID,
    GSBER,
    HBKID,
    HKONT,
    HRKFT,
    HWAE2,
    HWAE3,
    HWAER,
    HWMET,
    HZUON,
    IBLAR,
    IDXSP,
    IMKEY,
    INTSUBID,
    KBLNR,
    KBLPOS,
    KOART,
    KOKRS,
    KOKRS_SENDER,
    KOSTL,
    KSTRG,
    KTOPL,
    KUNNR,
    KUR2X,
    KUR3X,
    KURS2,
    KURS3,
    KURSF,
    KURSR,
    KURST,
    KURSX,
    KUTY2,
    KUTY3,
    KZKRS,
    KZWRS,
    LANDL,
    LDGRP,
    LENG,
    LIFNR,
    LOGSYSTEM_SENDER,
    LOTKZ,
    LZBKZ,
    MABER,
    MADAT,
    MAINT_TYPE,
    MANSP,
    MANST,
    MATNR,
    MAX_INSTANCES,
    METHOD,
    MM_MAKTX,
    MONAT,
    MSCHL,
    MWART,
    MWSKZ,
    NAME1,
    NETDT,
    NPLNR,
    NUMPG,
    OBJECT_TYPE_ID,
    OR_KTEXT,
    PARGB,
    PEINH,
    PERNR,
    PPDAT,
    PPNAM,
    PPRCT,
    PPTCOD,
    PPTME,
    PRCTR,
    PROJK,
    PROPMANO,
    PS_PROVIDER,
    PYAMT,
    PYCUR,
    QUANTITY,
    QUANUNIT,
    RCOMP,
    RDIM,
    RDIM_GUID,
    REBZG,
    REBZJ,
    REBZT,
    REBZZ,
    RECID,
    REINDAT,
    REPROCESSING_STATUS_CODE,
    RESUBMISSION,
    RF_FKBTX,
    RLDNR,
    RP_KTEXT,
    RP_LTEXT,
    RSTGR,
    SGTXT,
    SHKZG,
    SKFBT,
    SKNTO,
    SP_KTEXT,
    SP_LTEXT,
    SRCOBJ,
    SRCTLOGO,
    STBLG,
    STCEG,
    STGRD,
    STJAH,
    STODT,
    SUBSET,
    TBTKZ,
    TCODE,
    TGTOBJ,
    TGTTLOGO,
    TXKRS,
    UMRD2,
    UMRD3,
    UMSKS,
    UMSKZ,
    UPDDT,
    USERID,
    USNAM,
    UZAWE,
    VALUT,
    VATDATE,
    VBEWA,
    VBUND,
    VERTN,
    VERTT,
    VNAME,
    VPRSV,
    VPTNR,
    VRSDT,
    VRSKZ,
    WERKS,
    WWERT,
    XBLNR,
    XBLNR_ALT,
    XCPDD,
    XEGDR,
    XHKOM,
    XINVE,
    XMCA,
    XMWST,
    XNEGP,
    XNETB,
    XREF1,
    XREF1_HD,
    XREF2,
    XREF2_HD,
    XREF3,
    XREORG,
    XREVERSAL,
    XREVERSED,
    XREVERSING,
    XRUEB,
    XSKRL,
    XSNET,
    XSPLIT,
    XSTOV,
    XUMSW,
    XUSVR,
    XWVOF,
    ZBD1P,
    ZBD1T,
    ZBD2P,
    ZBD2T,
    ZBD3T,
    ZBFIX,
    ZEKKN,
    ZFBDT,
    ZINKZ,
    ZLSCH,
    ZLSPR,
    ZOLLD,
    ZOLLT,
    ZTERM,
    ZUONR,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, AUSBK, BELNR, BUKRS, BWART, BZKEY, CABPITEMNUMBER, CADOCUMENT, CAITEMISDOUBTFUL, CAITEMISOFFSETTING, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, DC_NAME, FIELDNAME, FISCALYEAR, GJAHR)
);

Learn More