C_RequisitionNoTouchRate

DDL: C_REQUISITIONNOTOUCHRATE SQL: CMMREQNOTOUCH Type: view CONSUMPTION

Requisition No Touch Rate

C_RequisitionNoTouchRate is a Consumption CDS View that provides data about "Requisition No Touch Rate" in SAP S/4HANA. It reads from 1 data source (C_PurRequisitionNoTouch). It is used in 6 Fiori applications: Procurement Overview Page, Purchase Requisition Average Approval Time, Purchase Requisition Item Changes, ....

1 data source(s) Used in 6 Fiori app(s)

Data Sources (1)

SourceAliasJoin Type
C_PurRequisitionNoTouch C_PurRequisitionNoTouch from

Parameters (4)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_DateFunction datefunctionid
P_StartDate badat
P_EndDate badat

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName CMMREQNOTOUCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Requisition No Touch Rate view
Analytics.query true view
OData.publish true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fiori Apps (6)

App IDApp NameTypeDescription
F1990 Procurement Overview Page Transactional, Analytical The Procurement Overview Page enables business users to perform their daily tasks quickly and effectively without the need to open many different reports and transactions. All the relevant information is shown on a single page - visualized on cards for multiple types of content in an attractive and efficient way. The user-friendly experience makes viewing data, filtering data and acting upon it simple, faster and smarter.
F2014 Purchase Requisition Average Approval Time Analytical
F2015 Purchase Requisition Item Changes Analytical
F2016 Purchase Requisition Item Types Analytical
F2017 Purchase Requisition to Order Cycle Time Analytical
F2018 Purchase Requisition No Touch Rate Analytical

Procurement Overview Page

Business Role: Purchaser

The Procurement Overview Page enables business users to perform their daily tasks quickly and effectively without the need to open many different reports and transactions. Information is displayed on set of actionable cards. Users can therefore focus on the most important tasks, enabling faster decisions and immediate action.

Purchase Requisition Average Approval Time

Business Role: Strategic Buyer

You can use this app to identify the average time it takes to create a purchase order: from the creation of a shopping cart to the creation of the purchase order. It measures the average creation time over the past 365 days from the current date. The average approval time is shown in days.The role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. The following authorization objects must be maintained in SU22:•M_BANF_EKG•M_BANF_EKO•M_BANF_WRK•S_RS_COMP•S_RS_COMP1The KPI is displayed in the following views:•By Supplier•By Purchasing Category•By Material Group•By Purchasing Group•By Purchasing Organization•Document•Trend

Purchase Requisition Item Changes

Business Role: Strategic Buyer

This app displays the absolute number of item changes in the last 365 days from the current date. All changes to items are logged.The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22:•M_BANF_EKG•M_BANF_EKO•M_BANF_WRK•F_BKPF_BUKThe KPI is displayed in the following views:•By Supplier•By Material Group•By Purchasing Group•By Purchasing Organization•Document•TrendThis app displays the absolute number of item changes in the last 365 days from the current date. All changes to items are logged. The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app.

Purchase Requisition Item Types

Business Role: Strategic Buyer

You can use this app to identify the number of free-text items created from the GUI in the last 365 days (from the current date). The requisitions for which material was specified are shown as number of material items created (GUI) at the time of creation. Similarly, the number of material items, free text items, and catalog items created from the Fiori app are also shown in the application.The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22:•M_BANF_EKG•M_BANF_EKO•M_BANF_WRK•F_BKPF_BUKThe KPI is displayed in the following views:•By Supplier•By Material Group•By Purchasing Group•By Purchasing Organization•Document•Trend

Purchase Requisition to Order Cycle Time

Business Role: Strategic Buyer

