CFIN_AVSO_ITEME

Transparent Table Temporary Data
34 Fields 1 CDS Views

CFin Rpld Sales Document Item (API)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CFinRpldSalesDocumentItem view_entity from CONSUMPTION CFin Rpld Sales Document Item (API)

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
sourcesystemlogicalsystem LOGSYSTEM_SENDER Sender Log Sys.
cfinreplicatedsalesdocument FINS_CFIN_AV_RPLD_SLS_DOC Central Finance Repl. Sales Document
cfinrpldsalesdocumentitem FINS_CFIN_AV_RPLD_SLS_DOC_ITEM Central Finance Repl. Sales Doc. Item
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
referencesddocument VGBEL Reference Doc.
referencesddocumentitem VGPOS Reference Item
referencesddocumentcategory VBTYPL_V Prec.Doc.Categ.
businessarea FIS_RBUSA Business Area
material MATNR Material
salesorderitemcategory PSTYV Item Category
division SPART Division
plant WERKS_D Plant
materialgroup MATKL Material Group
storagelocation LGORT_D Location
profitcenter FIS_PRCTR Profit Center
wbselementexternalid PS_POSID_EDIT WBS Element
creationdate FIS_CPDAT Creation Date
lastchangedate AEDAT Changed On
isreturnsitem SHKZG_VA Returns
originsddocument VBELV Originating Doc
originsddocumentitem POSNV Origin. Item
targetquantity DZMENG Target Quantity
targetquantityunit DZIEME Target Qty UoM
netamount NETWR_AP Net Value
orderid FIS_AUFNR Order ID
transactioncurrency FIS_RWCUR Transaction Currency
salesdocumentrjcnreason ABGRU_VA RejectionReason
pricingdate PRSDT Pricing Date
additionalvaluedays VALTG Add. Value Days
billingdate FKDAT Billing Date
dummy_avsoitm_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 Sales Document Item (API)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVSO_ITEME (
    MANDT,                        -- Client [MANDT]
    AV_DBKEY,                     -- DB Key [FINS_CFIN_AV_DBKEY]
    SOURCESYSTEMLOGICALSYSTEM,    -- Sender Log Sys. [LOGSYSTEM_SENDER]
    CFINREPLICATEDSALESDOCUMENT,  -- Central Finance Repl. Sales Document [FINS_CFIN_AV_RPLD_SLS_DOC]
    CFINRPLDSALESDOCUMENTITEM,    -- Central Finance Repl. Sales Doc. Item [FINS_CFIN_AV_RPLD_SLS_DOC_ITEM]
    LASTCHANGEDATETIME,           -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    REFERENCESDDOCUMENT,          -- Reference Doc. [VGBEL]
    REFERENCESDDOCUMENTITEM,      -- Reference Item [VGPOS]
    REFERENCESDDOCUMENTCATEGORY,  -- Prec.Doc.Categ. [VBTYPL_V]
    BUSINESSAREA,                 -- Business Area [FIS_RBUSA]
    MATERIAL,                     -- Material [MATNR]
    SALESORDERITEMCATEGORY,       -- Item Category [PSTYV]
    DIVISION,                     -- Division [SPART]
    PLANT,                        -- Plant [WERKS_D]
    MATERIALGROUP,                -- Material Group [MATKL]
    STORAGELOCATION,              -- Location [LGORT_D]
    PROFITCENTER,                 -- Profit Center [FIS_PRCTR]
    WBSELEMENTEXTERNALID,         -- WBS Element [PS_POSID_EDIT]
    CREATIONDATE,                 -- Creation Date [FIS_CPDAT]
    LASTCHANGEDATE,               -- Changed On [AEDAT]
    ISRETURNSITEM,                -- Returns [SHKZG_VA]
    ORIGINSDDOCUMENT,             -- Originating Doc [VBELV]
    ORIGINSDDOCUMENTITEM,         -- Origin. Item [POSNV]
    TARGETQUANTITY,               -- Target Quantity [DZMENG]
    TARGETQUANTITYUNIT,           -- Target Qty UoM [DZIEME]
    NETAMOUNT,                    -- Net Value [NETWR_AP]
    ORDERID,                      -- Order ID [FIS_AUFNR]
    TRANSACTIONCURRENCY,          -- Transaction Currency [FIS_RWCUR]
    SALESDOCUMENTRJCNREASON,      -- RejectionReason [ABGRU_VA]
    PRICINGDATE,                  -- Pricing Date [PRSDT]
    ADDITIONALVALUEDAYS,          -- Add. Value Days [VALTG]
    BILLINGDATE,                  -- Billing Date [FKDAT]
    DUMMY_AVSOITM_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    COMPANYCODE,                  -- Company Code [BUKRS]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More