topic Re: LSMW in Application Development and Automation Discussions

LSMW

Former Member — Fri, 13 Oct 2006 08:55:51 GMT

HI Experts,

when i am going to excute read data step in lsmw

i am getting error as file "c:/asd.txt" and source structure structmm01 have no fields with the same name

here i am taking flat file (text file) that contains fields and data

matnr-200-100

mtart-halt

mbrsh-c

matkl-001

meins-st

please clarify my doubt

Thanks,

Divya sree

Re: LSMW

Former Member — Fri, 13 Oct 2006 09:01:24 GMT

Hi,

When you define the file path in the Specify Files option make sure that you have not clicked the option 'Field Names at the Start of File

If you remove this option then it will work fine.Suppose you do need the field names make sure that the names at the beginning of the file is the same as the field names specified in the Source Structure.

Re: LSMW

Former Member — Fri, 13 Oct 2006 09:36:20 GMT

i am giving flat file contents as follows

900-100,roh,m,001,st

still i am getting error as conversion errro bmmh1-meins content st,

no description transferred

plz clarify

Thanks,

Divya sree

Re: LSMW

Former Member — Fri, 13 Oct 2006 09:51:12 GMT

I am not quite sure wat is ur scenario. But may be one of the reason is the field length would not be maintained in the flat file. I mean to say if material no lenth is 13 digits and in ur flat file ur having mat no as 1245, then u have to append 9 blank spaces in this case. In simple what ever data u r having, if it is not upto length, then put remaining spaces to the right.

Shane

Re: LSMW

Former Member — Fri, 13 Oct 2006 10:48:15 GMT

HI,

Still i am getting same error

Re: LSMW

Former Member — Fri, 13 Oct 2006 18:53:55 GMT

What about trying to use EA instead of ST ?

Re: LSMW

Former Member — Fri, 13 Oct 2006 23:35:32 GMT

Divya,

1. Make sure the fields in the structure of the lsmw is same as the flat file structure.

2. refer the size of the fields in flat file and lsmw structure, it should be same.

3. Do you want to upload materials ?? Which method are you using ..BDC,idoc ?? if you are uploading the material data in the file is not enough.

REgards

vivek

reward points for all the helpful answers

Re: LSMW

Former Member — Sun, 15 Oct 2006 07:15:48 GMT

Hi Divya,

This is probaly due to incorrect flat file contents.

Preapre your flat file data in this way.

1)Copy your flat file data into MS Excel.(Note : Each cell holds only one data field, i.e.. 200-100 ).

2)Save as ( Text tab delimited).

In your LSMW Specify file section.

Select the following.

Sepearators

Tabulator

File Structure

Field Order matches source strcu defn.

Code page

ASCII

Regards,

AS

Re: LSMW

shishupalreddy — Mon, 16 Oct 2006 11:01:12 GMT

Hi Divya,

Asper your flat file structre when you are selectiong the option for reading the file in LSMW

Better choose COMMA DELIMITER instead of TAB delimitor

It will work fine