P_Wrkpckgteamplanactual

DDL: P_WRKPCKGTEAMPLANACTUAL SQL: PWRKTEAMPLNACT Type: view CONSUMPTION
13 Fields 1 Data Sources

P_Wrkpckgteamplanactual is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_WrkPkgWrkItmPlnActByEmployee) and exposes 13 fields.

Data Sources (1)

SourceAliasJoin Type
I_WrkPkgWrkItmPlnActByEmployee PlanActualData from

Parameters (1)

NameTypeDefault
P_FiscalYearPeriod fis_jahrper

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName PWRKTEAMPLNACT view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
EngagementProject I_WrkPkgWrkItmPlnActByEmployee EngagementProject Engmnt Project ID
WorkPackage I_WrkPkgWrkItmPlnActByEmployee WorkPackage Plan Item
WorkItem I_WrkPkgWrkItmPlnActByEmployee WorkItem Work Item ID
EngagementProjectResource I_WrkPkgWrkItmPlnActByEmployee EngagementProjectResource Resource ID
EmploymentInternalID I_WrkPkgWrkItmPlnActByEmployee EmploymentInternalID WorkForce Assgmt ID
FiscalPeriod I_WrkPkgWrkItmPlnActByEmployee FiscalPeriod Tax period
FiscalYearPeriod I_WrkPkgWrkItmPlnActByEmployee FiscalYearPeriod Period/Year
FiscalYear I_WrkPkgWrkItmPlnActByEmployee FiscalYear G/L Fiscal Year
EngagementProjectServiceOrg I_WrkPkgWrkItmPlnActByEmployee EngagementProjectServiceOrg Service Org.
UnitOfMeasure I_WrkPkgWrkItmPlnActByEmployee UnitOfMeasure Unit Protected Qty
ActlEffortQty I_WrkPkgWrkItmPlnActByEmployee ActlEffortQty
PlndEffortQty I_WrkPkgWrkItmPlnActByEmployee PlndEffortQty Total Quantity
_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 P_Wrkpckgteamplanactual.
-- 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: PWRKTEAMPLNACT
-- Parameters: P_FiscalYearPeriod : fis_jahrper

CREATE VIEW P_Wrkpckgteamplanactual AS
SELECT
  PlanActualData.EngagementProject AS EngagementProject,
  PlanActualData.WorkPackage AS WorkPackage,
  PlanActualData.WorkItem AS WorkItem,
  PlanActualData.EngagementProjectResource AS EngagementProjectResource,
  PlanActualData.EmploymentInternalID AS EmploymentInternalID,
  PlanActualData.FiscalPeriod AS FiscalPeriod,
  PlanActualData.FiscalYearPeriod AS FiscalYearPeriod,
  PlanActualData.FiscalYear AS FiscalYear,
  PlanActualData.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  PlanActualData.UnitOfMeasure AS UnitOfMeasure,
  PlanActualData.ActlEffortQty AS ActlEffortQty,
  PlanActualData.PlndEffortQty AS PlndEffortQty
FROM I_WrkPkgWrkItmPlnActByEmployee AS PlanActualData
;

Learn More