topic Re: UPLOADING DATA THROUGH LSMW in Application Development and Automation Discussions

UPLOADING DATA THROUGH LSMW

Former Member — Thu, 30 Jul 2009 07:15:46 GMT

Hello Experts,

in "Maintain Field Mapping and Conversion Rules" menu of the LSMW, i want to MAP the my own created SOURCE STRUCTURE WITH A TABLE STRUCTURE....

SOurce structure that i have defined have exactly same number of fields as in the table...But in the "Maintain Field Mapping and Conversion Rules" steps, i am not getting source fields(fields that i have defined under the source structure is not displayed) ...so i can't map those fields with my table fields...

could you please tell me , how can get those fields so that i can map those fields with the table fields??

i have also created a table maintenance generator & using transaction SM 30... but i am getting an warning "CAUTION : THE TABLE IS CROSS-CLIENT"...Why it is so?? what does that mean????

Please Help...

Re: UPLOADING DATA THROUGH LSMW

RaymondGiuseppi — Thu, 30 Jul 2009 07:20:49 GMT

Your database table as no client (MANDT) field in the key list, so the warning is issued. (this is a "workbench" table, not master data or transaction data)

Between "Maintain source structures" and "Maintain field mapping and conversion rules" steps you must perform "Maintain source fields" and "Maintain structure relations" steps (Look at [Legacy System Migration Workbench|http://help.sap.com/saphelp_nw70/helpdata/en/ad/2d54a41d7011d2b42e006094b944c8/frameset.htm])

Regards,

Raymond

Re: UPLOADING DATA THROUGH LSMW

Former Member — Thu, 30 Jul 2009 07:31:11 GMT

Hi,

Are you making use of recording of SM30 to upload your data in your Z table?

When you create and save the recording in the LSMW; click the button default all.

After that you will be able to map your source structure fields with your target structure fields in the field mapping step.

The warning your are getting because your table does not have MANDT field,.

You have made a client independent table and that is the reason why you get the message.

Regards,

Ankur Parab

Edited by: Ankur Parab on Jul 30, 2009 1:01 PM

Re: UPLOADING DATA THROUGH LSMW

Former Member — Thu, 30 Jul 2009 07:37:38 GMT

Thanks A Lot..Ankur...

I have been wasting my time regarding this thing for last 2-3 hrs...I have searched several LSMW documents, it was not written in any of them...

Thanks again...

Anupam..

Edited by: Anupam_TCS on Jul 30, 2009 9:37 AM

Edited by: Anupam_TCS on Jul 30, 2009 9:38 AM