C_MDChgProcStepActivationKPI

DDL: C_MDCHGPROCSTEPACTIVATIONKPI SQL: CMDCHNGPRCACTKPI Type: view CONSUMPTION

MD Change Process Step Activation KPI

C_MDChgProcStepActivationKPI is a Consumption CDS View that provides data about "MD Change Process Step Activation KPI" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcStepActivationKPI) and exposes 32 fields with key field MDChgProcessStepUUID.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcStepActivationKPI I_MDChgProcStepActivationKPI from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMDCHNGPRCACTKPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label MD Change Process Step Activation KPI view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessStep MDChgProcessStep
MDChgProcessTypeID MDChgProcessTypeID
MDChgProcessGoal MDChgProcessGoal
MDChgProcessStatus MDChgProcessStatus
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
MDChgProcessStepAdapter MDChgProcessStepAdapter
MDChgProcessStepType MDChgProcessStepType
MDChgProcessStepStatus MDChgProcessStepStatus
MDChgProcessStepStartDateTime MDChgProcessStepStartDateTime
MDChgProcessStepFinishDateTime MDChgProcessStepFinishDateTime
MDNrOfNewSglRecdDirectActvtn MDNrOfNewSglRecdDirectActvtn
MDNrOfNewBestRecdDirectActvtn MDNrOfNewBestRecdDirectActvtn
MDNrOfUpdatesDirectActvtn MDNrOfUpdatesDirectActvtn
MDNrOfDeletionsDirectActvtn MDNrOfDeletionsDirectActvtn
MDNrOfNewSglRecdChangeRequest MDNrOfNewSglRecdChangeRequest
MDNrOfNewBestRecdChangeRequest MDNrOfNewBestRecdChangeRequest
MDNrOfUpdatesChangeRequest MDNrOfUpdatesChangeRequest
MDNrOfDeletionsChangeRequest MDNrOfDeletionsChangeRequest
MDNrOfNewSglRecdActvtnFailed MDNrOfNewSglRecdActvtnFailed
MDNrOfNewBestRecdActvtnFailed MDNrOfNewBestRecdActvtnFailed
MDNrOfUpdatesActvtnFailed MDNrOfUpdatesActvtnFailed
MDNrOfDeletionsActvtnFailed MDNrOfDeletionsActvtnFailed
MDNrOfNewSglRecdCleansingCase MDNrOfNewSglRecdCleansingCase
MDNrOfNewBestRecdCleansingCase MDNrOfNewBestRecdCleansingCase
MDNrOfUpdatesCleansingCase MDNrOfUpdatesCleansingCase
MDNrOfDeletionsCleansingCase MDNrOfDeletionsCleansingCase
MDNrOfNewSglRecdNotActivated MDNrOfNewSglRecdNotActivated
MDNrOfNewBestRecdNotActivated MDNrOfNewBestRecdNotActivated
MDNrOfUpdatesNotActivated MDNrOfUpdatesNotActivated
MDNrOfDeletionsNotActivated MDNrOfDeletionsNotActivated
@AbapCatalog.sqlViewName: 'CMDCHNGPRCACTKPI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'MD Change Process Step Activation KPI'
@VDM.viewType: #CONSUMPTION

@ObjectModel.alternativeKey: [{
        id : 'MASTERDATACHANGEPROCESS',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MASTERDATACHANGEPROCESS']
    },{
        id : 'MDCHGPROCESSSTEP',
        uniqueness : #UNIQUE_IF_NOT_INITIAL,
        element : ['MDCHGPROCESSSTEP']
    }]

@ObjectModel: {
  usageType.serviceQuality: #B,
  usageType.sizeCategory : #L,
  usageType.dataClass: #MIXED
}

define view C_MDChgProcStepActivationKPI
  as select from I_MDChgProcStepActivationKPI
{
      //I_MDChgProcStepActivationKPI

  key MDChgProcessStepUUID,
      MasterDataChangeProcess,
      MDChgProcessStep,

      MDChgProcessTypeID,
      MDChgProcessGoal,
      MDChgProcessStatus,      
      MDChgProcessSrceObjectTypeCode,
      MDChgProcessStepAdapter,
      MDChgProcessStepType,
      MDChgProcessStepStatus,
      MDChgProcessStepStartDateTime,
      MDChgProcessStepFinishDateTime,

      MDNrOfNewSglRecdDirectActvtn,
      MDNrOfNewBestRecdDirectActvtn,
      MDNrOfUpdatesDirectActvtn,
      MDNrOfDeletionsDirectActvtn,

      MDNrOfNewSglRecdChangeRequest,
      MDNrOfNewBestRecdChangeRequest,
      MDNrOfUpdatesChangeRequest,
      MDNrOfDeletionsChangeRequest,

      MDNrOfNewSglRecdActvtnFailed,
      MDNrOfNewBestRecdActvtnFailed,
      MDNrOfUpdatesActvtnFailed,
      MDNrOfDeletionsActvtnFailed,

      MDNrOfNewSglRecdCleansingCase,
      MDNrOfNewBestRecdCleansingCase,
      MDNrOfUpdatesCleansingCase,
      MDNrOfDeletionsCleansingCase,

      MDNrOfNewSglRecdNotActivated,
      MDNrOfNewBestRecdNotActivated,
      MDNrOfUpdatesNotActivated,
      MDNrOfDeletionsNotActivated
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDCHGPROCSTEPACTIVATIONKPI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/