C_MaintMblApplicationUserQuery

DDL: C_MAINTMBLAPPLICATIONUSERQUERY Type: view CONSUMPTION

Mobile Application User - Query

C_MaintMblApplicationUserQuery (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_MaintMblApplicationUserQuery is a Consumption CDS View that provides data about "Mobile Application User - Query" in SAP S/4HANA. It reads from 1 data source (I_MaintMblApplicationUserCube) and exposes 12 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_MaintMblApplicationUserCube I_MaintMblApplicationUserCube from

Annotations (12)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
MobileUserServerInternal MobileUserServerInternal Syclo Middleware Server Serial No.
MobileUserApplication MobileUserApplication Mobile Application Name
MobileUserGroupInternal MobileUserGroupInternal Syclo Middleware User Group Id
MobileUser MobileUser User Name
MaintMobileApplicationUserName MaintMobileApplicationUserName User Description
MobileUserIsLocked MobileUserIsLocked Is Locked
MobileUserProductRoleIsValid MobileUserProductRoleIsValid Flag - No Valid Product Role
MobileUserLogicalSystem MobileUserLogicalSystem Logical System
CreationDate CreationDate Created On
CalendarYear CalendarYear Creation Year
CalendarMonth CalendarMonth Creation Month
MaintMblApplNumberOfUsers MaintMblApplNumberOfUsers Number of Users

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_MaintMblApplicationUserQuery.
-- 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_MaintMblApplicationUserQuery AS
SELECT
  MobileUserServerInternal,
  MobileUserApplication,
  MobileUserGroupInternal,
  MobileUser,
  MaintMobileApplicationUserName,
  MobileUserIsLocked,
  MobileUserProductRoleIsValid,
  MobileUserLogicalSystem,
  CreationDate,
  CalendarYear,
  CalendarMonth,
  MaintMblApplNumberOfUsers
FROM I_MaintMblApplicationUserCube
;