_CADOCUMENT

18 Fields

_CADOCUMENT is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CAReversalDocumentNumber CAReversalDocumentNumber 5
_CADocumentOriginCode _CADocumentOriginCode 1
CAApplicationArea CAApplicationArea 4
CADocumentNumber CADocumentNumber 3
CADocumentOriginCode CADocumentOriginCode 7
CADocumentType CADocumentType 6
CAPostingDate CAPostingDate,PostingDate 9
CAReconciliationKey CAReconciliationKey 9
CAReferenceDocument CAReferenceDocument 4
CAReversedDocumentNumber CAReversedDocumentNumber 2
CATaxCompanyCode CATaxCompanyCode 4
CreatedByUser CreatedByUser 6
CreationDate CreationDate 7
CreationTime CreationTime 1
DocumentDate DocumentDate 2
OriginalReferenceDocument OriginalReferenceDocument 1
TaxReportingDate TaxReportingDate 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CADOCUMENT (
    CAREVERSALDOCUMENTNUMBER,
    _CADOCUMENTORIGINCODE,
    CAAPPLICATIONAREA,
    CADOCUMENTNUMBER,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CAREVERSEDDOCUMENTNUMBER,
    CATAXCOMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTDATE,
    ORIGINALREFERENCEDOCUMENT,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CAREVERSALDOCUMENTNUMBER)
);

Learn More