CFIN_AV_SI_GLACC

Transparent Table Application Table
18 Fields 2 CDS Views

Supplier Invoice: GL Account Related Data

CFIN_AV_SI_GLACC is an SAP database table in S/4HANA. Supplier Invoice: GL Account Related Data. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CFinRpldSuplrInvcItmGLAcct view_entity from EXTENSION CFin Rpld SI Item GLAcc - Extension
R_CFinRpldSuplrInvcItemGLAcct view_entity from BASIC CFin Rpld Supplier Invoice Item GL Acc

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
av_parentkey FINS_CFIN_AV_PARENTKEY Parent Key
av_rootkey FINS_CFIN_AV_ROOTKEY Root Key
fins_logsys LOGSYS Logical system
belnr RE_BELNR Inv. Doc. No.
gjahr GJAHR Fiscal Year
buzei RBLGP Item
cobl_nr COBL_NR Seq. Number
mwskz MWSKZ Tax Code
wrbtr WRBTR_CS Amount
shkzg SHKZG Debit/Credit
xnegp XNEGP Negative Postg
koart KOART Account type
saknr SAKNR G/L Account
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
dummy_avsiitmglacc_incl_eew_ps CFD_DUMMY Dummy

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.

-- Supplier Invoice: GL Account Related Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_SI_GLACC (
    MANDT,                           -- Client [MANDT]
    AV_DBKEY,                        -- DB Key [FINS_CFIN_AV_DBKEY]
    AV_PARENTKEY,                    -- Parent Key [FINS_CFIN_AV_PARENTKEY]
    AV_ROOTKEY,                      -- Root Key [FINS_CFIN_AV_ROOTKEY]
    FINS_LOGSYS,                     -- Logical system [LOGSYS]
    BELNR,                           -- Inv. Doc. No. [RE_BELNR]
    GJAHR,                           -- Fiscal Year [GJAHR]
    BUZEI,                           -- Item [RBLGP]
    COBL_NR,                         -- Seq. Number [COBL_NR]
    MWSKZ,                           -- Tax Code [MWSKZ]
    WRBTR,                           -- Amount [WRBTR_CS]
    SHKZG,                           -- Debit/Credit [SHKZG]
    XNEGP,                           -- Negative Postg [XNEGP]
    KOART,                           -- Account type [KOART]
    SAKNR,                           -- G/L Account [SAKNR]
    TXDAT_FROM,                      -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    TAX_COUNTRY,                     -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    DUMMY_AVSIITMGLACC_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More