C_MblApplPushNotification

DDL: C_MBLAPPLPUSHNOTIFICATION Type: view_entity CONSUMPTION Package: RAP_MAO_MAIF_ADMIN
23 Fields 1 Data Sources 3 Associations 1 OData Services

Mobile Application Push Notification

C_MblApplPushNotification is a Consumption CDS View that provides data about "Mobile Application Push Notification" in SAP S/4HANA. It reads from 1 data source (I_MblApplPushNotification) and exposes 23 fields with key field MobileApplicationPushInternal. It has 3 associations to related views. It is exposed through 1 OData service (UI_MOBILEAPPLPUSH). Part of development package RAP_MAO_MAIF_ADMIN.

Data Sources (1)

SourceAliasJoin Type
I_MblApplPushNotification PushNotification from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_MblApplPushScenarioDef _PushScenario $projection.MblApplPushScenarioInternal = _PushScenario.MblApplPushScenarioInternal
[0..1] I_MblUsrApplPushStatusText _PushStatusText $projection.MobileUserApplicationPushSts = _PushStatusText.MobileUserApplicationPushSts and _PushStatusText.Language = $session.system_language
[1..*] C_MblApplPushRecipients _PushRecipients

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mobile Application Push Notification view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MOBILEAPPLPUSH UI_MOBILEAPPLPUSH_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MobileApplicationPushInternal MobileApplicationPushInternal Push Instance GUID
MobileUserApplication MobileUserApplication Mobile Application
MblApplPushScenarioInternal MblApplPushScenarioInternal Workflow definition
MobileUserApplPushObjKey MobileUserApplPushObjKey Push Object Key
MobileUserApplPushObjKeyRef MobileUserApplPushObjKeyRef Reference Object Key
MobileUserApplicationPushSts MobileUserApplicationPushSts Push Status
MblUsrApplPushStatusName _PushStatusText MblUsrApplPushStatusName
MblUsrApplNmbrOfPushRecipients MblUsrApplNmbrOfPushRecipients Subscriber Count
MobileUserApplPushExprtnDteTme MobileUserApplPushExprtnDteTme Time Stamp
MblUsrApplPushProcdDteTme MblUsrApplPushProcdDteTme Time Stamp
MblUsrApplPushCancelDteTme MblUsrApplPushCancelDteTme Time Stamp
MobileUserApplPushCmpltDteTme MobileUserApplPushCmpltDteTme Time Stamp
MblUsrApplPushEventInternal MblUsrApplPushEventInternal ID
MobileUserApplPushEvtParam MobileUserApplPushEvtParam Bkgrd event param.
MobileUserApplPushQueuedRFC MobileUserApplPushQueuedRFC Queue Name
MobileUserApplPushCreatedBy MobileUserApplPushCreatedBy Version Created By
MblUsrApplPushCreatedDteTme MblUsrApplPushCreatedDteTme Time Stamp
MobileUserApplPushChangedBy MobileUserApplPushChangedBy User Name
MblUsrApplPushChangedDteTme MblUsrApplPushChangedDteTme Time Stamp
MobileApplicationPushRecipient
MobileApplPushNotifTitle
_PushScenario _PushScenario
_PushRecipients _PushRecipients

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 C_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 C_MblApplPushNotification AS
SELECT
  MobileApplicationPushInternal,
  MobileUserApplication,
  MblApplPushScenarioInternal,
  MobileUserApplPushObjKey,
  MobileUserApplPushObjKeyRef,
  MobileUserApplicationPushSts,
  _PushStatusText.MblUsrApplPushStatusName AS MblUsrApplPushStatusName,
  MblUsrApplNmbrOfPushRecipients,
  MobileUserApplPushExprtnDteTme,
  MblUsrApplPushProcdDteTme,
  MblUsrApplPushCancelDteTme,
  MobileUserApplPushCmpltDteTme,
  MblUsrApplPushEventInternal,
  MobileUserApplPushEvtParam,
  MobileUserApplPushQueuedRFC,
  MobileUserApplPushCreatedBy,
  MblUsrApplPushCreatedDteTme,
  MobileUserApplPushChangedBy,
  MblUsrApplPushChangedDteTme,
  cast( ' ' as uname ) AS MobileApplicationPushRecipient,
  concat_with_space(MobileUserApplPushObjKey, concat_with_space('-', MobileUserApplication,1), 1) AS MobileApplPushNotifTitle
FROM I_MblApplPushNotification AS PushNotification
LEFT OUTER JOIN C_MblApplPushScenarioDef AS _PushScenario ON MblApplPushScenarioInternal = _PushScenario.MblApplPushScenarioInternal  -- association [1..1]
LEFT OUTER JOIN I_MblUsrApplPushStatusText AS _PushStatusText ON MobileUserApplicationPushSts = _PushStatusText.MobileUserApplicationPushSts AND _PushStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MblApplPushRecipients AS _PushRecipients ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More