C_MDQltyBusRuleSimlnDetail

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_MDQltyBusRuleSimlnDetail.
-- 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_MDQltyBusRuleSimlnDetail AS
SELECT
  MDQualityBusinessRuleUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessDescription,
  _ProcessStateCode.MDChgProcessStatusStateName AS MDChgProcessStatusStateName,
  _ProcessStateCode.MDChgProcessTypeID AS MDChgProcessTypeID,
  _ProcessStateCode.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  _ProcessStateCode.MDChgProcessStatusStateCode AS MDChgProcessStatusStateCode,
  MDChgProcessRequestor,
  _SimulationCreatorContactCard.FullName AS MDChgProcessRequestorName,
  MDChgProcCreateAtDateTime,
  cast(MDQNmbrOfRecdFailedInactv as mdq_sim_nmbr_failed_inact preserving type) AS MDQNmbrOfRecdFailedInactv,
  cast(MDQRuleSimlnScoreInactvVal as mdq_sim_score_inact preserving type) AS MDQRuleSimlnScoreInactvVal,
  cast(MDQNmbrOfRecdFailedActv as mdq_sim_nmbr_failed_act preserving type) AS MDQNmbrOfRecdFailedActv,
  cast(MDQRuleSimlnScoreActvVal as mdq_sim_score_act preserving type) AS MDQRuleSimlnScoreActvVal,
  cast(MDQNmbrOfRecdSuccessInactv as mdq_sim_nmbr_success_inact preserving type) AS MDQNmbrOfRecdSuccessInactv,
  cast(MDQNmbrOfRecdSuccessActv as mdq_sim_nmbr_success_act preserving type) AS MDQNmbrOfRecdSuccessActv,
  cast(MDQNmbrOfRecdOutOfScopeInactv as mdq_sim_nmbr_outofscope_inact preserving type) AS MDQNmbrOfRecdOutOfScopeInactv,
  cast(MDQNmbrOfRecdOutOfScopeActv as mdq_sim_nmbr_outofscope_act preserving type) AS MDQNmbrOfRecdOutOfScopeActv
FROM I_MDQltyBusRuleSimlnDetail AS _SimulationDetail
LEFT OUTER JOIN I_MDCloudUserContactCard AS _SimulationCreatorContactCard ON MDChgProcessRequestor = _SimulationCreatorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN P_MDChangeProcessStatusState AS _ProcessStateCode ON MasterDataChangeProcessUUID = _ProcessStateCode.MasterDataChangeProcessUUID  -- association [0..1]
;