Deprecated
This CDS view is deprecated in S/4HANA. Use C_WorkPackage instead. View all deprecated CDS views →

C_WorkpackageDetails

DDL: C_WORKPACKAGEDETAILS SQL: CWORKPKGDETAIL Type: view CONSUMPTION
36 Fields 1 Data Sources 7 Associations

Work Package Details

C_WorkpackageDetails is a Consumption CDS View that provides data about "Work Package Details" in SAP S/4HANA. It reads from 1 data source (I_WorkPackage) and exposes 36 fields. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkPackage WorkPackage from

Associations (7)

CardinalityTargetAliasCondition
[0..*] C_WorkpackageMember _WorkpackageMember $projection.WorkPackage = _WorkpackageMember.WorkPackage
[0..1] C_EngagementProjectDetails _EngagementProject $projection.EngagementProjFinPlanUUID = _EngagementProject.EngagementProjFinPlanUUID
[0..1] E_Workpackage _Extension $projection.WorkPackageUUID = _Extension.WorkPackageUUID
[0..*] C_WorkpackageWorkItem _WorkPackageWorkItem $projection.WorkPackage = _WorkPackageWorkItem.WorkPackage and $projection.EngagementProjFinPlanUUID = _WorkPackageWorkItem.EngagementProjFinPlanUUID
[0..*] I_EngmntProjectUnitDataVersion _UnitPlanData $projection.WorkPackage = _UnitPlanData.WorkPackage
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.WorkPackageUnitUoM = _UnitOfMeasure.UnitOfMeasure
[0..1] I_EngagementProjectResource _WorkPackageUnit $projection.WorkPackageUnit = _WorkPackageUnit.EngagementProjectResource and _WorkPackageUnit.EngagementProjectResourceType = '0SRV'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CWORKPKGDETAIL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Work Package Details view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_WorkPackage view

Fields (36)

KeyFieldSource TableSource FieldDescription
WorkPackage I_WorkPackage WorkPackage Plan Item
WorkPackageUUID I_WorkPackage WorkPackageUUID Work Package UUID
EngagementProjFinPlanUUID I_WorkPackage EngagementProjFinPlanUUID Engagement Project
WorkPackageName I_WorkPackage WorkPackageName Plan Item Desc.
WorkPackageStartDate I_WorkPackage WorkPackageStartDate Start Date
WorkPackageEndDate I_WorkPackage WorkPackageEndDate End Date
WBSElementObject I_WorkPackage WBSElementObject Object number
WBSDescription I_WorkPackage WBSDescription WBS Element Name
SalesOrder I_WorkPackage SalesOrder SD Document
SalesOrderItem I_WorkPackage SalesOrderItem Sales Order Item
LastChangedByUser I_WorkPackage LastChangedByUser User Name
LastChangeDateTime I_WorkPackage LastChangeDateTime Timestamp
WorkPackageType I_WorkPackage WorkPackageType Work Package Type
Currency WorkPackagePlanData Currency Valuation Crcy
PlndCostAmt WorkPackagePlanData PlndCostAmt Amount
PlndEffortQty WorkPackagePlanData PlndEffortQty Total Quantity
PlndRevnAmt WorkPackagePlanData PlndRevnAmt Amount
PlannedUnitRevenue WorkPackagePlanData PlannedUnitRevenue
WorkPackageUnit WorkPackagePlanData WorkPackageUnit
WorkPackageUnitQuantity WorkPackagePlanData PlanUnitQuantity
WorkPackageUnitUoM WorkPackagePlanData WorkPackageUnitUoM
CreationDateTime I_WorkPackage CreationDateTime Timestamp
CreatedByUser I_WorkPackage CreatedByUser User Name
NumberOfWorkItems WorkItemCount NumberOfWorkItems
EngagementProject EngagementProject EngagementProject Engmnt Project ID
_EngagementProjFinancialPlan I_WorkPackage _EngagementProjFinancialPlan
_SalesOrder I_WorkPackage _SalesOrder
_SalesOrderItem I_WorkPackage _SalesOrderItem
_WBSElement I_WorkPackage _WBSElement
_EngagementProjectPlanData I_WorkPackage _EngagementProjectPlanData
_WorkpackageMember _WorkpackageMember
_WorkPackageWorkItem _WorkPackageWorkItem
_EngagementProject _EngagementProject
_UnitPlanData _UnitPlanData
_WorkPackageUnit _WorkPackageUnit
_UnitOfMeasure _UnitOfMeasure

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 C_WorkpackageDetails.
-- 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: CWORKPKGDETAIL

