C_MaintMblTransHistoryQuery

DDL: C_MAINTMBLTRANSHISTORYQUERY Type: view CONSUMPTION
15 Fields 1 Data Sources

Mobile Transaction History - Query

C_MaintMblTransHistoryQuery (Consumption)

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

Cross Applications

C_MaintMblTransHistoryQuery is a Consumption CDS View that provides data about "Mobile Transaction History - Query" in SAP S/4HANA. It reads from 1 data source (I_MaintMblTransHistoryCube) and exposes 15 fields.

SAP Help Documentation

CategoryCDS Views for SAP Maintenance Assistant
Data CategoryQuery
Purpose
This CDS view allows you to generate a report of mobile transaction history for a set of business object types, mobile users, or mobile applications. 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 per day? 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 need to access it via another CDS view (privileged mode). You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

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 Meausre

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentMOB-APP-MAO-ERP
CapabilitiesAnalytical Query
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintMblTransHistoryCube I_MaintMblTransHistoryCube from

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CMNTMBLTRANHISTQ view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Mobile Transaction History - Query view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (15)

KeyFieldSource TableSource FieldDescription
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
ODataMobileDataObject ODataMobileDataObject oData Mobile Data Object Id
OMDOModelEntityTypeName OMDOModelEntityTypeName Service Builder: Artifact Name
OMDOTechnicalEntityType OMDOTechnicalEntityType oMDO - Technical Entity Type
OMDOOperation OMDOOperation OMDO Operation
MaintMblTransChangedByUserUUID MaintMblTransChangedByUserUUID Changed By
LastChangeDate LastChangeDate Changed On
CalendarYear CalendarYear Calendar Year
CalendarMonth CalendarMonth Calendar Month
NrOfMaintMblTransHistRecords NrOfMaintMblTransHistRecords Number of Mobile Transactions

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_MaintMblTransHistoryQuery.
-- 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_MaintMblTransHistoryQuery AS
SELECT
  MobileUserApplication,
  MaintMblTransBusinessObjectKey,
  BusinessObjectType,
  MobileDataObject,
  MblDtaObjectHandlerMethodType,
  MaintMblApplInbTransReqType,
  ODataMobileDataObject,
  OMDOModelEntityTypeName,
  OMDOTechnicalEntityType,
  OMDOOperation,
  MaintMblTransChangedByUserUUID,
  LastChangeDate,
  CalendarYear,
  CalendarMonth,
  NrOfMaintMblTransHistRecords
FROM I_MaintMblTransHistoryCube
;

Learn More