I_CHGRECDREFEBOM

CDS View
31 Fields 9 CDS Views

Change Record Reference EBOM

I_CHGRECDREFEBOM is a CDS View in S/4HANA. Change Record Reference EBOM. It contains 31 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
A_ChgRecdRefEngBOM view_entity from COMPOSITE Change Record ref Engineering BOM
C_EngSnpshtChgNtcForEBOMVH view inner CONSUMPTION Eng Snapshot Change Notice Change Records for EBOM
I_ChgImpactEBOMAssg view from COMPOSITE Engineering BOM Assignment
I_ChgRecdRefEngBOMTP view from TRANSACTIONAL Change Record Reference Object EBOM
I_PlngScopeDetsAssgdToChgRecd view left_outer COMPOSITE Details of Planning Scopes Assigned to Change Record
P_ChgRecdRefEngBOM view from TRANSACTIONAL Private view for Eng. BOM Reference
P_EngBOMAndPlngScpAssgd view inner COMPOSITE All Engineering BOM and Plng Scopes Assgd to Change Record
P_EngBOMAssgdToChgRecd view from COMPOSITE Engineering BOM Details Assigned To Change Record
R_ChgRecdObjPgEngBOMTP view_entity from TRANSACTIONAL Chg Recd Obj Pg Eng BOM

Fields (31)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialVariant BillOfMaterialVariant 4
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
KEY BillOfMaterialVersion BillOfMaterialVersion 2
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChgRecdRefEngBillOfMatlUUID 4
KEY Material Material 3
KEY Plant Plant 4
BillOfMaterial BillOfMaterial 4
BillOfMaterialCategory BillOfMaterialCategory 4
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 3
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecdRefInternalKey1EngBOM 1
ChgRecRefInternalKey2 ChgRecdRefInternalKey2EngBOM 1
ChgRecRefInternalKey3 ChgRecdRefInternalKey3EngBOM 1
ChgRecRefInternalKey4 ChgRecdRefInternalKey4EngBOM 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 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 EBOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFEBOM (
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    CHANGERECORDREFERENCEUUID,
    MATERIAL,
    PLANT,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    CHANGENUMBER,
    CHANGERECORD,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CHGRECREFINTERNALKEY1,
    CHGRECREFINTERNALKEY2,
    CHGRECREFINTERNALKEY3,
    CHGRECREFINTERNALKEY4,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, CHANGERECORDREFERENCEUUID, MATERIAL, PLANT)
);

Learn More