I_CADOCUMENT

CDS View
22 Fields 31 CDS Views

Contract Accounting Document

I_CADOCUMENT is a CDS View in S/4HANA. Contract Accounting Document. It contains 22 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
I_CADocumentCube view_entity from COMPOSITE Contract Accounting Document - Cube
I_CADocumentHeader view from BASIC Contract Accounting Document
I_CAWriteOffDocument view_entity from COMPOSITE Contract Accounting Write Off Document
I_NL_SAFTBusinessPartner view inner COMPOSITE SAF-T NL Business Partner
P_BE_ANNSLSLISTCAITM view_entity from CONSUMPTION
P_BE_ANNSLSLISTCANOTXGRPRVSL view_entity from CONSUMPTION
P_BE_ANNSLSLISTCARVSLITM view_entity from CONSUMPTION
P_BE_DomesticSalesListFica view union_all CONSUMPTION Domestic Sales List FICA view for BE
P_BOPDbtflRblsCARslt view_entity from COMPOSITE
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
P_BOPFICA_BP_ITEM_2_REV view_entity from COMPOSITE
P_CACUSTTRIALBALITEM1 view_entity inner COMPOSITE
P_CAStRpTaxItemWithSrcDoc view_entity inner COMPOSITE
P_CATransferredDocumentHeader view_entity from COMPOSITE
P_ContrAcctgBPItmPostdClrdRvsd view_entity from COMPOSITE
P_ContrAcctgBPItmPostdClrdRvsd view_entity union_all COMPOSITE
P_ContrAcctgGLItem view_entity from COMPOSITE
P_GR_CustomerLedgerBasicItem view_entity inner COMPOSITE
P_LU_SAFTContractAccBPItem1 view_entity from COMPOSITE
P_LU_SAFTContractAccBPItem1 view_entity union_all COMPOSITE
P_LU_SAFTContractAccBPItemCust view_entity from COMPOSITE
P_LU_SAFTContractAccBPItemCust view_entity union_all COMPOSITE
P_LU_SAFTContractAccGenLedItm1 view_entity from COMPOSITE
P_NO_CADocumentBPItem view_entity inner COMPOSITE
P_PT_CADocItmAnnex view_entity inner CONSUMPTION Contract Accounting Document Item for Portugal Annex O
P_PT_CAOpenItemSum view_entity inner COMPOSITE
P_RO_SAFTCActgDocumentSrc0 view_entity from CONSUMPTION
P_SK_CADocumentSourceBase view_entity from COMPOSITE
R_CADocumentTP view_entity from TRANSACTIONAL Contract Accounting Document - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber,CAReversalDocumentNumber 9
CA1stCountrySpecificReference CA1stCountrySpecificReference,IL_ElectronicDocOutgDocUnqID 2
CAApplicationArea CAApplicationArea 4
CADocumentOriginCode CADocumentOriginCode 1
CADocumentType AccountingDocumentType,CADocumentType 12
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 1
CAFirstCountrySpecificDate CAFirstCountrySpecificDate 1
CAInvoicingDocument CAInvoicingDocument 1
CAPostingDate CAPostingDate,PostingDate,ReportingDate 13
CAReconciliationKey CAReconciliationKey 7
CAReferenceDocument CAReferenceDocument 6
CAReversalDocumentNumber CAReversalDocumentNumber 2
CAReversedDocumentNumber CAReversedDocumentNumber 4
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
CreationTime CreationTime 2
DocumentDate DocumentDate 10
LastChangeDate LastChangeDate 2
LogicalSystem LogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 1
TaxFulfillmentDate TaxFulfillmentDate 1
TaxReportingDate TaxReportingDate 3

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,
    CA1STCOUNTRYSPECIFICREFERENCE,
    CAAPPLICATIONAREA,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CADOCUMENTTYPEFORGLTRANSFER,
    CAFIRSTCOUNTRYSPECIFICDATE,
    CAINVOICINGDOCUMENT,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CAREVERSALDOCUMENTNUMBER,
    CAREVERSEDDOCUMENTNUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTDATE,
    LASTCHANGEDATE,
    LOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    TAXFULFILLMENTDATE,
    TAXREPORTINGDATE,
    PRIMARY KEY (CADOCUMENTNUMBER)
);

Learn More