Hierarchy
IS-OIL (Software Component) IS-OIL⤷
IS-OIL-DS (Application Component) Downstream⤷
OI0_COMMON (Package) Common obj. in IS-Oil Downstream
IMG Activity
| ID | SIMG_EURO_ROIHEW20 | ROIHEW20: Adjust excise duty valuation records |
| Transaction Code | S_SO5_65000009 | IMG activity: SIMG_EURO_ROIHEW20 |
| Created on | 19990913 | |
| Customizing Attributes | SIMG_EURO_ROIHEW20 | ROIHEW20: Adjust excise duty valuation records |
| Customizing Activity | SIMG_EURO_ROIHEW20 | ROIHEW20: Adjust excise duty valuation records |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | SIMG_EURO_ROIHEW20 |
Description
Report ROIHEW20 is used to check and correct the excise duty values for all excise duty-paid valuation records. This is done by calculating the excise duty value from the excise duty stock quantity and the current excise duty rate.
The report calculates the excise duty value for an excise duty-paid material within the company code that was entered, by multiplying the excise duty stock quantity with the current excise duty rate from Table OIH01 (Excise Duty Rates table). Any differences between the excise duty value held in the valuation segment of a material and the calculated excise duty value is displayed in the report output.
The report can either be run in test mode, which will list all materials where there is a difference between the two values, or it can be run so that any differences in the excise duty values are automatically reconciled.
Activities
- On the initial screen, enter the company code of the materials that are to be checked/reconciled.
- To run the program in test mode, select the "List ED Valuation Record Diff" field. This will generate a report of any differences, but will not make any adjustments.
- To run the program so that any differences are reconciled, select "Adjust ED Valuation Records".
Further Notes
Check Excise Duty Rates Table (OIH01)
Please check the Excise Duty rates Table for entries that might cause rounding differences during the local currency conversion to euro. You should set up the excise duty rates so that the rounding differences are as small as possible (see the example below).
The excise duty inventory value is converted during local currency conversion. Excise duty rates are also held in local currency and therefore subject to local currency conversion. The ED inventory value and the excise duty rates are converted to euro using the fixed exchange rate.
In the final phase of the conversion, the ED inventory value is comparedwith the excise duty rate * quantity. As a result of rounding amounts to cents, differences can occur. The system takes into account differences that occur during the conversion procedure (see the program documentation for Report ROIHEW22 and ROIHEW32).
Example
Values before the local currency conversion:
Material Test-01
Stock 1,000,000 L15
Excise duty rate 14 DEM / 10 L15
ED inventory value 1,400,000.00 DEM
Fixed exchange rate (EUR -> DEM) 1.95583
------------------------------------------------------------------------
Values after the local currency conversion:
ED inventory value using exchange rate 715,808.63 EUR
Excise duty rate 7.16 EUR / 10 L15
ED inventory value using converted ED Rate 716,000.00 EUR
Rounding difference 191.37 EUR
------------------------------------------------------------------------
To avoid big rounding differences, the ED rates should be set up, for example in the following way (for example: 1400 DEM / 1000 L15).
Values before local currency conversion:
Excise duty rate 1400 DEM / 1000 L15
ED inventory value before conversion 1,400,000.00 DEM
------------------------------------------------------------------------
Values after local currency conversion:
ED inventory value using exchange rate 715,808.63 EUR
Excise duty Rate 715.81 EUR / 1000 L15
ED inventory value using converted ED Rate 715,810.00 EUR
Rounding difference 1.37 EUR
Business Attributes
| ASAP Roadmap ID | 601 | Euro Conversion |
| 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 | SIMG_EURO_ROIHEW20 | 0 | I270009311 | Tariffs, Duties and Permits |
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 |
| IMGDUMMY | D - Dummy object | O4KD | OILEURO002 | Excise Duty Valuation record 1/3 |
History
| Last changed by/on | SAP | 20000221 |
| SAP Release Created in |
