RG1 Register-Value is not Appearing

[Former Member]

Dear All,

when I extract RG1 & takes print. All data is coming right. But in the following column

*On Payment of duty *

Quantity Value

100 0

Value is coming zero. This value is selling price or std. cost value.

Kindly help me on this issue.

Best Regards

Sainath

[Former Member · Accepted solution]

Hi

Check whether the table J_1IEXCHDTL (EXCISE DETAIL TABLE) is updated with EXBAS (excise base value) for excise invoice is created. If EXBAS field is not updated with excise base value then system will not

bring the Base value and duty values in the RG1 register.

In order to update the base value you have to set the PR00 condtion category as "H' then create a fresh test

cycle and update RG1 you will be able see the base value and duty values..

For already created excise document system will not update the exbas value though you have set the condition category for PR00 as H. You have to manually update it.

Regards

MBS

[Former Member]

Hi Sainath

Value is not appearing in the register is bcos J_1IEXCHDTL - EXBAS is not updatd when you created excise invoice.

In case of if you have UTXJ condition type which has excise base value , than base value will get updated from UTXJ.

If it is TAXINN, than it will look for the condition type based Condition class - (KONV-KOAID) as B and Condition category (KONV-KNTYP) as G or H.

If the above conditions failed then it will update only zero to the excise base in J_1IEXCHDTL - EXBAS.

Above logic you can find in the program MJ1IINF01 (Somewer around 250th line).

In case if you want add your own logic for getting excise base you can use a function module J_1I7_USEREXIT_CALC_EXC_BASE. For more information refer SAP Note number 1003634.

Regards

Mani