P_USER_INFO_PROF

DDL: P_USER_INFO_PROF SQL: PUSERINFOPROF Type: view
21 Fields 1 Data Sources

User Information and Profiles Parameter

P_USER_INFO_PROF is a CDS View that provides data about "User Information and Profiles Parameter" in SAP S/4HANA. It reads from 1 data source (P_ALL_PROF) and exposes 21 fields with key fields mandt, bname.

Data Sources (1)

SourceAliasJoin Type
P_ALL_PROF P_ALL_PROF inner

Parameters (2)

NameTypeDefault
prof1 xuprofile
prof2 xuprofile

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSERINFOPROF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User Information and Profiles Parameter view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY mandt usr02 mandt Editing Client
KEY bname usr02 bname User name
class usr02 class User Group
accnt usr02 accnt Number
gltgv usr02 gltgv Valid from
gltgb usr02 gltgb Valid to
ustyp usr02 ustyp User Type
uflag usr02 uflag User Lock
tzone usr02 tzone Time Zone Difference
zbvmaster usr02 zbvmaster CUA User
refuser usrefus refuser Reference user
useralias usrefus useralias Alias
usgrp_user usgrp_user
usr21 usr21
usr01 usr01 User group
usr06 usr06 User fld 7-amt
usracl usracl
usr05 usr05 User field qty.
agr agr
obj obj Object Name
profile prof 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_INFO_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: PUSERINFOPROF
-- Parameters: prof1 : xuprofile, prof2 : xuprofile

CREATE VIEW P_USER_INFO_PROF AS
SELECT
  usr02.mandt AS mandt,
  usr02.bname AS bname,
  usr02.class AS class,
  usr02.accnt AS accnt,
  usr02.gltgv AS gltgv,
  usr02.gltgb AS gltgb,
  usr02.ustyp AS ustyp,
  usr02.uflag AS uflag,
  usr02.tzone AS tzone,
  usr02.zbvmaster AS zbvmaster,
  usrefus.refuser AS refuser,
  usrefus.useralias AS useralias,
  usgrp_user,
  usr21,
  usr01,
  usr06,
  usracl,
  usr05,
  agr,
  obj,
  prof.profile AS profile
INNER JOIN P_ALL_PROF ON /* join condition not captured in parsed metadata */
;

Learn More