C_MblApplPushRecipients

DDL: C_MBLAPPLPUSHRECIPIENTS Type: view_entity CONSUMPTION
21 Fields 1 Data Sources 1 Associations 1 OData Services

Mobile Appl Push Notification Recipients

C_MblApplPushRecipients is a Consumption CDS View that provides data about "Mobile Appl Push Notification Recipients" in SAP S/4HANA. It reads from 1 data source (I_MblApplPushRecipients) and exposes 21 fields with key field MblApplPushItemInternal. It has 1 association to related views. It is exposed through 1 OData service (UI_MOBILEAPPLPUSH).

Data Sources (1)

SourceAliasJoin Type
I_MblApplPushRecipients PushRecipients from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_MobileDataUnitMessageQueue _PushMessage $projection.MblApplMessageInternal = _PushMessage.MblApplMessageInternal

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mobile Appl Push Notification Recipients 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_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MblApplPushItemInternal MblApplPushItemInternal Push ItemGU
MobileApplicationPushInternal MobileApplicationPushInternal Push Instance GUID
MobileUserRecordInternal MobileUserRecordInternal Sort No.
MblApplMessageInternal MblApplMessageInternal Message GUID
MobileUserInternal MobileUserInternal User GUID
MobileApplicationPushRecipient MobileApplicationPushRecipient User Name
MobileUserApplication MobileUserApplication Mobile Application
MblUsrApplPushEmlNotifIsEnbld MblUsrApplPushEmlNotifIsEnbld Active Flag
MobileUserApplicationPushSts MobileUserApplicationPushSts Push Status
MobileUserApplPushExprtnDteTme MobileUserApplPushExprtnDteTme Time Stamp
MblUsrApplPushCancelDteTme MblUsrApplPushCancelDteTme Time Stamp
MblApplPushServerConfDteTme MblApplPushServerConfDteTme Time Stamp
MblApplPushClientConfDteTme MblApplPushClientConfDteTme Time Stamp
MblApplClntErrDteTme MblApplClntErrDteTme Time Stamp
MobileUserApplPushCreatedBy MobileUserApplPushCreatedBy Version Created By
MblUsrApplPushCreatedDteTme MblUsrApplPushCreatedDteTme Time Stamp
MobileUserApplPushChangedBy MobileUserApplPushChangedBy User Name
MblUsrApplPushChangedDteTme MblUsrApplPushChangedDteTme Time Stamp
MblApplOutbTrggrProcDteTme _PushMessage MblApplOutbTrggrProcDteTme
_PushNotification _PushNotification
_PushMessage _PushMessage

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_MblApplPushRecipients.
-- 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_MblApplPushRecipients AS
SELECT
  MblApplPushItemInternal,
  MobileApplicationPushInternal,
  MobileUserRecordInternal,
  MblApplMessageInternal,
  MobileUserInternal,
  MobileApplicationPushRecipient,
  MobileUserApplication,
  MblUsrApplPushEmlNotifIsEnbld,
  MobileUserApplicationPushSts,
  MobileUserApplPushExprtnDteTme,
  MblUsrApplPushCancelDteTme,
  MblApplPushServerConfDteTme,
  MblApplPushClientConfDteTme,
  MblApplClntErrDteTme,
  MobileUserApplPushCreatedBy,
  MblUsrApplPushCreatedDteTme,
  MobileUserApplPushChangedBy,
  MblUsrApplPushChangedDteTme,
  _PushMessage.MblApplOutbTrggrProcDteTme AS MblApplOutbTrggrProcDteTme
FROM I_MblApplPushRecipients AS PushRecipients
LEFT OUTER JOIN C_MobileDataUnitMessageQueue AS _PushMessage ON MblApplMessageInternal = _PushMessage.MblApplMessageInternal  -- association [1..1]
;

Learn More