Skip to Content
avatar image
Former Member

RG1 Problem

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2008 at 06:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2008 at 06:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded