BOM_HEADER

BOM_HEADER is an SAP database table in S/4HANA. It contains 51 fields.

Fields (51)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 4
KEY BillOfMaterialCategory BillOfMaterialCategory 4
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY BillOfMaterialVersion BillOfMaterialVersion 2
KEY EngineeringChangeDocument EngineeringChangeDocument 4
KEY Material Material 4
KEY Plant Plant 4
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 4
BillOfMaterialHdrDetailsText BillOfMaterialHdrDetailsText 2
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 4
BillOfMaterialStatus BillOfMaterialStatus 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 4
BillOfMaterialVariantUsageDesc BillOfMaterialVariantUsageDesc 1
BOMAlternativeText BOMAlternativeText 4
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 2
BOMExplosionApplication BOMExplosionApplication 2
BOMGroup BOMGroup 4
BOMHeaderBaseUnit BOMHeaderBaseUnit 4
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 4
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 4
BOMHeaderText BOMHeaderText 4
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 3
BOMIsToBeDeleted BOMIsToBeDeleted 4
BOMTechnicalType BOMTechnicalType 3
BOMUsagePriority BOMUsagePriority 4
BOMVersionStatus BOMVersionStatus 2
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 4
CreatedByUser CreatedByUser 4
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 4
EngineeringChangeDocForEdit EngineeringChangeDocForEdit 4
HeaderValidityEndDate HeaderValidityEndDate 2
HeaderValidityStartDate HeaderValidityStartDate 2
IsALE IsALE 2
IsConfiguredMaterial IsConfiguredMaterial 4
IsLatestBOMVersion IsLatestBOMVersion 2
IsMarkedForDeletion IsMarkedForDeletion 4
IsMultipleBOMAlt IsMultipleBOMAlt 2
IsVersionBillOfMaterial IsVersionBillOfMaterial 2
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 4
LastChangeDate LastChangeDate 4
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 4
MaterialToLotSizeQuantity MaterialToLotSizeQuantity 2
MatFromLotSizeQuantity MatFromLotSizeQuantity 2
PlantName PlantName 2
ProductDescription ProductDescription 2
RecordCreationDate RecordCreationDate 4
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 BOM_HEADER (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALHDRDETAILSTEXT,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVARIANTUSAGEDESC,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISTOBEDELETED,
    BOMTECHNICALTYPE,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    ENGINEERINGCHANGEDOCFOREDIT,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALTOLOTSIZEQUANTITY,
    MATFROMLOTSIZEQUANTITY,
    PLANTNAME,
    PRODUCTDESCRIPTION,
    RECORDCREATIONDATE,
    SALESORDER,
    SALESORDERITEM,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT)
);