CFIN_AVCI_DOCE

Transparent Table Temporary Data

CFin Rpld Billing Document (API)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CFinRpldBillingDocument view_entity from CONSUMPTION CFin Rpld Billing Document (API)

Fields (22)

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
soldtoparty KUNAG Sold-to Party
sddocumentcategory VBTYPL Document Cat.
creationdate ERDAT Created On
companycode BUKRS Company Code
cancelledbillingdocument SFAKN Canceld Bill.Dc
billingdocumentdate FKDAT Billing Date
transactioncurrency WAERK Doc. Currency
accountingexchangerate KURRF Exch.Rate Acct.
payerparty KUNRG Payer
taxdeparturecountry LANDTX Tax Depar. C/R
exchangeratedate WWERT_D Translatn Date
billingdocumentiscancelled FKSTO Canceled
vatregistrationorigin STCEG_H OriginSlsTxNo.
billingdocumentcategory FKTYP BillingCategory
isdeleted FINS_CFIN_AV_ISDELETED Logically Deleted
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
billtoparty KUNRE Bill-to Party
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.

-- CFin Rpld Billing Document (API)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVCI_DOCE (
    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]
    SOLDTOPARTY,                    -- Sold-to Party [KUNAG]
    SDDOCUMENTCATEGORY,             -- Document Cat. [VBTYPL]
    CREATIONDATE,                   -- Created On [ERDAT]
    COMPANYCODE,                    -- Company Code [BUKRS]
    CANCELLEDBILLINGDOCUMENT,       -- Canceld Bill.Dc [SFAKN]
    BILLINGDOCUMENTDATE,            -- Billing Date [FKDAT]
    TRANSACTIONCURRENCY,            -- Doc. Currency [WAERK]
    ACCOUNTINGEXCHANGERATE,         -- Exch.Rate Acct. [KURRF]
    PAYERPARTY,                     -- Payer [KUNRG]
    TAXDEPARTURECOUNTRY,            -- Tax Depar. C/R [LANDTX]
    EXCHANGERATEDATE,               -- Translatn Date [WWERT_D]
    BILLINGDOCUMENTISCANCELLED,     -- Canceled [FKSTO]
    VATREGISTRATIONORIGIN,          -- OriginSlsTxNo. [STCEG_H]
    BILLINGDOCUMENTCATEGORY,        -- BillingCategory [FKTYP]
    ISDELETED,                      -- Logically Deleted [FINS_CFIN_AV_ISDELETED]
    LASTCHANGEDATETIME,             -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    BILLTOPARTY,                    -- Bill-to Party [KUNRE]
    DUMMY_AVCI_INCL_EEW_PS,         -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, AV_DBKEY)
);