R_MaintMblApplPushNotifTP

DDL: R_MAINTMBLAPPLPUSHNOTIFTP Type: view_entity TRANSACTIONAL Package: RAP_MAO_MAIF_ADMIN
32 Fields 1 Data Sources 2 Associations

Mobile Push Notification - TP

R_MaintMblApplPushNotifTP is a Transactional CDS View that provides data about "Mobile Push Notification - TP" in SAP S/4HANA. It reads from 1 data source (I_MblApplPushNotification) and exposes 32 fields with key field MobileApplicationPushInternal. It has 2 associations to related views. Part of development package RAP_MAO_MAIF_ADMIN.

Data Sources (1)

SourceAliasJoin Type
I_MblApplPushNotification I_MblApplPushNotification from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MblUsrApplPushStatusText _PushStatusText _PushStatusText.MobileUserApplicationPushSts = $projection.MobileUserApplicationPushSts
[0..*] R_MaintMblApplPushRecipientTP _PushRecipients

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mobile Push Notification - TP view
ObjectModel.sapObjectNodeType.name MaintMblApplPushNotification view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MobileApplicationPushInternal MobileApplicationPushInternal Push Instance GUID
MobileUserApplication MobileUserApplication Mobile Application
MblApplPushScenarioInternal MblApplPushScenarioInternal Workflow definition
MobileUserRecordInternal MobileUserRecordInternal UUID
MblUsrApplPushSourceType MblUsrApplPushSourceType SRVC Source Type
MobileUserApplPushSourceObj MobileUserApplPushSourceObj Source object
MobileUserApplPushObjKey MobileUserApplPushObjKey Push Object Key
MobileUserApplPushObjKeyRef MobileUserApplPushObjKeyRef Reference Object Key
MobileUserApplicationPushSts MobileUserApplicationPushSts Push Status
MblUsrApplNmbrOfPushRecipients MblUsrApplNmbrOfPushRecipients Subscriber Count
MblUsrApplPushEmlNotifIsEnbld MblUsrApplPushEmlNotifIsEnbld Active Flag
MobileUserApplPushExprtnDteTme MobileUserApplPushExprtnDteTme Time Stamp
MblUsrApplPushProcdDteTme MblUsrApplPushProcdDteTme Time Stamp
MblUsrApplPushCancelDteTme MblUsrApplPushCancelDteTme Time Stamp
MobileUserApplPushCmpltDteTme MobileUserApplPushCmpltDteTme Time Stamp
MblApplPushServerCmpltdDteTme MblApplPushServerCmpltdDteTme Time Stamp
MblUsrApplPushEnqueueDteTme MblUsrApplPushEnqueueDteTme Time Stamp
MblUsrApplPushEventInternal MblUsrApplPushEventInternal ID
MobileUserApplPushEvtParam MobileUserApplPushEvtParam Bkgrd event param.
MobileUserApplPushQueuedRFC MobileUserApplPushQueuedRFC Queue Name
MobileUserApplPushScenarioPrio MobileUserApplPushScenarioPrio Workflow priority
MobileUserApplPushHistIsEnbld MobileUserApplPushHistIsEnbld Boolean
MblUsrApplPushOutbTrggrIsEnbld MblUsrApplPushOutbTrggrIsEnbld Boolean
MobileUserApplPushRetryIsAllwd MobileUserApplPushRetryIsAllwd Boolean
MblUsrApplFetchCallbackIsAllwd MblUsrApplFetchCallbackIsAllwd Boolean
MobileUserApplPushCreatedBy MobileUserApplPushCreatedBy Version Created By
MblUsrApplPushCreatedDteTme MblUsrApplPushCreatedDteTme Time Stamp
MobileUserApplPushChangedBy MobileUserApplPushChangedBy User Name
MblUsrApplPushChangedDteTme MblUsrApplPushChangedDteTme Time Stamp
MobileApplPushNotifTitle
_PushRecipients _PushRecipients
_PushStatusText _PushStatusText

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 R_MaintMblApplPushNotifTP.
-- 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 R_MaintMblApplPushNotifTP AS
SELECT
  MobileApplicationPushInternal,
  MobileUserApplication,
  MblApplPushScenarioInternal,
  MobileUserRecordInternal,
  MblUsrApplPushSourceType,
  MobileUserApplPushSourceObj,
  MobileUserApplPushObjKey,
  MobileUserApplPushObjKeyRef,
  MobileUserApplicationPushSts,
  MblUsrApplNmbrOfPushRecipients,
  MblUsrApplPushEmlNotifIsEnbld,
  MobileUserApplPushExprtnDteTme,
  MblUsrApplPushProcdDteTme,
  MblUsrApplPushCancelDteTme,
  MobileUserApplPushCmpltDteTme,
  MblApplPushServerCmpltdDteTme,
  MblUsrApplPushEnqueueDteTme,
  MblUsrApplPushEventInternal,
  MobileUserApplPushEvtParam,
  MobileUserApplPushQueuedRFC,
  MobileUserApplPushScenarioPrio,
  MobileUserApplPushHistIsEnbld,
  MblUsrApplPushOutbTrggrIsEnbld,
  MobileUserApplPushRetryIsAllwd,
  MblUsrApplFetchCallbackIsAllwd,
  MobileUserApplPushCreatedBy,
  MblUsrApplPushCreatedDteTme,
  MobileUserApplPushChangedBy,
  MblUsrApplPushChangedDteTme,
  concat_with_space(MobileUserApplPushObjKey, concat_with_space('-', MobileUserApplication,1), 1) AS MobileApplPushNotifTitle
FROM I_MblApplPushNotification
LEFT OUTER JOIN I_MblUsrApplPushStatusText AS _PushStatusText ON _PushStatusText.MobileUserApplicationPushSts = MobileUserApplicationPushSts  -- association [0..*]
LEFT OUTER JOIN R_MaintMblApplPushRecipientTP AS _PushRecipients ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More