How to determine the tables behind a standard BW object
I have seen a lot of posts asking for standard tables behind BW objects. I hope to clarify this with this blog. Actually an object is transported between two BW system by transporting the table entries of standard table associated with the object. Let me show you how to see the standard table behind a DSO.
1) Collect any DSO in a transport request
2) Double click on the TR to get the below screen
3) Double click on the line corresponding to the DSO or Right click on the line and press display . You will get the list of tables associated with DSO.
Thus you can get all the tables associated with the DSO. You can see the description of the table in SE11 to know what is stored in these tables and find the table you are looking for.
You can see all the tables associated with any BW object (Cube,infoobject, Multiprovider, transformation etc) by following the above technique.