C_WorkPackage

DDL: C_WORKPACKAGE SQL: CWORKPACKAGE Type: view CONSUMPTION
32 Fields 2 Data Sources 6 Associations

Work Package

C_WorkPackage is a Consumption CDS View that provides data about "Work Package" in SAP S/4HANA. It reads from 2 data sources (P_EngagementProjFinancialPlan, I_WorkPackage) and exposes 32 fields. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_EngagementProjFinancialPlan FinancialPlan inner
I_WorkPackage WorkPackage from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[0..1] E_Workpackage _Extension $projection.WorkPackageUUID = _Extension.WorkPackageUUID
[0..*] C_WorkpackageWorkItem _WorkPackageWorkItem $projection.WorkPackage = _WorkPackageWorkItem.WorkPackage and _WorkPackageWorkItem.EngagementProjFinPlanUUID = WorkPackage.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 (10)

NameValueLevelField
AbapCatalog.sqlViewName CWORKPACKAGE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Work Package 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

Fields (32)

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
WorkPackageWBSObjectNumber 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 P_EngagementProjFinancialPlan Currency Valuation Crcy
EngagementProject P_EngagementProjFinancialPlan EngagementProject Engmnt Project ID
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
_EngagementProjFinancialPlan I_WorkPackage _EngagementProjFinancialPlan
_EngagementProjectPlanData I_WorkPackage _EngagementProjectPlanData
_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_WorkPackage.
-- 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: CWORKPACKAGE

CREATE VIEW C_WorkPackage 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 WorkPackageWBSObjectNumber,
  WorkPackage.WBSDescription AS WBSDescription,
  WorkPackage.SalesOrder AS SalesOrder,
  WorkPackage.SalesOrderItem AS SalesOrderItem,
  WorkPackage.LastChangedByUser AS LastChangedByUser,
  WorkPackage.LastChangeDateTime AS LastChangeDateTime,
  WorkPackage.WorkPackageType AS WorkPackageType,
  FinancialPlan.Currency AS Currency,
  FinancialPlan.EngagementProject AS EngagementProject,
  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,
  WorkPackage._EngagementProjFinancialPlan AS _EngagementProjFinancialPlan,
  WorkPackage._EngagementProjectPlanData AS _EngagementProjectPlanData
FROM I_WorkPackage AS WorkPackage
INNER JOIN P_EngagementProjFinancialPlan AS FinancialPlan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- 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 _WorkPackageWorkItem.EngagementProjFinPlanUUID = WorkPackage.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