I_ChgRecdRefEBOM

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ChgRecdRefEBOM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICHGRECDREFEBOM

CREATE VIEW I_ChgRecdRefEBOM AS
SELECT
  ChangeRecordReferenceUUID,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterialVariant,
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVersion,
  ChangeRecord,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ChangeRecordRefObjectUUID,
  ParentChangeRecordRefUUID,
  IsMainReference,
  ChangeRecordReference,
  ChgRecRefInternalKey1,
  ChgRecRefInternalKey2,
  ChgRecRefInternalKey3,
  ChgRecRefInternalKey4,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ChangeRecordVirtualRefInd,
  ChangeRecordItemRelevance,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  ChangeRecordItemProcgStatus,
  ChgRecdItmTgtSts,
  ChgRecdItmDSgntr,
  ChangeRecordItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  ChangeNumber
FROM I_ChgRecdRefEBOMDataMigrtn
LEFT OUTER JOIN I_ChangeRecordItemValidity AS _ChgRecord ON ChangeRecordUUID = _ChgRecord.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _calendar ON _calendar.CalendarDate = $session.system_date  -- association [0..1]
;