_BOMITEM

19 Fields

_BOMITEM is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY BillOfMaterialVersion BillOfMaterialVersion 1
KEY BOMItemInternalChangeCount BOMItemInternalChangeCount 1
KEY HeaderChangeDocument HeaderChangeDocument 1
KEY Material Material 1
KEY Plant Plant 1
_BOMItemCategory _BOMItemCategory 1
_UnitOfMeasure _UnitOfMeasure 1
BillOfMaterialComponent BillOfMaterialComponent 3
BillOfMaterialItemCategory BillOfMaterialItemCategory 3
BillOfMaterialItemNumber BillOfMaterialItemNumber 3
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 3
BillOfMaterialItemUnit BillOfMaterialItemUnit 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BOMItemDescription BOMItemDescription 1
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 1
BOMItemText2 BOMItemText2 1
EngineeringChangeDocument EngineeringChangeDocForEdit,EngineeringChangeDocument 1
MaterialGroup MaterialGroup 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 _BOMITEM (
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEMINTERNALCHANGECOUNT,
    HEADERCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    _BOMITEMCATEGORY,
    _UNITOFMEASURE,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BILLOFMATERIALVARIANTUSAGE,
    BOMITEMDESCRIPTION,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMTEXT2,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIALGROUP,
    PRIMARY KEY (BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, BOMITEMINTERNALCHANGECOUNT, HEADERCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More