I_MDChgProcessStatusStateCode

DDL: I_MDCHGPROCESSSTATUSSTATECODE SQL: IMDCHGPROCSTATEC Type: view BASIC

MD Change Process Status State Code

I_MDChgProcessStatusStateCode is a Basic CDS View that provides data about "MD Change Process Status State Code" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcess) and exposes 8 fields with key field MasterDataChangeProcessUUID. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess I_MasterDataChangeProcess from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MDChgProcessStep _CurrentStep _CurrentStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID and _CurrentStep.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber
[0..1] I_MDChangeProcessIsIdle _ProcessIsIdle _ProcessIsIdle.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[0..1] P_MDChangeProcessLastStep _ProcessLastStep _ProcessLastStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCSTATEC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label MD Change Process Status State Code view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber
MDChgProcessStatus MDChgProcessStatus
MDChgProcessChkPointIsActive MDChgProcessChkPointIsActive
MDChgProcessTypeID MDChgProcessTypeID
MDChgProcessGoal MDChgProcessGoal 
@AbapCatalog.sqlViewName: 'IMDCHGPROCSTATEC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #M, serviceQuality: #C }
@EndUserText.label: 'MD Change Process Status State Code'
define view I_MDChgProcessStatusStateCode
  as select from I_MasterDataChangeProcess
  association [0..1] to I_MDChgProcessStep        as _CurrentStep     on  _CurrentStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
                                                                      and _CurrentStep.MDChgProcessStep            = $projection.MDChgProcessCurrentStepNumber
  association [0..1] to I_MDChangeProcessIsIdle   as _ProcessIsIdle   on  _ProcessIsIdle.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..1] to P_MDChangeProcessLastStep as _ProcessLastStep on  _ProcessLastStep.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
{
  key MasterDataChangeProcessUUID,
      MDChgProcessSrceObjectTypeCode,
      MasterDataChangeProcess,
      MDChgProcessCurrentStepNumber,
      MDChgProcessStatus,
      MDChgProcessChkPointIsActive,
      @ObjectModel.readOnly: true
      cast(   case when MDChgProcessIsErased = 'X' then '014'
                   when MDChgProcessStatus = 'S' then '006'
                   when MDChgProcessStatus = 'F' then '005'
                   when MDChgProcessStatus = 'P' then '013'
                   when MDChgProcessStatus = 'R' then '011'
                   when MDChgProcessStatus = 'W' then '012'
                   else
                   case when _CurrentStep.MDChgProcessStepStatus = '4'
                        then case when MDChgProcessChkPointIsActive is not initial then '001'
                                  when MDChgProcessCurrentStepNumber = _ProcessLastStep.MDChgProcessLastStepNumber then '010'
                                  else '008'
                             end
                        when _CurrentStep.MDChgProcessStepStatus = '1' then '002'
                        when _CurrentStep.MDChgProcessStepStatus = '2' then '003'
                        when _CurrentStep.MDChgProcessStepStatus = '3' then '004'
                        when _CurrentStep.MDChgProcessStepStatus = '5' then '007'
                        else case when _ProcessIsIdle.MDChgProcessIsIdle is initial
                                       and MDChgProcessCurrentStepNumber is initial then '009'
                                  when MDChgProcessChkPointIsActive is not initial then '001'
                                  else '008'
                             end
                   end
              end as mdc_process_status_state_code
      )                              as MDChgProcessStatusStateCode,
      MDChgProcessTypeID,
      MDChgProcessGoal
}

Learn More