CFIN_AVCI_ITEME

Transparent Table Temporary Data
29 Fields 1 CDS Views

CFin Rpld Billing Document Item (API)

CFIN_AVCI_ITEME is an SAP database table in S/4HANA. CFin Rpld Billing Document Item (API). It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CFinRpldBillingDocumentItem view_entity from CONSUMPTION CFin Rpld Billing Document Item (API)

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
sourcesystemlogicalsystem LOGSYS Logical system
cfinreplicatedbillingdocument FINS_CFIN_AV_RPLD_BILLING_DOC Central Finance Repl. Billing Document
cfinrpldbillingdocumentitem FINS_CFIN_AV_RPLD_BILL_DOC_ITM Central Finance Repl. Billing Doc. Item
material MATNR Material
plant WERKS_D Plant
transactioncurrency WAERK Doc. Currency
netamount NETWR_FP Net Value
returnitemprocessingtype SHKZG_VF Returns
billingquantity FKIMG Invoiced Qty
billingquantityunit VRKME Sales Unit
referencesddocumentcategory VBTYPL_V Prec.Doc.Categ.
billingquantityinbaseunit FKLMG Bill.Qty in SKU
baseunit MEINS Base Unit
salesdocument FINS_CFIN_AV_RPLD_SLS_DOC Central Finance Repl. Sales Document
salesdocumentitem FINS_CFIN_AV_RPLD_SLS_DOC_ITEM Central Finance Repl. Sales Doc. Item
zerovatrsn J_1ARFZVAT Reason for Zero VAT
referencesddocument VGBEL Reference Doc.
wbselementexternalid PS_POSID_EDIT WBS Element
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
billingdocumentitemtext ARKTX Item Descr.
taxcode MWSKZ Tax Code
dummy_avciitm_incl_eew_ps CFD_DUMMY Dummy
costcenter KOSTL Cost Center
profitcenter PRCTR Profit Center
departurecountry LAND1 Country/Reg.
taxjurisdiction TXJCD Tax Jur.
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 Billing Document Item (API)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVCI_ITEME (
    MANDT,                          -- Client [MANDT]
    AV_DBKEY,                       -- DB Key [FINS_CFIN_AV_DBKEY]
    SOURCESYSTEMLOGICALSYSTEM,      -- Logical system [LOGSYS]
    CFINREPLICATEDBILLINGDOCUMENT,  -- Central Finance Repl. Billing Document [FINS_CFIN_AV_RPLD_BILLING_DOC]
    CFINRPLDBILLINGDOCUMENTITEM,    -- Central Finance Repl. Billing Doc. Item [FINS_CFIN_AV_RPLD_BILL_DOC_ITM]
    MATERIAL,                       -- Material [MATNR]
    PLANT,                          -- Plant [WERKS_D]
    TRANSACTIONCURRENCY,            -- Doc. Currency [WAERK]
    NETAMOUNT,                      -- Net Value [NETWR_FP]
    RETURNITEMPROCESSINGTYPE,       -- Returns [SHKZG_VF]
    BILLINGQUANTITY,                -- Invoiced Qty [FKIMG]
    BILLINGQUANTITYUNIT,            -- Sales Unit [VRKME]
    REFERENCESDDOCUMENTCATEGORY,    -- Prec.Doc.Categ. [VBTYPL_V]
    BILLINGQUANTITYINBASEUNIT,      -- Bill.Qty in SKU [FKLMG]
    BASEUNIT,                       -- Base Unit [MEINS]
    SALESDOCUMENT,                  -- Central Finance Repl. Sales Document [FINS_CFIN_AV_RPLD_SLS_DOC]
    SALESDOCUMENTITEM,              -- Central Finance Repl. Sales Doc. Item [FINS_CFIN_AV_RPLD_SLS_DOC_ITEM]
    ZEROVATRSN,                     -- Reason for Zero VAT [J_1ARFZVAT]
    REFERENCESDDOCUMENT,            -- Reference Doc. [VGBEL]
    WBSELEMENTEXTERNALID,           -- WBS Element [PS_POSID_EDIT]
    LASTCHANGEDATETIME,             -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    BILLINGDOCUMENTITEMTEXT,        -- Item Descr. [ARKTX]
    TAXCODE,                        -- Tax Code [MWSKZ]
    DUMMY_AVCIITM_INCL_EEW_PS,      -- Dummy [CFD_DUMMY]
    COSTCENTER,                     -- Cost Center [KOSTL]
    PROFITCENTER,                   -- Profit Center [PRCTR]
    DEPARTURECOUNTRY,               -- Country/Reg. [LAND1]
    TAXJURISDICTION,                -- Tax Jur. [TXJCD]
    COMPANYCODE,                    -- Company Code [BUKRS]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More