RG1 Problem

[Former Member]

Hi experts,

While extracting RG1 the following problem has been faced:

Assessable value and BED rate is not appearing

2) For the materials which do not have any transactions during a particular month does not appear in the RG1 for that month, though we have closing balances for those materials

3) After downloading the RG1 for the month of May, closing balance was not coming properly though production & removal qty are correct. For some enteries system is not deducting the removal qty from the closing balance and copying the same closing balance as opening balance for next line, so it is creating difference in final closing balance.

can anyone advise

[Former Member · Accepted solution]

For assessable value and BED rate please check if the table J_1irg1 is updated with the base value. Unless the base value is updated BED rate cannot be calculated. This would be because of no bASB value in the table J_1iexcdtl.

Please note that the excis ebase value will become zero IF the outgoing

excise invoice which is referred during GR is not updated with the

EXBAS after J1IIN.

Please check the excise detail table (J_1iexcdtl) in the field EXBAS

to see if there is any value for the ETT DLFC posted through J1IIN.

Can you please go through the SAP note mentioned below and apply.

1042035

1035545

1003634

If you mark the Condition category as 'H' for the Price condition

which has the assesable value then the Excise base value will flow but

the price condition should be non statistical, if it is statistical in

your pricing procedure then you will have use the user exit

J_1I7_USEREXIT_CALC_EXC_BASE which has the KONV structure , you will

have to pass the value to the parameter EXCITM_BASE.

The notes given will be of use for the future transactions. Ensure that

you have given some logic in the user exit to allow the system to copy

the base value to the excise detail table.

This will not however work for the older Excise invoices which have

already been saved without the excise base value. You will have to write

a small Z program to fill this detail in the excise invoices.

[Former Member]

Sorry for the second issue, system will not bring the balance of those material for which there is no updation in the period you are extracting. The data is extracted from Rg1 table for the period you give in the transaction J2I5, if there is no transaction for a particular material then the data is not updated in this table and hence it will not be fetched in the register either.