P_Workpackagepurchaseorder

@AbapCatalog.sqlViewName: 'PWPPURCHASEORDER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_Workpackagepurchaseorder
  as select from I_WorkPackage             as WorkPACKAGE
    join         I_WBSElementBasicData     as WBSElement              on WBSElement.WBSElementObject = WorkPACKAGE.WBSElementObject
    join         I_PurOrdAccountAssignment as PurOrdAccountAssignment on PurOrdAccountAssignment.WBSElementInternalID = WBSElement.WBSElementInternalID
    join         I_PurchasingDocumentItem  as PurchasingDocumentItem  on  PurchasingDocumentItem.PurchasingDocument         = PurOrdAccountAssignment.PurchaseOrder
                                                                      and PurchasingDocumentItem.PurchasingDocumentItem     = PurOrdAccountAssignment.PurchaseOrderItem
                                                                      and PurchasingDocumentItem.PurchasingDocumentCategory = 'F'
    join         I_PurgDocScheduleLine     as PurgDocScheduleLine     on  PurgDocScheduleLine.PurchasingDocument     = PurchasingDocumentItem.PurchasingDocument
                                                                      and PurgDocScheduleLine.PurchasingDocumentItem = PurchasingDocumentItem.PurchasingDocumentItem

{
  key PurchasingDocumentItem.PurchasingDocument                         as  PurchaseOrder,
  key PurchasingDocumentItem.PurchasingDocumentItem                     as  PurchaseOrderItem,
  key PurgDocScheduleLine.ScheduleLine                                  as  ScheduleLine,
      WorkPACKAGE.WorkPackageUUID                                       as  WorkPackageUUID,
      WorkPACKAGE.WorkPackage                                           as  WorkPackage,
      WorkPACKAGE.EngagementProjFinPlanUUID                             as  EngagementProjFinPlanUUID,
      WBSElement.WBSElementInternalID                                   as  WBSElementInternalID,
      PurOrdAccountAssignment.PurchaseOrder                             as  PurchasingDocument,
      //PurchasingDocumentItem._PurchasingDocument._Supplier.SupplierName as  SupplierName,

      
      PurchasingDocumentItem.DocumentCurrency                           as  Currency,
      
      PurchasingDocumentItem.NetPriceAmount                             as  PurchaseOrderNetPriceAmount,
      PurchasingDocumentItem.PurchasingDocumentItemText,
      // PurchasingDocumentItem.ServicePerformer,

      // PurchasingDocumentItem._ServicePerformer.BusinessPartnerName,

      PurchasingDocumentItem.OrderQuantityUnit,
      PurchasingDocumentItem.OrderQuantity,
      
      PurchasingDocumentItem.NetAmount,
      PurchasingDocumentItem.Material,
      PurgDocScheduleLine.ScheduleLineDeliveryDate,
      PurgDocScheduleLine.RoughGoodsReceiptQty,
      sum(PurgDocScheduleLine.ScheduleLineOpenQuantity)                 as  OpenQuantity,
      // PurchasingDocumentItem.OrderQuantity - PurgDocScheduleLine.RoughGoodsReceiptQty as OpenQuantity

      _PurchaseOrder

}
group by
  PurchasingDocumentItem.PurchasingDocument,
  PurchasingDocumentItem.PurchasingDocumentItem,
  PurgDocScheduleLine.ScheduleLine,
  WorkPACKAGE.WorkPackageUUID,
  WorkPACKAGE.WorkPackage,
  WorkPACKAGE.EngagementProjFinPlanUUID,
  WBSElement.WBSElementInternalID,
  PurOrdAccountAssignment.PurchaseOrder,
  //PurchasingDocumentItem._PurchasingDocument._Supplier.SupplierName,

  PurchasingDocumentItem.DocumentCurrency,
  PurchasingDocumentItem.NetPriceAmount,
  PurchasingDocumentItem.PurchasingDocumentItemText,
  // PurchasingDocumentItem.ServicePerformer,

  // PurchasingDocumentItem._ServicePerformer.BusinessPartnerName,

  PurchasingDocumentItem.OrderQuantityUnit,
  PurchasingDocumentItem.OrderQuantity,
  PurchasingDocumentItem.NetAmount,
  PurchasingDocumentItem.Material,
  PurgDocScheduleLine.ScheduleLineDeliveryDate,
  PurgDocScheduleLine.RoughGoodsReceiptQty
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTITEM",
"I_PURGDOCSCHEDULELINE",
"I_PURORDACCOUNTASSIGNMENT",
"I_WBSELEMENTBASICDATA",
"I_WORKPACKAGE"
],
"ASSOCIATED":
[
"I_PURCHASEORDER"
],
"BASE":
[
"I_PURORDACCOUNTASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/