I have to work on this scenario which involves a selection screen where user can enter multiple values for a department. For each department I have to display the different set of data based on the business logic. The same data also needs to be downloaded in different sheets of the same Excel file meaning different tab for each department.
The number of departments will be determined at the run time, therefore the tabs will also be determined during run time.
I think we need to create different internal tables dynamically.
Can anyone Please help me on this?