CREATE VIEW C_WorkpackageDetails AS
SELECT
  WorkPackage.WorkPackage AS WorkPackage,
  WorkPackage.WorkPackageUUID AS WorkPackageUUID,
  WorkPackage.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  WorkPackage.WorkPackageName AS WorkPackageName,
  WorkPackage.WorkPackageStartDate AS WorkPackageStartDate,
  WorkPackage.WorkPackageEndDate AS WorkPackageEndDate,
  WorkPackage.WBSElementObject AS WBSElementObject,
  WorkPackage.WBSDescription AS WBSDescription,
  WorkPackage.SalesOrder AS SalesOrder,
  WorkPackage.SalesOrderItem AS SalesOrderItem,
  WorkPackage.LastChangedByUser AS LastChangedByUser,
  WorkPackage.LastChangeDateTime AS LastChangeDateTime,
  WorkPackage.WorkPackageType AS WorkPackageType,
  WorkPackagePlanData.Currency AS Currency,
  WorkPackagePlanData.PlndCostAmt AS PlndCostAmt,
  WorkPackagePlanData.PlndEffortQty AS PlndEffortQty,
  WorkPackagePlanData.PlndRevnAmt AS PlndRevnAmt,
  WorkPackagePlanData.PlannedUnitRevenue AS PlannedUnitRevenue,
  WorkPackagePlanData.WorkPackageUnit AS WorkPackageUnit,
  WorkPackagePlanData.PlanUnitQuantity AS WorkPackageUnitQuantity,
  WorkPackagePlanData.WorkPackageUnitUoM AS WorkPackageUnitUoM,
  WorkPackage.CreationDateTime AS CreationDateTime,
  WorkPackage.CreatedByUser AS CreatedByUser,
  WorkItemCount.NumberOfWorkItems AS NumberOfWorkItems,
  EngagementProject.EngagementProject AS EngagementProject,
  WorkPackage._EngagementProjFinancialPlan AS _EngagementProjFinancialPlan,
  WorkPackage._SalesOrder AS _SalesOrder,
  WorkPackage._SalesOrderItem AS _SalesOrderItem,
  WorkPackage._WBSElement AS _WBSElement,
  WorkPackage._EngagementProjectPlanData AS _EngagementProjectPlanData
FROM I_WorkPackage AS WorkPackage
LEFT OUTER JOIN C_WorkpackageMember AS _WorkpackageMember ON WorkPackage = _WorkpackageMember.WorkPackage  -- association [0..*]
LEFT OUTER JOIN C_EngagementProjectDetails AS _EngagementProject ON EngagementProjFinPlanUUID = _EngagementProject.EngagementProjFinPlanUUID  -- association [0..1]
LEFT OUTER JOIN E_Workpackage AS _Extension ON WorkPackageUUID = _Extension.WorkPackageUUID  -- association [0..1]
LEFT OUTER JOIN C_WorkpackageWorkItem AS _WorkPackageWorkItem ON WorkPackage = _WorkPackageWorkItem.WorkPackage AND EngagementProjFinPlanUUID = _WorkPackageWorkItem.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN I_EngmntProjectUnitDataVersion AS _UnitPlanData ON WorkPackage = _UnitPlanData.WorkPackage  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON WorkPackageUnitUoM = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectResource AS _WorkPackageUnit ON WorkPackageUnit = _WorkPackageUnit.EngagementProjectResource AND _WorkPackageUnit.EngagementProjectResourceType = '0SRV'  -- association [0..1]
;

Learn More