FDC_D_DFT_AC_HDR

Transparent Table Application Table
76 Fields 6 CDS Views

Draft persistence of AccDocHdr

FDC_D_DFT_AC_HDR is an SAP database table in S/4HANA. Draft persistence of AccDocHdr. It contains 76 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FACVD_CLRIT_05 view left_outer Open items of incoming payment for manual clearing
FACVD_CLRIT_06 view left_outer Open items of outgoing payment for manual clearing
Facvd_Dft_Wli view inner Draft of Accounting Document Header
facvd_Uplddoc_All view inner Uploaded Documents
farvd_bs_it_02 view_entity left_outer Bank Statement Items
P_Arbanktransactiondocitem_07 view left_outer COMPOSITE

Fields (76)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key FDC_DFT_KEY RAW16
root_key FDC_DFT_KEY RAW16
bukrs BUKRS Company Code
belnr FIS_BELNR_INPUT Document Number
blart FIS_BLART Journal Entry Type
bldat FIS_BLDAT Journal Entry Date
budat BUDAT Posting Date
vatdate VATDATE Tax Reporting Date
whtdate WHTDATE Wtax Reporting Date
fulfilldate FOT_FULFILLDATE Tax Fulfill. Date
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
monat MONAT Period
wwert FAC_WWERT_D Translation Date
waers FAC_TWAER Transaction Currency
ldgrp FAGL_LDGRP Ledger Group
kursf FIS_KURSF Exchange Rate
fwste FWSTE Amount
hwste HWSTE LC Tax
pargb_hdr FIS_PARGB Partner Bus. Area
brnch J_1ABRNCH Branch number
reindat REINDAT Inv. Recpt Date
numpg J_1ANOPG Number of Pages
bttype FINS_BTTYPE Bus. Trans. Category
bktxt FAC_BKTXT Header Text
xmwst XMWST Calculate Tax
xsnet XSNET Net Entry
xblnr XBLNR1 Reference
txkrs TXKRS_BKPF Rate for Taxes
ctxkrs CTXKRS Tax Rate: RC
bvorg FAC_BVORG Intercompany Transac
curtp_input FINS_CURTYPE_FOR_INPUT Debits/Credits Cur.
grpid GRPID_BKPF Session Name
xref1_hd XREF1_HD Ref.key(head) 1
xref2_hd XREF2_HD Ref.key(head.)2
augtx FAC_AUGTX Clearing Text
stgrd STGRD Reversal Reason
stodt RBDAT Plnd Reversal Date
glo_ref1_hd FAC_GLO_REF1_HD Country/Region Specific Reference 1
glo_dat1_hd FAC_GLO_DAT1_HD Country/Region Specific Date 1
glo_ref2_hd FAC_GLO_REF2_HD Country/Region Specific Reference 2
glo_dat2_hd FAC_GLO_DAT2_HD Country/Region Specific Date 2
glo_ref3_hd FAC_GLO_REF3_HD Country/Region Specific Reference 3
glo_dat3_hd FAC_GLO_DAT3_HD Country/Region Specific Date 3
glo_ref4_hd FAC_GLO_REF4_HD Country/Region Specific Reference 4
glo_dat4_hd FAC_GLO_DAT4_HD Country/Region Specific Date 4
glo_ref5_hd FAC_GLO_REF5_HD Country/Region Specific Reference 5
glo_dat5_hd FAC_GLO_DAT5_HD Country/Region Specific Date 5
glo_bp1_hd FAC_GLO_BP1_HD Ctry/Reg. Specific Business Partner 1
glo_bp2_hd FAC_GLO_BP2_HD Ctry/Reg. Specific Business Partner 2
ux_me_wwert FDC_UX_ME UI Field Control
ux_me_hwste FDC_UX_ME UI Field Control
ux_me_kursf FDC_UX_ME UI Field Control
ux_me_txkrs FDC_UX_ME UI Field Control
ux_me_vatdate FDC_UX_ME UI Field Control
ux_me_fulfilldate FDC_UX_ME UI Field Control
kukey KUKEY_EB Short Key
esnum ESNUM_EB Memo Record No.
reprocreasoncode abap.char
avkoa KOART_AV Account Type
avkon KTONR_AV Account
tatyp FDC_TATYP Payment Trans. Cat.
fwaer FWAER_EB ForeignCurrency
fwbtr FWBTR_EB For. Crcy Amt
ruleuuid FAR_PSTRL_NODE_KEY Rule Key
grpnr GRPNR_EB Bundle Number
bukrsadv BUKRS Company Code
koartadv KOART_AV Account Type
kontoadv KTONR_AV Account
avsidadv AVSID Payt Advice No.
tmpid FDC_ACCDOC_TMP_DOC_ID Temp. Document ID
hold_doc_crdat abap.dats
tcode TCODE Transaction Code
dispute_act_count abap.numc
bstat BSTAT_D Document Status
scvariant SCVARIANT Variant

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.

