how to export data in sap to excel?
Save as type EXCEL files, then click Save. Transaction Code, CLICK on the Export icon and Select Local File. In the Save list in file pop up box, Select format Text with Tabs.