C_MDChgProcBPRelshpDetailsTP

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_MDChgProcBPRelshpDetailsTP.
-- 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_MDChgProcBPRelshpDetailsTP AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  _StepType._MDChgProcStepTypeT.MDChgProcessStepTypeName : localized AS MDChgProcessStepTypeNamelocalized,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  MDChgProcessStepAdapter,
  MDChgProcessStepAdapterConfign,
  MDChgProcessStepChkPointIsActv,
  MDChgProcessStepOriglNumber,
  MDChgProcessStepOriglSqncNmbr,
  MDChgProcessStepStartIsReqd,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepFilterChain,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  MDChgProcessStpOwnConfignIsRqd,
  _MasterDataChangeProcess.MDChgProcessDescription AS MDChgProcessDescription,
  MDChgProcessGoal,
  _ProcessGoal._Text.MDChgProcessGoalName : localized AS MDChgProcessGoalNamelocalized,
  MDChgProcessNmbrOfSrceRecords,
  MDChgProcessCurrentStepNumber,
  MDChgProcessStepWrkflwDefID,
  MDChgProcessStepWrkflwHandle,
  MDChgProcessStepWrkflwSts,
  MDChgProcessStepWrkflwOvrlDcsn
FROM I_MDChangeProcessStepTP_2
LEFT OUTER JOIN C_BusPartRelationshipProcessTP AS _BusPartRelationshipProcess ON MasterDataChangeProcess = _BusPartRelationshipProcess.MasterDataChangeProcess AND MDChgProcessStep = _BusPartRelationshipProcess.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BusPartRelshpTmeDpndcyProcTP AS _BusPartRelshpTmeDpndcyProc ON MasterDataChangeProcess = _BusPartRelshpTmeDpndcyProc.MasterDataChangeProcess AND MDChgProcessStep = _BusPartRelshpTmeDpndcyProc.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BusPartContactPersonProcTP AS _BusPartRelshpContactProc ON MasterDataChangeProcess = _BusPartRelshpContactProc.MasterDataChangeProcess AND MDChgProcessStep = _BusPartRelshpContactProc.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPContactPersonAddressProcTP AS _BPRelContactPersonAddrProc ON MasterDataChangeProcess = _BPRelContactPersonAddrProc.MasterDataChangeProcess AND MDChgProcessStep = _BPRelContactPersonAddrProc.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPCntctPersnMblNumberProcTP AS _BPRelCntctPersnMobileNumber ON MasterDataChangeProcess = _BPRelCntctPersnMobileNumber.MasterDataChangeProcess AND MDChgProcessStep = _BPRelCntctPersnMobileNumber.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPCntctPersnTelNmbrProcTP AS _BPRelCntctPersnPhoneNumber ON MasterDataChangeProcess = _BPRelCntctPersnPhoneNumber.MasterDataChangeProcess AND MDChgProcessStep = _BPRelCntctPersnPhoneNumber.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPCntctPersnFaxNumberProcTP AS _BPRelCntctPersnFaxNumber ON MasterDataChangeProcess = _BPRelCntctPersnFaxNumber.MasterDataChangeProcess AND MDChgProcessStep = _BPRelCntctPersnFaxNumber.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPCntctPersnEmailAddrProcTP AS _BPRelCntctPersnEmailAddress ON MasterDataChangeProcess = _BPRelCntctPersnEmailAddress.MasterDataChangeProcess AND MDChgProcessStep = _BPRelCntctPersnEmailAddress.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_BPCntctPersnWebsiteURLProcTP AS _BPRelCntctPersnWebsiteURL ON MasterDataChangeProcess = _BPRelCntctPersnWebsiteURL.MasterDataChangeProcess AND MDChgProcessStep = _BPRelCntctPersnWebsiteURL.MDChgProcessStep  -- association [0..*]
;