Report on Excise Part 2 details
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.