A_EngmntProjWrkPckgFunc

DDL: A_ENGMNTPROJWRKPCKGFUNC SQL: AEPWORKPCKGEFUNC Type: view CONSUMPTION
9 Fields 1 Data Sources 3 Associations

Work Package Fuctions

A_EngmntProjWrkPckgFunc is a Consumption CDS View that provides data about "Work Package Fuctions" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjWrkPckgFunc) and exposes 9 fields with key fields WorkPackage, WorkPackageFunctionID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjWrkPckgFunc I_EngmntProjWrkPckgFunc from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[1..1] A_EngmntProjWrkPckg _WorkPackage $projection.WorkPackage = _WorkPackage.WorkPackage
[0..*] A_EngmntProjWrkPckgFuncTxt _Text $projection.WorkPackageFunctionID = _Text.WorkPackageFunctionID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName AEPWORKPCKGEFUNC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Work Package Fuctions 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 (9)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage WorkPackage Plan Item
KEY WorkPackageFunctionID WorkPackageFunctionID
EngagementProject EngagementProject Engmnt Project ID
WorkPackageName WorkPackageName Plan Item Desc.
WorkPackageFunctionName WorkPackageFunctionName
WorkPackageFunctionIsBlocked WorkPackageFunctionIsBlocked
_Text _Text
_WorkPackage _WorkPackage
_EngagementProject _EngagementProject

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_EngmntProjWrkPckgFunc.
-- 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: AEPWORKPCKGEFUNC

CREATE VIEW A_EngmntProjWrkPckgFunc AS
SELECT
  WorkPackage,
  WorkPackageFunctionID,
  EngagementProject,
  WorkPackageName,
  WorkPackageFunctionName,
  WorkPackageFunctionIsBlocked
FROM I_EngmntProjWrkPckgFunc
LEFT OUTER JOIN A_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN A_EngmntProjWrkPckg AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [1..1]
LEFT OUTER JOIN A_EngmntProjWrkPckgFuncTxt AS _Text ON WorkPackageFunctionID = _Text.WorkPackageFunctionID  -- association [0..*]
;

Learn More