CFIN_AV_CI_ROOT

Transparent Table Application Table
27 Fields 4 CDS Views

Billing Document: Header Data

CFIN_AV_CI_ROOT is an SAP database table in S/4HANA. Billing Document: Header Data. It contains 27 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_CFinRpldBillingDocument view from EXTENSION CFin Rpld Customer Invoice - Extension
I_CFinRpldBillingDocument view from BASIC CFin Rpld Billing Document: Header
I_CFinRpldBillingDocumentItem view inner BASIC CFin Replicated Billing Document: Item
R_CFinRpldBillingDocument view_entity from BASIC CFin Replicated Billing Document

Fields (27)

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
vbeln VBELN_VF Billing Doc.
kunag KUNAG Sold-to Party
erdat ERDAT Created On
bukrs BUKRS Company Code
vbtyp VBTYPL Document Cat.
sfakn SFAKN Canceld Bill.Dc
fkdat FKDAT Billing Date
waerk WAERK Doc. Currency
kurrf KURRF Exch.Rate Acct.
kunrg KUNRG Payer
valtg VALTG Add. Value Days
kalsm KALSMASD Pric. Procedure
knumv KNUMV Doc. Condition
landtx LANDTX Tax Depar. C/R
kurrf_dat WWERT_D Translatn Date
fksto FKSTO Canceled
stceg_h STCEG_H OriginSlsTxNo.
iuuc_operat_flag FINS_CFIN_AV_OPERATION Delete/Archive
fktyp FKTYP BillingCategory
dummy_avci_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.

-- Billing Document: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_CI_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]
    VBELN,                   -- Billing Doc. [VBELN_VF]
    KUNAG,                   -- Sold-to Party [KUNAG]
    ERDAT,                   -- Created On [ERDAT]
    BUKRS,                   -- Company Code [BUKRS]
    VBTYP,                   -- Document Cat. [VBTYPL]
    SFAKN,                   -- Canceld Bill.Dc [SFAKN]
    FKDAT,                   -- Billing Date [FKDAT]
    WAERK,                   -- Doc. Currency [WAERK]
    KURRF,                   -- Exch.Rate Acct. [KURRF]
    KUNRG,                   -- Payer [KUNRG]
    VALTG,                   -- Add. Value Days [VALTG]
    KALSM,                   -- Pric. Procedure [KALSMASD]
    KNUMV,                   -- Doc. Condition [KNUMV]
    LANDTX,                  -- Tax Depar. C/R [LANDTX]
    KURRF_DAT,               -- Translatn Date [WWERT_D]
    FKSTO,                   -- Canceled [FKSTO]
    STCEG_H,                 -- OriginSlsTxNo. [STCEG_H]
    IUUC_OPERAT_FLAG,        -- Delete/Archive [FINS_CFIN_AV_OPERATION]
    FKTYP,                   -- BillingCategory [FKTYP]
    DUMMY_AVCI_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More