I_MblApplPushScenarioDef

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MblApplPushScenarioDef.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MblApplPushScenarioDef AS
SELECT
  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,
  changed_ts AS MblUsrApplPushChangedDteTme
FROM /syclo/psh00 AS PushScenario
-- UNION ALL with additional select branch(es): /syclo/ypsh00
;