P_ReqnToOrderCycleTime1

@AbapCatalog.sqlViewName: 'PMMREQORDCYCL1'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_ReqnToOrderCycleTime1
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : badat,
    P_EndDate         : badat

  as select from    P_PurReqnCurrencyConvrsn( P_DisplayCurrency: $parameters.P_DisplayCurrency,
                                              P_StartDate : $parameters.P_StartDate,
                                              P_EndDate : $parameters.P_EndDate )

    inner join      I_PurchaseOrderItem as PurchaseOrderItem  on  PurchaseOrderItem.PurchaseRequisition     = P_PurReqnCurrencyConvrsn.PurchaseRequisition
                                                              and PurchaseOrderItem.PurchaseRequisitionItem = P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem
    inner join      I_PurchaseOrder     as PurchaseOrder      on  PurchaseOrder.PurchaseOrder = PurchaseOrderItem.PurchaseOrder
                                                              and PurchaseOrder.CreationDate  = P_PurReqnCurrencyConvrsn.CreationDate
//    left outer join I_PurchaseOrderItem as PurchaseOrderItem1 on  PurchaseOrderItem1.PurchaseOrder    = PurchaseOrderItem.PurchaseOrder

//                                                              and PurchaseOrderItem.PurchaseOrderItem > PurchaseOrderItem1.PurchaseOrderItem


{
  key P_PurReqnCurrencyConvrsn.PurchaseRequisition,
  key P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem,
  key P_PurReqnCurrencyConvrsn.AccountAssignmentNumber ,
      min(PurchaseOrderItem.PurchaseOrder)                     as PurchaseOrder,
      //key min(PurchaseOrderItem.PurchaseOrderItem) as PurchaseOrderItem,

      P_PurReqnCurrencyConvrsn.PurchasingGroup,
      P_PurReqnCurrencyConvrsn.PurchasingOrganization,
      P_PurReqnCurrencyConvrsn.Supplier,
      //P_PurReqnCurrencyConvrsn.SupplierCountry,

      cast(case
      when P_PurReqnCurrencyConvrsn.SupplierCountry is null  then ''
      else P_PurReqnCurrencyConvrsn.SupplierCountry end as mm_a_supplier_country ) as SupplierCountry ,
      P_PurReqnCurrencyConvrsn.Material,
      P_PurReqnCurrencyConvrsn.MaterialGroup,
      P_PurReqnCurrencyConvrsn.Plant,
      P_PurReqnCurrencyConvrsn.PurReqCreationDate,
      PurchaseRequisitionType,

      P_PurReqnCurrencyConvrsn.CostCenter,
      P_PurReqnCurrencyConvrsn.CreatedByUser,
      P_PurReqnCurrencyConvrsn.PurchaseRequisitionPrice  as PurchaseRequisitionPrice,
      P_PurReqnCurrencyConvrsn.CalendarWeek,
      P_PurReqnCurrencyConvrsn.CalendarMonth,
      P_PurReqnCurrencyConvrsn.CalendarQuarter,
      P_PurReqnCurrencyConvrsn.CalendarYear //,

}
//where

//      PurchaseOrder.PurchasingDocumentDeletionCode     = ''

//  and PurchaseOrderItem.PurchasingDocumentDeletionCode = ''

//  and PurchaseOrder.ReleaseIsNotCompleted              = ''

//  and PurchaseOrder.PurchasingCompletenessStatus       = ''

  //and PurchaseOrderItem1.PurchaseOrder                 is null

group by
  P_PurReqnCurrencyConvrsn.PurchaseRequisition,
  P_PurReqnCurrencyConvrsn.PurchaseRequisitionItem,
  P_PurReqnCurrencyConvrsn.AccountAssignmentNumber,
  P_PurReqnCurrencyConvrsn.PurchasingGroup,
  P_PurReqnCurrencyConvrsn.PurchasingOrganization,
  P_PurReqnCurrencyConvrsn.Supplier,
  P_PurReqnCurrencyConvrsn.SupplierCountry,
  P_PurReqnCurrencyConvrsn.Material,
  P_PurReqnCurrencyConvrsn.MaterialGroup,
  P_PurReqnCurrencyConvrsn.Plant,
  P_PurReqnCurrencyConvrsn.PurReqCreationDate,
  PurchaseRequisitionType,

  P_PurReqnCurrencyConvrsn.CostCenter,
  P_PurReqnCurrencyConvrsn.CreatedByUser,
  P_PurReqnCurrencyConvrsn.PurchaseRequisitionPrice,
  P_PurReqnCurrencyConvrsn.CalendarWeek,
  P_PurReqnCurrencyConvrsn.CalendarMonth,
  P_PurReqnCurrencyConvrsn.CalendarQuarter,
  P_PurReqnCurrencyConvrsn.CalendarYear