C_ChangeRecordObjPgMfgSnpsht

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 C_ChangeRecordObjPgMfgSnpsht.
-- 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: CCHGRCDOBJPGMSP

CREATE VIEW C_ChangeRecordObjPgMfgSnpsht AS
SELECT
  ChangeRecordReferenceUUID,
  _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon AS ChangeRecordRefObjIcon,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  BillOfMaterialVariantUsage,
  BillOfMaterialVariant,
  cast(_EngSnpshtObjRef.EngSnpshtRefKey5 as cs_versn) AS BillOfMaterialVersion,
  EngSnapshotID,
  EngSnapshotUUID,
  EngSnpshtRevisionNumber,
  EngSnapshotType,
  _EngSnpshtTypeText.EngSnapshotTypeText AS EngSnapshotTypeText,
  _EngSnpshtHeader.EngSnpshtProposedEffectiveDate AS EngSnpshtProposedEffectiveDate,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ChangeRecordRefObjectUUID,
  ChangeRecordReference,
  ParentChangeRecordRefUUID,
  IsMainReference,
  CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  ChangeRecordItemRelevance,
  cast ('' as mpe_sta_routing_type ) AS EngSnapshotRoutingType,
  cast ('' as ddtext ) AS EngSnapshotRoutingTypeText,
  cast ('' as mpe_sta_rework_routing ) AS EngSnapshotRoutingIsRework,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld AS ChgRecdItemProcgStatusIsEnbld,
  _ChangeRecordObjPg.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  ChangeRecordItemProcgStatus,
  ChgRecdCurrentItemProcgStatus,
  ChgRecdItmDSgntr,
  cast( '' as boolean) AS DigitalSignUserIsAuthorized,
  _DigSignStatusText.ChgRecdDigSignStatusTxt AS ChgRecdDigSignStatusTxt,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  ChangeNumber,
  cast( '' as boolean) AS ChgRecdObjDgtlSgntrEnable,
  cast (' ' as mpe_business_process preserving type) AS BillOfOpsBusinessProcess
FROM I_ChgRecdRefMfgSnpshtTP AS ChangeRecordRefMfgSnpshtTP
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BOMUsageText ON BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordItemRelSnpshtVH AS _ChangeRecordItemRelSnpshtVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelSnpshtVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelSnpshtVH.ChangeRecordType  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordRefObjIcons AS _ChangeRecordRefObjIcons ON ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID AND ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtHdr AS _EngSnpshtHeader ON EngSnapshotID = _EngSnpshtHeader.EngSnapshotID AND EngSnpshtRevisionNumber = _EngSnpshtHeader.EngSnpshtRevisionNumber  -- association [0..1]
LEFT OUTER JOIN I_EngSnpshtObjRef AS _EngSnpshtObjRef ON EngSnapshotUUID = _EngSnpshtObjRef.EngSnapshotUUID AND Material = _EngSnpshtObjRef.EngSnpshtRefKey1 AND Plant = _EngSnpshtObjRef.EngSnpshtRefKey2 AND BillOfMaterialVariant = _EngSnpshtObjRef.EngSnpshtRefKey3 AND BillOfMaterialVariantUsage = _EngSnpshtObjRef.EngSnpshtRefKey4 AND _EngSnpshtObjRef.EngSnpshtRefType = 'MBOM'  -- association [0..*]
LEFT OUTER JOIN C_ChgRecordItemProcgStatusVH AS _ProcessingStatusVH ON ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus AND ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus AND ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus  -- association [1..1]
LEFT OUTER JOIN I_ChgRecdItemProcgStatusText AS _ProcessingStatusTxt ON ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecdDigSignStatusVH AS _DigSignStatusText ON ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtTypeText AS _EngSnpshtTypeText ON EngSnapshotType = _EngSnpshtTypeText.EngSnapshotType  -- association [0..*]
;