I_ChgRecdRefPlngScpTP

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_ChgRecdRefPlngScpTP.
-- 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: ICHGRECREFPLSTP

CREATE VIEW I_ChgRecdRefPlngScpTP AS
SELECT
  reference_pls.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  PlanningScope.DocumentId AS DocumentId,
  case when PlanningScope.SourceMaterial is null then cast(SUBSTRING( ChangeRecordReference, 1, 40) as matnr) else cast(PlanningScope.SourceMaterial as matnr) end as SourceMaterial AS SourceMaterialasmatnrendasSourceMaterial,
  PlanningScope.PlanningScopeDescription AS PlanningScopeDescription,
  reference_pls.ChangeRecordUUID AS ChangeRecordUUID,
  reference_pls.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_pls.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_pls.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_pls.ChangeRecordReference AS ChangeRecordReference,
  reference_pls.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_pls.IsMainReference AS IsMainReference,
  reference_pls.CreatedByUser AS CreatedByUser,
  reference_pls.CreationDateTime AS CreationDateTime,
  reference_pls.LastChangedByUser AS LastChangedByUser,
  reference_pls.LastChangeDateTime AS LastChangeDateTime,
  reference_pls.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_pls.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_pls. ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_pls.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_pls. ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  reference_pls.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  reference_pls.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_pls.ExpdCompltnDte AS ExpdCompltnDte,
  reference_pls.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_pls.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_pls.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefPlngScpBsc AS reference_pls
LEFT OUTER JOIN I_PlngScpHdr AS PlanningScope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecord ON ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefPlngScpBsc AS _PlngScpExtension ON ChangeRecordReferenceUUID = _PlngScpExtension.ChangeRecordReferenceUUID  -- association [0..1]
;