‎2010 Oct 20 3:48 PM
Hello,
I am looking for a function module or something alike where I can find the tables used in a specific view.
I know how to get the data from the view, but I only want the table names.
Can anyone help?
‎2010 Oct 20 4:15 PM
Hi,
Please try with the Function Module "VIEW_GET_TABLES" by passing the name of the View to the Importing Paramater "VIEWNAME" and tables parameter "VIEW_TABLES" will list the tables used in the VIEW.
Regards,
Srinivas
‎2010 Oct 20 3:59 PM
‎2010 Oct 20 4:07 PM
‎2010 Oct 20 4:15 PM
I know that one, but I need it while running a program. I don't know exactly which view I will need at running time so se11 will not be helpful for me.
‎2010 Oct 20 4:15 PM
Hi,
Please try with the Function Module "VIEW_GET_TABLES" by passing the name of the View to the Importing Paramater "VIEWNAME" and tables parameter "VIEW_TABLES" will list the tables used in the VIEW.
Regards,
Srinivas
‎2010 Oct 20 4:17 PM
Hi,
DB table DD26S holds the data for VIEWS and TABLE Relationship,
Can use DD26S table itself.
Even you can create new FM using this table.
Thanks,
Anmol.