ORDERCOMPONENT

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

Fields (19)

KeyField CDS FieldsUsed in Views
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
FormulaKey FormulaKey 2
InheritedBOMItemNode InheritedBOMItemNode 1
MaterialCompIsAlternativeItem MaterialCompIsAlternativeItem 1
MatlCompDiscontinuationType MatlCompDiscontinuationType 1
OriginalReservation OriginalReservation 1
OriginalReservationItem OriginalReservationItem 1
UsageProbabilityPercent UsageProbabilityPercent 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 2
VariableSizeComponentUnit VariableSizeComponentUnit 2
VariableSizeDimension1 VariableSizeDimension1 2
VariableSizeDimension2 VariableSizeDimension2 2
VariableSizeDimension3 VariableSizeDimension3 2
VariableSizeDimensionUnit VariableSizeDimensionUnit 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 ORDERCOMPONENT (
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    FORMULAKEY,
    INHERITEDBOMITEMNODE,
    MATERIALCOMPISALTERNATIVEITEM,
    MATLCOMPDISCONTINUATIONTYPE,
    ORIGINALRESERVATION,
    ORIGINALRESERVATIONITEM,
    USAGEPROBABILITYPERCENT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT
);