CFIN_AVSO_DOCE

Transparent Table Temporary Data
29 Fields 1 CDS Views

CFin Rpld Sales Document (API)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CFinRpldSalesDocument view_entity from CONSUMPTION CFin Rpld Sales Document (API)

Fields (29)

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
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
isdeleted FINS_CFIN_AV_ISDELETED Logically Deleted
referencesddocument VGBEL Reference Doc.
referencesddocumentcategory VBTYPL Document Cat.
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
billingcompanycode BUKRS_VF CCodeToBeBilled
creationdate FIS_CPDAT Creation Date
sddocumentcategory VBTYPL Document Cat.
salesordertype SALES_ORDER_TYPE Sales Order Type
costcenter FIS_KOSTL Cost Center
transactioncurrency FIS_RWCUR Transaction Currency
lastchangedate AEDAT Changed On
createdbyuser VDM_CREATEDBYUSERID Created By
salesorderdate AUDAT Document Date
totalnetamount NETWR_AK Net Value
salesgroup VKGRP Sales Group
salesoffice VKBUR Sales Office
taxdeparturecountry LANDTX Tax Depar. C/R
soldtoparty KUNAG Sold-to Party
organizationdivision SPART Division
pricingdate PRSDT Pricing Date
additionalvaluedays VALTG Add. Value Days
billingdate FKDAT Billing Date
dummy_avso_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.

-- CFin Rpld Sales Document (API)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVSO_DOCE (
    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]
    LASTCHANGEDATETIME,           -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    ISDELETED,                    -- Logically Deleted [FINS_CFIN_AV_ISDELETED]
    REFERENCESDDOCUMENT,          -- Reference Doc. [VGBEL]
    REFERENCESDDOCUMENTCATEGORY,  -- Document Cat. [VBTYPL]
    SALESORGANIZATION,            -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,          -- Distr. Channel [VTWEG]
    BILLINGCOMPANYCODE,           -- CCodeToBeBilled [BUKRS_VF]
    CREATIONDATE,                 -- Creation Date [FIS_CPDAT]
    SDDOCUMENTCATEGORY,           -- Document Cat. [VBTYPL]
    SALESORDERTYPE,               -- Sales Order Type [SALES_ORDER_TYPE]
    COSTCENTER,                   -- Cost Center [FIS_KOSTL]
    TRANSACTIONCURRENCY,          -- Transaction Currency [FIS_RWCUR]
    LASTCHANGEDATE,               -- Changed On [AEDAT]
    CREATEDBYUSER,                -- Created By [VDM_CREATEDBYUSERID]
    SALESORDERDATE,               -- Document Date [AUDAT]
    TOTALNETAMOUNT,               -- Net Value [NETWR_AK]
    SALESGROUP,                   -- Sales Group [VKGRP]
    SALESOFFICE,                  -- Sales Office [VKBUR]
    TAXDEPARTURECOUNTRY,          -- Tax Depar. C/R [LANDTX]
    SOLDTOPARTY,                  -- Sold-to Party [KUNAG]
    ORGANIZATIONDIVISION,         -- Division [SPART]
    PRICINGDATE,                  -- Pricing Date [PRSDT]
    ADDITIONALVALUEDAYS,          -- Add. Value Days [VALTG]
    BILLINGDATE,                  -- Billing Date [FKDAT]
    DUMMY_AVSO_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More