P_USR02_USR21

DDL: P_USR02_USR21 SQL: PUSR02USR21 Type: view
3 Fields 2 Data Sources

User from USR02 and USR21

P_USR02_USR21 is a CDS View that provides data about "User from USR02 and USR21" in SAP S/4HANA. It reads from 2 data sources (usr02, usr21) and exposes 3 fields.

Data Sources (2)

SourceAliasJoin Type
usr02 usr02 from
usr21 usr21 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSR02USR21 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User from USR02 and USR21 view

Fields (3)

KeyFieldSource TableSource FieldDescription
mandt usr02 mandt Editing Client
bname usr02 bname User name
class usr02 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 P_USR02_USR21.
-- 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: PUSR02USR21

CREATE VIEW P_USR02_USR21 AS
SELECT
  usr02.mandt AS mandt,
  usr02.bname AS bname,
  usr02.class AS class
FROM usr02
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
;

Learn More