I_MaintMblApplPushNotifCube

DDL: I_MAINTMBLAPPLPUSHNOTIFCUBE Type: view_entity COMPOSITE
63 Fields 1 Data Sources 9 Associations

Mobile Push Notification - Cube

I_MaintMblApplPushNotifCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_MaintMblApplPushNotifCube is a Composite CDS View (Cube) that provides data about "Mobile Push Notification - Cube" in SAP S/4HANA. It reads from 1 data source (I_MblApplPushNotification) and exposes 63 fields with key field MobileApplicationPushInternal. It has 9 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentMOB-APP-MAO-ERP
CapabilitiesData Provider for Analytical Queries
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MblApplPushNotification I_MblApplPushNotification from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_MblApplPushScenarioDef _PushScenario _PushScenario.MblApplPushScenarioInternal = $projection.MblApplPushScenarioInternal
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.MobileUserApplPushCreatedBy
[1..1] I_CalendarDate _CreationDate _CreationDate.CalendarDate = $projection.CreationDate
[0..1] I_CalendarDate _ExpirationDate _ExpirationDate.CalendarDate = $projection.MaintMblApplPushNotifExprtnDte
[0..1] I_CalendarDate _ProcessingDate _ProcessingDate.CalendarDate = $projection.MaintMblApplPushNotifProcgDate
[0..1] I_CalendarDate _CancellationDate _CancellationDate.CalendarDate = $projection.MaintMblApplPushNotifCanclnDte
[0..1] I_CalendarDate _CompletionDate _CompletionDate.CalendarDate = $projection.MntMblAppPushNotifCompltnDate
[0..1] I_CalendarDate _ServerCompletionDate _ServerCompletionDate.CalendarDate = $projection.MntMblAppPushServerCompltnDate
[0..1] I_CalendarDate _EnqueueDate _EnqueueDate.CalendarDate = $projection.MntMblAppPushNotifEnqueueDate

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IMNTMBLPSHNOTIFC view
EndUserText.label Mobile Push Notification - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY MobileApplicationPushInternal MobileApplicationPushInternal Push scenario instance GUID
MobileUserApplication MobileUserApplication Mobile Application Name
MblApplPushScenarioInternal MblApplPushScenarioInternal Workflow definition
MblUsrApplPushSourceType MblUsrApplPushSourceType Push Scenario Source Type
MobileUserApplPushSourceObj MobileUserApplPushSourceObj Push source object
MobileUserApplicationPushSts MobileUserApplicationPushSts Push instance status
MblUsrApplPushEmlNotifIsEnbld MblUsrApplPushEmlNotifIsEnbld Active Flag
MblUsrApplPushEventInternal MblUsrApplPushEventInternal Background Processing Event
MobileUserApplPushEvtParam MobileUserApplPushEvtParam Background Event Parameters (Such as, Jobname/Jobcount)
MobileUserApplPushScenarioPrio MobileUserApplPushScenarioPrio Push scenario priority
MobileUserApplPushHistIsEnbld MobileUserApplPushHistIsEnbld Boolean Type: 'X' == True '' == False
MblUsrApplPushOutbTrggrIsEnbld MblUsrApplPushOutbTrggrIsEnbld Boolean Type: 'X' == True '' == False
MobileUserApplPushRetryIsAllwd MobileUserApplPushRetryIsAllwd Boolean Type: 'X' == True '' == False
MblUsrApplFetchCallbackIsAllwd MblUsrApplFetchCallbackIsAllwd Boolean Type: 'X' == True '' == False
MobileUserApplPushCreatedBy MobileUserApplPushCreatedBy Version Created By
CreationDate CreationDate Created On
MaintMblApplPushNotifCrtnYear _CreationDate CalendarYear Calendar Year
MaintMblApplPushNotifCrtnMonth _CreationDate CalendarMonth Calendar Month
MaintMblApplPushNotifExprtnDte MaintMblApplPushNotifExprtnDte Expired On
MaintMblApplPushNotifExprtnYr _ExpirationDate CalendarYear Calendar Year
MntMblAppPushNotifExprtnMonth _ExpirationDate CalendarMonth Calendar Month
MaintMblApplPushNotifProcgDate MaintMblApplPushNotifProcgDate Processed On
MaintMblApplPushNotifProcgYear _ProcessingDate CalendarYear Calendar Year
MaintMblApplPushNotifProcgMnth _ProcessingDate CalendarMonth Calendar Month
MaintMblApplPushNotifCanclnDte MaintMblApplPushNotifCanclnDte Cancelled On
MaintMblApplPushNotifCanclnYr _CancellationDate CalendarYear Calendar Year
MntMblAppPushNotifCanclnMonth _CancellationDate CalendarMonth Calendar Month
MntMblAppPushNotifCompltnDate MntMblAppPushNotifCompltnDate Completed On
MaintMblApplPushNotifCompltnYr _CompletionDate CalendarYear Calendar Year
MntMblAppPushNotifCompltnMonth _CompletionDate CalendarMonth Calendar Month
MntMblAppPushServerCompltnDate MntMblAppPushServerCompltnDate Server Completed On
MntMblAppPushServerCompltnYear _ServerCompletionDate CalendarYear Calendar Year
MntMblAppPushServerCompltnMnth _ServerCompletionDate CalendarMonth Calendar Month
MntMblAppPushNotifEnqueueDate MntMblAppPushNotifEnqueueDate Enqueued On
MaintMblApplPushNotifEnqueueYr _EnqueueDate CalendarYear Calendar Year
MntMblAppPushNotifEnqueueMonth _EnqueueDate CalendarMonth Calendar Month
MntMblAppNrOfPushNotifRecords 1 Number of Push Notification Records
MblUsrApplNmbrOfPushRecipients MblUsrApplNmbrOfPushRecipients Total number of subscribers
_CreationDate _CreationDate
_CreationYear _CreationDate _CalendarYear
_CreationMonth _CreationDate _CalendarMonth
_ExpirationDate _ExpirationDate
_ExpirationYear _ExpirationDate _CalendarYear
_ExpirationMonth _ExpirationDate _CalendarMonth
_ProcessingDate _ProcessingDate
_ProcessingYear _ProcessingDate _CalendarYear
_ProcessingMonth _ProcessingDate _CalendarMonth
_CancellationDate _CancellationDate
_CancellationYear _CancellationDate _CalendarYear
_CancellationMonth _CancellationDate _CalendarMonth
_CompletionDate _CompletionDate
_CompletionYear _CompletionDate _CalendarYear
_CompletionMonth _CompletionDate _CalendarMonth
_ServerCompletionDate _ServerCompletionDate
_ServerCompletionYear _ServerCompletionDate _CalendarYear
_ServerCompletionMonth _ServerCompletionDate _CalendarMonth
_EnqueueDate _EnqueueDate
_EnqueueYear _EnqueueDate _CalendarYear
_EnqueueMonth _EnqueueDate _CalendarMonth
_CreatedByUser _CreatedByUser
_PushScenario _PushScenario
_PushStatusText _PushStatusText
_SourceTypeText _SourceTypeText

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_MaintMblApplPushNotifCube.
-- 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_MaintMblApplPushNotifCube AS
SELECT
  MobileApplicationPushInternal,
  MobileUserApplication,
  MblApplPushScenarioInternal,
  MblUsrApplPushSourceType,
  MobileUserApplPushSourceObj,
  MobileUserApplicationPushSts,
  MblUsrApplPushEmlNotifIsEnbld,
  MblUsrApplPushEventInternal,
  MobileUserApplPushEvtParam,
  MobileUserApplPushScenarioPrio,
  MobileUserApplPushHistIsEnbld,
  MblUsrApplPushOutbTrggrIsEnbld,
  MobileUserApplPushRetryIsAllwd,
  MblUsrApplFetchCallbackIsAllwd,
  MobileUserApplPushCreatedBy,
  CreationDate,
  _CreationDate.CalendarYear AS MaintMblApplPushNotifCrtnYear,
  _CreationDate.CalendarMonth AS MaintMblApplPushNotifCrtnMonth,
  MaintMblApplPushNotifExprtnDte,
  _ExpirationDate.CalendarYear AS MaintMblApplPushNotifExprtnYr,
  _ExpirationDate.CalendarMonth AS MntMblAppPushNotifExprtnMonth,
  MaintMblApplPushNotifProcgDate,
  _ProcessingDate.CalendarYear AS MaintMblApplPushNotifProcgYear,
  _ProcessingDate.CalendarMonth AS MaintMblApplPushNotifProcgMnth,
  MaintMblApplPushNotifCanclnDte,
  _CancellationDate.CalendarYear AS MaintMblApplPushNotifCanclnYr,
  _CancellationDate.CalendarMonth AS MntMblAppPushNotifCanclnMonth,
  MntMblAppPushNotifCompltnDate,
  _CompletionDate.CalendarYear AS MaintMblApplPushNotifCompltnYr,
  _CompletionDate.CalendarMonth AS MntMblAppPushNotifCompltnMonth,
  MntMblAppPushServerCompltnDate,
  _ServerCompletionDate.CalendarYear AS MntMblAppPushServerCompltnYear,
  _ServerCompletionDate.CalendarMonth AS MntMblAppPushServerCompltnMnth,
  MntMblAppPushNotifEnqueueDate,
  _EnqueueDate.CalendarYear AS MaintMblApplPushNotifEnqueueYr,
  _EnqueueDate.CalendarMonth AS MntMblAppPushNotifEnqueueMonth,
  1 AS MntMblAppNrOfPushNotifRecords,
  MblUsrApplNmbrOfPushRecipients,
  _CreationDate._CalendarYear AS _CreationYear,
  _CreationDate._CalendarMonth AS _CreationMonth,
  _ExpirationDate._CalendarYear AS _ExpirationYear,
  _ExpirationDate._CalendarMonth AS _ExpirationMonth,
  _ProcessingDate._CalendarYear AS _ProcessingYear,
  _ProcessingDate._CalendarMonth AS _ProcessingMonth,
  _CancellationDate._CalendarYear AS _CancellationYear,
  _CancellationDate._CalendarMonth AS _CancellationMonth,
  _CompletionDate._CalendarYear AS _CompletionYear,
  _CompletionDate._CalendarMonth AS _CompletionMonth,
  _ServerCompletionDate._CalendarYear AS _ServerCompletionYear,
  _ServerCompletionDate._CalendarMonth AS _ServerCompletionMonth,
  _EnqueueDate._CalendarYear AS _EnqueueYear,
  _EnqueueDate._CalendarMonth AS _EnqueueMonth
FROM I_MblApplPushNotification
LEFT OUTER JOIN I_MblApplPushScenarioDef AS _PushScenario ON _PushScenario.MblApplPushScenarioInternal = MblApplPushScenarioInternal  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = MobileUserApplPushCreatedBy  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CreationDate ON _CreationDate.CalendarDate = CreationDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _ExpirationDate ON _ExpirationDate.CalendarDate = MaintMblApplPushNotifExprtnDte  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ProcessingDate ON _ProcessingDate.CalendarDate = MaintMblApplPushNotifProcgDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CancellationDate ON _CancellationDate.CalendarDate = MaintMblApplPushNotifCanclnDte  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CompletionDate ON _CompletionDate.CalendarDate = MntMblAppPushNotifCompltnDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ServerCompletionDate ON _ServerCompletionDate.CalendarDate = MntMblAppPushServerCompltnDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _EnqueueDate ON _EnqueueDate.CalendarDate = MntMblAppPushNotifEnqueueDate  -- association [0..1]
;

Learn More