Question:
Can an already created R3 query be accessed through RSA3? (on the R3 side)
If not, how to access and utilize the query to create a DataSource?
Answer:
do you mean you want to use an already created query (abap query, abap report, or others) to create a datasource that will feed BW ?
Try using RSO2 to create a generic datasource, based on an infoset (layer in SQ02) and attach you report to this infoset as a data retrieval program
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Is there a way to directly see the R3 query while in in RSA3 on R3?
Answer:
No.
for bw, we don't actually use the query itself, we use the layer that the query is based on;
transaction is SQ02
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
How is SQ02 used?
Answer:
SQ02 is the basis for which you run queries against.
Simplified, SQ02 behaves like MS Access. In that you can select tables from R/3 (like connecting access to select linked tables from a datasource) and it will also bring up the relationships (key constraints) between the tables, or depending on what they are you (I think) can define your own.
A step further from that, you can then define what fields are or are not available from those tables. Once you have defined an InfoSet (or rather an InfoSet Catalog) you can then create queries against it.
You don't create a datasource from a query, but rather from this catalog. Mostly because with the datasource against this, you can limit the data you bring across by limiting it via selections in your infopackage.
One thing to remember is that you must create the catalog in the "global" area , and not "standard" as you cannot create a ds against a catalog created as standard.
This is just based upon my knowledge of having to use it in regards to DS. I am sure someone could provide more or better detail.
- Stephen
Answer:
Awesome!