I_MblApplPushNotification

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_MblApplPushNotification.
-- 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_MblApplPushNotification AS
SELECT
  instance_guid AS MobileApplicationPushInternal,
  mobile_app AS MobileUserApplication,
  scenario_id AS MblApplPushScenarioInternal,
  record_id AS MobileUserRecordInternal,
  source_type AS MblUsrApplPushSourceType,
  source_object AS MobileUserApplPushSourceObj,
  objkey AS MobileUserApplPushObjKey,
  objkey_ref AS MobileUserApplPushObjKeyRef,
  push_status AS MobileUserApplicationPushSts,
  total_subscriber AS MblUsrApplNmbrOfPushRecipients,
  email_notif AS MblUsrApplPushEmlNotifIsEnbld,
  expiration_ts AS MobileUserApplPushExprtnDteTme,
  process_ts AS MblUsrApplPushProcdDteTme,
  cancel_ts AS MblUsrApplPushCancelDteTme,
  complete_ts AS MobileUserApplPushCmpltDteTme,
  srv_complete_ts AS MblApplPushServerCmpltdDteTme,
  enqueue_ts AS MblUsrApplPushEnqueueDteTme,
  event_id AS MblUsrApplPushEventInternal,
  event_param AS MobileUserApplPushEvtParam,
  qrfc_queue AS MobileUserApplPushQueuedRFC,
  priority AS MobileUserApplPushScenarioPrio,
  enable_history AS MobileUserApplPushHistIsEnbld,
  enable_otrig AS MblUsrApplPushOutbTrggrIsEnbld,
  allow_retry AS MobileUserApplPushRetryIsAllwd,
  fetch_callback AS MblUsrApplFetchCallbackIsAllwd,
  created_by AS MobileUserApplPushCreatedBy,
  created_ts AS MblUsrApplPushCreatedDteTme,
  changed_by AS MobileUserApplPushChangedBy,
  changed_ts AS MblUsrApplPushChangedDteTme,
  tstmp_to_dats( created_ts, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate
FROM /syclo/psh01 AS PushNotification
LEFT OUTER JOIN I_MblUsrApplPushStatusText AS _PushStatusText ON _PushStatusText.MobileUserApplicationPushSts = MobileUserApplicationPushSts  -- association [0..*]
LEFT OUTER JOIN I_MaintMblApplPushSrceTypeText AS _SourceTypeText ON _SourceTypeText.MblUsrApplPushSourceType = MblUsrApplPushSourceType  -- association [0..*]
;