I_EngmntProjWrkPckgWrkItm

DDL: I_ENGMNTPROJWRKPCKGWRKITM SQL: IEPWRKPKGWRKITEM Type: view COMPOSITE
20 Fields 1 Data Sources 3 Associations

Work Item of Work Package

I_EngmntProjWrkPckgWrkItm is a Composite CDS View that provides data about "Work Item of Work Package" in SAP S/4HANA. It reads from 1 data source (I_WorkPackageWorkItem) and exposes 20 fields with key fields WorkPackage, WorkItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkPackageWorkItem WorkPackageWorkItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_EngmntProjWrkPckg _WorkPackage $projection.EngagementProject = _WorkPackage.EngagementProject and $projection.WorkPackage = _WorkPackage.WorkPackage
[0..1] I_EngagementProjFinancialPlan _EngagementProjFinancialPlan $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
[0..*] I_EngagementProjectPlanData _EngagementProjectPlanData $projection.WorkPackage = _EngagementProjectPlanData.WorkPackage and $projection.EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID and $projection.WorkItem = _EngagementProjectPlanData.WorkItem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPWRKPKGWRKITEM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Item of Work Package view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage I_WorkPackageWorkItem WorkPackage Plan Item
KEY WorkItem I_WorkPackageWorkItem WorkItem Work Item ID
WorkPackageName _WorkPackage WorkPackageName Plan Item Desc.
EngagementProject I_WorkPackageWorkItem EngagementProject Engmnt Project ID
WorkPackageUUID I_WorkPackageWorkItem WorkPackageUUID Work Package UUID
WorkItemUUID I_WorkPackageWorkItem WorkItemUUID
EngagementProjFinPlanUUID I_WorkPackageWorkItem EngagementProjFinPlanUUID Engagement Project
EngagementProjectType
EngagementProjectServiceOrg
EngagementProjectCategory
ProjectProfileCode
ProjectVisibility
EngmntProjectHeaderCompanyCode
EngagementProjectCostCenter
ProfitCenter
WorkItemName I_WorkPackageWorkItem WorkItemName
WorkItemIsInactive I_WorkPackageWorkItem WorkItemIsInactive
_WorkPackage _WorkPackage
_EngagementProjFinancialPlan _EngagementProjFinancialPlan
_EngagementProjectPlanData _EngagementProjectPlanData

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_EngmntProjWrkPckgWrkItm.
-- 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: IEPWRKPKGWRKITEM

CREATE VIEW I_EngmntProjWrkPckgWrkItm AS
SELECT
  WorkPackageWorkItem.WorkPackage AS WorkPackage,
  WorkPackageWorkItem.WorkItem AS WorkItem,
  _WorkPackage.WorkPackageName AS WorkPackageName,
  WorkPackageWorkItem.EngagementProject AS EngagementProject,
  WorkPackageWorkItem.WorkPackageUUID AS WorkPackageUUID,
  WorkPackageWorkItem.WorkItemUUID AS WorkItemUUID,
  WorkPackageWorkItem.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  _EngagementProjFinancialPlan._EngagementProject.EngagementProjectType AS EngagementProjectType,
  _EngagementProjFinancialPlan._EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  _EngagementProjFinancialPlan._EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  _EngagementProjFinancialPlan._EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  _EngagementProjFinancialPlan._EngagementProject.ProjectVisibility AS ProjectVisibility,
  _EngagementProjFinancialPlan._EngagementProject.CompanyCode AS EngmntProjectHeaderCompanyCode,
  _EngagementProjFinancialPlan._EngagementProject.CostCenter AS EngagementProjectCostCenter,
  _EngagementProjFinancialPlan._EngagementProject.ProfitCenter AS ProfitCenter,
  WorkPackageWorkItem.WorkItemName AS WorkItemName,
  WorkPackageWorkItem.WorkItemIsInactive AS WorkItemIsInactive
FROM I_WorkPackageWorkItem AS WorkPackageWorkItem
LEFT OUTER JOIN I_EngmntProjWrkPckg AS _WorkPackage ON EngagementProject = _WorkPackage.EngagementProject AND WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectPlanData AS _EngagementProjectPlanData ON WorkPackage = _EngagementProjectPlanData.WorkPackage AND EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID AND WorkItem = _EngagementProjectPlanData.WorkItem  -- association [0..*]
;

Learn More