_DOCHEADER

20 Fields

_DOCHEADER is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CAPostingDate CAPostingDate,PostingDate 10
KEY CAReferenceDocument CAReferenceDocument 7
KEY DocumentDate DocumentDate 10
_DocOriginCode _DocOriginCode 1
CAApplicationArea CAApplicationArea 5
CADocumentOriginCode CADocumentOriginCode 6
CADocumentType CADocumentType 8
CAReconciliationKey CAReconciliationKey 6
CAReversalDocumentNumber CAReversalDocumentNumber 4
CAReversedDocumentNumber CAReversedDocumentNumber 3
CATaxCompanyCode CATaxCompanyCode 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 5
CreationTime CreationTime 2
LogicalSystem LogicalSystem 1
OriginalReferenceDocument OriginalReferenceDocument 3
ReferenceDocumentType ReferenceDocumentType 1
TaxFulfillmentDate TaxFulfillmentDate 2
TaxReportingDate TaxReportingDate 3
TransactionCurrency DocumentOpenItemCurrency,TransactionCurrency 4

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 _DOCHEADER (
    CAPOSTINGDATE,
    CAREFERENCEDOCUMENT,
    DOCUMENTDATE,
    _DOCORIGINCODE,
    CAAPPLICATIONAREA,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CARECONCILIATIONKEY,
    CAREVERSALDOCUMENTNUMBER,
    CAREVERSEDDOCUMENTNUMBER,
    CATAXCOMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    LOGICALSYSTEM,
    ORIGINALREFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    TAXFULFILLMENTDATE,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CAPOSTINGDATE, CAREFERENCEDOCUMENT, DOCUMENTDATE)
);

Learn More