_CADOCUMENT

14 Fields

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

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CAReversalDocumentNumber CAReversalDocumentNumber 2
CAApplicationArea CAApplicationArea 2
CADocumentNumber CADocumentNumber 3
CADocumentOriginCode CADocumentOriginCode 2
CADocumentType CADocumentType 3
CAPostingDate CAPostingDate 5
CAReconciliationKey CAReconciliationKey 5
CAReferenceDocument CAReferenceDocument 2
CATaxCompanyCode CATaxCompanyCode 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
CreationTime CreationTime 1
DocumentDate DocumentDate 1
TransactionCurrency TransactionCurrency 1

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,
    CAAPPLICATIONAREA,
    CADOCUMENTNUMBER,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CATAXCOMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CAREVERSALDOCUMENTNUMBER)
);

Learn More