I have developed an ALV Report in which,
1) I select data using select * from one table into internal table which is defined as TYPE STANDARD TABLE OF database table.
2) Build the field catalog using 'LVC_FIELDCATALOG_MERGE' and using the DB table as a structure.
3) Display grid using CALL METHOD g_grid->set_table_for_first_display.
Now there is some change in the requirement such that, I need to add few fields from other table into the layout. This new table is related to the existing table.
So please advice me,
1) How can I use inner join? Whether can I use select * from one table and select few fields from other table in inner join ?
Thanks and regards,