C_MDChgProcStepEffctvConfignTP

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_MDChgProcStepEffctvConfignTP.
-- 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_MDChgProcStepEffctvConfignTP AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  _MDChgProcessStepType.MDChgProcessStepTypeName AS MDChgProcessStepTypeName,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  MDChgProcessStepAdapter,
  MDChgProcessStepAdapterConfign,
  _MDChgProcStepAdptrConfignTxt.MDChgProcStepAdptrConfignText AS MDChgProcStepAdptrConfignText,
  MDChgProcessStepChkPointIsActv,
  MDChgProcessStepOriglNumber,
  MDChgProcessStepOriglSqncNmbr,
  MDChgProcessStepStartIsReqd,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  MDChgProcessStpOwnConfignIsRqd,
  MDChgProcIsAdhocStep,
  MDChgProcessStepActionControl,
  MDChgProcessStepAuthznGroup,
  cast( '' as boole_d preserving type ) AS MDChgProcFltrMtchgIsHidden,
  cast( '' as boole_d preserving type ) AS MDChgProcFltrCalcIsHidden,
  cast( '' as boole_d preserving type ) AS MDChgProcFltrValdtnIsHidden,
  cast( '' as abap.char( 3 ) ) AS MDChgProcFilterStepType,
  _MDChgProcEffctvConfign.MDChgProcGoalIsCnsldtnActvRecd AS MDChgProcGoalIsCnsldtnActvRecd,
  _MDChgProcEffctvConfign.MDChgProcessIsReliable AS MDChgProcessIsReliable
FROM I_MDChgProcStepEffctvConfignTP
LEFT OUTER JOIN I_MDChangeProcStepTypeT AS _MDChgProcessStepType ON _MDChgProcessStepType.MDChgProcessStepType = MDChgProcessStepType AND _MDChgProcessStepType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_MDChgProcessStepAdapterVH AS _MDChgProcessStepAdapterVH ON _MDChgProcessStepAdapterVH.MDChgProcessWlObjectTypeCode = MDChgProcessSrceObjectTypeCode AND _MDChgProcessStepAdapterVH.MDChgProcessStepType = MDChgProcessStepType AND _MDChgProcessStepAdapterVH.MDChgProcessStepAdapter = MDChgProcessStepAdapter  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessStepAdapterText AS _MDChgProcessStepAdapterText ON _MDChgProcessStepAdapterText.MDChgProcessStepAdapter = MDChgProcessStepAdapter AND _MDChgProcessStepAdapterText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcStepAdapterConfignT AS _MDChgProcStepAdptrConfignTxt ON _MDChgProcStepAdptrConfignTxt.MDChgProcessWlObjectTypeCode = MDChgProcessSrceObjectTypeCode AND _MDChgProcStepAdptrConfignTxt.MDChgProcessStepType = MDChgProcessStepType AND _MDChgProcStepAdptrConfignTxt.MDChgProcessStepAdapterConfign = MDChgProcessStepAdapterConfign AND _MDChgProcStepAdptrConfignTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_MDEffctvBstRecdCalcSystemTP AS _MDEffctvBstRecdCalcSystemTP ON _MDEffctvBstRecdCalcSystemTP.MDChgProcessStepUUID = MDChgProcessStepUUID AND _MDEffctvBstRecdCalcSystemTP.MDChgProcessStepAdapterConfign = MDChgProcessStepAdapterConfign AND _MDEffctvBstRecdCalcSystemTP.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode  -- association [0..*]
LEFT OUTER JOIN C_MDEffctvBstRecdCalcTableTP AS _MDEffctvBstRecdCalcTableTP ON _MDEffctvBstRecdCalcTableTP.MDChgProcessStepUUID = MDChgProcessStepUUID AND _MDEffctvBstRecdCalcTableTP.MDChgProcessStepAdapterConfign = MDChgProcessStepAdapterConfign AND _MDEffctvBstRecdCalcTableTP.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode  -- association [0..*]
LEFT OUTER JOIN C_MDEffctvBstRecdCalcFieldTP AS _MDEffctvBstRecdCalcFieldTP ON _MDEffctvBstRecdCalcFieldTP.MDChgProcessStepUUID = MDChgProcessStepUUID AND _MDEffctvBstRecdCalcFieldTP.MDChgProcessStepAdapterConfign = MDChgProcessStepAdapterConfign AND _MDEffctvBstRecdCalcFieldTP.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode  -- association [0..*]
LEFT OUTER JOIN C_MDEffctvConfignValidationTP AS _StepConfigurationValidation ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignActivationTP AS _StepConfigurationActivation ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignEvaluationTP AS _StepConfigurationEvaluation ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignFilterTP AS _StepConfigurationFilter ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignFuzzyTP AS _StepConfigurationMatching ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignMassEnrichTP AS _StepConfigurationMassEnrich ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignMassSearchTP AS _StepConfigurationMassSearch ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN C_MDEffctvConfignBstRecdCalcTP AS _StepConfigurationBstRecdCalc ON /* condition not available in parsed metadata */  -- association [0..1]
;