CFIN_ACDOC_IT

Transparent Table Application Table
31 Fields 1 CDS Views

CFIN View on /AIF/PERS_XML: Accounting Document Line Item

CFIN_ACDOC_IT is an SAP database table in S/4HANA. CFIN View on /AIF/PERS_XML: Accounting Document Line Item. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CFinRpldTransDocumentItem view_entity from BASIC CFIN Rpld Transaction Document Item

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY msgguid GUID_32 GUID 16
KEY posnr POSNR_ACC Position
bukrs BUKRS Company Code
gjahr GJAHR Fiscal Year
buzei BUZEI Item
bschl BSCHL Posting Key
dmbtr DMBTR Amount in LC
currkey_10 FAGL_CURRKEY_10 CCode Currency
wrbtr WRBTR Amount
waers WAERS Currency
currkey_30 FAGL_CURRKEY_30 Group Currency
dmbe2 DMBE2 LC2 Amount
shkzg SHKZG Debit/Credit
mwskz MWSKZ Tax Code
umskz UMSKZ Special G/L Ind
kokrs KOKRS CO Area
kostl KOSTL Cost Center
prctr PRCTR Profit Center
koart KOART Account type
ktopl KTOPL Chart of Accts
hkont HKONT G/L Acct
kunnr KUNNR Customer
lifnr LIFNR Supplier
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
bukrs_sender BUKRS_SENDER Sender CoCode
belnr_sender BELNR_SENDER Sender Doc.No.
gjahr_sender GJAHR_SENDER Sender FiscalYr
vbund VBUND Company ID
matnr MATNR Material
rmvct RMVCT Transact. Type

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.

-- CFIN View on /AIF/PERS_XML: Accounting Document Line Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_ACDOC_IT (
    MANDT,             -- Client [MANDT]
    MSGGUID,           -- GUID 16 [GUID_32]
    POSNR,             -- Position [POSNR_ACC]
    BUKRS,             -- Company Code [BUKRS]
    GJAHR,             -- Fiscal Year [GJAHR]
    BUZEI,             -- Item [BUZEI]
    BSCHL,             -- Posting Key [BSCHL]
    DMBTR,             -- Amount in LC [DMBTR]
    CURRKEY_10,        -- CCode Currency [FAGL_CURRKEY_10]
    WRBTR,             -- Amount [WRBTR]
    WAERS,             -- Currency [WAERS]
    CURRKEY_30,        -- Group Currency [FAGL_CURRKEY_30]
    DMBE2,             -- LC2 Amount [DMBE2]
    SHKZG,             -- Debit/Credit [SHKZG]
    MWSKZ,             -- Tax Code [MWSKZ]
    UMSKZ,             -- Special G/L Ind [UMSKZ]
    KOKRS,             -- CO Area [KOKRS]
    KOSTL,             -- Cost Center [KOSTL]
    PRCTR,             -- Profit Center [PRCTR]
    KOART,             -- Account type [KOART]
    KTOPL,             -- Chart of Accts [KTOPL]
    HKONT,             -- G/L Acct [HKONT]
    KUNNR,             -- Customer [KUNNR]
    LIFNR,             -- Supplier [LIFNR]
    LOGSYSTEM_SENDER,  -- Sender Log Sys. [LOGSYSTEM_SENDER]
    BUKRS_SENDER,      -- Sender CoCode [BUKRS_SENDER]
    BELNR_SENDER,      -- Sender Doc.No. [BELNR_SENDER]
    GJAHR_SENDER,      -- Sender FiscalYr [GJAHR_SENDER]
    VBUND,             -- Company ID [VBUND]
    MATNR,             -- Material [MATNR]
    RMVCT,             -- Transact. Type [RMVCT]
    PRIMARY KEY (MANDT, MSGGUID, POSNR)
);

Learn More