I_MDQltyBusRuleSimulation

DDL: I_MDQLTYBUSRULESIMULATION Type: view_entity BASIC

MDQ Business Rule Simulation

I_MDQltyBusRuleSimulation is a Basic CDS View that provides data about "MDQ Business Rule Simulation" in SAP S/4HANA. It reads from 1 data source (mdc_d_prcroot) and exposes 9 fields with key field MasterDataChangeProcessUUID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
mdc_d_prcroot _MasterDataChangeProcess from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label MDQ Business Rule Simulation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID mdc_d_prcroot db_key
MasterDataChangeProcess mdc_d_prcroot id
MDChgProcessDescription mdc_d_prcroot description
MDChgProcessSrceObjectTypeCode mdc_d_prcroot source_otc
MDChgProcessRequestor mdc_d_prcroot requestor
MDChgProcessCreationDate mdc_d_prcroot create_date
MDChgProcessCreationTime mdc_d_prcroot create_time
MDChgProcessFinishTime mdc_d_prcroot finish_time
MDChgProcessFinishDate mdc_d_prcroot finish_date 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'MDQ Business Rule Simulation'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{ serviceQuality: #C, sizeCategory: #M, dataClass: #MIXED }
@VDM.viewType:#BASIC

define view entity I_MDQltyBusRuleSimulation
  as select from mdc_d_prcroot    as _MasterDataChangeProcess
    join         mdc_d_prcstep    as _MDChgProcessStep        on  _MDChgProcessStep.parent_key  = _MasterDataChangeProcess.db_key
                                                              and _MDChgProcessStep.step_number = '0001'
    join         mdc_d_cnfsim     as _SimulationConfiguration on _SimulationConfiguration.mdchgprocsimlnconfignuuid = _MDChgProcessStep.process_config_uuid
    join         mdc_d_cnfsimmdqr as _SimulationRule          on _SimulationRule.mdchgprocsimlnuuid = _SimulationConfiguration.mdchgprocsimlnuuid

{
  key  _MasterDataChangeProcess.db_key                  as MasterDataChangeProcessUUID,
  key  cast( _SimulationRule.mdqualitybusinessruleuuid as
             mdq_rule_definition_uuid preserving type ) as MDQualityBusinessRuleUUID,
       _MasterDataChangeProcess.id                      as MasterDataChangeProcess,
       _MasterDataChangeProcess.description             as MDChgProcessDescription,
       _MasterDataChangeProcess.source_otc              as MDChgProcessSrceObjectTypeCode,
       _MasterDataChangeProcess.requestor               as MDChgProcessRequestor,
       _MasterDataChangeProcess.create_date             as MDChgProcessCreationDate,
       _MasterDataChangeProcess.create_time             as MDChgProcessCreationTime,
       _MasterDataChangeProcess.finish_time             as MDChgProcessFinishTime,
       _MasterDataChangeProcess.finish_date             as MDChgProcessFinishDate
}
where 
  _MasterDataChangeProcess.goal = 'T' and
  _MasterDataChangeProcess.erased <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MDC_D_CNFSIM",
"MDC_D_CNFSIMMDQR",
"MDC_D_PRCROOT",
"MDC_D_PRCSTEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More