SAP ABAP Data Element SCMTMS_KPI_ID (Key Performance Indicator)
Hierarchy
☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-TMS (Application Component) Transportation Management (no software transports)
     ⤷ RS_BCT_SCM_TM (Package) BW: Content Transportation Management
Basic Data
Data Element SCMTMS_KPI_ID
Short Description Key Performance Indicator  
Data Type
Category of Dictionary Type     Direct Type Entry
Type of Object Referenced     No Information
Domain / Name of Reference Type      
Data Type CHAR   Character String 
Length 4    
Decimal Places 0    
Output Length 4    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 KPI 
Medium 20 KPI 
Long 30 Key Performance Indicator 
Heading 30 Key Performance Indicator 
Documentation

Definition

Specifies a performance parameter that influences the score of a carrier. These scores enable you to analyze the performance of the carriers and determine the carriers that can be used for transportation of goods.

Use

SAP delivers the following key performance indicators in the system:

  • Delay in Delivery and Delay in Pick-Up
    • In Customizing, key performance indicators (KPIs) Delay in Delivery and Delay in Pick-Up are available. You enter a score impact of Negative and a value for these KPIs. The system calculates the score of a carrier for these delays in the following method:

  1. Ignores the deliveries with no delay and with 0-2 hours' delay
  2. Multiples the percentage of deliveries with 2-4 hours' delay by 2
  3. Multiples the percentage of deliveries with 4-10 hours' delay by 4
  4. Multiples the percentage of deliveries with more than 10 hours' delay by 10
  5. Adds these values and multiples it by -1 since you have specified a negative score impact
    6. The system then multiples the result by the value of the KPI to obtain the score.
    For example, in Customizing, you have specified a KPI of Delay in Pick-Up with score impact of Negative and value of 6. A carrier has made the deliveries with the following delays:
  6. 49% deliveries with no delay
  7. 20% deliveries with 0-2 hours delay
  8. 10% deliveries with of 2-4 hours delay
  9. 30% deliveries with 4-10 hours delay
  10. 1% deliveries with 10 hours delay
    11. The system calculates the score using the following formula:
    ((10*2+30*4+1*10)*-1)*6 = -900

  • Invoice Discrepancy
    • In Customizing, the KPI Invoice Discrepancy is available. You enter a score impact of Negative and a value for this KPI. The system calculates the score of a carrier for this discrepancy in the following manner:

  1. Calculates the percentage of difference between the planned cost and actual cost against the actual cost in the invoices
  2. Calculates the percentage of invoices with different planned cost and actual cost against the total number of invoices
  3. Adds the two numbers and multiples it by -1 since you have specified a negative score impact
    4. The system then multiples the result by the value of the KPI to obtain the score.
    For example, in Customizing, you have specified a KPI of Invoice Discrepancy with score impact of Negative and value of 6. A shipper has 50 Invoices from a carrier. The total planned cost in these 50 invoices is EUR 12,000. However, the actual cost is EUR 20,000. Out of 50 invoices, 10 invoices have different planned cost and actual cost. The system calculates the score in the following manner:
  4. Calculates the percentage of difference between the planned cost and actual cost against the actual cost in the invoices as a positive value (((12000-20000)/20000)*100=40)
  5. Calculates the percentage of invoices with different planned cost and actual cost against the total number of invoices ((10/50)*100=20)
  6. Adds the two numbers and multiplies the result by -1 (((20+50)*-1) =-70)
    7. The system then calculates the score by multiplying it with the KPI value (-70*6=-420)

The total score of a carrier is determined by the sum of all the KPI scores analyzed for the carrier. For example, a carrier has a score of -100 for KPI Invoice Discrepancy and -500 for KPI Delay in Pick-Up. The total score for the carrier is -100+ (-500) =-600.

Note that you can also specify KPIs that influence the score of a carrier. You must define logic the system uses to calculate score for a carrier for the KPI you have defined.

Dependencies

Example

History
Last changed by/on SAP  20141031 
SAP Release Created in 7X7