I_SALESORDERBOMLINK

CDS View

Sales Order Link for BOM

I_SALESORDERBOMLINK is a CDS View in S/4HANA. Sales Order Link for BOM. It contains 7 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_AssemblySalesOrderBOM view from COMPOSITE Assembly Determination Sales Order BOM
I_BomHeaderChanges view inner BASIC BOM Header Changes
I_ProjNtwkActyMatBOMAssembly view union_all COMPOSITE BOM Assembly for Ntwk Activity Comp
I_SalesOrderBOMLinkDEX view from BASIC Data extraction for SO bomlink
P_BillOfMaterialHeader view left_outer COMPOSITE
P_BOMHeaderType view union_all BASIC
P_BOMItemChanges view inner BASIC
P_EngSnpshtMfgBOM view_entity union_all COMPOSITE All Material and Sales Order BOM
P_ProjMatBOMAssembly view union_all BASIC
SHSM_KDST view from CDS View for use in CS_KDST search help

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
KEY Material Material 3
KEY Plant Plant 4
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 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.

-- Sales Order Link for BOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERBOMLINK (
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    MATERIAL,
    PLANT,
    SALESORDER,
    SALESORDERITEM,
    PRIMARY KEY (BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, MATERIAL, PLANT)
);