Usr02_Class

DDL: USR02_CLASS SQL: USR02CLASS_V Type: view
2 Fields 1 Data Sources

User with user group

Usr02_Class is a CDS View that provides data about "User with user group" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 2 fields with key field bname.

Data Sources (1)

SourceAliasJoin Type
usr02 usr02 from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName USR02CLASS_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label User with user group view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY bname bname User name
class class User Group

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 Usr02_Class.
-- 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.
-- SQL view name: USR02CLASS_V

CREATE VIEW Usr02_Class AS
SELECT
  bname,
  class
FROM usr02
;

Learn More