P_UserObjectAuth

DDL: P_USEROBJECTAUTH SQL: PUSEROBJECTAUTH Type: view

Users with Object and Authorization

P_UserObjectAuth is a CDS View that provides data about "Users with Object and Authorization" in SAP S/4HANA. It reads from 4 data sources (usrefus, ust04, ust10s, ust10s) and exposes 7 fields.

Data Sources (4)

SourceAliasJoin Type
usrefus usrefus left_outer
ust04 ust04 left_outer
ust10s ust10s left_outer
ust10s ust10s left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSEROBJECTAUTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Users with Object and Authorization view

Fields (7)

KeyFieldSource TableSource FieldDescription
bname ust04 bname User name
profile ust04 profile WBS sched. prof
objct ust10s objct Object
bname User name
profile ust04 profile WBS sched. prof
objct ust10s objct Object
auth ust10s auth Authorization

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_UserObjectAuth.
-- 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: PUSEROBJECTAUTH

CREATE VIEW P_UserObjectAuth AS
SELECT
  ust04.bname AS bname,
  ust04.profile AS profile,
  ust10s.objct AS objct,
  ust10s.auth AS auth
LEFT OUTER JOIN ust10s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usrefus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ust04 ON /* join condition not captured in parsed metadata */
;