P_MDChangeProcessStatusState

DDL: P_MDCHANGEPROCESSSTATUSSTATE SQL: PMDCHGPROCSTATE Type: view CONSUMPTION Package: MDC_PROCESS_OBJECT

Helper view for process state

P_MDChangeProcessStatusState is a Consumption CDS View that provides data about "Helper view for process state" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessStatusStateCode) and exposes 8 fields with key field MasterDataChangeProcessUUID. It has 1 association to related views. Part of development package MDC_PROCESS_OBJECT.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessStatusStateCode I_MDChgProcessStatusStateCode from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_MDChangeProcessStatusStateT _ProcessStateText _ProcessStateText.MDChgProcessStatusStateCode = $projection.MDChgProcessStatusStateCode and _ProcessStateText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMDCHGPROCSTATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber
MDChgProcessStatus MDChgProcessStatus
MDChgProcessChkPointIsActive MDChgProcessChkPointIsActive
MDChgProcessStatusStateCode MDChgProcessStatusStateCode
MDChgProcessTypeID MDChgProcessTypeID
MDChgProcessStatusStateName _ProcessStateText MDChgProcessStatusStateName Process Status
@AbapCatalog.sqlViewName: 'PMDCHGPROCSTATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.private:true
@VDM.viewType: #CONSUMPTION
define view P_MDChangeProcessStatusState
  as select from I_MDChgProcessStatusStateCode
  association [0..1] to C_MDChangeProcessStatusStateT as _ProcessStateText on  _ProcessStateText.MDChgProcessStatusStateCode = $projection.MDChgProcessStatusStateCode
                                                                           and _ProcessStateText.Language                    = $session.system_language

{
  key MasterDataChangeProcessUUID,
      MasterDataChangeProcess,
      MDChgProcessCurrentStepNumber,
      MDChgProcessStatus,
      MDChgProcessChkPointIsActive,
      MDChgProcessStatusStateCode,
      MDChgProcessTypeID,
//      @ObjectModel.virtualElement: true

//      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MDC_PROCESS_STATE_CALC_EXIT'

//      cast( '' as abap.char( 100 ) ) as MDChgProcessStatusStateName

      @EndUserText.label: 'Process Status'
      @EndUserText.quickInfo: 'Process Status'
      @UI.hidden: true
      _ProcessStateText.MDChgProcessStatusStateName as MDChgProcessStatusStateName
}