SAP ABAP Data Element CEPLREREG (Calculation type in planning using ratios)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE (Package) Profitability Analysis
Basic Data
Data Element CEPLREREG
Short Description Calculation type in planning using ratios  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type CEPLREREG    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
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 Calc. type 
Medium 15 Calc. type 
Long 20 Calculation type 
Heading 5 CType 
Documentation

Definition

Ratios let you simulate price and quantity changes in planning. A ratio is the quotient between two value fields, such as sales revenue divided by quantity.

The calculation type is only relevant for single ratios in manual planning, not for ratio schemes!

Which calculations are carried out (such as price = revenue/quantity, revenue = quantity * price or quantity = revenue/price) when you change one or more of these fields manually depends on a number of factors:

  • which of the fields are in the layout and can be entered manually
  • which fields were changed
  • which calculation type was chosen when you defined the ratio

  1. If you change one of the three fields and the other two either
    • can be entered or
    • cannot be entered or are not even in the layout

      the system cannot decide which of the two fields should be calculated. +n this case the calculation type determines which field should be calculated:

   Value changed manually       Value recalculated 

   Calculation type 1: 
   Revenue Price 
   Quantity                     Revenue 
   Price                        Revenue
   Calculation type 2: 
   Revenue Quantity 
   Quantity                     Revenue 
   Price                        Revenue

  1. If you change one of the fields and only one of the other two fields can be entered manually, the system assumes that it should calculate the field that cannot be entered manually, regardless of which calculation type was chosen.

Example:

Revenue and price can be entered, but not the quantity. When you change the revenue, the system calculates the quantity as revenue divided by the price.

  1. When you change two of the fields, the system calculates the third field.
  2. If you change all three fields, the system calculates sales as
    quantity * price and overwrites the manually entered value.

History
Last changed by/on SAP  19971104 
SAP Release Created in