I_MDCHANGEPROCESSGOALVALUEHELP

CDS View

MD Change Process Goal

I_MDCHANGEPROCESSGOALVALUEHELP is a CDS View in S/4HANA. MD Change Process Goal. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MDChangeProcessGoalValueHelp view from CONSUMPTION MD Change Process Goal Value Help
@AbapCatalog.sqlViewName: 'IMDCHGPROCGOALVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'MDChgProcessGoal'
@ObjectModel: {
    resultSet.sizeCategory: #XS,
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MIXED }
@ObjectModel.dataCategory: #VALUE_HELP
//@Search.searchable: true

@VDM:           {viewType:           #BASIC}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'MD Change Process Goal'
@Search.searchable: true
@Consumption.ranked: true 
define view I_MDChangeProcessGoalValueHelp
  as select from I_MDChangeProcGoal
{
      //

      @ObjectModel.text.association: '_Text'
      //      @Search.defaultSearchElement: true

      //      @Search.fuzzinessThreshold: 0.8

      //      @Search.ranking: #HIGH

      @EndUserText.label: 'Category'
      @Consumption.filter.hidden: true
      //  key dd07l.domvalue_l as DomainValueLow,

      //  key cast ( cast ( substring( domvalue_l, 1, 1 ) as abap.char( 1 ) ) as mdc_process_goal ) as MDChgProcessGoal,  

      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key MDChgProcessGoal,
      @EndUserText.label: 'Process Goal'
      @Search.defaultSearchElement: false
      @Search.ranking: #LOW
      _MDChangeProcGoalT as _Text
      //

}
where
(
       MDChgProcessGoal = 'G'
    or MDChgProcessGoal = 'U'
    or MDChgProcessGoal = 'C'
    or MDChgProcessGoal = 'F'
    or MDChgProcessGoal = 'X'
    or MDChgProcessGoal = 'Q'
    or MDChgProcessGoal = 'P'
    or MDChgProcessGoal = 'Y'
    or MDChgProcessGoal = 'T'
    or MDChgProcessGoal = 'O'
  )