P_PurgRequisitionValueHelp

@AbapCatalog.sqlViewName: 'PPURGREQN_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true

@ObjectModel.semanticKey: ['PurchaseRequisition', 'PurchaseRequisitionItem']
@ObjectModel.representativeKey: 'PurchaseRequisition'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Value help for purchase requisition'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_PurgRequisitionValueHelp
  as select from I_Purchaserequisitionitem as PurchaseRequisitionItem

  association [0..*] to I_MaterialText as _MaterialText on $projection.Material = _MaterialText.Material

  association [0..1] to I_Plant        as _Plant        on $projection.Plant = _Plant.Plant
  
   association [0..1] to I_Supplier                     as _DesiredSupplier             on  $projection.Supplier = _DesiredSupplier.Supplier

{

     // @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }

  key PurchaseRequisitionItem.PurchaseRequisition         as PurchaseRequisition,

     // @ObjectModel.foreignKey.association

  key PurchaseRequisitionItem.PurchaseRequisitionItem     as PurchaseRequisitionItem,

     // @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }

      PurchaseRequisitionItem.PurchaseRequisitionItemText as PurchaseRequisitionItemText,

      PurchaseRequisitionItem.ProcessingStatus            as ProcessingStatus,

     // @ObjectModel.text.association: '_MaterialText'

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }

      PurchaseRequisitionItem.Material                    as Material,

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM}

      PurchaseRequisitionItem.Plant                       as Plant,

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }

      _Plant.PlantName,
      
     // @UI.hidden: true

     //@Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentCategory,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsPurReqnBlocked,
      //@UI.hidden: true

      //@Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsPurReqnCmplt,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.Supplier,
      
     // _DesiredSupplier.IsBusinessPurposeCompleted,

      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.FixedSupplier,
      
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsDeleted,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsClosed,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.OrderedQuantity,
      
      //@UI.hidden: true

      cast(PurchaseRequisitionItem.RequestedQuantity as abap.dec( 25, 2 ))                                                                                   as       RequestedQuantity,
      
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentItemCategory,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentSubtype,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem._Supplier.IsBusinessPurposeCompleted,
      
      PurchaseRequisitionItem.PurchaseRequisitionType,
      
      PurchaseRequisitionItem.PurchasingGroup,
      
      PurchaseRequisitionItem.PurchasingOrganization,
      
      _MaterialText

}
where
           PurchaseRequisitionItem.PurchasingDocumentCategory           =  'B'
  and      PurchaseRequisitionItem.IsPurReqnBlocked                     =  ' '
  and     ( IsPurReqnCmplt                       =  ' ' or ( IsPurReqnCmplt = 'X' and PurReqnCmpltnsCat='A' ) )
  and(
    (
           PurchaseRequisitionItem.Supplier                             =  ' '
    )
    or(
           _DesiredSupplier.IsBusinessPurposeCompleted              =  ' '
    )
  )
  and(
    (
           PurchaseRequisitionItem.FixedSupplier                        =  ' '
    )
    or(
           PurchaseRequisitionItem._Supplier.IsBusinessPurposeCompleted =  ' '
    )
  )
  and      PurchaseRequisitionItem.IsDeleted                            =  ' '
  and      PurchaseRequisitionItem.IsClosed                             =  ' '
  and(
    (
      (
         (
           ( PurchaseRequisitionItem.OrderedQuantity                      <  PurchaseRequisitionItem.RequestedQuantity )
           or
          ( RequestedQuantity = 0 and PurchaseRequisitionItem.PurchasingDocumentItemCategory = 'A' )  //3397671

        )  
        or PurchaseRequisitionItem.PurchasingDocumentItemCategory       =  '8'
      )
      and  PurchaseRequisitionItem.PurchasingDocumentSubtype            <> 'R'
    )
    or(
           PurchaseRequisitionItem.PurchasingDocumentSubtype            =  'R'
      and  PurchaseRequisitionItem.ProcessingStatus                     <> 'K'
      and  PurchaseRequisitionItem.ProcessingStatus                     <> 'L'
    )
  )