I_OQ_COMM_USER

DDL: I_OQ_COMM_USER Type: view_entity
3 Fields 2 Data Sources

Communication User

I_OQ_COMM_USER is a CDS View that provides data about "Communication User" in SAP S/4HANA. It reads from 2 data sources (oqomscntxt, usrefus) and exposes 3 fields with key field UserID.

Data Sources (2)

SourceAliasJoin Type
oqomscntxt oqomscntxt from
usrefus usrefus left_outer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Communication User view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID oqomscntxt owner Vehicle Owner
UserName usrefus useralias Alias
Destination oqomscntxt destination RFC Destination

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_OQ_COMM_USER.
-- 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_OQ_COMM_USER AS
SELECT
  oqomscntxt.owner AS UserID,
  usrefus.useralias AS UserName,
  oqomscntxt.destination AS Destination
FROM oqomscntxt
LEFT OUTER JOIN usrefus ON /* join condition not captured in parsed metadata */
;

Learn More