C_BusPartRelationshipProcessTP

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_BusPartRelationshipProcessTP.
-- 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_BusPartRelationshipProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessSrceBusPart1,
  MDChgProcessSrceBusPart2,
  RelationshipCategory,
  BusinessPartner1,
  BusinessPartner2,
  BP1AuthorizationGroup,
  BP2AuthorizationGroup,
  BP1DataControllerSet,
  BP1DataController1,
  BP1DataController2,
  BP1DataController3,
  BP1DataController4,
  BP1DataController5,
  BP1DataController6,
  BP1DataController7,
  BP1DataController8,
  BP1DataController9,
  BP1DataController10,
  BP2DataControllerSet,
  BP2DataController1,
  BP2DataController2,
  BP2DataController3,
  BP2DataController4,
  BP2DataController5,
  BP2DataController6,
  BP2DataController7,
  BP2DataController8,
  BP2DataController9,
  BP2DataController10,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessRecordObjectText,
  virtual RelatedBPNumberDisplay : bu_partner AS virtualRelatedBPNumberDisplaybu_partner,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  virtual MDChgProcessNumberOfMessages : abap.int8 AS int8,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  MDChgProcessValidationStatus,
  MDChgProcessActivationTarget,
  _RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChangeProcKPIValueKeyDesc
FROM I_BusPartRelationshipProcessTP
LEFT OUTER JOIN I_BusPartRelshpProcessChanges 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 C_BPRelshpProcessChangesUnion AS _ChangesUnion ON MasterDataChangeProcess = _ChangesUnion.MasterDataChangeProcess AND MDChgProcessStep = _ChangesUnion.MDChgProcessStep AND MDChgProcessSrceSystem = _ChangesUnion.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ChangesUnion.MDChgProcessSrceObject AND _ChangesUnion.MDChgProcessSourceModified = 'X'  -- association [0..*]
;