SAP ABAP IMG Activity RSBCTSDPR_LOOKUP (Score Lookup Table)
Hierarchy
BI_CONT (Software Component) Business Intelligence Content
   BW-BCT-SPL-SDR (Application Component) Supplier Delivery Performance Rating
     RS_BCT_SPL_SDPR (Package) BW: Content Logistics - Supplier Delivery Performance Rating
IMG Activity
ID RSBCTSDPR_LOOKUP Score Lookup Table  
Transaction Code S_B52_73000007   (empty) 
Created on 20031120    
Customizing Attributes RSBCTSDPR_LOOKUP   Score Lookup Table 
Customizing Activity RSBCTSDPR_LOOKUP   Score Lookup Table 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name RSBCTSDPR_LOOKUP    

Use

Some metrics make use of a lookup to convert a calculated percentage to a score value. In this activity, you specify the mappings from percentages to score values for metrics that make use of such a lookup.

To find out which metrics use a score value lookup, you can check the setting of field Score Lookup Mode for the metric in IMG activity Definition of Metric ID's.

In general, you always specify the mapping of an interval of percentage values to a score value. Dependent on the setting of the Score Lookup Mode of the metric, you either specify the lower boundary or the upper boundary of the interval. The related other end of the interval is defined by another entry in this table.

Requirements

You can only define mappings for metrics that have been defined with the IMG activity Definition of Metric ID's previously.

Standard settings

Activities

For every metric that uses a lookup to convert a percentage to a score value, a mapping has to be defined. In this activity, you specify such a mapping by a couple of table entries. You need to make sure that the entire interval for percentages that ranges from 0 to 100 is covered by the mapping.

A single table entry defines a mapping for a single percentage interval for a particular metric to a single score value:

  1. You specify the combination of delivery type and metric for which you want to define this interval mapping. Please note that it only make sense to use combinations that are listed in the IMG activity Valid Combinations of Metrics and Delivery Types.
  2. You specify the boundary of the interval. Whether this boundary is a lower boundary or an upper boundary depends on the setting of the Score Lookup Mode for the metric.
  3. You assign a score point value for this interval. It can be any positive number including 0.

If you create, change, or delete entries in this table, all these changes will affect metric calculations that are performed after the changes have been saved, but not those metric scores that already have been calculated.

Example

Here is how the entries defined in this IMG activity are used to lookup a score value:

  • If the Score Lookup Mode for the metric is set to lower bound:
    For a given metric M and a percentage P, the lookup procedure searches for an entry with the same metric M and the greatest lower boundary LB with LB < P, and returns the score points of this entry.
  • If the Score Lookup Mode for the metric is upper bound:
    For a given metric M and a percentage P, the lookup procedure searches for an entry R with the same metric M and the smallest upper boundary UB with UB > = P, and returns the score points of this entry.

Business Attributes
ASAP Roadmap ID 207   Establish Reporting 
Mandatory / Optional 1   Mandatory activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG RSBCTSDPR_LOOKUP 0 ARS0000023 Business Content and Extractors 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
RSBCTSDPR_LOOKUP S - Table (with text table) SM30  
History
Last changed by/on SAP  20031120 
SAP Release Created in 351