P_PPM_LocalAuthorizations

DDL: P_PPM_LOCALAUTHORIZATIONS SQL: PPPMLOCALAUTH Type: view BASIC
13 Fields 7 Data Sources

P_PPM_LocalAuthorizations is a Basic CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 13 fields with key fields object_id, Activity, UserID, Activity, UserID.

Data Sources (7)

SourceAliasJoin Type
aco_user_group GroupAuth union
aco_role RoleAuth union
aco_substitute sub inner
aco_user UserAuth from
P_PPM_UserGroupHierarchy UserGroup inner
agr_users UserRole inner
aco_user usr union

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PPPMLOCALAUTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY object_id aco_user object_id Transaction ID
KEY Activity aco_user activity VAT Activity
KEY UserID aco_user user_id User Name
object_id Transaction ID
KEY Activity aco_user activity VAT Activity
KEY UserID aco_substitute user_id_subst User Name
object_id Transaction ID
KEY Activity aco_user_group activity VAT Activity
KEY UserID P_PPM_UserGroupHierarchy UserID User Name
object_id Transaction ID
KEY Activity aco_role activity VAT Activity
KEY UserID agr_users uname User Name
ObjectType aco_role type Worklist Type

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_PPM_LocalAuthorizations.
-- 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: PPPMLOCALAUTH

CREATE VIEW P_PPM_LocalAuthorizations AS
SELECT
  UserAuth.object_id AS object_id,
  UserAuth.activity AS Activity,
  UserAuth.user_id AS UserID,
  RoleAuth.type AS ObjectType
FROM aco_user AS UserAuth
INNER JOIN aco_substitute AS sub ON /* join condition not captured in parsed metadata */
INNER JOIN P_PPM_UserGroupHierarchy AS UserGroup ON /* join condition not captured in parsed metadata */
INNER JOIN agr_users AS UserRole ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): aco_user, aco_user_group, aco_role
;

Learn More