-- Draft persistence of AccDocHdr
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDC_D_DFT_AC_HDR (
    MANDT,              -- Client [MANDT]
    DB_KEY,             -- RAW16 [FDC_DFT_KEY]
    ROOT_KEY,           -- RAW16 [FDC_DFT_KEY]
    BUKRS,              -- Company Code [BUKRS]
    BELNR,              -- Document Number [FIS_BELNR_INPUT]
    BLART,              -- Journal Entry Type [FIS_BLART]
    BLDAT,              -- Journal Entry Date [FIS_BLDAT]
    BUDAT,              -- Posting Date [BUDAT]
    VATDATE,            -- Tax Reporting Date [VATDATE]
    WHTDATE,            -- Wtax Reporting Date [WHTDATE]
    FULFILLDATE,        -- Tax Fulfill. Date [FOT_FULFILLDATE]
    TAX_COUNTRY,        -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    MONAT,              -- Period [MONAT]
    WWERT,              -- Translation Date [FAC_WWERT_D]
    WAERS,              -- Transaction Currency [FAC_TWAER]
    LDGRP,              -- Ledger Group [FAGL_LDGRP]
    KURSF,              -- Exchange Rate [FIS_KURSF]
    FWSTE,              -- Amount [FWSTE]
    HWSTE,              -- LC Tax [HWSTE]
    PARGB_HDR,          -- Partner Bus. Area [FIS_PARGB]
    BRNCH,              -- Branch number [J_1ABRNCH]
    REINDAT,            -- Inv. Recpt Date [REINDAT]
    NUMPG,              -- Number of Pages [J_1ANOPG]
    BTTYPE,             -- Bus. Trans. Category [FINS_BTTYPE]
    BKTXT,              -- Header Text [FAC_BKTXT]
    XMWST,              -- Calculate Tax [XMWST]
    XSNET,              -- Net Entry [XSNET]
    XBLNR,              -- Reference [XBLNR1]
    TXKRS,              -- Rate for Taxes [TXKRS_BKPF]
    CTXKRS,             -- Tax Rate: RC [CTXKRS]
    BVORG,              -- Intercompany Transac [FAC_BVORG]
    CURTP_INPUT,        -- Debits/Credits Cur. [FINS_CURTYPE_FOR_INPUT]
    GRPID,              -- Session Name [GRPID_BKPF]
    XREF1_HD,           -- Ref.key(head) 1 [XREF1_HD]
    XREF2_HD,           -- Ref.key(head.)2 [XREF2_HD]
    AUGTX,              -- Clearing Text [FAC_AUGTX]
    STGRD,              -- Reversal Reason [STGRD]
    STODT,              -- Plnd Reversal Date [RBDAT]
    GLO_REF1_HD,        -- Country/Region Specific Reference 1 [FAC_GLO_REF1_HD]
    GLO_DAT1_HD,        -- Country/Region Specific Date 1 [FAC_GLO_DAT1_HD]
    GLO_REF2_HD,        -- Country/Region Specific Reference 2 [FAC_GLO_REF2_HD]
    GLO_DAT2_HD,        -- Country/Region Specific Date 2 [FAC_GLO_DAT2_HD]
    GLO_REF3_HD,        -- Country/Region Specific Reference 3 [FAC_GLO_REF3_HD]
    GLO_DAT3_HD,        -- Country/Region Specific Date 3 [FAC_GLO_DAT3_HD]
    GLO_REF4_HD,        -- Country/Region Specific Reference 4 [FAC_GLO_REF4_HD]
    GLO_DAT4_HD,        -- Country/Region Specific Date 4 [FAC_GLO_DAT4_HD]
    GLO_REF5_HD,        -- Country/Region Specific Reference 5 [FAC_GLO_REF5_HD]
    GLO_DAT5_HD,        -- Country/Region Specific Date 5 [FAC_GLO_DAT5_HD]
    GLO_BP1_HD,         -- Ctry/Reg. Specific Business Partner 1 [FAC_GLO_BP1_HD]
    GLO_BP2_HD,         -- Ctry/Reg. Specific Business Partner 2 [FAC_GLO_BP2_HD]
    UX_ME_WWERT,        -- UI Field Control [FDC_UX_ME]
    UX_ME_HWSTE,        -- UI Field Control [FDC_UX_ME]
    UX_ME_KURSF,        -- UI Field Control [FDC_UX_ME]
    UX_ME_TXKRS,        -- UI Field Control [FDC_UX_ME]
    UX_ME_VATDATE,      -- UI Field Control [FDC_UX_ME]
    UX_ME_FULFILLDATE,  -- UI Field Control [FDC_UX_ME]
    KUKEY,              -- Short Key [KUKEY_EB]
    ESNUM,              -- Memo Record No. [ESNUM_EB]
    REPROCREASONCODE,   -- abap.char
    AVKOA,              -- Account Type [KOART_AV]
    AVKON,              -- Account [KTONR_AV]
    TATYP,              -- Payment Trans. Cat. [FDC_TATYP]
    FWAER,              -- ForeignCurrency [FWAER_EB]
    FWBTR,              -- For. Crcy Amt [FWBTR_EB]
    RULEUUID,           -- Rule Key [FAR_PSTRL_NODE_KEY]
    GRPNR,              -- Bundle Number [GRPNR_EB]
    BUKRSADV,           -- Company Code [BUKRS]
    KOARTADV,           -- Account Type [KOART_AV]
    KONTOADV,           -- Account [KTONR_AV]
    AVSIDADV,           -- Payt Advice No. [AVSID]
    TMPID,              -- Temp. Document ID [FDC_ACCDOC_TMP_DOC_ID]
    HOLD_DOC_CRDAT,     -- abap.dats
    TCODE,              -- Transaction Code [TCODE]
    DISPUTE_ACT_COUNT,  -- abap.numc
    BSTAT,              -- Document Status [BSTAT_D]
    SCVARIANT,          -- Variant [SCVARIANT]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More