_HEADER

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

Fields (161)

KeyField CDS FieldsUsed in Views
KEY CN_GoldenTaxCombinationID CN_GoldenTaxCombinationID 2
KEY CN_GoldenTaxDocument CN_GoldenTaxDocument 2
KEY CnsldtnPostingRuleLogUUID CnsldtnPostingRuleLogUUID 1
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 8
KEY SalesOrder SalesOrder 1
AbsoluteExchangeRate AbsoluteExchangeRate 3
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocument AccountingDocument 1
AccountingDocumentCategory AccountingDocumentCategory 3
AccountingDocumentHeaderText AccountingDocumentHeaderText 4
AccountingDocumentType AccountingDocumentType 3
AlternativeReferenceDocument AlternativeReferenceDocument 3
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
CmmdtyExpnCallingApplication CmmdtyExpnCallingApplication 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 12
CompanyCodeCurrency CompanyCodeCurrency 1
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
ConsolidationGroup ConsolidationGroup 1
ConsolidationTask ConsolidationTask 1
ConsolidationTaskRunIsTest ConsolidationTaskRunIsTest 1
ConsolidationTaskType ConsolidationTaskType 1
ConsolidationVersion ConsolidationVersion 1
context_suplr_cat RespyMgmtRespyCntxtSupplierCat 1
contexttype ResponsibilityContextType 1
ControllingAreaForEdit ControllingAreaForEdit 1
CreatedByUser CreatedByUser 30
CreationDate CreationDate 24
CreationDateTime CreationDateTime 1
CreationTime CreationTime 6
Currency Currency,TransactionCurrency 4
CurrencyIsHidden CurrencyIsHidden 1
Customer SoldToParty 1
CustomsDeclarationDate CustomsDeclarationDate,ForEditCustomsDeclarationDate 1
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
DeliveryNetworkName DeliveryNetworkName 5
DocumentDate DocumentDate 7
DocumentReferenceID DocumentReferenceID 3
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 2
fikrs FinancialManagementArea 1
FiscalPeriod FiscalPeriod 4
FiscalYear FiscalYear 1
FiscalYearForEdit FiscalYearForEdit 1
FiscalYearPeriod FiscalYearPeriod 1
GoodsMovementCode GoodsMovementCode 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
IsReversal IsReversal 3
IsReversed IsReversed 3
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 5
PaymentTerms PaymentTerms 2
PayrollCurrency PayrollCurrency 1
Plant Plant 1
PostingDate PostingDate 8
PRAAutoSuspensionLevel PRAAutoSuspensionLevel 2
ProductionPlant ProductionPlant 1
ProjectUUID MasterProjectUUID 1
PurchaseOrderDate PurchaseOrderDate 2
PurchaseOrderType PurchaseOrderType 2
PurchasingDocumentStatus PurchasingDocumentStatus 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
ReferenceDocument ReferenceDocument 3
ReverseDocument ReverseDocument 3
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 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
SenderAccountingDocument SenderAccountingDocument 3
SenderCompanyCode SenderCompanyCode 3
SenderFiscalYear SenderFiscalYear 3
SenderLogicalSystem SenderLogicalSystem 3
ServicePartsSelectionType ServicePartsSelectionType 1
status HCMTimeEventStatus 1
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 1
Supplier Supplier,SupplierForEdit 3
SupplierAccountGroup SupplierAccountGroup 1
SupplierAuthznGrp SupplierAuthznGrp 1
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 1
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd 1
TaxFulfillmentDate TaxFulfillmentDate 3
TaxReportingDate TaxReportingDate 4
TransactionCode TransactionCode 1
transactiontype headerTransactionType 2
UnitOfMeasure UnitOfMeasure 3
UnitOfMeasureIsHidden UnitOfMeasureIsHidden 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,
    CNSLDTNPOSTINGRULELOGUUID,
    EWMWAREHOUSE,
    HANDLINGUNITNUMBER,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    SALESORDER,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEREFERENCEDOCUMENT,
    BLART,
    BLTYP,
    BUDAT,
    BUKRS,
    CAAUTHORIZATIONGROUP,
    CAPACITYLASTCHANGEDATETIME,
    CAREVERSALDOCUMENTNUMBER,
    CASTANDARDCOMPANYCODE,
    CHANGEDOCCHANGETYPE,
    CHANGEDOCLANGUAGE,
    CHANGEHISTORYCOUNT,
    CHANGETRANSACTIONCODE,
    CHECK_CATEGORY,
    CMMDTYEXPNCALLINGAPPLICATION,
    COMBINEDACCTSTATUSTEXT,
    COMBINEDACCTSTSCRITLTY,
    COMBINEDHDRSTATUSTEXT,
    COMBINEDHDRSTSCRITLTY,
    COMBINEDMKTGSTATUSCRITLTY,
    COMBINEDMKTGSTATUSTEXT,
    COMBINEDOWNRSTATUSTEXT,
    COMBINEDOWNRSTSCRITLTY,
    COMBINEDTAXSTATUSTEXT,
    COMBINEDTAXSTSCRITLTY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONTASK,
    CONSOLIDATIONTASKRUNISTEST,
    CONSOLIDATIONTASKTYPE,
    CONSOLIDATIONVERSION,
    CONTEXT_SUPLR_CAT,
    CONTEXTTYPE,
    CONTROLLINGAREAFOREDIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CURRENCY,
    CURRENCYISHIDDEN,
    CUSTOMER,
    CUSTOMSDECLARATIONDATE,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELIVERYNETWORKNAME,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FIKRS,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARFOREDIT,
    FISCALYEARPERIOD,
    GOODSMOVEMENTCODE,
    GRANTCURRENCY,
    GRANTEEMGMTAPPROVALDATE,
    GRANTEEMGMTAPPROVALTIME,
    GRANTEEMGMTBUDGETINGPROCESS,
    GRANTEEMGMTBUDGETREASON,
    GRANTEEMGMTBUDGETSTATUS,
    GRANTEEMGMTBUDGETVERSION,
    GRANTEEMGMTBUDGETVERSIONORIGIN,
    GRANTEEMGMTWORKFLOWSTATUS,
    GRANTID,
    GTEEMBDGTENTRYDOCRVSLSTATUS,
    GTEEMBUDGETENTRYDOCORIGIN,
    GTEEMBUDGETENTRYDOCSTATUS,
    GTEEMBUDGETENTRYDOCUMENTDESC,
    GTEEMBUDGETENTRYDOCUMENTTYPE,
    GTEEMRVSLREFBUDGETENTRYDOC,
    HWAER,
    INCOTERMSVERSION,
    INVENTORYTRANSACTIONTYPE,
    INVTRYMGMTREFERENCEDOCUMENT,
    ISREVERSAL,
    ISREVERSED,
    ISSETTLED,
    KOKRS,
    LEDGERGROUP,
    LOCALCURRENCY,
    LOCKBOX,
    LOGICALSYSTEM,
    MASTERPROJECT,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTTYPE,
    MATERIALDOCUMENTHEADERTEXT,
    MOD_TIMESTAMP,
    NAME,
    ORIGINALREFERENCEDOCUMENT,
    PAYMENTTERMS,
    PAYROLLCURRENCY,
    PLANT,
    POSTINGDATE,
    PRAAUTOSUSPENSIONLEVEL,
    PRODUCTIONPLANT,
    PROJECTUUID,
    PURCHASEORDERDATE,
    PURCHASEORDERTYPE,
    PURCHASINGDOCUMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REFERENCEDOCUMENT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RU_CUSTOMSDECLARATION,
    RU_CUSTOMSDECLARATIONORIGIN,
    RU_CUSTOMSDECLARATIONTYPE,
    RU_ENTRYCUSTOMSOFFICE,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SERVICEPARTSSELECTIONTYPE,
    STATUS,
    SUPLRCOISBUSPRPSCMPLTD,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERAUTHZNGRP,
    SUPPLIERCOMPANYAUTHZNGROUP,
    SUPPLIERISBUSPRPSCMPLTD,
    TAXFULFILLMENTDATE,
    TAXREPORTINGDATE,
    TRANSACTIONCODE,
    TRANSACTIONTYPE,
    UNITOFMEASURE,
    UNITOFMEASUREISHIDDEN,
    VERSION_NO,
    WAERS,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKITEM_ID,
    PRIMARY KEY (CN_GOLDENTAXCOMBINATIONID, CN_GOLDENTAXDOCUMENT, CNSLDTNPOSTINGRULELOGUUID, EWMWAREHOUSE, HANDLINGUNITNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTTYPE, SALESORDER)
);