C_BPHierNodeTimeSliceProcessTP

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_BPHierNodeTimeSliceProcessTP.
-- 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 C_BPHierNodeTimeSliceProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPHierNdeTmeSliceValidFromDate,
  BPHierNodeTimeSliceValidToDate,
  BPHierarchyParentNodeUUID,
  BPHierNodeTimeSliceCreatedBy,
  BPHierNdeTmeSliceCrtedDateTime,
  BPHierNdeTmeSliceLastChangedBy,
  BPHierNdeTimeSliceChgdDateTime,
  _HierarchyNode.MDChgProcessRecordObjectText AS MDChgProcessRecordObjectText,
  _HierParentNode.MDChgProcessRecordObjectText AS MDChgProcParentRecordObjText,
  _HierarchyNode.BPHierarchyNodeDisplayID AS BPHierarchyNodeDisplayID,
  _HierarchyNode.MDChgProcHierRecordObjText AS MDChgProcHierRecordObjText,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcKPIUpdateStatus,
  _HierarchyNode.BusinessPartnerHierarchyUUID AS BusinessPartnerHierarchyUUID,
  _HierarchyNode.MDChgProcSrceObjBPHierarchy AS MDChgProcSrceObjBPHierarchy,
  _HierarchyNode._Hierarchy.MDChgProcessSrceSystem AS MDChgProcSrceSystemHierarchy,
  _HierarchyNode.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _HierarchyNode._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType
FROM I_BPHierNodeTimeSliceProcessTP
LEFT OUTER JOIN C_BPHierNodeTimeSliceProcChgs AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '5855'  -- association [0..1]
;