Application Development 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: 

LSMW Source and Field Mapping

Former Member
0 Kudos
2,154

Hi,

I'm trying to use the LSMW. What is the fastest way to maintain the source field and relationship?? Is it possible to define the source field and length in a text file and load it in the LSMW??

Regards,

Kit

1 ACCEPTED SOLUTION

ak_upadhyay
Contributor
0 Kudos
829

Hi,

Maintain field mapping and conversion rules

--> Keep your cursor on ‘TCODE’ field and click on ‘Insert Rule’ icon

-->Choose radio button ‘Constant’ to enter value ‘XD02’ transaction code.

> Keep your cursor on field ‘KUNNR’ and click on ‘Assign source field’ icon

-->Choose source field ‘Customer’ from source structure ‘XD02S’.

-->Similarly, choose source fields for Sales Organization, Distribution Channel, and Division.

--> Scroll down to structure BKNVV fields and assign source fields to three fields Sales Office, Sales Group, and Customer Group

-->Save and go back to main screen

Reward points if useful....

Regards

AK

4 REPLIES 4

Former Member
0 Kudos
829

Hi Kit,

u can create source fields in faster way.

menupath

In the 3rd step i.e., Maintain source fields

source fields -> table maintenance

here u can fill all the fields at a time.

u can also maintain the fields in a file and copy and paste them in the Table maintenance .

In 5th step i.e., Maintain Field Mapping and Conversion Rules

Extras -> Auto field Mapping

Now u get the auto field mapping setting pop-up.

click ok.

Now u Get the auto field mapping proposel pop-up.

Here check Target field and Source field and click on Accept proposel push button for all the fields.

with this the source and target field mapping are done automatically.

reward if helpfull

raam

ak_upadhyay
Contributor
0 Kudos
830

Hi,

Maintain field mapping and conversion rules

--> Keep your cursor on ‘TCODE’ field and click on ‘Insert Rule’ icon

-->Choose radio button ‘Constant’ to enter value ‘XD02’ transaction code.

> Keep your cursor on field ‘KUNNR’ and click on ‘Assign source field’ icon

-->Choose source field ‘Customer’ from source structure ‘XD02S’.

-->Similarly, choose source fields for Sales Organization, Distribution Channel, and Division.

--> Scroll down to structure BKNVV fields and assign source fields to three fields Sales Office, Sales Group, and Customer Group

-->Save and go back to main screen

Reward points if useful....

Regards

AK

Former Member
0 Kudos
829

Hi All,

Thanks for the helpful and immediate reply, but when i execute the "specify file" step in LSMW, after giving the file name(c:\as91.txt) with tab delimeted, am getting an error as FILE NAME 'CONVERTED DATA:'MAX.45 CHARS.REMAINING DATA SAVED.Please advise on how to proceed.?

Thanks n Regards,

Indu.

Former Member
0 Kudos
829

Hi All,

Thanks for the helpful and immediate reply, but when i execute the "specify file" step in LSMW, after giving the file name(c:\as91.txt) with tab delimeted, am getting an error as FILE NAME 'CONVERTED DATA:'MAX.45 CHARS.REMAINING DATA SAVED.Please advise on how to proceed.?

Thanks n Regards,

Indu.