@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
}
/*+[internal] {
"BASEINFO":
{
"FROM ":
[
"I_MASTERDATACHANGEPROCESSVH",
"I_MDCHANGEPROCESSVARIANT"
],
"ASSOCIATED":
[
"C_MASTERDATACHANGEPROCESSGOAL",
"I_MDCHANGEPROCESSVARIANT",
"I_MDCHGPROCESSTYPETEXT",
"I_USER"
],
"BASE":
[
"I_MASTERDATACHANGEPROCESSVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Depth:
1
2
3
4
5
All
Reload
C_MasterDataChangeProcessVH view