I_BILLOFMATERIALSUBITEMS

CDS View
8 Fields 3 CDS Views

Basic for BOM sub items

I_BILLOFMATERIALSUBITEMS is a CDS View in S/4HANA. Basic for BOM sub items. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BillOfMaterialSubItemsHeader view from COMPOSITE Composite for sub items
I_SalesOrderBOMSubitemHeader view_entity from COMPOSITE Sales Order Bill Of Material Subitem
I_WBSBillOfMatlSubitemHeader view_entity from COMPOSITE WBS Bill of Material Subitem

Fields (8)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 3
KEY BillOfMaterialCategory BillOfMaterialCategory 3
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 3
KEY BOMItemInternalChangeCount BOMItemInternalChangeCount 3
KEY BOMSubItemNumberValue BOMSubItemNumberValue 3
BillOfMaterialSubItemQuantity BillOfMaterialSubItemQuantity 3
BillOfMaterialSubItemText BillOfMaterialSubItemText 3
BOMSubItemInstallationPoint BOMSubItemInstallationPoint 3

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.

-- Basic for BOM sub items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIALSUBITEMS (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BOMITEMINTERNALCHANGECOUNT,
    BOMSUBITEMNUMBERVALUE,
    BILLOFMATERIALSUBITEMQUANTITY,
    BILLOFMATERIALSUBITEMTEXT,
    BOMSUBITEMINSTALLATIONPOINT,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BOMITEMINTERNALCHANGECOUNT, BOMSUBITEMNUMBERVALUE)
);

Learn More