P_PURREQUISITIONNOTOUCH1

CDS View

Purchase Requisition No Touch1

P_PURREQUISITIONNOTOUCH1 is a CDS View in S/4HANA. Purchase Requisition No Touch1. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PurReqnNoTouch view from CONSUMPTION Purchase Requisition No Touch Rate
C_PurRequisitionNoTouch view from CONSUMPTION Purchase Requisition No Touch Rate 
@AbapCatalog.sqlViewName: 'PMMPRNOTOU'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Requisition No Touch1'
define view P_PurRequisitionNoTouch1 
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate : budat, 
    P_EndDate   : budat 
  as select distinct from P_PurRequisitionNoTouch  (  P_StartDate:$parameters.P_StartDate ,
                                             P_EndDate:$parameters.P_EndDate ) as RequisitionItem
                                             
 left outer join I_PurReqnAccountAssignment                                                                        as AccountAssignment on  RequisitionItem.PurchaseRequisition     = AccountAssignment.PurchaseRequisition
                                                                                                                                           and RequisitionItem.PurchaseRequisitionItem = AccountAssignment.PurchaseRequisitionItem                                             
{
  key  RequisitionItem.PurchaseRequisition,
  key  RequisitionItem.PurchaseRequisitionItem,
  key  Supplier,
  
       RequisitionItem.PurchasingGroup,
       RequisitionItem.PurchasingOrganization,
       RequisitionItem.CompanyCode,
       PurchaseRequisitionType,
       RequisitionItem.MaterialGroup,
       RequisitionItem.Material,
       RequisitionItem.Plant,
       AccountAssignment.CostCenter,
       PurReqnItemClassification,
       RequisitionItem.CreatedByUser,
       RequisitionItem.CreationDate,
     //  max(PurReqnNoTouchType) as PurReqnNoTouchType

      PurReqnNoTouchType,

//      //Added for High, Medium & Low  categorisation

//      cast( case when PurReqnNoTouchType = 'N' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithNoTouch,

//

//      cast( case when PurReqnNoTouchType = 'L' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithLow,

//

//      cast( case when PurReqnNoTouchType = 'H' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithHighTouch,

      //Added for displaying PR value in document view

      RequisitionItem.BaseUnit,
      PurReqCreationDate,
      RequestedQuantity,
      PurReqnPriceQuantity,  
      PurReqnItemCurrency,
      //PurchaseRequisitionPrice,         

       
      cast( currency_conversion(  amount             => PurchaseRequisitionPrice ,
                                  source_currency    => PurReqnItemCurrency,
                                  target_currency    =>  :P_DisplayCurrency,
                                  exchange_rate_date => PurReqCreationDate,
                                  exchange_rate_type => 'M'
                               ) as abap.curr(21,5) )  as PurchaseRequisitionPrice
}
//group by

//  RequisitionItem.PurchaseRequisition,

//  RequisitionItem.PurchaseRequisitionItem,

//  Supplier,

//  RequisitionItem.PurchasingGroup,

//  RequisitionItem.PurchasingOrganization,

//  RequisitionItem.CompanyCode,

//  PurchaseRequisitionType,

//  RequisitionItem.MaterialGroup,

//  RequisitionItem.Material,

//  RequisitionItem.Plant,

//  AccountAssignment.CostCenter,

//  PurReqnItemClassification,

//  RequisitionItem.CreatedByUser,

//  RequisitionItem.CreationDate

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURREQNACCOUNTASSIGNMENT",
"P_PURREQUISITIONNOTOUCH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More