Hi, can any one tell me how to export data from SAP to
Excel sheet. Plz., It's very urgent.
Answers were Sorted based on User's Feedback
Answer / kesdec21
There are two option to export SAP data to Excel Sheet.
a) LIST > Export >Spreadsheet or Local File....
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rahman
FOR THIS U USE COMMA(,)SEPARATOR OR TAB SEPARATOR IN NOTE PAD
EX: VENDOR,COMPANY CODE,A/CGROUP, LIKE THIS
use the LSMW method , u can br0wse about this thing ( lsmw)
step: capture the field technical names
xk01:
vendor: LAFNK
COMPANY:BUKRS
ACCOUNT GROUP= KTOKK
TITLE= TITILE_MEDI
TOMARROW I WILL GIVE INDETAIL
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kishore
in you running program one menu bar is there. In that menu
u will find out the options of the html document, spread
sheet(ms-Excel sheet), and word document. u will click that
one then immediately it can be converted. It can be called
as a reports also ok.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rakeshkumar byagoti
Go to LIST then EXPORT then select Local file in dropdawn u
select spreadsheet then select excel format finally save it
in "file.xls" format.
| Is This Answer Correct ? | 1 Yes | 1 No |
While defining chart of account, there is field "manual creation of cost element" and "automatic creation of cost element", what is it?
In - Order to cash process like Sales order,Delivery,Billing,Payment - In COPA at what point of OTC the entry is updated in COPA & what was that entry
what are the segment of gl master record ?
Explain open sql vs native sql?
Please provide me information why, how often and which accounts are included in the clearing job. What is the logic of the clearings?
I am not able to post W/H tax entry in F-43, though I have performed all the steps for W/H tax configuration? The pop up window for W/H tax is not showing, and in FB60 too the W/H tax,base amount entry, is suppressed.Pls help with the problem Note: The Comp. Code for which W/H tax has been configured is set up on a newly loaded SAP software.
What is the examples of Value fields?
What are the documents require for Born in sale in relation to sales tax?
What business process implementation you did on GL?
what is as-is and to-be document and how prepared the to-be document
after entering (transation data) in the company code if our clint want to change the company code what is the procedure to change..
what do you mean by the reversal posting?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)