I_CADOCUMENT

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);