LSMW "Specify Files"

[Former Member]

Hi,

In the LSMW steps, when I am using SPecify Files , I want to set values of 'File Content' , 'Delimiter', 'File Structure',

'File Type','Code Page' along with the Path and Name of a excel file. Can you tell me what will be these values when the

file is an EXCEL file.

Useful answer will be rewarded.

Regards,

Tanmay

[Former Member]

Hi,

In the 5th Step Select <b>'Data for One Source Structure'</b> , below, we have an option for Separator, you need to select the separator which you maintained in the Excle file. An in the file structure(Below Option) select the check box for Field order matches source structure defination

Regards

Sudheer

[Former Member]

hi Tanmay,

First of all one main thing,

Its not possible to upload the excel file in LSMW. you should conver that file into text file then u can upload that file... so at that time you can give all the fields as usual...

~~Guduri

[Former Member]

hi Tanmay,

for uploading data from excel sheet you have to save your excel file in ".csv" format. i.e. "csv-comma delimited" or "text with tab delimited".

FIRST SAVE YOUR EXCEL SHEET WITH ",csv" format

In the step SPECIFY FILES->SELECT LEGACY DATA ON pC->select create button on toll bar->specify path->give name

here only u can specify 'File Content' as data from one structure , 'Delimiter as comma', 'File Structure' as filed order matches source structure definition,

'File Type' as Record end marker(text file),'Code Page' as ASCII.

if useful reward points

[Former Member]

Hi Tanmay,

Plz go through this URL.

www.saptechnical.com

Rgds,

P.Nag

[Former Member]

Solved.

Thanks.

Tanmay