Hi, can any one tell me how to export data from SAP to Excel sheet. Plz., It&#

Hi, can any one tell me how to export data from SAP to
Excel sheet. Plz., It's very urgent.

Question Posted / sandip.palit81

4 Answers
15140 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi, can any one tell me how to export data from SAP to Excel sheet. Plz., It's very urgent...

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

Hi, can any one tell me how to export data from SAP to Excel sheet. Plz., It's very urgent...

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

Hi, can any one tell me how to export data from SAP to Excel sheet. Plz., It's very urgent...

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

Hi, can any one tell me how to export data from SAP to Excel sheet. Plz., It's very urgent...

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

Post New Answer

More SAP FI-CO (Financial Accounting & Controlling) Interview Questions

what is documentation in SAP FI? and what is reporting in SAP FI?

0 Answers ETPL,

what is the difference between field status group and field status variant asked at tcs

4 Answers TCS,

How many years we can open at a time in asset a/c?

4 Answers Cap Gemini,

What is open line item management?

0 Answers

What are the procedure for implementing FI Sub Module, like AR, AP, AA etc

0 Answers Accenture,

Explain about asset master?

0 Answers

Is it possible to assign a cost center to a plant? if yes, then how?

1 Answers

what area are you specialized in accounting?

4 Answers ABB,

What are the precautions to be taken while maintaining the 3keh table for profit center accounting?

0 Answers

What is an asset explorer? : fi- asset accounting

0 Answers

What are Business Partner Conversions? How would you perform Business Partner Conversions and why are they necessary? Discuss Business partner conversions on the SAP Treasury side? Explain the scenario in detail?

0 Answers IBM,

I have two companies one is parent company & another sister company. Both companies have same vendors & customers. Can I assign dunning procedure for both comapnies?

4 Answers Accenture,

For more SAP FI-CO (Financial Accounting & Controlling) Interview Questions Click Here