CFIN_AV_SI_ITEM

Transparent Table Application Table
25 Fields 3 CDS Views

Supplier Invoice: Item Data

CFIN_AV_SI_ITEM is an SAP database table in S/4HANA. Supplier Invoice: Item Data. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CFinRpldSupplierInvoiceItem view from EXTENSION CFin Rpld Suplr Invoice Item - Extension
I_CFinRpldSupplierInvoiceItem view from BASIC CFin Replicated Supplier Invoice: Item
R_CFinRpldSuplrInvcItmPORef view_entity from BASIC CFin Rpld Supplier Invoice Item PO Ref

Fields (25)

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
mwskz MWSKZ Tax Code
matnr MATNR Material
wrbtr WRBTR_CS Amount
werks WERKS_D Plant
menge MENGE_D Quantity
meins MEINS Base Unit
bstme BSTME Order Unit
lifnr LIFNR Supplier
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
lfbnr LFBNR Reference Doc.
lfgja LFGJA Year Cur.Period
lfpos LFPOS Ref. Doc. Item
tbtkz TBTKZ Subseq. Dr/Cr
dummy_avsiitm_incl_eew_ps CFD_DUMMY Dummy
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.

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: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_SI_ITEM (
    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]
    MWSKZ,                      -- Tax Code [MWSKZ]
    MATNR,                      -- Material [MATNR]
    WRBTR,                      -- Amount [WRBTR_CS]
    WERKS,                      -- Plant [WERKS_D]
    MENGE,                      -- Quantity [MENGE_D]
    MEINS,                      -- Base Unit [MEINS]
    BSTME,                      -- Order Unit [BSTME]
    LIFNR,                      -- Supplier [LIFNR]
    EBELN,                      -- Purchasing Doc. [EBELN]
    EBELP,                      -- Item [EBELP]
    LFBNR,                      -- Reference Doc. [LFBNR]
    LFGJA,                      -- Year Cur.Period [LFGJA]
    LFPOS,                      -- Ref. Doc. Item [LFPOS]
    TBTKZ,                      -- Subseq. Dr/Cr [TBTKZ]
    DUMMY_AVSIITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    TXDAT_FROM,                 -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    TAX_COUNTRY,                -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More