CFIN_AV_SI_ROOT

Transparent Table Application Table
26 Fields 3 CDS Views

Supplier Invoice: Header Data

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CFinRpldSupplierInvoice view from EXTENSION CFin Rpld Supplier Invoice - Extension
I_CFinRpldSupplierInvoice view from BASIC CFin Rpld Supplier Invoice: Header
R_CFinRpldSupplierInvoice view_entity from BASIC CFin Replicated Supplier Invoice

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
av_changedtime FINS_CFIN_AV_CHANGEDTIME Changed On
av_changeuser FINS_CFIN_AV_CHANGEUSER Changed By
av_createdtime FINS_CFIN_AV_CREATEDTIME Created On
av_createuser FINS_CFIN_AV_CREATEUSER Created By
fins_logsys LOGSYS Logical system
belnr RE_BELNR Inv. Doc. No.
gjahr GJAHR Fiscal Year
bldat BLDAT Document Date
budat BUDAT Posting Date
blart BLART Document Type
stblg RE_STBLG Reversed by
stjah RE_STJAH Year
ivtyp IVTYP IV category
waers WAERS Currency
vgart M8VGA Transactn Type
bukrs BUKRS Company Code
lifnr LIFRE Invoicing Party
cpudt CPUDT Entered On
cputm CPUTM Entered at
rbstat RBSTAT Inv. status
logmx_uuid FINS_CFIN_AV_LOGMX_UUID Mexico UUID
iuuc_operat_flag FINS_CFIN_AV_OPERATION Delete/Archive
xrech XRECH Invoice
dummy_avsi_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: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_SI_ROOT (
    MANDT,                   -- Client [MANDT]
    AV_DBKEY,                -- DB Key [FINS_CFIN_AV_DBKEY]
    AV_CHANGEDTIME,          -- Changed On [FINS_CFIN_AV_CHANGEDTIME]
    AV_CHANGEUSER,           -- Changed By [FINS_CFIN_AV_CHANGEUSER]
    AV_CREATEDTIME,          -- Created On [FINS_CFIN_AV_CREATEDTIME]
    AV_CREATEUSER,           -- Created By [FINS_CFIN_AV_CREATEUSER]
    FINS_LOGSYS,             -- Logical system [LOGSYS]
    BELNR,                   -- Inv. Doc. No. [RE_BELNR]
    GJAHR,                   -- Fiscal Year [GJAHR]
    BLDAT,                   -- Document Date [BLDAT]
    BUDAT,                   -- Posting Date [BUDAT]
    BLART,                   -- Document Type [BLART]
    STBLG,                   -- Reversed by [RE_STBLG]
    STJAH,                   -- Year [RE_STJAH]
    IVTYP,                   -- IV category [IVTYP]
    WAERS,                   -- Currency [WAERS]
    VGART,                   -- Transactn Type [M8VGA]
    BUKRS,                   -- Company Code [BUKRS]
    LIFNR,                   -- Invoicing Party [LIFRE]
    CPUDT,                   -- Entered On [CPUDT]
    CPUTM,                   -- Entered at [CPUTM]
    RBSTAT,                  -- Inv. status [RBSTAT]
    LOGMX_UUID,              -- Mexico UUID [FINS_CFIN_AV_LOGMX_UUID]
    IUUC_OPERAT_FLAG,        -- Delete/Archive [FINS_CFIN_AV_OPERATION]
    XRECH,                   -- Invoice [XRECH]
    DUMMY_AVSI_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More