C_MDChgProcStepSimulationKPI

DDL: C_MDCHGPROCSTEPSIMULATIONKPI SQL: CMDCHNGPRCSIMKPI Type: view CONSUMPTION

Master Data Change Process Step Simulation KPI

C_MDChgProcStepSimulationKPI is a Consumption CDS View that provides data about "Master Data Change Process Step Simulation KPI" in SAP S/4HANA. It is exposed through 1 OData service (MASTERDATACHANGEPROCESSSD).

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMDCHNGPRCSIMKPI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Data Change Process Step Simulation KPI view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
MASTERDATACHANGEPROCESSSD MASTERDATACHANGEPROCESSSB V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID
KEY MDQualityBusinessRuleUUID MDQualityBusinessRuleUUID Rule UUID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessTypeID MDChgProcessTypeID Process Template
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStepAdapter MDChgProcessStepAdapter
MDChgProcessStepType MDChgProcessStepType
MDChgProcessStepStartDateTime MDChgProcessStepStartDateTime
MDChgProcessStepFinishDateTime MDChgProcessStepFinishDateTime
MDChgProcessStepConfign MDChgProcessStepConfign
MDQltyNmbrOfRecdSuccess
MDQltyNmbrOfRecdFailed
MDQltyNmbrOfRecdOutOfScope
MDQualityBusinessRule
MDQualityBusinessRuleName
MDQltyBusinessRuleBaseTable

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_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: CMDCHNGPRCSIMKPI

CREATE VIEW C_MDChgProcStepSimulationKPI AS
SELECT
  MDChgProcessStepUUID,
  MDQualityBusinessRuleUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepAdapter,
  MDChgProcessStepType,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  cast( 0 as abap.int4 ) AS MDQltyNmbrOfRecdSuccess,
  cast( 0 as abap.int4 ) AS MDQltyNmbrOfRecdFailed,
  cast( 0 as abap.int4 ) AS MDQltyNmbrOfRecdOutOfScope,
  cast( '' as mdc_mdq_rule_definition_id ) AS MDQualityBusinessRule,
  cast( '' as mdc_mdq_rule_definition_name ) AS MDQualityBusinessRuleName,
  cast( '' as mdc_table_name ) AS MDQltyBusinessRuleBaseTable
;