Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Function module get tables from view

Former Member
0 Likes
3,481

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?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,546

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

5 REPLIES 5
Read only

RaymondGiuseppi
Active Contributor
0 Likes
1,546

Try to find a FM using table DD26S.

Regards,

Raymond

Read only

Former Member
0 Likes
1,546

se11...display the view....

Read only

0 Likes
1,546

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.

Read only

Former Member
0 Likes
1,547

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

Read only

Former Member
0 Likes
1,546

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.