Hierarchy
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIC (Package) MAP Marketing, Accounting and Pricing
Basic Data
Data Element | OIC_RNDTERM |
Short Description | Rule for rounding formula term value |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | OIC_EXIT | |
Data Type | NUMC | Character string with only digits |
Length | 3 | |
Decimal Places | 0 | |
Output Length | 3 | |
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 | Rnd. rule |
Medium | 15 | Rounding rule |
Long | 20 | Term rounding rule |
Heading | 5 | Rule |
Documentation
Definition
This field controls the way in which the results of the formula term evaluation are rounded.
The rounding is performed using user exit routines. Certain user exit routines are delivered which round the input value to a certain number of decimals or tens.
Further methods that can be used for rounding are defined in Customizing for Industry Solution Oil & Gas (Downstream) under the following menu path:
MAP (Marketing, Accounting and Pricing) -> Formula & Average Pricing -> Maintain formula & average pricing user exits -> Formula evaluation -> Formula rounding
The following section describes at what step of the evaluation the rounding occurs for the two possible calculation modes (Step 2 for value-based calculation and step 3 for rate-based calculation). Depending on the calculation mode, different results are rounded:
Calculation steps for value-based calculation:
- The formula term value is calculated by adding up all item values belonging to that term.
- The calculated formula term value (result of step 1) is rounded.
Calculation steps for rate-based calculation:
- The term rate (specified in [ cuky_t / (prun_t * uom_t ) ] ) of a formula term is calculated by adding up all item rates belonging to that term. Each item rate is specified in the combination cuky_f / prun_f / uom_f .
The combination cuky_t / prun_t / uom_t is always identical with the combination of the formula rate (cuky_f / prun_f / uom_f ). - The formula term rate (specified in [ cuky_f / (prun_f * uom_f) ] ) is rounded.
Terminology for 'decimals' and 'tens'
Assume you have a field with the value 123.456 .
- The digits after the decimal sign (4, 5 and 6) are called decimals.
- The digits before the decimal sign (1,2 and 3) are called tens.
Example
Calculation mode is value based:
- A formula term value of 123.45 USD is rounded to 123.50 USD, if the user exit routine "ROUNDING with 1 Dec" is selected.
- A formula term value of 123.45 USD is rounded to 120.00 USD, if the user exit routine "ROUNDING to 1. Tens" is selected.
Note: For value-based calculation, the number of decimals of the field that is rounded depends on the number of decimals the corresponding currency has (2 decimals in this example for USD).
Calculation mode is rate based:
- A formula term rate of 123.45678901234567 USD / 1 TO is rounded to 123.45680000000000 USD / 1 TO, if user exit routine "ROUNDING with 4 Dec" is selected.
- A formula term rate of 123.45678901234567 USD / 1 TO is rounded to 120.00000000000000 USD / 1 TO, if user exit routine "ROUNDING to 1. Tens " is selected.
Note: For rate-based calculation the fields used internally always have 14 decimals.
Procedure
Enter a user exit routine number or select one from the list.
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in |