_BILLOFMATERIALITEM

_BILLOFMATERIALITEM is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialComponent BillOfMaterialComponent 1
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID 1
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 1
BillOfMaterialItemUnit BillOfMaterialItemUnit 3
MaterialIsCoProduct MaterialIsCoProduct 2
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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 _BILLOFMATERIALITEM (
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    MATERIALISCOPRODUCT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIALCOMPONENT, BILLOFMATERIALITEMUUID)
);