Hi all,
I have created one transaction which is displaying two table contols in the screen.there are two i/o field also in the same screen, where users can input the name of tables (say MARA & MARC) now on hitting enter, both table control will be populated by respective fieldnames of the tables.
Now if the user select some fields from both table control, and if any common field is there in the selection ( MARA-matnr, MARC-matnr), and click a button (say next) can we create & execute one dynamic sql query , having join on this fields. Please note the table name, and selection of fields for join is dynamic.