on 01-07-2008 7:18 AM
Hi all,
Can you please explain me how to write a query joining tables in SAP ?
Thanks,
Avani.
Hi
Check info from sdn only
User T-code: SQVI
Enter your "query name" and press"create"
Enter title
In Data source " select Table join"
select basis mode and press continue.
Press Insert table and give the tabes one by one.
Drag the parameter and drop in another table to establish link and link all the tables.
Press check to check whether your link is correct, then press back
You will be able to see the tables and fields on left hand side.
Select the appropriate parameters for selection fields and list fields
Selection fields- For selection of data, the initial screen of report.
List fields are nothing but output.
Execute the report.
You will find the initial screen of report.
Give your parameters for output and execute again.
You will receive the desired output.
You can down load the output in spread sheet/ in the format desired.
At last save your query before coming out of transaction
Vishal...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Neetha,
Please search in this forum and if you find difficulty in understanding then post in the forum.
Regards,
Ramesh
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 SQVI and earlier threads for detailed explaination.
use search option in the forum
Thanks
suresh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
10 | |
9 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.