HEADER

167 Fields

HEADER is an SAP database table in S/4HANA. It contains 167 fields.

Fields (167)

KeyField CDS FieldsUsed in Views
KEY acc_id acc_id,BankAccountInternalID 2
KEY AccountID AccountID 8
KEY bname bname 1
KEY CompanyCode CompanyCode 9
KEY EndDate EndDate 1
KEY EngSnapshotID EngSnapshotID 1
KEY entity_name entity_name 1
KEY FinancialStatementHierarchy FinancialStatementHierarchy 1
KEY FiscalYear FiscalYear 1
KEY PurchasingHistoryDocument PurchasingHistoryDocument 1
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear 1
KEY StartDate StartDate 1
KEY state state 1
KEY tkonn TradingContractNumber 2
_CompanyCode _CompanyCode 1
abwae abwae 1
acc_num acc_num,BankAccountNumber 2
acc_type_id acc_type_id 1
AccountHolder AccountHolder 1
AccountNumber AccountNumber 7
AccountSupervisor AccountSupervisor 1
AccountType AccountType 1
AccountValidTo AccountValidTo 3
aedat CreationDate,TradingContractChangedOnDate 3
aenam TradingContractChangedBy 2
azdat azdat 1
bank_contact bank_contact 1
BankAccountCurrency BankAccountCurrency 4
BankAccountDescription BankAccountDescription 3
BankAddressNo BankAddressNo 4
BankContact BankContact 1
BankCountry BankCountry 8
BankCountryDesp BankCountryDesp 1
BankKey BankKey 8
bankl Bank,bankl 3
bankn bankn 1
BankName BankName 5
banks BankCountry,banks,land1 4
BankStatementUpload BankStatementUpload 1
bedat PurchaseOrderDate 1
beneficial beneficial 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
bnkn2 bnkn2 1
btbsta ContractStatus 2
bukrs bukrs 3
BusinessArea BusinessArea 1
CashToleranceGroup CashToleranceGroup 1
CentralBAMAccount CentralBAMAccount 1
ChangedAtDate ChangedAtDate 1
ChangedAtTime ChangedAtTime 1
ChangedBy ChangedBy 1
ClosedAtDate ClosedAtDate 1
ClosedAtTime ClosedAtTime 1
ClosedBy ClosedBy 1
company_code CompanyCode 2
CompanyAddressNo CompanyAddressNo 4
CompanyCodeDesp CompanyCodeDesp 6
CompanyContact CompanyContact 1
CompanyCountry CompanyCountry 3
ContractAccount GrantorDocumentContractAccount 3
ControlKey ControlKey 4
CreatedAtDate CreatedAtDate 1
CreatedAtTime CreatedAtTime 1
CreatedBy CreatedBy 1
CreatedByUser DocumentCreatedByUser 3
CreationDateTime creationdatetime,DocumentCreationDateTime 4
Currency Currency 2
CutOffCrossBorder CutOffCrossBorder 1
CutOffDomestic CutOffDomestic 1
ddl_name ddl_name 1
DocumentDescription DocumentDescription 3
DocumentEndDate DocumentEndDate 3
DocumentEndDateTime DocumentEndDateTime 3
DocumentStartDate DocumentStartDate 3
DocumentStartDateTime DocumentStartDateTime 3
dtaai dtaai 1
ekorg PurchasingOrganization 2
employee_id employee_id 1
EngSnapshotName EngSnapshotName 1
entity_name_raw view_name 1
EoDImort EoDImort 1
erdat DocumentDate 2
ernam TradingContractCreatedBy 2
fdgrp fdgrp 1
GrantorAgreementStatus GrantorAgreementStatus 1
GrantorAgreementType GrantorAgreementType 1
GrantorAgreementUUID GrantorAgreementUUID 1
GrantorApplicationStatus GrantorApplicationStatus 1
GrantorApplicationType GrantorApplicationType 1
GrantorApplicationUUID GrantorApplicationUUID 1
GrantorClaimStatus GrantorClaimStatus 1
GrantorClaimType GrantorClaimType 1
GrantorClaimUUID GrantorClaimUUID 1
GrantorDocumentIsCancelled GrantorDocumentIsCancelled 3
gsber gsber 1
HasError DocumentHasError 3
hbid1 hbid1 1
hbid2 hbid2 1
hbkid hbkid 2
HierarchyID hierarchy 1
HierAttributeRangeFromVal aging 2
hkid1 hkid1 1
hkid2 hkid2 1
hkont hkont 1
hktid hktid 2
HouseBankCompanyCode HouseBankCompanyCode 1
HouseBankCompanyCodeDesp HouseBankCompanyCodeDesp 1
iban iban 6
ImportingChannel ImportingChannel 1
IntradayImport IntradayImport 1
IntradayIsReconciled IntradayIsReconciled 1
IsOpen DocumentIsOpen 3
IsRejected DocumentIsRejected 3
IsReleased DocumentIsReleased 3
label_text view_text 1
Language GrantorDocumentLanguage 3
LastChangeDateTime DocumentLastChangeDateTime 3
LastChangedByUser DocumentLastChangedByUser 3
lifnr Supplier 1
Linkage_bukrs Linkage_bukrs 1
Linkage_hbkid Linkage_hbkid 1
Linkage_herku Linkage_herku 1
Linkage_hktid Linkage_hktid 1
Linkage_remoteaccount Linkage_remoteaccount 1
Linkage_valid_from Linkage_valid_from 1
Linkage_valid_to Linkage_valid_to 1
MasterProject MasterProject 2
MasterProjectIsConfidential MasterProjectIsConfidential 5
MasterProjectOrganization MasterProjectOrganization 5
MasterProjectType MasterProjectType 5
Material Material 1
mindt mindt 1
OpenedAtDate OpenedAtDate 1
OpenedAtTime OpenedAtTime 1
OpenedBy OpenedBy 1
PlannedClosingDate PlannedClosingDate 1
Plant Plant 1
PostingDate DocumentPostingDate 3
PRAFundsTransferIsSimulated PRAFundsTransferIsSimulated 1
prctr prctr 1
ProfitCenter ProfitCenter 1
ProjectUUID MasterProjectUUID,ProjectUUID 4
refzl refzl 1
RelationshipManager RelationshipManager 1
ReverseDocument ReverseDocument 1
sdwrs TradingContractCurrency 2
segment segment 2
source_origin source_origin 1
sourcingprojectquotation headerID 1
spart Division 2
SpecificationInternalID SpecificationInternalID 1
Status BankAccountStatus,Status 3
StatusDesp StatusDesp 1
tctyp TradingContractType 2
tkonn_ex TradingContractExternalID 2
tksachb PersonResponsible 2
UploadBSFlag UploadBSFlag 1
valid_from valid_from 2
valid_to valid_to 1
ValidFrom ValidFrom 1
ValidTo ValidTo 1
vkorg SalesOrganization 2
vtweg DistributionChannel 2
waers DocumentCurrency,waers 2
wekon wekon 1
wikon wikon 1
wkkon wkkon 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 (
    ACC_ID,
    ACCOUNTID,
    BNAME,
    COMPANYCODE,
    ENDDATE,
    ENGSNAPSHOTID,
    ENTITY_NAME,
    FINANCIALSTATEMENTHIERARCHY,
    FISCALYEAR,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTYEAR,
    STARTDATE,
    STATE,
    TKONN,
    _COMPANYCODE,
    ABWAE,
    ACC_NUM,
    ACC_TYPE_ID,
    ACCOUNTHOLDER,
    ACCOUNTNUMBER,
    ACCOUNTSUPERVISOR,
    ACCOUNTTYPE,
    ACCOUNTVALIDTO,
    AEDAT,
    AENAM,
    AZDAT,
    BANK_CONTACT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTDESCRIPTION,
    BANKADDRESSNO,
    BANKCONTACT,
    BANKCOUNTRY,
    BANKCOUNTRYDESP,
    BANKKEY,
    BANKL,
    BANKN,
    BANKNAME,
    BANKS,
    BANKSTATEMENTUPLOAD,
    BEDAT,
    BENEFICIAL,
    BILLOFMATERIALVARIANTUSAGE,
    BNKN2,
    BTBSTA,
    BUKRS,
    BUSINESSAREA,
    CASHTOLERANCEGROUP,
    CENTRALBAMACCOUNT,
    CHANGEDATDATE,
    CHANGEDATTIME,
    CHANGEDBY,
    CLOSEDATDATE,
    CLOSEDATTIME,
    CLOSEDBY,
    COMPANY_CODE,
    COMPANYADDRESSNO,
    COMPANYCODEDESP,
    COMPANYCONTACT,
    COMPANYCOUNTRY,
    CONTRACTACCOUNT,
    CONTROLKEY,
    CREATEDATDATE,
    CREATEDATTIME,
    CREATEDBY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENCY,
    CUTOFFCROSSBORDER,
    CUTOFFDOMESTIC,
    DDL_NAME,
    DOCUMENTDESCRIPTION,
    DOCUMENTENDDATE,
    DOCUMENTENDDATETIME,
    DOCUMENTSTARTDATE,
    DOCUMENTSTARTDATETIME,
    DTAAI,
    EKORG,
    EMPLOYEE_ID,
    ENGSNAPSHOTNAME,
    ENTITY_NAME_RAW,
    EODIMORT,
    ERDAT,
    ERNAM,
    FDGRP,
    GRANTORAGREEMENTSTATUS,
    GRANTORAGREEMENTTYPE,
    GRANTORAGREEMENTUUID,
    GRANTORAPPLICATIONSTATUS,
    GRANTORAPPLICATIONTYPE,
    GRANTORAPPLICATIONUUID,
    GRANTORCLAIMSTATUS,
    GRANTORCLAIMTYPE,
    GRANTORCLAIMUUID,
    GRANTORDOCUMENTISCANCELLED,
    GSBER,
    HASERROR,
    HBID1,
    HBID2,
    HBKID,
    HIERARCHYID,
    HIERATTRIBUTERANGEFROMVAL,
    HKID1,
    HKID2,
    HKONT,
    HKTID,
    HOUSEBANKCOMPANYCODE,
    HOUSEBANKCOMPANYCODEDESP,
    IBAN,
    IMPORTINGCHANNEL,
    INTRADAYIMPORT,
    INTRADAYISRECONCILED,
    ISOPEN,
    ISREJECTED,
    ISRELEASED,
    LABEL_TEXT,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LIFNR,
    LINKAGE_BUKRS,
    LINKAGE_HBKID,
    LINKAGE_HERKU,
    LINKAGE_HKTID,
    LINKAGE_REMOTEACCOUNT,
    LINKAGE_VALID_FROM,
    LINKAGE_VALID_TO,
    MASTERPROJECT,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTTYPE,
    MATERIAL,
    MINDT,
    OPENEDATDATE,
    OPENEDATTIME,
    OPENEDBY,
    PLANNEDCLOSINGDATE,
    PLANT,
    POSTINGDATE,
    PRAFUNDSTRANSFERISSIMULATED,
    PRCTR,
    PROFITCENTER,
    PROJECTUUID,
    REFZL,
    RELATIONSHIPMANAGER,
    REVERSEDOCUMENT,
    SDWRS,
    SEGMENT,
    SOURCE_ORIGIN,
    SOURCINGPROJECTQUOTATION,
    SPART,
    SPECIFICATIONINTERNALID,
    STATUS,
    STATUSDESP,
    TCTYP,
    TKONN_EX,
    TKSACHB,
    UPLOADBSFLAG,
    VALID_FROM,
    VALID_TO,
    VALIDFROM,
    VALIDTO,
    VKORG,
    VTWEG,
    WAERS,
    WEKON,
    WIKON,
    WKKON,
    PRIMARY KEY (ACC_ID, ACCOUNTID, BNAME, COMPANYCODE, ENDDATE, ENGSNAPSHOTID, ENTITY_NAME, FINANCIALSTATEMENTHIERARCHY, FISCALYEAR, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTYEAR, STARTDATE, STATE, TKONN)
);

Learn More