Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel file upload using LSMW

Former Member
0 Likes
4,002

HI all,

Is it possible to upload excel file using LSMW method?

If it is? Plz tell me the process ASAP.

Thanks & regards,

Srini

1 ACCEPTED SOLUTION
Read only

manthanraja
Active Participant
0 Likes
2,372

you can save the excel file as CSV or text and upload ..

8 REPLIES 8
Read only

Former Member
0 Likes
2,372

hi

in ms-excel save xls file as text (tab separated)

in sap-lsmw step 7 (specify file) set tabulator as seperator

regards,darek

Read only

0 Likes
2,372

HI,

Is it possible to upload excel file directlly in LSMW?

Thanks,

Srini

Read only

0 Likes
2,372

no...

Read only

manthanraja
Active Participant
0 Likes
2,373

you can save the excel file as CSV or text and upload ..

Read only

0 Likes
2,372

HI,

Is it possible to upload excel file directlly in LSMW?

Thanks,

Srini

Read only

0 Likes
2,372

no

Read only

StMou
Active Participant
0 Likes
2,372

Hi,

It's no possible to upload directly Excel file in LSMW.

You must transform to an flat File.

There are 6 delimiters

- No Separator

- Tabulator

- Semi-Colon

- Comma

- Blanks

- Others

Rgds

Read only

Former Member
0 Likes
2,372

You can use tr. CG3Z upload to system file. After, AL11 look up your file

Otherwise, CG3Y download a file from system file.

Regards.