on 12-11-2009 9:41 AM
Dear Experts,
Report with the details of sales including material, qty, billing number, excise invoice no, date of invoice, base value, excise duty, cess, vat. is there any standard report like this , pls help me out
Thanks
Basavaraj
Create SAP Query:SQVI by using Table join option ,
Join the tables: J_1IEXCHDR & J_1IEXCDTL .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go to SQVI and do the following:
1) Give some description in "Quickview"
2) Click "Create" button
3) Give some description in "Title"
4) From the tab "Data Source", select "Table Join" and click blue tick
5) Press "Shift + F1"
6) Give the table you wanted and press enter
7) Again Press "Shift + F1"
😎 Again give the table you wanted and press enter
9) Press F3
10) On your left screen you can see those two tables with header "List fields" and "Selection Field"
11) Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field
thanks
G. Lakshmipathi
Have you checked j1i7 ??
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check t-code J1ILN...Indirect Taxes -Reports ..
Reg,
JJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use Tables VBRK & J_1IEXCHDR.
Best Regards,
Ankur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.