Report on Excise Part 2 details

[Former Member]

Hello friends,

I want following report on excise to be extrated from SAP

1.GR No.& date 2.Part II number 3. Excise invoice no. & date 4. Vendor name 5. Duty amount

The details are available in foll tables

J_1IPART2 - all details available except Excise invoice no

J_1IGRXREF - all details available except Part II number.

I am trying write query with these tables. But i am not able to get any common field.

Pls. adivce me on the above issue.

Regards

Venki

[deiva · Accepted solution]

Hai,

1.USe TCode J1I6 - help for internally generated documents.Input the selection parameter ETT & Excise group, with selected dates.Select the radio button Part1 & part2 posted.

2.This will match ur requirement.

[Former Member]

Hi Deivakaniraja ,

Thanks for your reply. It matched my requirement fully.

Regrds

Venki

[Former Member]

Hi,

Look for j1i7 & give the period & excise group

Pandari

[Former Member]

Dear,

Please check J1I7 t-code for your requirement.

Regards,

Mahesh Wagh

[deiva]

Hai,

Sorry use J1I7 instead of J1I6 - Cenvat forecast.

1.USe TCode J1I7 - help for internally generated documents.Input the selection parameter ETT & Excise group, with selected dates.Select the radio button Part1 & part2 posted.

2.This will match ur requirement