P_USER_COMPOSITE_PROF

DDL: P_USER_COMPOSITE_PROF SQL: PUSRPROFC Type: view
5 Fields 5 Data Sources

Get Profiles for users

P_USER_COMPOSITE_PROF is a CDS View that provides data about "Get Profiles for users" in SAP S/4HANA. It reads from 5 data sources (usr10, usr10, usrefus, ust04, ust04) and exposes 5 fields.

Data Sources (5)

SourceAliasJoin Type
usr10 usr10 left_outer
usr10 usr10 left_outer
usrefus usrefus left_outer
ust04 ust04 left_outer
ust04 ust04 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSRPROFC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get Profiles for users view

Fields (5)

KeyFieldSource TableSource FieldDescription
bname usr02 bname User name
class usr02 class User Group
bname User name
class usr02 class User Group
profile ust04 profile WBS sched. prof

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_USER_COMPOSITE_PROF.
-- 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: PUSRPROFC

CREATE VIEW P_USER_COMPOSITE_PROF AS
SELECT
  usr02.bname AS bname,
  usr02.class AS class,
  ust04.profile AS profile
LEFT OUTER JOIN ust04 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr10 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usrefus ON /* join condition not captured in parsed metadata */
;

Learn More