Two Dimensional Report - With FTP download and formatting in EXCEL
I have a ztable with customer,daily quantity , date as columns. I need to make a report with date as rows and customer as columns . If a new customer is added in the ztable , one more column should come in the report.
Basically the internal table should change <b>dynamically</b>.
I have to download this report into FTP and should save as .xls file. All formatting that are there in SAP has to appear in the Excel Sheet also.
Is there any function module for Dynamic Internal Tables and make <b>formatting changes in EXCEL</b> ??
Thanks in Advance..