12-09-2019 10:12 AM
I would like to know if there is table which stores all the join tables used by an infoset (used by a query).
Thanks.
12-09-2019 10:32 AM
Do you mean BW infoset or ECC (SQxx)?
For BW, see answer here: https://answers.sap.com/questions/8760947/table-containing-infoset-information.html
12-09-2019 11:15 AM
Hello Victor Apostol,
You can check in the table RSQTOBJ, in case you want to know all the relevant tables try using RSQ* in SE11 and you will find all the tables related to Infoset.
Regards!
12-09-2019 12:12 PM
Thanks for the answer, unfortunately it does not help me.
I checked table RSQTOBJ and also the rest of RSQ* tables, none contain the actual tables from the infoset:
RSQACCMODE
RSQDIM
RSQDIMT
RSQFOBJ
RSQFOBJT
RSQIMPACT
RSQISET
RSQISETLOC
RSQISETT
RSQISETX
RSQONCOND
RSQRDB
RSQTOBJ
RSQTOBJT
RSQWCOND
So now I'm wondering if such table actually exist.
12-09-2019 1:37 PM
12-10-2019 6:54 AM
The details which you are looking for is available in table AQGSBWMAP
Input your infoset name to CLAS and TAB has all the tables used in the infoset.
02-20-2020 7:32 AM
Same question here - is there an transparent table which includes all (SAP ERP) InfoSets (created with SQ02) including the tables & fields used by the InfoSet?
In our system table AQGSBWMAP does only have entries for a small percentage of all InfoSets, many InfoSets are missing in this table. We already found the program RSAQSHSG for the InfoSet description, but we definitely need a transaprent table for further analysis.