I_ExtSrvcWrkPckgPlnByPerd

DDL: I_EXTSRVCWRKPCKGPLNBYPERD Type: view COMPOSITE
29 Fields 1 Data Sources 2 Associations

External Service Work Package Plan By Period

I_ExtSrvcWrkPckgPlnByPerd is a Composite CDS View that provides data about "External Service Work Package Plan By Period" in SAP S/4HANA. It reads from 1 data source (P_ExtSrvcProjWrkPckgDemdByPerd) and exposes 29 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ExtSrvcProjWrkPckgDemdByPerd P_ExtSrvcProjWrkPckgDemdByPerd from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[0..1] I_BillingControlCategoryText _BillingControlCategoryText $projection.BillingControlCategory = _BillingControlCategoryText.BillingControlCategory and _BillingControlCategoryText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEXTWPPLNBYPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label External Service Work Package Plan By Period view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view

Fields (29)

KeyFieldSource TableSource FieldDescription
EngagementProject EngagementProject Engmnt Project ID
EngagementProjFinPlanUUID EngagementProjFinPlanUUID Engagement Project
WorkPackage WorkPackage Plan Item
EngmtProjFinPlanVersion EngmtProjFinPlanVersion Plan Version ID
WorkItem WorkItem Work Item ID
Currency Currency Valuation Crcy
EngagementProjectResource EngagementProjectResource Resource ID
EngagementProjectResourceType EngagementProjectResourceType ResourceTypeID
EngmtProjEmployeeIsStaffed Confirmed Confirmed
EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
PlndCostAmt PlndCostAmt Amount
PlndRevnAmt PlndRevnAmt Amount
ActualPlanDeviationCost ActualPlanDeviationCost Cost Deviation
ActualPlanDeviationEffort ActualPlanDeviationEffort Effort Deviation
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
UnitOfMeasure UnitOfMeasure Unit Protected Qty
PlndEffortQty PlndEffortQty Total Quantity
EngagementProjectServiceOrg EngagementProjectServiceOrg Service Org.
EngmntProjPlanLineType EngmntProjPlanLineType Line type
_EngagementProject _EngagementProject
_PersonWorkAgreement_1 _PersonWorkAgreement_1
_PersonWorkAgreementDet _PersonWorkAgreementDet
_EngagementProjectResource _EngagementProjectResource
_EngagementProjectServiceOrg _EngagementProjectServiceOrg
_EngmntProjResourceType _EngmntProjResourceType
_WorkItem _WorkItem
_WorkPackage _WorkPackage
_BillingControlCategoryText _BillingControlCategoryText

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 I_ExtSrvcWrkPckgPlnByPerd.
-- 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.

CREATE VIEW I_ExtSrvcWrkPckgPlnByPerd AS
SELECT
  EngagementProject,
  EngagementProjFinPlanUUID,
  WorkPackage,
  EngmtProjFinPlanVersion,
  WorkItem,
  Currency,
  EngagementProjectResource,
  EngagementProjectResourceType,
  Confirmed AS EngmtProjEmployeeIsStaffed,
  EmploymentInternalID,
  PlndCostAmt,
  PlndRevnAmt,
  ActualPlanDeviationCost,
  ActualPlanDeviationEffort,
  FiscalYear,
  FiscalPeriod,
  UnitOfMeasure,
  PlndEffortQty,
  EngagementProjectServiceOrg,
  EngmntProjPlanLineType
FROM P_ExtSrvcProjWrkPckgDemdByPerd
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON EngagementProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- association [0..1]
;

Learn More