A_EngmntProjWrkPckg

DDL: A_ENGMNTPROJWRKPCKG SQL: AEPWORKPACKAGE Type: view CONSUMPTION
24 Fields 1 Data Sources 5 Associations

Work Package

A_EngmntProjWrkPckg is a Consumption CDS View that provides data about "Work Package" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjWrkPckg) and exposes 24 fields with key field WorkPackage. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjWrkPckg A from

Associations (5)

CardinalityTargetAliasCondition
[1..1] A_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[0..*] A_EngmntProjWrkPckgWrkItm _WorkPackageWorkItem $projection.WorkPackage = _WorkPackageWorkItem.WorkPackage
[0..*] A_EngmntProjWrkPckgFunc _WorkPackageFunctions $projection.WorkPackage = _WorkPackageFunctions.WorkPackage
[0..*] A_EngmntProjRsceDmnd _ResourceDemand $projection.WorkPackage = _ResourceDemand.WorkPackage
[0..1] E_Workpackage _Extension $projection.WorkPackageUUID = _Extension.WorkPackageUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AEPWORKPACKAGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Package view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage I_EngmntProjWrkPckg WorkPackage Plan Item
EngagementProject I_EngmntProjWrkPckg EngagementProject Engmnt Project ID
WorkPackageUUID I_EngmntProjWrkPckg WorkPackageUUID Work Package UUID
WorkPackageName I_EngmntProjWrkPckg WorkPackageName Plan Item Desc.
WorkPackageStartDate I_EngmntProjWrkPckg WorkPackageStartDate Start Date
WorkPackageEndDate I_EngmntProjWrkPckg WorkPackageEndDate End Date
LastChangeDateTime I_EngmntProjWrkPckg LastChangeDateTime Timestamp
CreationDateTime I_EngmntProjWrkPckg CreationDateTime Timestamp
WorkPackageType I_EngmntProjWrkPckg WorkPackageType
EngagementProjectType I_EngmntProjWrkPckg EngagementProjectType
EngagementProjectServiceOrg I_EngmntProjWrkPckg EngagementProjectServiceOrg Service Org.
EngagementProjectCategory I_EngmntProjWrkPckg EngagementProjectCategory
ProjectProfileCode I_EngmntProjWrkPckg ProjectProfileCode Project Profile
ProjectVisibility I_EngmntProjWrkPckg ProjectVisibility
CompanyCode I_EngmntProjWrkPckg CompanyCode Receiver Company Code
CostCenter I_EngmntProjWrkPckg CostCenter Cost Center
ProfitCenter I_EngmntProjWrkPckg ProfitCenter Profit Center
WorkPackageUnit I_EngmntProjWrkPckg WorkPackageUnit
WorkPackageUnitUoM I_EngmntProjWrkPckg WorkPackageUnitUoM
PlanUnitQuantity I_EngmntProjWrkPckg PlanUnitQuantity
_EngagementProject _EngagementProject
_WorkPackageFunctions _WorkPackageFunctions
_WorkPackageWorkItem _WorkPackageWorkItem
_ResourceDemand _ResourceDemand

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 A_EngmntProjWrkPckg.
-- 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: AEPWORKPACKAGE

CREATE VIEW A_EngmntProjWrkPckg AS
SELECT
  A.WorkPackage AS WorkPackage,
  A.EngagementProject AS EngagementProject,
  A.WorkPackageUUID AS WorkPackageUUID,
  A.WorkPackageName AS WorkPackageName,
  A.WorkPackageStartDate AS WorkPackageStartDate,
  A.WorkPackageEndDate AS WorkPackageEndDate,
  A.LastChangeDateTime AS LastChangeDateTime,
  A.CreationDateTime AS CreationDateTime,
  A.WorkPackageType AS WorkPackageType,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.ProjectVisibility AS ProjectVisibility,
  A.CompanyCode AS CompanyCode,
  A.CostCenter AS CostCenter,
  A.ProfitCenter AS ProfitCenter,
  A.WorkPackageUnit AS WorkPackageUnit,
  A.WorkPackageUnitUoM AS WorkPackageUnitUoM,
  A.PlanUnitQuantity AS PlanUnitQuantity
FROM I_EngmntProjWrkPckg AS A
LEFT OUTER JOIN A_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN A_EngmntProjWrkPckgWrkItm AS _WorkPackageWorkItem ON WorkPackage = _WorkPackageWorkItem.WorkPackage  -- association [0..*]
LEFT OUTER JOIN A_EngmntProjWrkPckgFunc AS _WorkPackageFunctions ON WorkPackage = _WorkPackageFunctions.WorkPackage  -- association [0..*]
LEFT OUTER JOIN A_EngmntProjRsceDmnd AS _ResourceDemand ON WorkPackage = _ResourceDemand.WorkPackage  -- association [0..*]
LEFT OUTER JOIN E_Workpackage AS _Extension ON WorkPackageUUID = _Extension.WorkPackageUUID  -- association [0..1]
;

Learn More