I_MDChgProcStepSimulationKPI

DDL: I_MDCHGPROCSTEPSIMULATIONKPI SQL: IMDCHNGPRCSIMKPI Type: view BASIC Package: MDC_PROCESS_OBJECT
12 Fields 2 Data Sources

MD Change Process Step Simulation KPI

I_MDChgProcStepSimulationKPI is a Basic CDS View that provides data about "MD Change Process Step Simulation KPI" in SAP S/4HANA. It reads from 2 data sources (mdc_d_cnfsimmdqr, mdc_d_prcstep) and exposes 12 fields with key fields MDChgProcessStepUUID, MDQualityBusinessRuleUUID. Part of development package MDC_PROCESS_OBJECT.

Data Sources (2)

SourceAliasJoin Type
mdc_d_cnfsimmdqr _SimulationRule left_outer
mdc_d_prcstep Step from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHNGPRCSIMKPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label MD Change Process Step Simulation KPI view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID mdc_d_prcstep db_key UUID
KEY MDQualityBusinessRuleUUID mdc_d_cnfsimmdqr mdqualitybusinessruleuuid Rule UUID
MasterDataChangeProcess mdc_d_prcstep process_id Process Instance ID
MDChgProcessStep mdc_d_prcstep step_number Step Number
MDChgProcessTypeID _Root type_id Type ID
MDChgProcessGoal _Root goal Process Goal
MDChgProcessSrceObjectTypeCode
MDChgProcessStepAdapter mdc_d_prcstep adapter Step Adapter
MDChgProcessStepType mdc_d_prcstep step_type VSS Sol. Step Type
MDChgProcessStepStartDateTime
MDChgProcessStepFinishDateTime
MDChgProcessStepConfign mdc_d_prcstep process_config_uuid Config. UUID

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 I_MDChgProcStepSimulationKPI.
-- 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.
-- SQL view name: IMDCHNGPRCSIMKPI

CREATE VIEW I_MDChgProcStepSimulationKPI AS
SELECT
  Step.db_key AS MDChgProcessStepUUID,
  _SimulationRule.mdqualitybusinessruleuuid AS MDQualityBusinessRuleUUID,
  Step.process_id AS MasterDataChangeProcess,
  Step.step_number AS MDChgProcessStep,
  _Root.type_id AS MDChgProcessTypeID,
  _Root.goal AS MDChgProcessGoal,
  case when Step.source_otc is initial then _Root.source_otc else Step.source_otc end AS MDChgProcessSrceObjectTypeCode,
  Step.adapter AS MDChgProcessStepAdapter,
  Step.step_type AS MDChgProcessStepType,
  cast( Step.started_at as tzntstmps ) AS MDChgProcessStepStartDateTime,
  cast( Step.finished_at as tzntstmps ) AS MDChgProcessStepFinishDateTime,
  Step.process_config_uuid AS MDChgProcessStepConfign
FROM mdc_d_prcstep AS Step
LEFT OUTER JOIN mdc_d_cnfsimmdqr AS _SimulationRule ON /* join condition not captured in parsed metadata */
;

Learn More