CFIN_AVSI_ITEME

Transparent Table Temporary Data
24 Fields 1 CDS Views

CFin Rpld Supplier Invoice Item (API)

CFIN_AVSI_ITEME is an SAP database table in S/4HANA. CFin Rpld Supplier Invoice Item (API). It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CFinRpldSuplrInvcItmPORef view_entity from CONSUMPTION CFin Rpld Supplier Invoice Item (API)

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
sourcesystemlogicalsystem LOGSYS Logical system
cfinrpldsupplierinvoice FINS_CFIN_AV_RPLD_SUPLR_INVC Central Finance Repl. Supplier Invoice
fiscalyear GJAHR Fiscal Year
cfinrpldsupplierinvoiceitem FINS_CFIN_AV_RPLD_SUPLR_IV_ITM Central Finance Repl. Supplier Inv. Item
cfinrpldpurchasingdocument EBELN Purchasing Doc.
cfinrpldpurchasingdocumentitem EBELP Item
taxcode MWSKZ Tax Code
supplierinvoiceitemamount WRBTR_CS Amount
material MATNR Material
plant WERKS_D Plant
freightsupplier LIFNR Supplier
purchaseorderquantityunit BSTME Order Unit
quantityinpurchaseorderunit MENGE_D Quantity
quantityunit MEINS Base Unit
referencedocument LFBNR Reference Doc.
referencedocumentfiscalyear LFGJA Year Cur.Period
referencedocumentitem LFPOS Ref. Doc. Item
issubsequentdebitcredit TBTKZ Subseq. Dr/Cr
documentcurrency WAERS Currency
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
dummy_avsiitm_incl_eew_ps CFD_DUMMY Dummy
companycode BUKRS Company Code

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 Rpld Supplier Invoice Item (API)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVSI_ITEME (
    MANDT,                           -- Client [MANDT]
    AV_DBKEY,                        -- DB Key [FINS_CFIN_AV_DBKEY]
    SOURCESYSTEMLOGICALSYSTEM,       -- Logical system [LOGSYS]
    CFINRPLDSUPPLIERINVOICE,         -- Central Finance Repl. Supplier Invoice [FINS_CFIN_AV_RPLD_SUPLR_INVC]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    CFINRPLDSUPPLIERINVOICEITEM,     -- Central Finance Repl. Supplier Inv. Item [FINS_CFIN_AV_RPLD_SUPLR_IV_ITM]
    CFINRPLDPURCHASINGDOCUMENT,      -- Purchasing Doc. [EBELN]
    CFINRPLDPURCHASINGDOCUMENTITEM,  -- Item [EBELP]
    TAXCODE,                         -- Tax Code [MWSKZ]
    SUPPLIERINVOICEITEMAMOUNT,       -- Amount [WRBTR_CS]
    MATERIAL,                        -- Material [MATNR]
    PLANT,                           -- Plant [WERKS_D]
    FREIGHTSUPPLIER,                 -- Supplier [LIFNR]
    PURCHASEORDERQUANTITYUNIT,       -- Order Unit [BSTME]
    QUANTITYINPURCHASEORDERUNIT,     -- Quantity [MENGE_D]
    QUANTITYUNIT,                    -- Base Unit [MEINS]
    REFERENCEDOCUMENT,               -- Reference Doc. [LFBNR]
    REFERENCEDOCUMENTFISCALYEAR,     -- Year Cur.Period [LFGJA]
    REFERENCEDOCUMENTITEM,           -- Ref. Doc. Item [LFPOS]
    ISSUBSEQUENTDEBITCREDIT,         -- Subseq. Dr/Cr [TBTKZ]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    LASTCHANGEDATETIME,              -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    DUMMY_AVSIITM_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More