I_MaintMblTransHistoryCube

DDL: I_MAINTMBLTRANSHISTORYCUBE Type: view_entity COMPOSITE
22 Fields 1 Data Sources 3 Associations

Mobile Transaction History - Cube

I_MaintMblTransHistoryCube (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_MaintMblTransHistoryCube is a Composite CDS View (Cube) that provides data about "Mobile Transaction History - Cube" in SAP S/4HANA. It reads from 1 data source (I_MaintMblTransactionHistory) and exposes 22 fields with key field MaintMblTransHistoryRecordUUID. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for SAP Maintenance Assistant
Data CategoryCube
Purpose
This CDS view provides the data to answer the following business questions: Who creates or updates business objects actively? How many business objects are created by the user? How many business objects are created each day? How many business objects are processed perday? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following business catalog assigned: Business catalog from the business role template: SAP_BR_MAIF_MOBILE_ADMIN SAP_EAM_BC_MAIF_ADM_MNG_PC

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment MobileUserApplication Mobile Application Attribute MaintMblTransBusinessObjectKey Object Key Attribute BusinessObjectType Object Type Attribute MobileDataObject Mobile Data Object Attribute MblDtaObjectHandlerMethodType Mobile Data Object Handler Method Type Attribute MaintMblApplInbTransReqType Request Type Attribute ODataMobileDataObject OData Mobile Data Object Attribute OMDOModelEntityTypeName Entity Type Attribute OMDOOperation OMDO Operation Attribute MaintMblTransChangedByUserUUID Changed By Attribute LastChangeDate Changed On Attribute NrOfMaintMblTransHistRecords Number of Mobile Transactions Measure

View on SAP Help Portal →

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_MaintMblTransactionHistory I_MaintMblTransactionHistory from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_OMDOModTechEntyTypeAssgmt _TechEntyTypeAssgmt _TechEntyTypeAssgmt.ODataMobileDataObject = $projection.ODataMobileDataObject and _TechEntyTypeAssgmt.OMDOTechnicalEntityType = $projection.OMDOTechnicalEntityType
[1..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = $projection.LastChangeDate
[1..1] I_MobileApplicationUser _LastChangedByUser _LastChangedByUser.MobileUserInternal = $projection.MaintMblTransChangedByUserUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IMNTMBLTRANHISTC view
EndUserText.label Mobile Transaction History - 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 #MIXED view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintMblTransHistoryRecordUUID MaintMblTransHistoryRecordUUID Registry Record GUID
MobileUserApplication MobileUserApplication Mobile Application Name
MaintMblTransBusinessObjectKey MaintMblTransBusinessObjectKey Mobile transaction history object key
BusinessObjectType BusinessObjectType Object Type
MobileDataObject MobileDataObject Syclo Mobile Data Object ID
MblDtaObjectHandlerMethodType MblDtaObjectHandlerMethodType Mobile Data Object Handler Method Type
MaintMblApplInbTransReqType MaintMblApplInbTransReqType Inbound Transaction: Requesting Type
OMDOTechnicalEntityType OMDOTechnicalEntityType oMDO - Technical Entity Type
OMDOModelEntityTypeName _TechEntyTypeAssgmt OMDOModelEntityTypeName Service Builder: Artifact Name
OMDOOperation OMDOOperation oMDO Operation
ODataMobileDataObject ODataMobileDataObject oData Mobile Data Object Id
MaintMblTransChangedByUserUUID MaintMblTransChangedByUserUUID User GUID
LastChangeDate LastChangeDate Changed On
CalendarYear _CalendarDate CalendarYear Calendar Year
CalendarMonth _CalendarDate CalendarMonth Calendar Month
NrOfMaintMblTransHistRecords 1 Number of Mobile Transactions
_CalendarDate _CalendarDate
_CalendarYear _CalendarDate _CalendarYear
_CalendarMonth _CalendarDate _CalendarMonth
_LastChangedByUser _LastChangedByUser
_InbTransReqTypeText _InbTransReqTypeText
_MblDtaObjHdlrMethodTypeText _MblDtaObjHdlrMethodTypeText

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_MaintMblTransHistoryCube.
-- 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_MaintMblTransHistoryCube AS
SELECT
  MaintMblTransHistoryRecordUUID,
  MobileUserApplication,
  MaintMblTransBusinessObjectKey,
  BusinessObjectType,
  MobileDataObject,
  MblDtaObjectHandlerMethodType,
  MaintMblApplInbTransReqType,
  OMDOTechnicalEntityType,
  _TechEntyTypeAssgmt.OMDOModelEntityTypeName AS OMDOModelEntityTypeName,
  OMDOOperation,
  ODataMobileDataObject,
  MaintMblTransChangedByUserUUID,
  LastChangeDate,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  1 AS NrOfMaintMblTransHistRecords,
  _CalendarDate._CalendarYear AS _CalendarYear,
  _CalendarDate._CalendarMonth AS _CalendarMonth
FROM I_MaintMblTransactionHistory
LEFT OUTER JOIN I_OMDOModTechEntyTypeAssgmt AS _TechEntyTypeAssgmt ON _TechEntyTypeAssgmt.ODataMobileDataObject = ODataMobileDataObject AND _TechEntyTypeAssgmt.OMDOTechnicalEntityType = OMDOTechnicalEntityType  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = LastChangeDate  -- association [1..1]
LEFT OUTER JOIN I_MobileApplicationUser AS _LastChangedByUser ON _LastChangedByUser.MobileUserInternal = MaintMblTransChangedByUserUUID  -- association [1..1]
;

Learn More