I_BPHierarchyNodeProcessTP

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_BPHierarchyNodeProcessTP.
-- 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.

CREATE VIEW I_BPHierarchyNodeProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPHierarchyNodeUUID,
  MDChgProcessSrceBusPart,
  MDChgProcSrceObjBPHierarchy,
  BusinessPartnerHierarchyUUID,
  BusinessPartnerUUID,
  BPHierarchyNodeDisplayID,
  cast( concat_with_space( _BusinessPartnerAct.BusinessPartnerName ,concat( '(', concat( MDChgProcessSrceBusPart, ')' ) ) , 1) as abap.char(539) ) as BusinessPartnerName AS char539asBusinessPartnerName,
  cast( 'X' as mdc_source_modified ) AS IsChanged,
  BPHierarchyNodeCreatedBy,
  BPHierarchyNodeCreatedDateTime,
  BPHierarchyNodeLastChangedBy,
  BPHierNodeLastChangedDateTime,
  _Hierarchy.BPHierarchyDataType AS BPHierarchyDataType,
  _Hierarchy.MDChgProcessRecordObjectText AS MDChgProcHierRecordObjText,
  cast ( concat_with_space( case when MDChgProcessSourceModified = 'D' then _HierNodeDescAct.BPHierarchyNodeDescription when _HierNodeDescPrc.BPHierarchyNodeDescription <> '' then _HierNodeDescPrc.BPHierarchyNodeDescription else '' end , concat( '(', concat( BPHierarchyNodeDisplayID, ')' ) ), 1 ) as abap.char(539) ) as MDChgProcessRecordObjectText AS char539asMDChgProcessRecordObjectText,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessValidationStatus,
  MDChangeProcessSourceSystemOwn,
  MDChgProcessHierarchyLastStep
FROM I_BPHierarchyNodeProcess
LEFT OUTER JOIN I_BPHierNodeDescriptionProcTP AS _HierNodeDescPrc ON MasterDataChangeProcess = _HierNodeDescPrc.MasterDataChangeProcess AND MDChgProcessStep = _HierNodeDescPrc.MDChgProcessStep AND MDChgProcessSrceSystem = _HierNodeDescPrc.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _HierNodeDescPrc.MDChgProcessSrceObject AND 'E' = _HierNodeDescPrc.Language  -- association [1]
LEFT OUTER JOIN I_BPHierNodeDataDescriptionTP AS _HierNodeDescAct ON BPHierarchyNodeUUID = _HierNodeDescAct.BPHierarchyNodeUUID AND 'E' = _HierNodeDescAct.Language  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerAct ON BusinessPartnerUUID = _BusinessPartnerAct.BusinessPartnerUUID AND _BusinessPartnerAct.BusinessPartnerCategory = '2'  -- association [0..1]
LEFT OUTER JOIN I_BPHierNodeProcessKPIRecType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterRecordSts AS _KPIRecordStatusText ON MDChgProcessValidationStatus = _KPIRecordStatusText.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '5669'  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_BPHierNodeDescriptionProcTP AS _HierarchyNodeDescription ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPHierNodeTimeSliceProcessTP AS _HierarchyNodeTS ON /* condition not available in parsed metadata */  -- association [0..*]
;