I_PPM_AuthznBySubstitH

DDL: I_PPM_AUTHZNBYSUBSTITH SQL: IPPMAUTHZNSBSTH Type: view BASIC
5 Fields 3 Data Sources

Project Authorizations by Substitution

I_PPM_AuthznBySubstitH (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

R&D Engineering

I_PPM_AuthznBySubstitH is a Basic CDS View that provides data about "Project Authorizations by Substitution" in SAP S/4HANA. It reads from 3 data sources (/s4ppm/auth_ref, aco_substitute, aco_user) and exposes 5 fields with key fields ReferencedObjectUUID, Activity, UserID, SubstitutedUser.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-VDM
CapabilitiesAssociation Target for Defining CDS Entities
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>These CDS views are internally used by the system for Data Control Language (DCL) authorization checks. They are not intended for direct use.</p>

Documentation

Data Sources (3)

SourceAliasJoin Type
/s4ppm/auth_ref hier inner
aco_substitute sub inner
aco_user usr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPPMAUTHZNSBSTH view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Project Authorizations by Substitution view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ReferencedObjectUUID /s4ppm/auth_ref object_id Transaction ID
KEY Activity aco_user activity Activity for Authorization Check
KEY UserID aco_substitute user_id_subst User ID of Substitute
KEY SubstitutedUser aco_substitute user_id User Scope
ObjectType aco_user type Object Category

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 I_PPM_AuthznBySubstitH.
-- 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: IPPMAUTHZNSBSTH

CREATE VIEW I_PPM_AuthznBySubstitH AS
SELECT
  hier.object_id AS ReferencedObjectUUID,
  usr.activity AS Activity,
  sub.user_id_subst AS UserID,
  sub.user_id AS SubstitutedUser,
  usr.type AS ObjectType
FROM aco_user AS usr
INNER JOIN aco_substitute AS sub ON /* join condition not captured in parsed metadata */
INNER JOIN /s4ppm/auth_ref AS hier ON /* join condition not captured in parsed metadata */
;

Learn More