P_BOMITEMLINKS

CDS View
14 Fields 1 CDS Views

P_BOMITEMLINKS is a CDS View in S/4HANA. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BOMItemLinksTP view from TRANSACTIONAL Interface between BillOfMaterialItem and Link

Fields (14)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 1
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID 1
KEY EngineeringChangeDocument EngineeringChangeDocument 1
KEY Material Material 1
KEY MfgBillOfMaterial MfgBillOfMaterial 1
KEY MfgBillOfMaterialCategory MfgBillOfMaterialCategory 1
KEY MfgBillOfMaterialVariant MfgBillOfMaterialVariant 1
KEY MfgBillOfMaterialVersion MfgBillOfMaterialVersion 1
KEY Plant Plant 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
EngBillOfMaterial EngBillOfMaterial 1
EngBillOfMaterialCategory EngBillOfMaterialCategory 1
EngBillOfMaterialVariant EngBillOfMaterialVariant 1
EngBillOfMaterialVersion EngBillOfMaterialVersion 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 P_BOMITEMLINKS (
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMUUID,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    MFGBILLOFMATERIAL,
    MFGBILLOFMATERIALCATEGORY,
    MFGBILLOFMATERIALVARIANT,
    MFGBILLOFMATERIALVERSION,
    PLANT,
    BILLOFMATERIALITEMNUMBER,
    ENGBILLOFMATERIAL,
    ENGBILLOFMATERIALCATEGORY,
    ENGBILLOFMATERIALVARIANT,
    ENGBILLOFMATERIALVERSION,
    PRIMARY KEY (BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALITEMUUID, ENGINEERINGCHANGEDOCUMENT, MATERIAL, MFGBILLOFMATERIAL, MFGBILLOFMATERIALCATEGORY, MFGBILLOFMATERIALVARIANT, MFGBILLOFMATERIALVERSION, PLANT)
);

Learn More