P_PROF_PAR_REF

DDL: P_PROF_PAR_REF SQL: PPROFPARREF Type: view
4 Fields 2 Data Sources

Profiles with Parameter for ref.users

P_PROF_PAR_REF is a CDS View that provides data about "Profiles with Parameter for ref.users" in SAP S/4HANA. It reads from 2 data sources (usrefus, ust04) and exposes 4 fields.

Data Sources (2)

SourceAliasJoin Type
usrefus usrefus inner
ust04 ust04 inner

Parameters (1)

NameTypeDefault
prof xuprofile

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPROFPARREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Profiles with Parameter for ref.users view

Fields (4)

KeyFieldSource TableSource FieldDescription
bname usr02 bname User name
class usr02 class User Group
refuser usrefus refuser Reference user
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_PAR_REF.
-- 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: PPROFPARREF
-- Parameters: prof : xuprofile

CREATE VIEW P_PROF_PAR_REF AS
SELECT
  usr02.bname AS bname,
  usr02.class AS class,
  usrefus.refuser AS refuser,
  ust04.profile AS profile
INNER JOIN usrefus ON /* join condition not captured in parsed metadata */
INNER JOIN ust04 ON /* join condition not captured in parsed metadata */
;

Learn More