P_PROF

DDL: P_PROF SQL: PPROF Type: view
5 Fields 3 Data Sources

Get Profiles for users

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

Data Sources (3)

SourceAliasJoin Type
usrefus usrefus left_outer
ust04 ust04 left_outer
ust04 ust04 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPROF 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_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: PPROF

CREATE VIEW P_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 usrefus ON /* join condition not captured in parsed metadata */
;

Learn More