I_CHGRECDREFMBOM

CDS View
27 Fields 7 CDS Views

Change Record Reference MBOM

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

CDS Views using this table (7)

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 Private view for Mfg. BOM Reference
P_VersMfgBOMwithCRAssgd view inner COMPOSITE Mfg BOM and Change Record Assigned
P_VersMfgBOMwithOpenCRAssgd view inner COMPOSITE Version Controlled Mfg BOM With Their Change Records
R_ChgRecdObjPgMfgBOMTP view_entity from TRANSACTIONAL Chg Recd Obj Pg Mfg BOM

Fields (27)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 5
KEY BillOfMaterialCategory BillOfMaterialCategory 5
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChgRecdRefMfgBillOfMatlUUID 3
KEY ChgRecRefInternalKey4 ChgRecRefInternalKey4 2
KEY Plant Plant 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
BillOfMaterialVersion BillOfMaterialVersion 1
ChangeNumber ChangeNumber 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordRefObjectUUID BillOfMaterialHeaderUUID,ChangeRecordRefObjectUUID 3
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 2
Material Material 2
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 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,
    BILLOFMATERIALVERSION,
    CHANGENUMBER,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, CHANGERECORDREFERENCEUUID, CHGRECREFINTERNALKEY4, PLANT)
);

Learn More