I_EngagementProjectItem

DDL: I_ENGAGEMENTPROJECTITEM SQL: IEPPROJITEM Type: view BASIC
6 Fields 1 Data Sources 2 Associations

Item of Engagement Project

I_EngagementProjectItem (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_EngagementProjectItem is a Basic CDS View that provides data about "Item of Engagement Project" in SAP S/4HANA. It reads from 1 data source (P_EngagementProjectItem) and exposes 6 fields with key fields EngagementProject, EngagementProjectItemType, EngagementProjectItem. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Customer and Internal Project Management
Data CategoryTransactional
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the sales order for a customer project?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restrictions must be set to read access: Service Organization Subactivity for Master Project Authorization These restrictions can be edited in the Maintain Business Roles app.

Structure
Object types This view is built on the following object types: EngagementProject SalesOrder Main CDS parameters and filters This view has no input parameters or filters. Measures and attributes Some important measures and attributes are: Field Description Example Value in CDS View EngagementProject Uniquely identifies a project. EngagementProjectItemType Identifies the type of object linked to the project. 0PD (Project Internal ID) 0SOH (Sales Order ID) EngagementProjectItem Identifies the object linked to the project. If EngagementProjectItemType is 0PD , then the value excluding the leading “PD” gives the project internal ID. If EngagementProjectItemType is 0SOH , then the value gives the project’s sales order ID.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentCA-CPD-SS
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_EngagementProjectItem EngagementProjectItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[0..1] I_SalesOrder _SalesOrder $projection.EngagementProjectItem = _SalesOrder.SalesOrder and $projection.EngagementProjectItemType = '0SOH'

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPPROJITEM view
EndUserText.label Item of Engagement Project view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject P_EngagementProjectItem EngagementProject Commercial Project ID
KEY EngagementProjectItemType P_EngagementProjectItem EngagementProjectItemType Master Project: Related Object Link
KEY EngagementProjectItem P_EngagementProjectItem EngagementProjectItem Item Key (Master Project)
EngagementProjectUUID Engagement Project UUID
_EngagementProject _EngagementProject
_SalesOrder _SalesOrder

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_EngagementProjectItem.
-- 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: IEPPROJITEM

CREATE VIEW I_EngagementProjectItem AS
SELECT
  EngagementProjectItem.EngagementProject AS EngagementProject,
  EngagementProjectItem.EngagementProjectItemType AS EngagementProjectItemType,
  EngagementProjectItem.EngagementProjectItem AS EngagementProjectItem,
  cast(EngagementProjectItem.EngagementProjectUUID as /cpd/eng_db_key preserving type ) AS EngagementProjectUUID
FROM P_EngagementProjectItem AS EngagementProjectItem
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON EngagementProjectItem = _SalesOrder.SalesOrder AND EngagementProjectItemType = '0SOH'  -- association [0..1]
;

Learn More