R_EntProjectElementForUpdate

DDL: R_ENTPROJECTELEMENTFORUPDATE SQL: RPROJELEM4UPD Type: view COMPOSITE Package: VDM_PPM_OBJECTS_TP_TASK
16 Fields 1 Data Sources 4 Associations

Lists all elements a user is permitted and able to update

R_EntProjectElementForUpdate is a Composite CDS View that provides data about "Lists all elements a user is permitted and able to update" in SAP S/4HANA. It reads from 1 data source (R_EnterpriseProjectElement) and exposes 16 fields with key field TaskUUID. It has 4 associations to related views. Part of development package VDM_PPM_OBJECTS_TP_TASK.

Data Sources (1)

SourceAliasJoin Type
R_EnterpriseProjectElement Workpackage from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_PPM_AuthznByUsrH _AuthUser _AuthUser.ReferencedObjectUUID = $projection.TaskUUID and _AuthUser.UserID = $session.user and ( _AuthUser.Activity = 'Admin' or _AuthUser.Activity = 'Write' )
[0..*] I_PPM_AuthznBySubstitH _AuthSubst _AuthSubst.ReferencedObjectUUID = $projection.TaskUUID and _AuthSubst.UserID = $session.user and ( _AuthSubst.Activity = 'Admin' or _AuthSubst.Activity = 'Write' )
[0..*] I_PPM_AuthznByUserRoleH _AuthRole _AuthRole.ReferencedObjectUUID = $projection.TaskUUID and _AuthRole.UserID = $session.user and ( _AuthRole.Activity = 'Admin' or _AuthRole.Activity = 'Write' )
[0..*] I_PPM_AuthznByUsrGrpH _AuthGroup _AuthGroup.ReferencedObjectUUID = $projection.TaskUUID and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' )

Annotations (14)

NameValueLevelField
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName RPROJELEM4UPD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TaskUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Lists all elements a user is permitted and able to update view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID R_EnterpriseProjectElement ProjectElementUUID Obj Link Entity GUID
ProjectElement R_EnterpriseProjectElement ProjectElement Proj Element ID
WBSElementInternalID R_EnterpriseProjectElement WBSElementInternalID WBS Internal ID
ProjectUUID R_EnterpriseProjectElement ProjectUUID Project UUID
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
CompanyCode CompanyCode Receiver Company Code
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
Plant Plant Valuation Area
FunctionalArea FunctionalArea Sendr Fctl Area
IsEditable
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_EnterpriseProject _EnterpriseProject

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 R_EntProjectElementForUpdate.
-- 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: RPROJELEM4UPD

CREATE VIEW R_EntProjectElementForUpdate AS
SELECT
  Workpackage.ProjectElementUUID AS TaskUUID,
  Workpackage.ProjectElement AS ProjectElement,
  Workpackage.WBSElementInternalID AS WBSElementInternalID,
  Workpackage.ProjectUUID AS ProjectUUID,
  ControllingArea,
  ProfitCenter,
  CompanyCode,
  ResponsibleCostCenter,
  Plant,
  FunctionalArea,
  cast( 'X' as boolean preserving type ) AS IsEditable
FROM R_EnterpriseProjectElement AS Workpackage
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = TaskUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = TaskUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = TaskUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = TaskUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' )  -- association [0..*]
;

Learn More