06-13-2013 2:58 PM
Good day experts,
I have recently discovered Quickviewer and am having some problems extracting information;
On joining tables KONP and A620 I get a "No data was selected error". I have tried adding other tables with no avail, I have no authorizations issues, and on checking the tables individually there are no issues.
Any suggestions?
Regards,
Darren.
06-13-2013 3:36 PM
Hi Darren
I am able to Join these in SQVI as,
Advice - Please check in your Select Query that you have joined these on the same basis. If it is correct then check whether any corresponding data exists in SE16 in both tables.
BR,
Ankit.
Message was edited by: Ankit Maskara
06-13-2013 3:36 PM
Hi Darren
I am able to Join these in SQVI as,
Advice - Please check in your Select Query that you have joined these on the same basis. If it is correct then check whether any corresponding data exists in SE16 in both tables.
BR,
Ankit.
Message was edited by: Ankit Maskara
06-14-2013 7:31 AM
Brilliant! It worked, thank you Ankit!
Could you give me a bit of background as to why the table joins had not worked originally, or direct me to a document that can explain this process to me?
Regards,
Darren
06-14-2013 11:44 AM
Hi Darren,
Your Join conditions would not have been same as the ones shown above so your query was not working or maybe table T620 was not available in your system.
SQVI usage can be seen here - http://scn.sap.com/docs/DOC-27049
BR,
Ankit.
06-13-2013 3:39 PM