P_ExtSrvcProjWrkPckgPlnByPerd

DDL: P_EXTSRVCPROJWRKPCKGPLNBYPERD SQL: PEXTWPPLNBYPRD Type: view COMPOSITE
27 Fields 1 Data Sources 1 Associations

P_ExtSrvcProjWrkPckgPlnByPerd is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectPlnDataVersion) and exposes 27 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion PlanData from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PersnWrkAgreementDet _PersonWorkAgreementDet $projection.EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PEXTWPPLNBYPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject Engmnt Project ID
EngagementProjFinPlanUUID I_EngmntProjectPlnDataVersion EngagementProjFinPlanUUID Engagement Project
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage Plan Item
EngmtProjFinPlanVersion I_EngmntProjectPlnDataVersion EngmtProjFinPlanVersion Plan Version ID
BillingControlCategory I_EngmntProjectPlnDataVersion BillingControlCategory Billing Category
WorkItem I_EngmntProjectPlnDataVersion WorkItem Work Item ID
Currency I_EngmntProjectPlnDataVersion Currency Valuation Crcy
EngagementProjectResource I_EngmntProjectPlnDataVersion EngagementProjectResource Resource ID
EngagementProjectResourceType I_EngmntProjectPlnDataVersion EngagementProjectResourceType ResourceTypeID
EmploymentInternalID I_EngmntProjectPlnDataVersion EmploymentInternalID WorkForce Assgmt ID
PlndCostAmt
PlndRevnAmt
ActualPlanDeviationCost
ActualPlanDeviationEffort
FiscalYear I_EngmntProjectPlnDataVersion FiscalYear G/L Fiscal Year
FiscalPeriod I_EngmntProjectPlnDataVersion FiscalPeriod Tax period
UnitOfMeasure I_EngmntProjectPlnDataVersion UnitOfMeasure Unit Protected Qty
PlndEffortQty
EngagementProjectServiceOrg I_EngmntProjectPlnDataVersion EngagementProjectServiceOrg Service Org.
EngmntProjPlanLineType I_EngmntProjectPlnDataVersion EngmntProjPlanLineType Line type
Confirmed I_EngmntProjectPlnDataVersion EngmtProjEmployeeIsStaffed Confirmation of staffed Employee
_PersonWorkAgreementDet _PersonWorkAgreementDet
_WorkPackage I_EngmntProjectPlnDataVersion _WorkPackage
_WorkItem I_EngmntProjectPlnDataVersion _WorkItem
_EngagementProjectServiceOrg I_EngmntProjectPlnDataVersion _EngagementProjectServiceOrg
_EngagementProjectResource I_EngmntProjectPlnDataVersion _EngagementProjectResource
_EngmntProjResourceType I_EngmntProjectPlnDataVersion _EngmntProjResourceType

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_ExtSrvcProjWrkPckgPlnByPerd.
-- 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: PEXTWPPLNBYPRD

CREATE VIEW P_ExtSrvcProjWrkPckgPlnByPerd AS
SELECT
  PlanData.EngagementProject AS EngagementProject,
  PlanData.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  PlanData.WorkPackage AS WorkPackage,
  PlanData.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  PlanData.BillingControlCategory AS BillingControlCategory,
  PlanData.WorkItem AS WorkItem,
  PlanData.Currency AS Currency,
  PlanData.EngagementProjectResource AS EngagementProjectResource,
  PlanData.EngagementProjectResourceType AS EngagementProjectResourceType,
  PlanData.EmploymentInternalID AS EmploymentInternalID,
  sum(PlanData.PlndCostAmt) AS PlndCostAmt,
  sum(PlanData.PlndRevnAmt) AS PlndRevnAmt,
  sum(PlanData.ActualPlanDeviationCost ) AS ActualPlanDeviationCost,
  sum(PlanData.ActualPlanDeviationEffort) AS ActualPlanDeviationEffort,
  PlanData.FiscalYear AS FiscalYear,
  PlanData.FiscalPeriod AS FiscalPeriod,
  PlanData.UnitOfMeasure AS UnitOfMeasure,
  sum(PlanData.PlndEffortQty) AS PlndEffortQty,
  PlanData.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  PlanData.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  PlanData.EngmtProjEmployeeIsStaffed AS Confirmed,
  PlanData._WorkPackage AS _WorkPackage,
  PlanData._WorkItem AS _WorkItem,
  PlanData._EngagementProjectServiceOrg AS _EngagementProjectServiceOrg,
  PlanData._EngagementProjectResource AS _EngagementProjectResource,
  PlanData._EngmntProjResourceType AS _EngmntProjResourceType
FROM I_EngmntProjectPlnDataVersion AS PlanData
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement  -- association [0..*]
;

Learn More