C_MasterDataChangeProcessVH

DDL: C_MASTERDATACHANGEPROCESSVH SQL: CMDCHGPROCESSVH Type: view CONSUMPTION

VH for Master Data Change Process

C_MasterDataChangeProcessVH is a Consumption CDS View that provides data about "VH for Master Data Change Process" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcessVH) and exposes 15 fields with key fields MasterDataChangeProcessUUID, MasterDataChangeProcess. It has 3 associations to related views. It is exposed through 1 OData service (MASTERDATACHANGEPROCESSSD).

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcessVH I_MasterDataChangeProcessVH from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_MasterDataChangeProcessGoal _ProcessGoalText _ProcessGoalText.MDChgProcessGoal = $projection.MDChgProcessGoal
[0..*] I_MDChgProcessTypeText _ProcessTypeText _ProcessTypeText.MDChgProcessTypeID = $projection.MDChgProcessTypeID
[1] I_MDChangeProcessVariant _ProcessVariant _ProcessVariant.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMDCHGPROCESSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label VH for Master Data Change Process view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
MASTERDATACHANGEPROCESSSD MASTERDATACHANGEPROCESSSB V2 C1 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process
MDChgProcessCreationDate MDChgProcessCreationDate
MDChgProcessDescription MDChgProcessDescription
MDChgProcessTypeID MDChgProcessTypeID
MDChgProcessGoal MDChgProcessGoal
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode
MDChgProcessRequestor MDChgProcessRequestor Process Requestor
FullName FullName Process Requestor
MDChgProcessIsStarted MDChgProcessIsStarted
MDChgProcessIsErased MDChgProcessIsErased Deleted
MasterDataChangeProcessVariant _ProcessVariant MasterDataChangeProcessVariant
_User _User
_ProcessGoalText _ProcessGoalText
_ProcessTypeText _ProcessTypeText
@AbapCatalog.sqlViewName: 'CMDCHGPROCESSVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'VH for Master Data Change Process'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.presentationVariant: [{
  sortOrder: [{by: 'MasterDataChangeProcess', direction: #DESC }]
}]
@Search.searchable: true
@Consumption.ranked: true 
define view C_MasterDataChangeProcessVH
  as select from I_MasterDataChangeProcessVH
  association [0..*] to C_MasterDataChangeProcessGoal as _ProcessGoalText on _ProcessGoalText.MDChgProcessGoal = $projection.MDChgProcessGoal
  association [0..*] to I_MDChgProcessTypeText        as _ProcessTypeText on _ProcessTypeText.MDChgProcessTypeID = $projection.MDChgProcessTypeID
  association [1]    to I_MDChangeProcessVariant      as _ProcessVariant  on _ProcessVariant.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
{
      //I_MasterDataChangeProcessVH

      @UI.hidden: true
  key MasterDataChangeProcessUUID,
      @EndUserText.label: 'Process'
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key MasterDataChangeProcess,
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      MDChgProcessCreationDate,
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      MDChgProcessDescription,
      @Consumption.valueHelpDefinition: [{ entity: {name: 'I_MDChangeProcessTypeVH', element: 'MDChgProcessTypeID'}, distinctValues: true }]
      @ObjectModel.text.association: '_ProcessTypeText'
      @UI.textArrangement: #TEXT_FIRST
      @UI.hidden: true
      MDChgProcessTypeID,
      @Consumption.valueHelpDefinition: [{ entity: {name: 'C_MDChangeProcessGoalValueHelp', element: 'MDChgProcessGoal'}, distinctValues: true }]
      @ObjectModel.text.association: '_ProcessGoalText'
      @UI.textArrangement: #TEXT_FIRST
      @UI.hidden: true
      MDChgProcessGoal,
      @UI.hidden: true
      MDChgProcessSrceObjectTypeCode,
      @UI.hidden: true
      @EndUserText.label: 'Process Requestor'
      MDChgProcessRequestor,
      @EndUserText.label: 'Process Requestor'
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      FullName,
      @UI.hidden: true
      MDChgProcessIsStarted,
      @EndUserText.label: 'Deleted'
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      MDChgProcessIsErased,
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      _ProcessVariant.MasterDataChangeProcessVariant,
      //MDChgProcessFilterChain,

      /* Associations */
      //I_MasterDataChangeProcessVH

      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      _User,
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      _ProcessGoalText,
      @Search.defaultSearchElement:false
      @Search.ranking: #LOW
      _ProcessTypeText
}