topic Re: Excel file upload using LSMW in Application Development and Automation Discussions

Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 07:26:41 GMT

HI all,

Is it possible to upload excel file using LSMW method?

If it is? Plz tell me the process ASAP.

Thanks & regards,

Srini

Re: Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 07:31:13 GMT

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

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

regards,darek

Re: Excel file upload using LSMW

manthanraja — Thu, 25 Feb 2010 07:31:17 GMT

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

Re: Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 07:42:21 GMT

HI,

Is it possible to upload excel file directlly in LSMW?

Thanks,

Srini

Re: Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 07:42:39 GMT

HI,

Is it possible to upload excel file directlly in LSMW?

Thanks,

Srini

Re: Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 07:44:49 GMT

no...

Re: Excel file upload using LSMW

manthanraja — Thu, 25 Feb 2010 07:50:53 GMT

Re: Excel file upload using LSMW

StMou — Thu, 25 Feb 2010 10:16:42 GMT

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

Re: Excel file upload using LSMW

Former Member — Thu, 25 Feb 2010 10:49:05 GMT

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

Otherwise, CG3Y download a file from system file.

Regards.