D

206 Fields

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

Fields (206)

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 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
aedat aedat 3
anln1 anln1 3
anln2 anln2 3
aufnr aufnr 3
aufpl aufpl 3
BankGroupBP BankGroupBP 1
BankGroupName BankGroupName 1
bktxt bktxt 3
blart blart 3
bldat bldat 3
blnpz blnpz 3
bschl bschl 3
bstat bstat 3
btype btype 3
budat budat 3
buzei buzei 3
bvorg bvorg 3
bvtyp bvtyp 3
bwkey bwkey 3
bwtar bwtar 3
cc_ktext cc_ktext 3
cc_ltext cc_ltext 3
CommodityName CommodityName 1
comp_9001 comp_9001 1
comp_9002 comp_9002 1
comp_9003 comp_9003 1
comp_9004 comp_9004 1
comp_9005 comp_9005 1
counter counter 3
cpudt cpudt 3
cputm cputm 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
dabrz dabrz 3
datatype datatype 1
ddtext ddtext 1
diekz diekz 3
dtpaName dtpaName 1
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
ga_txt20 ga_txt20 3
ga_txt50 ga_txt50 3
geber geber 3
gsber gsber 3
hbkid hbkid 3
hkont hkont 3
hrkft hrkft 3
hwmet hwmet 3
hzuon hzuon 3
imkey imkey 3
koart koart 3
kokrs kokrs 3
kostl kostl 3
kstrg kstrg 3
ktopl ktopl 3
kunnr kunnr 3
kursf kursf 3
kursr kursr 3
landl landl 3
leng leng 1
lifnr lifnr 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
mm_maktx mm_maktx 3
monat monat 3
mschl mschl 3
mwart mwart 3
mwskz mwskz 3
name1 rcomp_unitName 1
nplnr nplnr 3
object_type_id ranking_factor_obj_type 1
or_ktext or_ktext 3
pargb pargb 3
peinh peinh 3
pernr pernr 3
pprct pprct 3
prctr prctr 3
projk projk 3
ps_provider ps_provider 1
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
rf_fkbtx rf_fkbtx 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
stceg stceg 3
tbtkz tbtkz 3
tcode tcode 3
tgtObj tgtObj 1
tgtTlogo tgtTlogo 1
umsks umsks 3
umskz umskz 3
upddt upddt 3
UserID UserID 5
usnam usnam 3
uzawe uzawe 3
valut valut 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
xcpdd xcpdd 3
xegdr xegdr 3
xhkom xhkom 3
xinve xinve 3
xmwst xmwst 3
xref1 xref1 3
xref2 xref2 3
xref3 xref3 3
xskrl xskrl 3
xsnet xsnet 3
xumsw xumsw 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,
    BZKEY,
    CABPITEMNUMBER,
    CADOCUMENT,
    CAITEMISDOUBTFUL,
    CAITEMISOFFSETTING,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    DC_NAME,
    FIELDNAME,
    FISCALYEAR,
    GJAHR,
    AEDAT,
    ANLN1,
    ANLN2,
    AUFNR,
    AUFPL,
    BANKGROUPBP,
    BANKGROUPNAME,
    BKTXT,
    BLART,
    BLDAT,
    BLNPZ,
    BSCHL,
    BSTAT,
    BTYPE,
    BUDAT,
    BUZEI,
    BVORG,
    BVTYP,
    BWKEY,
    BWTAR,
    CC_KTEXT,
    CC_LTEXT,
    COMMODITYNAME,
    COMP_9001,
    COMP_9002,
    COMP_9003,
    COMP_9004,
    COMP_9005,
    COUNTER,
    CPUDT,
    CPUTM,
    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,
    DABRZ,
    DATATYPE,
    DDTEXT,
    DIEKZ,
    DTPANAME,
    EBELN,
    EBELP,
    EGRUP,
    EMPFB,
    ESRNR,
    ESRPZ,
    ESRRE,
    ETYPE,
    FDGRP,
    FDLEV,
    FDTAG,
    FIKRS,
    FILKD,
    FIPOS,
    FISCPER,
    FISTL,
    FKBER,
    GA_TXT20,
    GA_TXT50,
    GEBER,
    GSBER,
    HBKID,
    HKONT,
    HRKFT,
    HWMET,
    HZUON,
    IMKEY,
    KOART,
    KOKRS,
    KOSTL,
    KSTRG,
    KTOPL,
    KUNNR,
    KURSF,
    KURSR,
    LANDL,
    LENG,
    LIFNR,
    LZBKZ,
    MABER,
    MADAT,
    MAINT_TYPE,
    MANSP,
    MANST,
    MATNR,
    MAX_INSTANCES,
    MM_MAKTX,
    MONAT,
    MSCHL,
    MWART,
    MWSKZ,
    NAME1,
    NPLNR,
    OBJECT_TYPE_ID,
    OR_KTEXT,
    PARGB,
    PEINH,
    PERNR,
    PPRCT,
    PRCTR,
    PROJK,
    PS_PROVIDER,
    QUANTITY,
    QUANUNIT,
    RCOMP,
    RDIM,
    RDIM_GUID,
    REBZG,
    REBZJ,
    REBZT,
    REBZZ,
    RECID,
    RF_FKBTX,
    RP_KTEXT,
    RP_LTEXT,
    RSTGR,
    SGTXT,
    SHKZG,
    SKFBT,
    SKNTO,
    SP_KTEXT,
    SP_LTEXT,
    SRCOBJ,
    SRCTLOGO,
    STCEG,
    TBTKZ,
    TCODE,
    TGTOBJ,
    TGTTLOGO,
    UMSKS,
    UMSKZ,
    UPDDT,
    USERID,
    USNAM,
    UZAWE,
    VALUT,
    VBEWA,
    VBUND,
    VERTN,
    VERTT,
    VNAME,
    VPRSV,
    VPTNR,
    VRSDT,
    VRSKZ,
    WERKS,
    WWERT,
    XBLNR,
    XCPDD,
    XEGDR,
    XHKOM,
    XINVE,
    XMWST,
    XREF1,
    XREF2,
    XREF3,
    XSKRL,
    XSNET,
    XUMSW,
    ZBD1P,
    ZBD1T,
    ZBD2P,
    ZBD2T,
    ZBD3T,
    ZBFIX,
    ZEKKN,
    ZFBDT,
    ZINKZ,
    ZLSCH,
    ZLSPR,
    ZOLLD,
    ZOLLT,
    ZTERM,
    ZUONR,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, AUSBK, BELNR, BUKRS, BZKEY, CABPITEMNUMBER, CADOCUMENT, CAITEMISDOUBTFUL, CAITEMISOFFSETTING, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, DC_NAME, FIELDNAME, FISCALYEAR, GJAHR)
);

Learn More