RG1

[Former Member]

Hi,

Can anybody pls tell me when we ned to update , extract n

[Former Member · Accepted solution]

Hi,

Whenever client sell to customers, The RG1 get to be updated.So for that we can update& extract the Registers.In general this list to be submitted in every month.

Regards

Rm

[Former Member]

Hello Rahul,

RG1 is used for finished goods. For every incoming & outgoing of finished goods, you have to update the RG1 register.

Incoming:

Finished goods received from Production to finished goods storage location/initial stock upload/any other incoming of finished goods.

Outgoing:

When PGI is done & excise invoice created then RG1 is updated.

Process:

You can update the RG1 register daily/weekly/monthly.

1. Always update the incoming entries first.

2. Then after incoming entries are updated, then update the outgoing entries.

Transaction codes:

J1I5 - Update of registers RG1 & RG23 (Part I)

Enter the company (company code)

Plant

Excise group

Posting Date

Movement type

Classification

Select the proper register (RG1)

"Classification"

for incoming entries for finished goods use RMA/ROP

for outgoing entries for finished goods use IDH/IDE/IWE/IWT/IWO.

Then execute - select the specific line which you want to update & click on "simulate". The system will show the green light against the line item. Then select the line item & click on "register entry". This will update the incoming movement of the finished goods.

Similarly do this for the outgoing movement by selecting the appropriate movement type & classification.

J2I5 - Excise registers extraction

Select the excise group

start date

end date

click on "select any register"

click on RG1 & execute

The system will pop up a message window showing RG1 & the sign shpwn should be a green tick mark. Then only the RG1 gets updated. Then click on the green tick mark below.

This completes your RG1 register extraction

J2I6 - Print Excise registers

Select RG1 & execute

Now select the excise group

start date

end date

You can select the print option also whether you want the print in Excel spreadsheet form or directly in the form of SAP Script.

Reward points if solution helps.

With best regards,

Allabaqsh G. Patil.

[Lakshmipathi]

Dear Rahul

Once you generate billing document, RG1 register will get updated and via J1I5, you can extract the datas.

thanks

G. Lakshmipathi