I_MDChgProcessStepEnhcd

DDL: I_MDCHGPROCESSSTEPENHCD SQL: IMDCPROCSENH Type: view COMPOSITE

MD Change Process Step Enhanced

I_MDChgProcessStepEnhcd is a Composite CDS View (Fact) that provides data about "MD Change Process Step Enhanced" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessStep) and exposes 11 fields with key fields MasterDataChangeProcess, MDChgProcessStep. It has 6 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessStep I_MDChgProcessStep from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
[0..1] I_MDChangeProcStepValdtnRslts _MDChangeProcStepValdtnRslts _MDChangeProcStepValdtnRslts.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _MDChangeProcStepValdtnRslts.MDChgProcessStep = $projection.MDChgProcessStep
[0..*] I_MDChangeProcModifdTables _MDChangeProcModifdTables _MDChangeProcModifdTables.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _MDChangeProcModifdTables.MDChgProcessStep = $projection.MDChgProcessStep
[0..*] I_MDChgProcModifdObjects _MDChgProcModifdObjects _MDChgProcModifdObjects.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _MDChgProcModifdObjects.MDChgProcessStep = $projection.MDChgProcessStep
[1..1] I_MDChgProcessStepType _MDChgProcessStepType _MDChgProcessStepType.MDChgProcessStepType = $projection.MDChgProcessStepType
[1..1] I_MDChangeProcStepStatus _MDChangeProcStepStatus _MDChangeProcStepStatus.MDChgProcessStepStatus = $projection.MDChgProcessStepStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCPROCSENH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MD Change Process Step Enhanced view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #FACT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
MDChgProcessStepType MDChgProcessStepType
MDChgProcessStepStatus MDChgProcessStepStatus
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
_MDChgProcessStepType _MDChgProcessStepType
_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd
_MDChangeProcStepStatus _MDChangeProcStepStatus
_MDChangeProcModifdTables _MDChangeProcModifdTables
_MDChgProcModifdObjects _MDChgProcModifdObjects
_MDChangeProcStepValdtnRslts _MDChangeProcStepValdtnRslts 
@AbapCatalog.sqlViewName: 'IMDCPROCSENH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MD Change Process Step Enhanced'
@ObjectModel.usageType: { sizeCategory: #M, dataClass: #TRANSACTIONAL, serviceQuality: #C }
@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #FACT
@ClientHandling.algorithm: #SESSION_VARIABLE
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_MDChgProcessStepEnhcd
  as select from I_MDChgProcessStep

  association [1..1] to I_MasterDataChangeProcessEnhcd as _MasterDataChangeProcessEnhcd on  _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess

  association [0..1] to I_MDChangeProcStepValdtnRslts  as _MDChangeProcStepValdtnRslts  on  _MDChangeProcStepValdtnRslts.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                                        and _MDChangeProcStepValdtnRslts.MDChgProcessStep        = $projection.MDChgProcessStep

  association [0..*] to I_MDChangeProcModifdTables     as _MDChangeProcModifdTables     on  _MDChangeProcModifdTables.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                                        and _MDChangeProcModifdTables.MDChgProcessStep        = $projection.MDChgProcessStep

  association [0..*] to I_MDChgProcModifdObjects       as _MDChgProcModifdObjects       on  _MDChgProcModifdObjects.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                                        and _MDChgProcModifdObjects.MDChgProcessStep        = $projection.MDChgProcessStep

  association [1..1] to I_MDChgProcessStepType         as _MDChgProcessStepType         on  _MDChgProcessStepType.MDChgProcessStepType = $projection.MDChgProcessStepType

  association [1..1] to I_MDChangeProcStepStatus       as _MDChangeProcStepStatus       on  _MDChangeProcStepStatus.MDChgProcessStepStatus = $projection.MDChgProcessStepStatus



{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
      @ObjectModel.foreignKey.association: '_MDChgProcessStepType'
      MDChgProcessStepType,
      @ObjectModel.foreignKey.association: '_MDChangeProcStepStatus'
      MDChgProcessStepStatus,
      MDChgProcessSrceObjectTypeCode,

      case when MDChgProcessStepStatus = '2' or
                MDChgProcessStepStatus = '3' or
                MDChgProcessStepStatus = '5' then 'X'
           else ''
           end as MDChgProcessStepIsIdle,


      //Associations

      //I_MDChgProcessStepEnhcd

      _MDChgProcessStepType,
      _MasterDataChangeProcessEnhcd,
      _MDChangeProcStepStatus,
      _MDChangeProcModifdTables,
      _MDChgProcModifdObjects,
      _MDChangeProcStepValdtnRslts //validation results


}

Learn More