I_CHGRECDREFMBOM

CDS View
11 Fields 6 CDS Views

Change Record Reference MBOM

I_CHGRECDREFMBOM is a CDS View in S/4HANA. Change Record Reference MBOM. It contains 11 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_ChgRecdRefMfgBOM view_entity from COMPOSITE Change Record Ref Manufacturing BOM
I_ChgImpactMBOMAssg view from COMPOSITE Manufacturing BOM Assignment
I_ChgRecdRefMfgBOMTP view from TRANSACTIONAL Change Record Reference MBOM
P_ChgRecdRefMfgBOM view from TRANSACTIONAL
P_VersMfgBOMwithCRAssgd view inner COMPOSITE
P_VersMfgBOMwithOpenCRAssgd view inner COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 4
KEY BillOfMaterialCategory BillOfMaterialCategory 4
KEY BillOfMaterialVariant BillOfMaterialVariant 3
KEY ChangeRecordReferenceUUID ChgRecdRefMfgBillOfMatlUUID 2
KEY ChgRecRefInternalKey4 ChgRecRefInternalKey4 2
KEY Plant Plant 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeRecordRefObjectUUID BillOfMaterialHeaderUUID 2
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 1
Material Material 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.

-- Change Record Reference MBOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFMBOM (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    CHANGERECORDREFERENCEUUID,
    CHGRECREFINTERNALKEY4,
    PLANT,
    BILLOFMATERIALVARIANTUSAGE,
    CHANGERECORDREFOBJECTUUID,
    CREATEDBYUSER,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, CHANGERECORDREFERENCEUUID, CHGRECREFINTERNALKEY4, PLANT)
);

Learn More