HEADER

174 Fields

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

Fields (174)

KeyField CDS FieldsUsed in Views
KEY acc_id acc_id,BankAccountInternalID 2
KEY AccountID AccountID 8
KEY AccountingDocument AccountingDocument 2
KEY bname bname 1
KEY CompanyCode CompanyCode 11
KEY EndDate EndDate 1
KEY EngSnapshotID EngSnapshotID 1
KEY entity_name entity_name 1
KEY FinancialStatementHierarchy FinancialStatementHierarchy 1
KEY FiscalYear FiscalYear 3
KEY Ledger Ledger 2
KEY PurchasingHistoryDocument PurchasingHistoryDocument 1
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear 1
KEY SourceLedger SourceLedger 2
KEY StartDate StartDate 1
KEY state state 1
_CompanyCode _CompanyCode 1
abwae abwae 1
acc_num acc_num,BankAccountNumber 2
acc_type_id acc_type_id 1
AccountHolder AccountHolder 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 2
AccountNumber AccountNumber 7
AccountSupervisor AccountSupervisor 1
AccountType AccountType 1
AccountValidTo AccountValidTo 3
aedat CreationDate 1
AlternativeReferenceDocument AlternativeReferenceDocument 2
azdat azdat,BankStatementDate 2
aznum BankStatement 1
azpgno BankStatementPageNumber 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
BG_SAFTInvoiceType BG_SAFTInvoiceType 2
BG_SAFTSystemID BG_SAFTSystemID 2
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
bnkn2 bnkn2 1
bukrs bukrs,CompanyCode 4
BusinessArea BusinessArea 1
BusinessTransactionTypeName BusinessTransactionTypeName 2
CashToleranceGroup CashToleranceGroup 1
CentralBAMAccount CentralBAMAccount 1
ChangedAtDate ChangedAtDate 1
ChangedAtTime ChangedAtTime 1
ChangedBy ChangedBy 1
CityName CityName 1
ClosedAtDate ClosedAtDate 1
ClosedAtTime ClosedAtTime 1
ClosedBy ClosedBy 1
CompanyAddressNo CompanyAddressNo 4
CompanyCodeDesp CompanyCodeDesp 6
CompanyContact CompanyContact 1
CompanyCountry CompanyCountry 3
ConditionSearchTermValue ConditionSearchTermValue 1
ConditionTable ConditionTable 1
ConditionValidityEndDate ConditionValidityEndDate 1
ConditionValidityStartDate ConditionValidityStartDate 1
ControlKey ControlKey 4
Country Country 1
CreatedAtDate CreatedAtDate 1
CreatedAtTime CreatedAtTime 1
CreatedBy CreatedBy 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
creationdatetime creationdatetime 1
Currency Currency 2
Customer Customer 1
CustomerCityName CustomerCityName 1
CustomerCountry CustomerCountry 1
CustomerPostalCode CustomerPostalCode 1
CustomerStreetName CustomerStreetName 1
CustomerTaxID5 CustomerTaxID5 1
CutOffCrossBorder CutOffCrossBorder 1
CutOffDomestic CutOffDomestic 1
ddl_name ddl_name 1
dtaai dtaai 1
ekorg PurchasingOrganization 2
employee_id employee_id 1
EngSnapshotName EngSnapshotName 1
entity_name_raw EntityNameCamelCase,view_name 2
EoDImort EoDImort 1
fdgrp fdgrp 1
FiscalPeriod FiscalPeriod 2
gsber gsber 1
hbid1 hbid1 1
hbid2 hbid2 1
hbkid hbkid 2
HierarchyID hierarchy 1
HierAttributeRangeFromVal aging 1
hkid1 hkid1 1
hkid2 hkid2 1
hkont hkont 1
hktid hktid 2
HouseBankCompanyCode HouseBankCompanyCode 1
HouseBankCompanyCodeDesp HouseBankCompanyCodeDesp 1
iban iban 6
ImportingChannel ImportingChannel 1
input_format BankStatementInputFormat 1
IntradayImport IntradayImport 1
IntradayIsReconciled IntradayIsReconciled 1
InvoiceDate InvoiceDate 2
label_text view_text 1
LastChangeDateTime LastChangeDateTime 1
LicenseGrantDate LicenseGrantDate 1
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
PaymentTermsName PaymentTermsName 2
PlannedClosingDate PlannedClosingDate 1
Plant Plant 1
PostalCode PostalCode 1
PostingDate PostingDate 2
prctr prctr 1
PrevApprovedConditionRecord PrevApprovedConditionRecord 1
PriceApprovalRequest SalesPriceApprovalRequest 1
ProfitCenter ProfitCenter 1
ProjectUUID MasterProjectUUID,ProjectUUID 4
refzl refzl 1
RelationshipManager RelationshipManager 1
ReverseDocument ReverseDocument 1
segment segment 2
SelfBillingValueItemDesc SelfBillingValueItemDesc 2
source_origin source_origin 1
sourcingprojectquotation headerID 1
SpecificationInternalID SpecificationInternalID 1
Status BankAccountStatus,Status 3
StatusDesp StatusDesp 1
StreetName StreetName 1
Supplier Supplier 2
SupplierCityName SupplierCityName 1
SupplierCountry SupplierCountry 1
SupplierPostalCode SupplierPostalCode 1
SupplierStreetName SupplierStreetName 1
SupplierTaxID5 SupplierTaxID5 2
TaxExemptionLicense TaxExemptionLicense 1
TaxReportingDate TaxReportingDate 2
UploadBSFlag UploadBSFlag 1
valid_from valid_from 2
valid_to valid_to 1
ValidFrom ValidFrom 1
ValidTo ValidTo 1
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,
    ACCOUNTINGDOCUMENT,
    BNAME,
    COMPANYCODE,
    ENDDATE,
    ENGSNAPSHOTID,
    ENTITY_NAME,
    FINANCIALSTATEMENTHIERARCHY,
    FISCALYEAR,
    LEDGER,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTYEAR,
    SOURCELEDGER,
    STARTDATE,
    STATE,
    _COMPANYCODE,
    ABWAE,
    ACC_NUM,
    ACC_TYPE_ID,
    ACCOUNTHOLDER,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTNUMBER,
    ACCOUNTSUPERVISOR,
    ACCOUNTTYPE,
    ACCOUNTVALIDTO,
    AEDAT,
    ALTERNATIVEREFERENCEDOCUMENT,
    AZDAT,
    AZNUM,
    AZPGNO,
    BANK_CONTACT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTDESCRIPTION,
    BANKADDRESSNO,
    BANKCONTACT,
    BANKCOUNTRY,
    BANKCOUNTRYDESP,
    BANKKEY,
    BANKL,
    BANKN,
    BANKNAME,
    BANKS,
    BANKSTATEMENTUPLOAD,
    BEDAT,
    BENEFICIAL,
    BG_SAFTINVOICETYPE,
    BG_SAFTSYSTEMID,
    BILLOFMATERIALVARIANTUSAGE,
    BNKN2,
    BUKRS,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPENAME,
    CASHTOLERANCEGROUP,
    CENTRALBAMACCOUNT,
    CHANGEDATDATE,
    CHANGEDATTIME,
    CHANGEDBY,
    CITYNAME,
    CLOSEDATDATE,
    CLOSEDATTIME,
    CLOSEDBY,
    COMPANYADDRESSNO,
    COMPANYCODEDESP,
    COMPANYCONTACT,
    COMPANYCOUNTRY,
    CONDITIONSEARCHTERMVALUE,
    CONDITIONTABLE,
    CONDITIONVALIDITYENDDATE,
    CONDITIONVALIDITYSTARTDATE,
    CONTROLKEY,
    COUNTRY,
    CREATEDATDATE,
    CREATEDATTIME,
    CREATEDBY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CURRENCY,
    CUSTOMER,
    CUSTOMERCITYNAME,
    CUSTOMERCOUNTRY,
    CUSTOMERPOSTALCODE,
    CUSTOMERSTREETNAME,
    CUSTOMERTAXID5,
    CUTOFFCROSSBORDER,
    CUTOFFDOMESTIC,
    DDL_NAME,
    DTAAI,
    EKORG,
    EMPLOYEE_ID,
    ENGSNAPSHOTNAME,
    ENTITY_NAME_RAW,
    EODIMORT,
    FDGRP,
    FISCALPERIOD,
    GSBER,
    HBID1,
    HBID2,
    HBKID,
    HIERARCHYID,
    HIERATTRIBUTERANGEFROMVAL,
    HKID1,
    HKID2,
    HKONT,
    HKTID,
    HOUSEBANKCOMPANYCODE,
    HOUSEBANKCOMPANYCODEDESP,
    IBAN,
    IMPORTINGCHANNEL,
    INPUT_FORMAT,
    INTRADAYIMPORT,
    INTRADAYISRECONCILED,
    INVOICEDATE,
    LABEL_TEXT,
    LASTCHANGEDATETIME,
    LICENSEGRANTDATE,
    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,
    PAYMENTTERMSNAME,
    PLANNEDCLOSINGDATE,
    PLANT,
    POSTALCODE,
    POSTINGDATE,
    PRCTR,
    PREVAPPROVEDCONDITIONRECORD,
    PRICEAPPROVALREQUEST,
    PROFITCENTER,
    PROJECTUUID,
    REFZL,
    RELATIONSHIPMANAGER,
    REVERSEDOCUMENT,
    SEGMENT,
    SELFBILLINGVALUEITEMDESC,
    SOURCE_ORIGIN,
    SOURCINGPROJECTQUOTATION,
    SPECIFICATIONINTERNALID,
    STATUS,
    STATUSDESP,
    STREETNAME,
    SUPPLIER,
    SUPPLIERCITYNAME,
    SUPPLIERCOUNTRY,
    SUPPLIERPOSTALCODE,
    SUPPLIERSTREETNAME,
    SUPPLIERTAXID5,
    TAXEXEMPTIONLICENSE,
    TAXREPORTINGDATE,
    UPLOADBSFLAG,
    VALID_FROM,
    VALID_TO,
    VALIDFROM,
    VALIDTO,
    WAERS,
    WEKON,
    WIKON,
    WKKON,
    PRIMARY KEY (ACC_ID, ACCOUNTID, ACCOUNTINGDOCUMENT, BNAME, COMPANYCODE, ENDDATE, ENGSNAPSHOTID, ENTITY_NAME, FINANCIALSTATEMENTHIERARCHY, FISCALYEAR, LEDGER, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTYEAR, SOURCELEDGER, STARTDATE, STATE)
);

Learn More