Skip to Content
0
May 02, 2014 at 10:32 AM

RG1 register- J_2iRG1BAL table values plant wise

49 Views

Hi Experts,

I have a requirement in RG1 report, client is not satisfied with the standard sap format, so we are intending to develop a Z-report. the steps which i am following as below:

I have uploaded the J_2iRG1BAL table but requirement is that when i execute J2I6 the balance should be fetched plantwise and same should be updated in report.

I have checked J_2iRG1BAL where we cannot maintain same material on same date.

I have uploaded the opening balance quantity in J_2IRG1BAL table in OP_CF and OP_FINISH column.

I am fetching quantity manufactured, quantity sold, relevant excise duties are from J_1irg1 table

Now the problem is opening balance column is not showing values plantwise , values should get fetched from J_2IRG1BAL table,if i go to that table , opening balance column is maintained.

Please suggest me where exactly to fetch the correct opening balance and closing balance to complete the report

With regards,

Hitesh