CFIN_AVCI_DOCE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CFinRpldBillingDocument | view_entity | from | CONSUMPTION | CFin Rpld Billing Document (API) |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA