C_MaintMblApplClientStateQuery

DDL: C_MAINTMBLAPPLCLIENTSTATEQUERY Type: view CONSUMPTION

Mobile Application Client State - Query

C_MaintMblApplClientStateQuery (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_MaintMblApplClientStateQuery is a Consumption CDS View that provides data about "Mobile Application Client State - Query" in SAP S/4HANA. It reads from 1 data source (I_MaintMblApplClientStateCube) and exposes 16 fields.

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_MaintMblApplClientStateCube I_MaintMblApplClientStateCube from

Annotations (12)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
MblUsrClntStateTechEntityType MblUsrClntStateTechEntityType oMDO - Technical Entity Type
OMDOModelEntityTypeName OMDOModelEntityTypeName Service Builder: Artifact Name
ODataMobileDataObject ODataMobileDataObject oData Mobile Data Object Id
OMDOOperation OMDOOperation OMDO Operation
MobileUserInternal MobileUserInternal Mobile User
MobileUserApplication MobileUserApplication Mobile Application Name
MobileUserHasUserSwitched MobileUserHasUserSwitched Boolean Type: 'X' == True '' == False
MntMblAppClntStateInitSyncDate MntMblAppClntStateInitSyncDate Initial Synchronized On
MntMblAppClntStateInitSyncYear MntMblAppClntStateInitSyncYear Initial Synchronization Year
MntMblAppClntStateInitSyncMnth MntMblAppClntStateInitSyncMnth Initial Synchronization Month
MobileUserClientStateIsActive MobileUserClientStateIsActive Boolean Type: 'X' == True '' == False
LastChangeDate LastChangeDate Changed On
MaintMblApplClntStateLastChgYr MaintMblApplClntStateLastChgYr Calendar Year
MntMblAppClntStateLastChgMonth MntMblAppClntStateLastChgMonth Calendar Month
MblUsrNumberOfClientStateKeys MblUsrNumberOfClientStateKeys 4 Byte Signed Integer
MntMblAppNrOfClntStateRecords MntMblAppNrOfClntStateRecords Number of Client State Records

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_MaintMblApplClientStateQuery.
-- 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_MaintMblApplClientStateQuery AS
SELECT
  MblUsrClntStateTechEntityType,
  OMDOModelEntityTypeName,
  ODataMobileDataObject,
  OMDOOperation,
  MobileUserInternal,
  MobileUserApplication,
  MobileUserHasUserSwitched,
  MntMblAppClntStateInitSyncDate,
  MntMblAppClntStateInitSyncYear,
  MntMblAppClntStateInitSyncMnth,
  MobileUserClientStateIsActive,
  LastChangeDate,
  MaintMblApplClntStateLastChgYr,
  MntMblAppClntStateLastChgMonth,
  MblUsrNumberOfClientStateKeys,
  MntMblAppNrOfClntStateRecords
FROM I_MaintMblApplClientStateCube
;