_HEADER

_HEADER is an SAP database table in S/4HANA. It contains 115 fields.

Fields (115)

KeyField CDS FieldsUsed in Views
KEY CN_GoldenTaxCombinationID CN_GoldenTaxCombinationID 2
KEY CN_GoldenTaxDocument CN_GoldenTaxDocument 2
KEY EWMWarehouse EWMWarehouse 1
KEY HandlingUnitNumber HandlingUnitNumber 1
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentYear MaterialDocumentYear 1
KEY ReferenceDocumentContext ReferenceDocumentContext 4
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 4
KEY ReferenceDocumentType ReferenceDocumentType 5
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocument AccountingDocument 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
blart EarmarkedFundsDocumentType 1
bltyp EarmarkedFundsDocumentCategory 1
budat PostingDate 1
bukrs CompanyCode 1
CAAuthorizationGroup CAAuthorizationGroup 1
CapacityLastChangeDateTime CapacityLastChangeDateTime 1
CAReversalDocumentNumber CAReversalDocumentNumber 1
CAStandardCompanyCode CAStandardCompanyCode 1
ChangeDocChangeType ChangeDocChangeType 3
ChangeDocLanguage ChangeDocLanguage 3
ChangeHistoryCount ChangeHistoryCount 1
ChangeTransactionCode ChangeTransactionCode 3
check_category check_category 1
CombinedAcctStatusText CombinedAcctStatusText 1
CombinedAcctStsCritlty CombinedAcctStsCritlty 1
CombinedHdrStatusText CombinedHdrStatusText 1
CombinedHdrStsCritlty CombinedHdrStsCritlty 1
CombinedMktgStatusCritlty CombinedMktgStatusCritlty 1
CombinedMktgStatusText CombinedMktgStatusText 1
CombinedOwnrStatusText CombinedOwnrStatusText 1
CombinedOwnrStsCritlty CombinedOwnrStsCritlty 1
CombinedTaxStatusText CombinedTaxStatusText 1
CombinedTaxStsCritlty CombinedTaxStsCritlty 1
CompanyCode CompanyCode,CompanyCodeForEdit 8
CompanyCodeCurrency CompanyCodeCurrency 1
context_suplr_cat RespyMgmtRespyCntxtSupplierCat 1
contexttype ResponsibilityContextType 1
ControllingAreaForEdit ControllingAreaForEdit 1
CreatedByUser CreatedByUser 29
CreationDate CreationDate 24
CreationTime CreationTime 6
Currency Currency,TransactionCurrency 2
Customer SoldToParty 1
CustomsDeclarationDate CustomsDeclarationDate,ForEditCustomsDeclarationDate 1
DeliveryNetworkName DeliveryNetworkName 5
DocumentDate DocumentDate 4
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 2
fikrs FinancialManagementArea 1
FiscalYearForEdit FiscalYearForEdit 1
GrantCurrency GrantCurrency 3
GranteeMgmtApprovalDate GranteeMgmtApprovalDate 3
GranteeMgmtApprovalTime GranteeMgmtApprovalTime 3
GranteeMgmtBudgetingProcess GranteeMgmtBudgetingProcess 3
GranteeMgmtBudgetReason GranteeMgmtBudgetReason 3
GranteeMgmtBudgetStatus GranteeMgmtBudgetStatus 3
GranteeMgmtBudgetVersion GranteeMgmtBudgetVersion 3
GranteeMgmtBudgetVersionOrigin GranteeMgmtBudgetVersionOrigin 3
GranteeMgmtWorkflowStatus GranteeMgmtWorkflowStatus 3
GrantID GrantID 3
GteeMBdgtEntryDocRvslStatus GteeMBdgtEntryDocRvslStatus 3
GteeMBudgetEntryDocOrigin GteeMBudgetEntryDocOrigin 3
GteeMBudgetEntryDocStatus GteeMBudgetEntryDocStatus 3
GteeMBudgetEntryDocumentDesc GteeMBudgetEntryDocumentDesc 3
GteeMBudgetEntryDocumentType GteeMBudgetEntryDocumentType 3
GteeMRvslRefBudgetEntryDoc GteeMRvslRefBudgetEntryDoc 3
hwaer CompanyCodeCurrency 1
IncotermsVersion IncotermsVersion 2
InventoryTransactionType InventoryTransactionType 1
InvtryMgmtReferenceDocument ReferenceDocument 1
IsSettled IsSettled 1
kokrs ControllingArea 1
LedgerGroup LedgerGroup 3
LocalCurrency LocalCurrency 2
Lockbox Lockbox 1
LogicalSystem LogicalSystem 3
MasterProject MasterProject 1
MasterProjectIsConfidential MasterProjectIsConfidential 1
MasterProjectOrganization MasterProjectOrganization 1
MasterProjectType MasterProjectType 1
MaterialDocumentHeaderText MaterialDocumentHeaderText 1
mod_timestamp HCMTimeEventModifDateTime 1
name piece_list_name 1
OriginalReferenceDocument OriginalReferenceDocument 2
PaymentTerms PaymentTerms 2
PayrollCurrency PayrollCurrency 1
Plant Plant 1
PostingDate PostingDate 5
ProductionPlant ProductionPlant 1
ProjectUUID MasterProjectUUID 1
PurchaseOrderDate PurchaseOrderDate 2
PurchaseOrderType PurchaseOrderType 2
PurchasingDocumentStatus PurchasingDocumentStatus 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
ReferenceDocument ReferenceDocument 3
RU_CustomsDeclaration RU_CustomsDeclaration,RU_CustomsDeclarationForEdit 1
RU_CustomsDeclarationOrigin RU_CustomsDeclarationOrigin,RU_CustomsDeclnOriginForEdit 1
RU_CustomsDeclarationType RU_CustomsDeclarationType,RU_CustomsDeclnTypeForEdit 1
RU_EntryCustomsOffice RU_EntryCustomsOffice,RU_EntryCustomsOfficeForEdit 1
status HCMTimeEventStatus 1
Supplier Supplier,SupplierForEdit 3
SupplierAuthznGrp SupplierAuthznGrp 1
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 1
TaxReportingDate TaxReportingDate 1
TransactionCode TransactionCode 1
transactiontype headerTransactionType 2
UnitOfMeasure UnitOfMeasure 1
version_no HCMTimeRequestVersion 1
waers TransactionCurrency 2
WorkCenter WorkCenter 2
WorkCenterCategoryCode WorkCenterCategoryCode 1
workitem_id HCMTimeEventInstanceID 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 _HEADER (
    CN_GOLDENTAXCOMBINATIONID,
    CN_GOLDENTAXDOCUMENT,
    EWMWAREHOUSE,
    HANDLINGUNITNUMBER,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    BLART,
    BLTYP,
    BUDAT,
    BUKRS,
    CAAUTHORIZATIONGROUP,
    CAPACITYLASTCHANGEDATETIME,
    CAREVERSALDOCUMENTNUMBER,
    CASTANDARDCOMPANYCODE,
    CHANGEDOCCHANGETYPE,
    CHANGEDOCLANGUAGE,
    CHANGEHISTORYCOUNT,
    CHANGETRANSACTIONCODE,
    CHECK_CATEGORY,
    COMBINEDACCTSTATUSTEXT,
    COMBINEDACCTSTSCRITLTY,
    COMBINEDHDRSTATUSTEXT,
    COMBINEDHDRSTSCRITLTY,
    COMBINEDMKTGSTATUSCRITLTY,
    COMBINEDMKTGSTATUSTEXT,
    COMBINEDOWNRSTATUSTEXT,
    COMBINEDOWNRSTSCRITLTY,
    COMBINEDTAXSTATUSTEXT,
    COMBINEDTAXSTSCRITLTY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTEXT_SUPLR_CAT,
    CONTEXTTYPE,
    CONTROLLINGAREAFOREDIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CURRENCY,
    CUSTOMER,
    CUSTOMSDECLARATIONDATE,
    DELIVERYNETWORKNAME,
    DOCUMENTDATE,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FIKRS,
    FISCALYEARFOREDIT,
    GRANTCURRENCY,
    GRANTEEMGMTAPPROVALDATE,
    GRANTEEMGMTAPPROVALTIME,
    GRANTEEMGMTBUDGETINGPROCESS,
    GRANTEEMGMTBUDGETREASON,
    GRANTEEMGMTBUDGETSTATUS,
    GRANTEEMGMTBUDGETVERSION,
    GRANTEEMGMTBUDGETVERSIONORIGIN,
    GRANTEEMGMTWORKFLOWSTATUS,
    GRANTID,
    GTEEMBDGTENTRYDOCRVSLSTATUS,
    GTEEMBUDGETENTRYDOCORIGIN,
    GTEEMBUDGETENTRYDOCSTATUS,
    GTEEMBUDGETENTRYDOCUMENTDESC,
    GTEEMBUDGETENTRYDOCUMENTTYPE,
    GTEEMRVSLREFBUDGETENTRYDOC,
    HWAER,
    INCOTERMSVERSION,
    INVENTORYTRANSACTIONTYPE,
    INVTRYMGMTREFERENCEDOCUMENT,
    ISSETTLED,
    KOKRS,
    LEDGERGROUP,
    LOCALCURRENCY,
    LOCKBOX,
    LOGICALSYSTEM,
    MASTERPROJECT,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTTYPE,
    MATERIALDOCUMENTHEADERTEXT,
    MOD_TIMESTAMP,
    NAME,
    ORIGINALREFERENCEDOCUMENT,
    PAYMENTTERMS,
    PAYROLLCURRENCY,
    PLANT,
    POSTINGDATE,
    PRODUCTIONPLANT,
    PROJECTUUID,
    PURCHASEORDERDATE,
    PURCHASEORDERTYPE,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REFERENCEDOCUMENT,
    RU_CUSTOMSDECLARATION,
    RU_CUSTOMSDECLARATIONORIGIN,
    RU_CUSTOMSDECLARATIONTYPE,
    RU_ENTRYCUSTOMSOFFICE,
    STATUS,
    SUPPLIER,
    SUPPLIERAUTHZNGRP,
    SUPPLIERCOMPANYAUTHZNGROUP,
    TAXREPORTINGDATE,
    TRANSACTIONCODE,
    TRANSACTIONTYPE,
    UNITOFMEASURE,
    VERSION_NO,
    WAERS,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKITEM_ID,
    PRIMARY KEY (CN_GOLDENTAXCOMBINATIONID, CN_GOLDENTAXDOCUMENT, EWMWAREHOUSE, HANDLINGUNITNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTTYPE)
);