I_WorkpackagePurchaseOrder

DDL: I_WORKPACKAGEPURCHASEORDER SQL: IWRKPCKGPURODR Type: view COMPOSITE
23 Fields 1 Data Sources 3 Associations

Work Package Pruchase Order

I_WorkpackagePurchaseOrder is a Composite CDS View that provides data about "Work Package Pruchase Order" in SAP S/4HANA. It reads from 1 data source (P_Workpackagepurchaseorder) and exposes 23 fields with key fields WorkPackage, PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_Workpackagepurchaseorder Workpackagepurchaseorder from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_EngagementProjFinancialPlan _EngagementProjFinancialPlan $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
[1..1] I_PurchaseOrderEnhanced _PurchaseOrderEnhanced _PurchaseOrderEnhanced.PurchaseOrder = $projection.PurchaseOrder
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem and _PurchasingDocumentItem.PurchasingDocumentCategory = 'F'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPCKGPURODR view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Work Package Pruchase Order view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage P_Workpackagepurchaseorder WorkPackage Plan Item
KEY PurchaseOrder P_Workpackagepurchaseorder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem P_Workpackagepurchaseorder PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine ScheduleLine Schedule Line
WorkPackageUUID P_Workpackagepurchaseorder WorkPackageUUID Work Package UUID
EngagementProjFinPlanUUID P_Workpackagepurchaseorder EngagementProjFinPlanUUID Engagement Project
WBSElementInternalID P_Workpackagepurchaseorder WBSElementInternalID WBS Internal ID
PurchasingDocument P_Workpackagepurchaseorder PurchasingDocument Purchasing Document
Currency P_Workpackagepurchaseorder Currency Valuation Crcy
PurchaseOrderNetPriceAmount P_Workpackagepurchaseorder PurchaseOrderNetPriceAmount Net Price
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantity OrderQuantity Quantity
NetAmount NetAmount Stated Amount
Material Material Vehicle Model
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
OpenQuantity OpenQuantity PBE Entry Open Qty
OpenQuantity0then3else2endasPriorityCode
_EngagementProjFinancialPlan _EngagementProjFinancialPlan
_PurchaseOrderEnhanced _PurchaseOrderEnhanced
_PurchaseOrder _PurchaseOrder
_PurchasingDocumentItem _PurchasingDocumentItem

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_WorkpackagePurchaseOrder.
-- 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: IWRKPCKGPURODR

CREATE VIEW I_WorkpackagePurchaseOrder AS
SELECT
  Workpackagepurchaseorder.WorkPackage AS WorkPackage,
  Workpackagepurchaseorder.PurchaseOrder AS PurchaseOrder,
  Workpackagepurchaseorder.PurchaseOrderItem AS PurchaseOrderItem,
  ScheduleLine,
  Workpackagepurchaseorder.WorkPackageUUID AS WorkPackageUUID,
  Workpackagepurchaseorder.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  Workpackagepurchaseorder.WBSElementInternalID AS WBSElementInternalID,
  Workpackagepurchaseorder.PurchasingDocument AS PurchasingDocument,
  Workpackagepurchaseorder.Currency AS Currency,
  Workpackagepurchaseorder.PurchaseOrderNetPriceAmount AS PurchaseOrderNetPriceAmount,
  PurchasingDocumentItemText,
  OrderQuantityUnit,
  OrderQuantity,
  NetAmount,
  Material,
  ScheduleLineDeliveryDate,
  RoughGoodsReceiptQty,
  OpenQuantity,
  case when ScheduleLineDeliveryDate > $session.system_date and Workpackagepurchaseorder.OpenQuantity = 0 then 3 else 2 end as PriorityCode AS OpenQuantity0then3else2endasPriorityCode
FROM P_Workpackagepurchaseorder AS Workpackagepurchaseorder
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderEnhanced AS _PurchaseOrderEnhanced ON _PurchaseOrderEnhanced.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem AND _PurchasingDocumentItem.PurchasingDocumentCategory = 'F'  -- association [0..1]
;

Learn More