| Author |
Message
|
| nabin |
 Posted: Sun Apr 11, 2010 8:49 pm Post subject: Problem in SAP QISS.... |
 |
|
Novice
Joined: 11 Mar 2010
Posts: 16
|
Hello ,
I am trying to retrive data from 2 tables in SAP (VBAK and VBUK). Have used QISS to join the tables. But I am not able to retrive data from both the tables at a time. Adapter methods are like I can fetch data from from 1 table at a time. Can u guys pls suggest me how can I fetch data from two tables ..
Thanks In Advance.
Nabin.. |
|
| Back to top |
|
 |
| nabin |
| Posted: Sun Apr 11, 2010 11:18 pm Post subject: |
|
|
Novice
Joined: 11 Mar 2010
Posts: 16
|
It worked. Now m able to fetch data from 2 tables. There was problem in the input XML.
Now I am trying to fetch data from 3 table in SAP. Is it possible using QISS?
B'coz I am trying in the same way as I have dine for 2 tables but m not able to retrive data form all the three tables.
Thanks In Advance
Nabin |
|
| Back to top |
|
|
| Connar |
| Posted: Tue Apr 10, 2012 10:46 pm Post subject: |
|
|
Newbie
Joined: 16 Jan 2012
Posts: 6
Location: Germany
|
I know that this thread is (exactly  ) two years old but I am currently facing the same problem. I want to join two tables using the Query Interface for SAP Software (QISS) but I am not able to get the contents of the joined tables. I have set up the adapter for the two tables and have specified the relationship between them (tried all the different configuration possibilities which came to my mind). However, I can only get the content of one table at a time.
Can anyone tell me, how to configure the SAP adapter to retrieve the joined table columns?
Thanks in advance. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Apr 11, 2012 5:39 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Connar wrote: |
I know that this thread is (exactly ) two years old but I am currently facing the same problem. I want to join two tables using the Query Interface for SAP Software (QISS) but I am not able to get the contents of the joined tables. I have set up the adapter for the two tables and have specified the relationship between them (tried all the different configuration possibilities which came to my mind). However, I can only get the content of one table at a time.
Can anyone tell me, how to configure the SAP adapter to retrieve the joined table columns?
Thanks in advance. |
Before I critique you for posting on an old thread, here is a nice SAP guide that talks about table joins through the query interface:
http://www.sap-press.de/download/dateien/2423/sappress_sap_query_reporting.pdf
First, don't open old threads, especially when they have little to do with your question.
Second, this is a WMB forum not an SAP forum. Your question is related to using SAP not WMB. WMB is a client of SAP and works like any other SAP client. To learn how to perform SAP table joins, go to the SAP forum. Hint: use the key word 'outer', do a sub-select at the db side to get your relevant data, see the following SAP tech notes (Note 48230, Note 652634, Note 634263), and set the rdn flag to enable joins.
| Quote: |
| You might consider reading some books about these topics because using them efficiently assumes that you have a good basic knowledge. Knowledge in a nutshell will not help you to survive in big data volumes or high transaction environments. |
DON'T REOPEN OLD THREADS.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Connar |
| Posted: Wed Apr 11, 2012 6:06 am Post subject: |
|
|
Newbie
Joined: 16 Jan 2012
Posts: 6
Location: Germany
|
I just found a solution for my problem. I had to apply changes to the WMB and not to SAP 
I think this post had a lot in common with my question but I will not reopen any thread again if it bothers you that much.
Anyhow, thanks for the SAP guide which may help me in the future in the case I have a real SAP question  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Apr 11, 2012 6:09 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Connar wrote: |
I just found a solution for my problem. I had to apply changes to the WMB and not to SAP
I think this post had a lot in common with my question but I will not reopen any thread again if it bothers you that much.
Anyhow, thanks for the SAP guide which may help me in the future in the case I have a real SAP question |
Be creative. Write your own thread. State your problem clearly. Tell what you tried and the results. Post logs and source code (in [c o d e ] tags).
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
