C_MDChgProcessActivatedProcess

DDL: C_MDCHGPROCESSACTIVATEDPROCESS Type: view_entity CONSUMPTION

Activated processes

C_MDChgProcessActivatedProcess is a Consumption CDS View that provides data about "Activated processes" in SAP S/4HANA. It has 2 associations to related views. It is exposed through 1 OData service (MASTERDATACHANGEPROCESSSD).

Exposed by 1 service(s) 11 fields

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MDChangeProcGoalT _ProcessGoalText _ProcessGoalText.MDChgProcessGoal = $projection.MDChgProcessGoal and _ProcessGoalText.Language = $session.system_language
[0..1] I_MasterDataChangeProcessUser _ProcessUser _ProcessUser.MDChgProcessRequestor = $projection.MDChgProcessRequestor and _ProcessUser.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Activated processes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
MASTERDATACHANGEPROCESSSD MASTERDATACHANGEPROCESSSB V2 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
KEY MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessDescription MDChgProcessDescription
MDChgProcessTypeID MDChgProcessTypeID
MDChgProcessGoal MDChgProcessGoal
MDChgProcessRequestor MDChgProcessRequestor
MDChgProcessIsErased MDChgProcessIsErased
MDChgProcessGoalName _ProcessGoalText MDChgProcessGoalName
CreatedByUserNameendasCreatedByUserName
_ProcessGoalText _ProcessGoalText
_ProcessUser _ProcessUser 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Activated processes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType: {
    serviceQuality: #X,
    sizeCategory: #XL,
    dataClass: #MIXED
  }
}
define view entity C_MDChgProcessActivatedProcess
  as select distinct from I_MDChgProcessActivatedProcess
  //  association [0..1] to I_MDChangeProcGoal            as _ProcessGoal on  _ProcessGoal.MDChgProcessGoal = $projection.MDChgProcessGoal

  association [0..1] to I_MDChangeProcGoalT           as _ProcessGoalText on  _ProcessGoalText.MDChgProcessGoal = $projection.MDChgProcessGoal
                                                                          and _ProcessGoalText.Language         = $session.system_language
  association [0..1] to I_MasterDataChangeProcessUser as _ProcessUser     on  _ProcessUser.MDChgProcessRequestor          = $projection.MDChgProcessRequestor
                                                                          and _ProcessUser.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode
{
  key MDChgProcessSrceObjectTypeCode,
  key MasterDataChangeProcess,
      MDChgProcessDescription,
      MDChgProcessTypeID,
      MDChgProcessGoal,
      MDChgProcessRequestor,
      MDChgProcessIsErased,

      _ProcessGoalText.MDChgProcessGoalName,
      case
        when _ProcessUser.CreatedByUserName is null then MDChgProcessRequestor
        else _ProcessUser.CreatedByUserName
      end as CreatedByUserName,

      _ProcessGoalText,
      _ProcessUser
}
where MDChgProcessIsErased is initial

Learn More