I_MDChgProcRAPBasedSwitch

DDL: I_MDCHGPROCRAPBASEDSWITCH SQL: IMDCHGPRAPBASED Type: view BASIC Package: MDC_RAP_SWITCH

Cloud Ready MDG Switch

I_MDChgProcRAPBasedSwitch is a Basic CDS View that provides data about "Cloud Ready MDG Switch" in SAP S/4HANA. It reads from 1 data source (mdc_model_otc) and exposes 2 fields with key field MDChgProcessSrceObjectTypeCode. Part of development package MDC_RAP_SWITCH.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
mdc_model_otc model from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPRAPBASED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cloud Ready MDG Switch view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrceObjectTypeCode mdc_model_otc bo_type
MDChgProcessSuiteObjTypeCode 
@AbapCatalog.sqlViewName: 'IMDCHGPRAPBASED'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #S, dataClass: #CUSTOMIZING }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Cloud Ready MDG Switch'
define view I_MDChgProcRAPBasedSwitch
  as select from           mdc_model_otc    as model
    left outer to one join mdc_model_suited as model_suited on model.bo_type = model_suited.bo_type

    left outer to one join mdc_rap_otc      as rap_otc      on model.bo_type      = rap_otc.rap_switchable_otc
                                                            or model_suited.suite = rap_otc.rap_switchable_otc
    left outer to one join mdc_rap_switch   as rap_switch   on model.bo_type      = rap_switch.rap_switchable_otc
                                                            or model_suited.suite = rap_switch.rap_switchable_otc
{
  key model.bo_type                                                            as MDChgProcessSrceObjectTypeCode,
      case when model_suited.suite is null then '' else model_suited.suite end as MDChgProcessSuiteObjTypeCode,
      cast (
        case
          when rap_otc.rap_switchable_otc is not null
            then 'X'
          when rap_switch.rap_switched_on is not null
            then rap_switch.rap_switched_on
          else ' ' 
        end as boole_d preserving type
      )                                                                        as MDChgProcRAPBsdSwitchIsActive
}

Learn More