RG1 Report

[Former Member]

Dear Experts,

  I have updated RG1 in J1I5 for RMA and IDH classification.Opening and closing balance quantity for one material is not updating in RG1 register after extraction in J2I6.

  That material is created in January.Please let me know why the Opening and closing quantity are not updating in RG1 registar?

   There is no entries in J_2IRG1BAL for that material.Entires are updated in J_1IRG1 table.

Regards,

Narendra

[Former Member]

We have applied this note to correct the same - 1673612.

Please check the availability of the note in your version.

Please make sure you have maintained the Chapter ID of all the materials and all relevant J1ID settings.

And, yes you have to make direct entry to Table.

[Former Member]

There is two way to update opening & closing balance for new material.

1) Whenever New material is created you need to upload opening balances as 0 in J_2IRG1BAL table with MATFORM as 'P'.

2) Or you can update MATFORM field in J_1IRG1 table as 'P'. Then again do extract (J2i6). Opening Closing balance will come. Next time there is no need to update MATFORM for the same material.

[Former Member]

Thanks for reply.

I don't have access to update directly in the table.

Let me know is there any another method to update the RG1 register by using any masters?

Regards,

Narendra

[Former Member]

You can use below given code to update MATFORM as 'P' in table J_1IRG1. After updating you can extract with j2i6, balance will be updated.

*&---------------------------------------------------------------------*

REPORT  ZMM_J_1IRG1_UPD.

TABLES:J_1IRG1.

PARAMETER :

           P_EXGRP LIKE J_1IRG1-EXGRP OBLIGATORY,

           P_SYEAR LIKE J_1IRG1-SYEAR OBLIGATORY,

           P_MATFM LIKE J_1IRG1-MATFORM OBLIGATORY.

DATA:WA_J_1IRG1 TYPE J_1IRG1,

     IT_J_1IRG1 TYPE  STANDARD TABLE OF J_1IRG1 INITIAL SIZE 0.

SELECT  * FROM J_1IRG1 INTO TABLE IT_J_1IRG1

           WHERE SYEAR = P_SYEAR

            AND EXGRP = P_EXGRP.

IF IT_J_1IRG1[] IS INITIAL.

  MESSAGE 'No Records Found' TYPE 'E'.

ENDIF.

LOOP AT IT_J_1IRG1 INTO WA_J_1IRG1.

  WA_J_1IRG1-MATFORM = P_MATFM.

  MODIFY IT_J_1IRG1 FROM WA_J_1IRG1 TRANSPORTING MATFORM.

  CLEAR: WA_J_1IRG1.

ENDLOOP.

UPDATE J_1IRG1 FROM TABLE IT_J_1IRG1.

IF SY-SUBRC EQ 0.

  MESSAGE 'Updated successfully' TYPE 'S'.

ENDIF.

[Former Member]

Hi Sanjeev,

  Thanks for u r reply.

  Why the mat form field is not updated for 1 particular material?Is there any problem with masters?

  Please suggest

Regards,

Narendra

[Former Member]

Dear Narendra,

Whenever New material is created we need to upload opening balances as 0 in J_2IRG1BALtable with MATFORM as 'P', otherwise if you will update with J1i5 system will update J1IRG1 table with blank MatForm.

Regards,

Sanjeev