I_MBLAPPLPUSHSCENARIODEF

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL
}

@EndUserText.label: 'Mobile Application Push Scenario'
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}

@ObjectModel: {
  modelingPattern: #ANALYTICAL_DIMENSION,
  representativeKey: 'MblApplPushScenarioInternal',
  supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET ],
  usageType:{
    serviceQuality: #A,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
  }
}

@VDM.viewType: #BASIC

define view entity I_MblApplPushScenarioDef 
as select from /syclo/psh00 as PushScenario
   left outer to one join /syclo/ypsh00 on  /syclo/ypsh00.scenario_id     = PushScenario.scenario_id
{
    key PushScenario.scenario_id         as MblApplPushScenarioInternal,
        PushScenario.mobile_app          as MobileUserApplication,
        PushScenario.source_type         as MblUsrApplPushSourceType,
        PushScenario.source_object       as MobileUserApplPushSourceObj,
        PushScenario.source_handler      as MblApplPushScenSourceHandler,
        PushScenario.subscriber_type     as MblApplPushScenSubscriberType,
        PushScenario.distributor_type    as MblApplPushDistributorType,
        PushScenario.distributor_obj     as MblApplPushDistributorObj,
        PushScenario.distrib_handler     as MblApplPushDistributionHandler,
        PushScenario.send_email          as MblUsrApplPushEmlNotifIsEnbld,
        PushScenario.subject             as MblApplPushEmailNotifDesc,
        PushScenario.message             as MblApplPushEmailMessageText,
        PushScenario.skip_datapack       as MblApplPushDataPackIsSkipped,
        PushScenario.active              as MblApplPushScenIsActive,
        PushScenario.push_validity       as MblApplPushNotifValidityInHrs,
        PushScenario.disable_event       as MblApplPushEvtTrggrIsDsbld,
        PushScenario.event_id            as MblUsrApplPushEventInternal,
        PushScenario.event_param         as MobileUserApplPushEvtParam,
        PushScenario.event_rule          as MobileApplicationPushEventRule,
        PushScenario.enable_qrfc         as MblApplQueuedRFCIsEnabled,
        PushScenario.qrfc_queue          as MblApplPushQueuedRFCName,
        PushScenario.qrfc_rule           as MblApplPushQueuedRFCRule,
        PushScenario.priority            as MobileUserApplPushScenarioPrio,
        PushScenario.flag_allow_merge    as MblApplPushMergeIsAllowed,
        PushScenario.flag_no_srv_comp    as MblApplPushServerCmpltdIsExcld,
        PushScenario.max_select_delay    as MblApplPushMaxSelDelayInSecs,
        PushScenario.num_select_retry    as MblApplPushNmbrOfSelRetry,
        PushScenario.enable_history      as MobileUserApplPushHistIsEnbld,
        PushScenario.enable_otrig        as MblUsrApplPushOutbTrggrIsEnbld,
        PushScenario.single_inst_proc    as MblApplSglInstceProcgIsUsed,
        PushScenario.refetch_interval    as MblApplPushRetryIntvlInSeconds,
        PushScenario.gen_meta_info       as MblApplPushMetadataIsRequired,
        PushScenario.no_self_push        as MblApplSelfPushIsDisabled,
        PushScenario.scenario_alias      as MblApplPushScenarioAlias,
        PushScenario.fetch_callback      as MblUsrApplFetchCallbackIsAllwd,
        PushScenario.check_mtran_hist    as MblApplPushTransHistIsChkd,
        PushScenario.mtran_his_intval    as MblApplTransHistIntvlInSecs,
        PushScenario.allow_subreq        as MblApplPushSubscriptionIsAllwd,
        PushScenario.subagent_id         as MblApplPushSubscrpnAgtInt,
        PushScenario.created_by          as MobileUserApplPushCreatedBy,
        PushScenario.created_ts          as MblUsrApplPushCreatedDteTme,
        PushScenario.changed_by          as MobileUserApplPushChangedBy,
        PushScenario.changed_ts          as MblUsrApplPushChangedDteTme
}
where
  /syclo/ypsh00.scenario_id is null
union all

select from /syclo/ypsh00
{
    key scenario_id         as MblApplPushScenarioInternal,
        mobile_app          as MobileUserApplication,
        source_type         as MblUsrApplPushSourceType,
        source_object       as MobileUserApplPushSourceObj,
        source_handler      as MblApplPushScenSourceHandler,
        subscriber_type     as MblApplPushScenSubscriberType,
        distributor_type    as MblApplPushDistributorType,
        distributor_obj     as MblApplPushDistributorObj,
        distrib_handler     as MblApplPushDistributionHandler,
        send_email          as MblUsrApplPushEmlNotifIsEnbld,
        subject             as MblApplPushEmailNotifDesc,
        message             as MblApplPushEmailMessageText,
        skip_datapack       as MblApplPushDataPackIsSkipped,
        active              as MblApplPushScenIsActive,
        push_validity       as MblApplPushNotifValidityInHrs,
        disable_event       as MblApplPushEvtTrggrIsDsbld,
        event_id            as MblUsrApplPushEventInternal,
        event_param         as MobileUserApplPushEvtParam,
        event_rule          as MobileApplicationPushEventRule,
        enable_qrfc         as MblApplQueuedRFCIsEnabled,
        qrfc_queue          as MblApplPushQueuedRFCName,
        qrfc_rule           as MblApplPushQueuedRFCRule,
        priority            as MobileUserApplPushScenarioPrio,
        flag_allow_merge    as MblApplPushMergeIsAllowed,
        flag_no_srv_comp    as MblApplPushServerCmpltdIsExcld,
        max_select_delay    as MblApplPushMaxSelDelayInSecs,
        num_select_retry    as MblApplPushNmbrOfSelRetry,
        enable_history      as MobileUserApplPushHistIsEnbld,
        enable_otrig        as MblUsrApplPushOutbTrggrIsEnbld,
        single_inst_proc    as MblApplSglInstceProcgIsUsed,
        refetch_interval    as MblApplPushRetryIntvlInSeconds,
        gen_meta_info       as MblApplPushMetadataIsRequired,
        no_self_push        as MblApplSelfPushIsDisabled,
        scenario_alias      as MblApplPushScenarioAlias,
        fetch_callback      as MblUsrApplFetchCallbackIsAllwd,
        check_mtran_hist    as MblApplPushTransHistIsChkd,
        mtran_his_intval    as MblApplTransHistIntvlInSecs,
        allow_subreq        as MblApplPushSubscriptionIsAllwd,
        subagent_id         as MblApplPushSubscrpnAgtInt,
        created_by          as MobileUserApplPushCreatedBy,
        created_ts          as MblUsrApplPushCreatedDteTme,
        changed_by          as MobileUserApplPushChangedBy,
        changed_ts          as MblUsrApplPushChangedDteTme
}
where
  deleted = ''