I_CADOCUMENT
Contract Accounting Document
I_CADOCUMENT is a CDS View in S/4HANA. Contract Accounting Document. It contains 59 fields. 64 CDS views read from this table.
CDS Views using this table (64)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CADocumentFlow | view_entity | from | CONSUMPTION | Contract Accounting Document Flow |
| C_CADocumentHeaderValueHelp | view | from | CONSUMPTION | Belegnummer |
| C_CADocumentReversal | view | from | CONSUMPTION | Reverse Document |
| C_CAReturnPaymentDocumentVH | view | from | CONSUMPTION | Payment Document auf Return Wertehilfer |
| C_RO_StRpDomesticSlsPurListC | view | left_outer | CONSUMPTION | Romania Domestic Sales and Purchase List - Cube |
| I_CAClarificationDocumentVH | view | from | COMPOSITE | Value Help for Clarification Document |
| I_CADisputeCaseFllwUpPosting | view | left_outer | COMPOSITE | Disputed Follow Up Posting Document |
| I_CADisputedDocument | view | inner | COMPOSITE | Documents in Dispute Cases |
| I_CADisputedPayment | view | left_outer | COMPOSITE | Disputed Payment |
| I_CADocumentCube | view_entity | from | COMPOSITE | Contract Accounting Document - Cube |
| I_CADocumentHeader | view | from | BASIC | Contract Accounting Document |
| I_CAInstallmentPlanVH | view_entity | from | COMPOSITE | Installment Plan Number |
| I_CAInterestNoticeHeader | view | from | COMPOSITE | View for Interest Notice Header Data |
| I_CANotDisputedClearedItem | view | inner | COMPOSITE | Not Disputed Cleared Items |
| I_CANotDisputedCredit | view | from | COMPOSITE | Not Disputed Credit |
| I_CANotDisputedOpenDoc | view | from | COMPOSITE | Not Disputed Open Doc |
| I_CANotDisputedOpenItem | view | inner | COMPOSITE | Not Disputed Open Items |
| I_CANotDisputedPayment | view | from | COMPOSITE | Not Disputed Payments |
| I_CAReturnDocumentValueHelp | view | from | COMPOSITE | Return Document Wertehilfer |
| I_CAReversalDocumentVH | view | from | COMPOSITE | Reversal Document |
| I_CAReversedDocumentVH | view | from | COMPOSITE | Reversed Document |
| I_CAScrtyDepRequestProcess | view_entity | left_outer | COMPOSITE | Document Process of a Specific Request |
| I_CASecurityDepositReqDoc | view_entity | left_outer | COMPOSITE | Security Deposit Request Document |
| I_CAWriteOffDocument | view_entity | from | COMPOSITE | Contract Accounting Write Off Document |
| I_CAWriteOffDocumentVH | view | from | COMPOSITE | Ausbuchungsbeleg |
| I_NL_SAFTBusinessPartner | view | inner | COMPOSITE | SAF-T NL Business Partner |
| I_PaytAdviceCADocumentVH | view | from | COMPOSITE | Payment Advice CA Payment Document |
| N_CADocument | view_entity | from | Contract Accounting Document | |
| P_BE_ANNSLSLISTCAITM | view_entity | from | CONSUMPTION | Domestic Sales List FI-CA Item |
| P_BE_ANNSLSLISTCANOTXGRPRVSL | view_entity | from | CONSUMPTION | Domestic Sales List FI-CA Reversal without Tax Grouping |
| P_BE_ANNSLSLISTCARVSLITM | view_entity | from | CONSUMPTION | Domestic Sales List FI-CA Reversal Item |
| P_BE_DomesticSalesListFica | view | union_all | CONSUMPTION | Domestic Sales List FICA view for BE |
| P_BOPDbtflRblsCARslt | view_entity | from | COMPOSITE | BOP Doubtful Receivables Contract Accounting Result |
| P_BOPFICA_BP_ITEM_2 | view_entity | from | COMPOSITE | FI-CA BP Item 2 |
| P_BOPFICA_BP_ITEM_2 | view_entity | union | COMPOSITE | FI-CA BP Item 2 |
| P_BOPFICA_BP_ITEM_2_OG | view_entity | from | COMPOSITE | FI-CA BP Item 2 Original Items |
| P_BOPFICA_BP_ITEM_2_REV | view_entity | from | COMPOSITE | FI-CA BP Item 2 Reversal Items |
| P_BOPFicaDoc0 | view | from | COMPOSITE | Analysis for BOP - FICA Document |
| P_CAAcctBalSmltdClrgBPItem | view_entity | inner | CONSUMPTION | Account Balance Simulated Clearing BP Items |
| P_CAClearingDocument | view | inner | COMPOSITE | Clearing Document |
| P_CACUSTTRIALBALITEM1 | view_entity | inner | COMPOSITE | CA Customer Trial Balance Item1 |
| P_CANotDisputedDocumentSum | view | inner | COMPOSITE | Not Disputed Document |
| P_CAStRpTaxItemWithSrcDoc | view_entity | inner | COMPOSITE | FICA Tax Item with Source Document |
| P_CATransferredDocumentHeader | view_entity | from | COMPOSITE | Trasferred document header |
| P_ContrAcctgBPItmPostdClrdRvsd | view_entity | from | COMPOSITE | BP line items: Posted, cleared, reversed |
| P_ContrAcctgBPItmPostdClrdRvsd | view_entity | union_all | COMPOSITE | BP line items: Posted, cleared, reversed |
| P_ContrAcctgGLItem | view_entity | from | COMPOSITE | FICA: GL Line Items |
| P_ContractAccountingLineItem | view | inner | CONSUMPTION | Items in Contract Accounting document |
| P_FR_AuditFECPaymentDocsInCA | view | inner | CONSUMPTION | France Audit FEC CA payment documents |
| P_GR_CustomerLedgerBasicItem | view_entity | inner | COMPOSITE | Greece Customer Ledger Basic Item |
| P_LU_SAFTContractAccBPItem1 | view_entity | from | COMPOSITE | LU SAFT Contract Account Business Partner Item 1 |
| P_LU_SAFTContractAccBPItem1 | view_entity | union_all | COMPOSITE | LU SAFT Contract Account Business Partner Item 1 |
| P_LU_SAFTContractAccBPItemCust | view_entity | from | COMPOSITE | LU SAFT Contract Account BP Item C |
| P_LU_SAFTContractAccBPItemCust | view_entity | union_all | COMPOSITE | LU SAFT Contract Account BP Item C |
| P_LU_SAFTContractAccGenLedItm1 | view_entity | from | COMPOSITE | LU SAFT Contract Account General Ledger Item 1 |
| P_NO_CADocumentBPItem | view_entity | inner | COMPOSITE | Norway Customer Line Item - CA BP Document Items |
| P_PT_CADocItmAnnex | view_entity | inner | CONSUMPTION | Contract Accounting Document Item for Portugal Annex O |
| P_PT_CAOpenItemSum | view_entity | inner | COMPOSITE | Portugal Contract Accounting Sum of Open Items |
| P_RO_SAFTCActgDocumentSrc0 | view_entity | from | CONSUMPTION | Source Document |
| P_SG_CAClrAmntCalc | view | inner | COMPOSITE | SG TL FICA Clearing Item Calc |
| P_SG_CAInvoiceTaxItem | view | inner | COMPOSITE | SG TL FICA Invoice Tax Item |
| P_SK_CADocumentSourceBase | view_entity | from | COMPOSITE | CA Document Source Base |
| R_CADocumentTP | view_entity | from | TRANSACTIONAL | Contract Accounting Document - TP |
| R_CADocumentTP_2 | view_entity | from | TRANSACTIONAL | Contract Accounting Document - TP |
Fields (59)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CADocumentNumber | CADocumentNumber,CAReversalDocumentNumber | 15 |
| KEY | CAReconciliationKey | CAReconciliationKey | 15 |
| _AccountingDocType | _AccountingDocType | 1 | |
| _CAApplicationArea | _ApplArea | 1 | |
| _CAClearingInformation | _CAClearingInformation | 1 | |
| _CADocTransactionClass | _CADocTransactionClass | 1 | |
| _CADocumentClass | _CADocumentClass | 1 | |
| _CADocumentOriginCode | _CADocumentOriginCode,_DocOriginCode | 3 | |
| _CADocumentSupplement | _CADocumentSupplement | 1 | |
| _CADocumentType | _DocType | 1 | |
| _CADocumentVersion | _CADocumentVersion | 1 | |
| _CAPostingReason | _CAPostingReason | 1 | |
| _CARequestedSpecialPeriod | _CARequestedSpecialPeriod | 1 | |
| _CAReturnReason | _CAReturnReason | 1 | |
| _CATaxSupplementStorageLoc | _CATaxSupplementStorageLoc | 1 | |
| _CAWorkflowCheckProcess | _WorkflowCheckProcess | 1 | |
| _CAWorkflowCheckReason | _WorkflowCheckReason | 1 | |
| _TransactionCurrency | _Currency | 1 | |
| CA1stCountrySpecificReference | CA1stCountrySpecificReference,IL_ElectronicDocOutgDocUnqID | 2 | |
| CAApplicationArea | CAApplicationArea | 8 | |
| CAClassificationKey | CAClassificationKey | 2 | |
| CAClearingInformation | CAClearingInformation | 1 | |
| CADocContainsCashFlowItems | CADocContainsCashFlowItems | 2 | |
| CADocumentClass | CADocumentClass | 2 | |
| CADocumentIsAged | CADocumentIsAged | 1 | |
| CADocumentOriginCode | CADocumentOriginCode | 10 | |
| CADocumentSupplements | CADocumentSupplements | 1 | |
| CADocumentTransactionClass | CADocumentTransactionClass | 1 | |
| CADocumentType | AccountingDocumentType,CADocumentType | 15 | |
| CADocumentTypeForGLTransfer | CADocumentTypeForGLTransfer | 3 | |
| CADocumentVersion | CADocumentVersion | 2 | |
| CAFirstCountrySpecificDate | CAFirstCountrySpecificDate | 1 | |
| CAInvoicingDocument | CAInvoicingDocument | 1 | |
| CAPostingDate | CAPostingDate,PostingDate,ReportingDate | 23 | |
| CAPostingReason | CAPostingReason | 1 | |
| CAReferenceDocument | CAReferenceDocument | 12 | |
| CARequestedPeriodForGLTransfer | CARequestedPeriodForGLTransfer | 1 | |
| CAReturnReason | CAReturnReason | 1 | |
| CAReversalDocumentNumber | CAReversalDocumentNumber | 9 | |
| CAReversedDocumentNumber | CAReversedDocumentNumber | 11 | |
| CASeparateDocIsCreatedInGL | CASeparateDocIsCreatedInGL | 2 | |
| CAStorageLocationOfTaxSuplmnt | CAStorageLocationOfTaxSuplmnt | 1 | |
| CATaxCodeWasExchanged | CATaxCodeWasExchanged | 1 | |
| CATaxCompanyCode | CATaxCompanyCode | 2 | |
| CAWorkflowCheckProcess | CAWorkflowCheckProcess | 1 | |
| CAWorkflowCheckReason | CAWorkflowCheckReason | 1 | |
| CreatedByUser | CreatedByUser | 14 | |
| CreationDate | CreationDate | 7 | |
| CreationTime | CreationTime | 4 | |
| DocumentDate | DocumentDate | 18 | |
| ExchangeRateDate | ExchangeRateDate | 1 | |
| IsIndividualPosting | IsIndividualPosting | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| LogicalSystem | LogicalSystem | 2 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 3 | |
| TaxFulfillmentDate | TaxFulfillmentDate | 1 | |
| TaxReportingDate | TaxReportingDate | 6 | |
| TransactionCurrency | TransactionCurrency | 2 |
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.
-- Contract Accounting Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADOCUMENT (
CADOCUMENTNUMBER,
CARECONCILIATIONKEY,
_ACCOUNTINGDOCTYPE,
_CAAPPLICATIONAREA,
_CACLEARINGINFORMATION,
_CADOCTRANSACTIONCLASS,
_CADOCUMENTCLASS,
_CADOCUMENTORIGINCODE,
_CADOCUMENTSUPPLEMENT,
_CADOCUMENTTYPE,
_CADOCUMENTVERSION,
_CAPOSTINGREASON,
_CAREQUESTEDSPECIALPERIOD,
_CARETURNREASON,
_CATAXSUPPLEMENTSTORAGELOC,
_CAWORKFLOWCHECKPROCESS,
_CAWORKFLOWCHECKREASON,
_TRANSACTIONCURRENCY,
CA1STCOUNTRYSPECIFICREFERENCE,
CAAPPLICATIONAREA,
CACLASSIFICATIONKEY,
CACLEARINGINFORMATION,
CADOCCONTAINSCASHFLOWITEMS,
CADOCUMENTCLASS,
CADOCUMENTISAGED,
CADOCUMENTORIGINCODE,
CADOCUMENTSUPPLEMENTS,
CADOCUMENTTRANSACTIONCLASS,
CADOCUMENTTYPE,
CADOCUMENTTYPEFORGLTRANSFER,
CADOCUMENTVERSION,
CAFIRSTCOUNTRYSPECIFICDATE,
CAINVOICINGDOCUMENT,
CAPOSTINGDATE,
CAPOSTINGREASON,
CAREFERENCEDOCUMENT,
CAREQUESTEDPERIODFORGLTRANSFER,
CARETURNREASON,
CAREVERSALDOCUMENTNUMBER,
CAREVERSEDDOCUMENTNUMBER,
CASEPARATEDOCISCREATEDINGL,
CASTORAGELOCATIONOFTAXSUPLMNT,
CATAXCODEWASEXCHANGED,
CATAXCOMPANYCODE,
CAWORKFLOWCHECKPROCESS,
CAWORKFLOWCHECKREASON,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
DOCUMENTDATE,
EXCHANGERATEDATE,
ISINDIVIDUALPOSTING,
LASTCHANGEDATE,
LOGICALSYSTEM,
ORIGINALREFERENCEDOCUMENT,
REFERENCEDOCUMENTTYPE,
TAXFULFILLMENTDATE,
TAXREPORTINGDATE,
TRANSACTIONCURRENCY,
PRIMARY KEY (CADOCUMENTNUMBER, CARECONCILIATIONKEY)
);
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