I_MaintMblApplObjectStatusCube

DDL: I_MAINTMBLAPPLOBJECTSTATUSCUBE Type: view_entity COMPOSITE Package: VDM_MAO_MAIF_ANALYTICS

Mobile Object Status - Cube

I_MaintMblApplObjectStatusCube (Composite)

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

Cross Applications

I_MaintMblApplObjectStatusCube is a Composite CDS View (Cube) that provides data about "Mobile Object Status - Cube" in SAP S/4HANA. It reads from 1 data source (I_MaintMblApplObjectStatus) and exposes 16 fields with key fields MobileUserApplication, MaintMblApplicationObjectKey, MaintMblApplObjMblStatusRecord. It has 2 associations to related views. Part of development package VDM_MAO_MAIF_ANALYTICS.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentMOB-APP-MAO-ERP
CapabilitiesData Provider for Analytical Queries
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintMblApplObjectStatus I_MaintMblApplObjectStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[1..1] I_CalendarDate _CreationDate _CreationDate.CalendarDate = $projection.CreationDate

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IMNTMBLOBJSTSC view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Mobile Object Status - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MobileUserApplication MobileUserApplication Mobile Application Name
KEY MaintMblApplicationObjectKey MaintMblApplicationObjectKey Object key for Mobile Status
KEY MaintMblApplObjMblStatusRecord MaintMblApplObjMblStatusRecord Record no.
MaintMblApplMobileStatus MaintMblApplMobileStatus Mobile Object Status
MaintMblApplObjMblStsIsActive MaintMblApplObjMblStsIsActive Active Flag
MaintMblApplicationObjectType MaintMblApplicationObjectType Object Type for Mobile Status
MaintMblApplObjectSortValue MaintMblApplObjectSortValue Sort Field
CreatedByUser CreatedByUser Created by
CreationDate CreationDate Created On
MaintMblApplObjMblStsCrtnYear _CreationDate CalendarYear Calendar Year
MaintMblApplObjMblStsCrtnMonth _CreationDate CalendarMonth Calendar Month
MntMblAppNrOfObjMblStsRecords 1 Number of Mobile Status Records
_CreationDate _CreationDate
_CreationYear _CreationDate _CalendarYear
_CreationMonth _CreationDate _CalendarMonth
_CreatedByUser _CreatedByUser

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_MaintMblApplObjectStatusCube.
-- 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_MaintMblApplObjectStatusCube AS
SELECT
  MobileUserApplication,
  MaintMblApplicationObjectKey,
  MaintMblApplObjMblStatusRecord,
  MaintMblApplMobileStatus,
  MaintMblApplObjMblStsIsActive,
  MaintMblApplicationObjectType,
  MaintMblApplObjectSortValue,
  CreatedByUser,
  CreationDate,
  _CreationDate.CalendarYear AS MaintMblApplObjMblStsCrtnYear,
  _CreationDate.CalendarMonth AS MaintMblApplObjMblStsCrtnMonth,
  1 AS MntMblAppNrOfObjMblStsRecords,
  _CreationDate._CalendarYear AS _CreationYear,
  _CreationDate._CalendarMonth AS _CreationMonth
FROM I_MaintMblApplObjectStatus
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CreationDate ON _CreationDate.CalendarDate = CreationDate  -- association [1..1]
;