_DOCHEADER

19 Fields

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

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CAReversalDocumentNumber CAReversalDocumentNumber 3
_DocOriginCode _DocOriginCode 1
CAApplicationArea CAApplicationArea 5
CADocumentOriginCode CADocumentOriginCode 6
CADocumentOriginCodeName CADocumentOriginCodeName 1
CADocumentType CADocumentType 7
CAPostingDate CAPostingDate 7
CAReconciliationKey CAReconciliationKey 5
CAReferenceDocument CAReferenceDocument 6
CAReversedDocumentNumber CAReversedDocumentNumber 1
CATaxCompanyCode CATaxCompanyCode 4
CreatedByUser CreatedByUser 4
CreationDate CreationDate 6
CreationTime CreationTime 2
DocumentDate DocumentDate 6
LogicalSystem LogicalSystem 1
OriginalReferenceDocument OriginalReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 1
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 (
    CAREVERSALDOCUMENTNUMBER,
    _DOCORIGINCODE,
    CAAPPLICATIONAREA,
    CADOCUMENTORIGINCODE,
    CADOCUMENTORIGINCODENAME,
    CADOCUMENTTYPE,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CAREVERSEDDOCUMENTNUMBER,
    CATAXCOMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTDATE,
    LOGICALSYSTEM,
    ORIGINALREFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CAREVERSALDOCUMENTNUMBER)
);

Learn More