This app is used to identify the average cycle time in days from shopping cart creation to sending the purchase order to the supplier, over the last 365 days from the current date.The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22:•M_BANF_EKG•M_BANF_EKO•M_BANF_WRK•F_BKPF_BUKThe KPI is displayed in the following views:•By Supplier•By Material Group•By Purchasing Group•By Purchasing Organization•Document•Trend

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'CMMREQNOTOUCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Requisition No Touch Rate'
@Analytics.query: true
@OData.publish: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_RequisitionNoTouchRate

  with parameters
    @Consumption.defaultValue: 'EUR'
    @Consumption.valueHelpDefinition: [{
      entity: {
        name:'I_Currency',
        element:'Currency'
      }
    }]
    P_DisplayCurrency        : displaycurrency,
    @Consumption.defaultValue: 'PREVIOUSYEARTODATE'
    @Consumption.valueHelpDefinition: [{
      entity: {
        name:'C_GregorianCalDateFuncVH',
        element:'DateFunction'
      }
    }]
    P_DateFunction : datefunctionid,

    @Consumption.derivation: { lookupEntity: 'C_SglGregorianCalDateFunction',
    resultElement: 'DateFunctionStartDate', binding: [ {
      targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' },
       { targetParameter : 'P_Language' , type : #SYSTEM_FIELD, value : '#SYSTEM_LANGUAGE'  } ]
    }
    @Consumption.hidden: true
    P_StartDate    : badat,

    @Consumption.derivation: { lookupEntity: 'C_SglGregorianCalDateFunction',
    resultElement: 'DateFunctionEndDate', binding: [ {
      targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' },
       { targetParameter : 'P_Language' , type : #SYSTEM_FIELD, value : '#SYSTEM_LANGUAGE'  } ]
    }
    @Consumption.hidden: true
    P_EndDate      : badat
    
//    P_PriceForLowCostItem    : mm_a_low_cost_value,

//

//    P_PriceForMediumCostItem : mm_a_medium_cost_value,

//

//    P_PriceForHighCostItem   : mm_a_high_cost_value


  as select from C_PurRequisitionNoTouch( P_DisplayCurrency: $parameters.P_DisplayCurrency, 
                                          P_StartDate: $parameters.P_StartDate,
                                          P_EndDate:$parameters.P_EndDate )
                                          //P_PriceForLowCostItem: $parameters.P_PriceForLowCostItem,

                                          //P_PriceForMediumCostItem: $parameters.P_PriceForMediumCostItem,

                                          //P_PriceForHighCostItem:  $parameters.P_PriceForHighCostItem  )


{
  key PurchaseRequisition,
      
      @EndUserText.quickInfo: 'Purchase Requisition Item'
  key PurchaseRequisitionItem,
      @ObjectModel.text.element:  [ 'SupplierName' ]
      @Consumption.valueHelpDefinition: [{ entity: { name : 'C_MM_SmplSupplierValueHelp', element : 'Supplier' } }]
  key Supplier,
      _Supplier.SupplierName,
      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      @Consumption.valueHelpDefinition: [{ entity: { name : 'C_PurchasingGroupValueHelp', element : 'PurchasingGroup' } }]
      PurchasingGroup,
    //  @Semantics.text: true

    //  _PurchasingGroup.PurchasingGroupName,

    
      @EndUserText.quickInfo: 'Purchasing Organization'
      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL      
      PurchasingOrganization,
   //   @Semantics.text: true

   //   _PurchasingOrganization.PurchasingOrganizationName,

      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      MaterialGroup,
    //  @Semantics.text: true

      //_MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName as MaterialGroupName,

      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      Material,
   //   @Semantics.text: true

    //  _Material._Text[1: Language = $session.system_language].MaterialName,

      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      PurReqnItemClassification,
   //   @Semantics.text: true

   //   _PurReqnItemClassfctn._PurReqnItemClassfctnText[1: Language = $session.system_language].PurReqItemClassificationText,

      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      PurReqnNoTouchType,
   //   @Semantics.text: true

   //   _PurReqnNoTouchType._PurReqnNoTouchTypeText[1: Language = $session.system_language ].PurReqnNoTouchTypeText,

      @AnalyticsDetails.query.display: #KEY_TEXT
      @Analytics.internalName:#LOCAL
      Plant,
    //  _Plant.PlantName,


      @ObjectModel.text.element: ['PurgCatName']
      @Consumption.labelElement: 'PurgCatName'
      @Consumption.valueHelpDefinition: [{ entity: { name : 'I_PurchasingCategoryValueHelp', element : 'PurchasingCategory' } }]
      PurchasingCategory,
      
      @EndUserText.quickInfo: 'Purchasing Category Name'
      @Semantics.text: true
      PurgCatName,
      
     @Consumption.valueHelpDefinition: [{ entity: { name : 'C_MM_CompanyCodeValueHelp', element : 'CompanyCode' } }]
      CompanyCode,

      CostCenter,

      CreatedByUser,
      CalendarYear,
      CalendarQuarter,
      CalendarMonth,
      CalendarWeek,
      
      //Added for displaying PR value in document view

      @Semantics.unitOfMeasure: true
      BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @EndUserText.label: 'Quantity Requested'
      @DefaultAggregation: null
      //@Analytics.hidden: true

      RequestedQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @EndUserText.label: 'Price Unit'
      @Analytics.hidden: true
      @DefaultAggregation: null
      PurReqnPriceQuantity,  
      @Semantics.currencyCode: true
      PurReqnItemCurrency,
      @EndUserText.label: 'Valuation Price'
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      @Analytics.hidden: true
      @DefaultAggregation: #SUM
      PurchaseRequisitionPrice,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'No Touch Count'
      NmbrOfPurReqnWithNoTouch,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'Low Touch Count'
      NmbrOfPurReqnWithLow,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'High Touch Count'
      NmbrOfPurReqnWithHighTouch,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'Count'
      PurchaseRequisitionItemCount,
            
//      //Added for High, Medium & Low  categorisation

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'High Touch Low Cost'

//      HighTouchLowCostItemsValue,

//      

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'High Touch Medium Cost'

//      HighTouchMediumCostItemsValue,

//      

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'High Touch High Cost'

//      HighTouchHighCostItemsValue,

//      

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'High Touch Very High Cost'

//      HighTouchVeryHighCostItmsVal,

//      

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'No Touch Low Cost'

//      NoTouchLowCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'No Touch Medium Cost'

//      NoTouchMediumCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'No Touch High Cost'

//      NoTouchHighCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'No Touch Very High Cost'

//      NoTouchVeryHighCostItemValue,

//      

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'Low Touch Low Cost'

//      LowTouchLowCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'Low Touch Medium Cost'

//      LowTouchMediumCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'Low Touch High Cost'

//      LowTouchHighCostItemValue,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'Low Touch Very High Cost'

//      LowTouchVeryHighCostItemValue,

      

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '$projection.NmbrOfPurReqnWithNoTouch / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'No Touch %'
      1                                                                              as NoTouchRatio,

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '( $projection.NmbrOfPurReqnWithNoTouch * 100 ) / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'No Touch Percentage'
      1                                                                              as NoTouchInPct,

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '$projection.NmbrOfPurReqnWithLow / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'Low Touch %'
      1                                                                              as LowTouchRatio,

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '( $projection.NmbrOfPurReqnWithLow * 100 ) / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'Low Touch Percentage'
      1                                                                              as LowTouchInPct,

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '$projection.NmbrOfPurReqnWithHighTouch / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'High Touch %'
      1                                                                              as HighTouchRatio,

      @DefaultAggregation: #FORMULA
      @AnalyticsDetails.query.formula: '( $projection.NmbrOfPurReqnWithHighTouch * 100 ) / $projection.PurchaseRequisitionItemCount '
      @EndUserText.label: 'High Touch Percentage'
      1                                                                              as HighTouchInPct

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

Learn More