CFIN_AV_CI_ITEM

Transparent Table Application Table
31 Fields 3 CDS Views

Billing Document: Item Data

CFIN_AV_CI_ITEM is an SAP database table in S/4HANA. Billing Document: Item Data. It contains 31 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CFinRpldBillingDocumentItem view from EXTENSION CFin Rpld CustInvc Item - Extension
I_CFinRpldBillingDocumentItem view from BASIC CFin Replicated Billing Document: Item
R_CFinRpldBillingDocumentItem view_entity from BASIC CFin Replicated Billing Document Item

Fields (31)

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
vbeln VBELN_VF Billing Doc.
posnr POSNR_VF Item
matnr MATNR Material
netwr NETWR_FP Net Value
shkzg SHKZG_VF Returns
fkimg FKIMG Invoiced Qty
vrkme VRKME Sales Unit
werks WERKS_D Plant
vgtyp VBTYPL_V Prec.Doc.Categ.
fareg FAREG Billing Rule
fklmg FKLMG Bill.Qty in SKU
meins MEINS Base Unit
aubel VBELN_VA Sales Document
aupos POSNR_VA Item
j_1arfz J_1ARFZVAT Reason for Zero VAT
vgbel VGBEL Reference Doc.
ps_psp_pnr PS_PSP_PNR WBS Element
kokrs KOKRS CO Area
dummy_avciitm_incl_eew_ps CFD_DUMMY Dummy
kostl KOSTL Cost Center
prctr PRCTR Profit Center
aland LAND1 Country/Reg.
txjcd TXJCD Tax Jur.
arktx ARKTX Item Descr.
mwsk1 MWSKZ Tax Code
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From

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: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_CI_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]
    VBELN,                      -- Billing Doc. [VBELN_VF]
    POSNR,                      -- Item [POSNR_VF]
    MATNR,                      -- Material [MATNR]
    NETWR,                      -- Net Value [NETWR_FP]
    SHKZG,                      -- Returns [SHKZG_VF]
    FKIMG,                      -- Invoiced Qty [FKIMG]
    VRKME,                      -- Sales Unit [VRKME]
    WERKS,                      -- Plant [WERKS_D]
    VGTYP,                      -- Prec.Doc.Categ. [VBTYPL_V]
    FAREG,                      -- Billing Rule [FAREG]
    FKLMG,                      -- Bill.Qty in SKU [FKLMG]
    MEINS,                      -- Base Unit [MEINS]
    AUBEL,                      -- Sales Document [VBELN_VA]
    AUPOS,                      -- Item [POSNR_VA]
    J_1ARFZ,                    -- Reason for Zero VAT [J_1ARFZVAT]
    VGBEL,                      -- Reference Doc. [VGBEL]
    PS_PSP_PNR,                 -- WBS Element [PS_PSP_PNR]
    KOKRS,                      -- CO Area [KOKRS]
    DUMMY_AVCIITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    KOSTL,                      -- Cost Center [KOSTL]
    PRCTR,                      -- Profit Center [PRCTR]
    ALAND,                      -- Country/Reg. [LAND1]
    TXJCD,                      -- Tax Jur. [TXJCD]
    ARKTX,                      -- Item Descr. [ARKTX]
    MWSK1,                      -- Tax Code [MWSKZ]
    TXDAT_FROM,                 -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More