LSMW Direct Input Custom Program

[Former Member]

Hi All,

I have been trying to set up a custom (Z Program) for direct input method for LSMW. So far I have dicovered that it can be achieved by modifing SXDA0-3 tables.

Has anyone achieved this successfully? Any example (even the simplest one) or step by step help would be highly appreciated.

Regards,

~Mark

[RichHeilman]

Hi Mark, first, are you trying to develop a custom program to update custom tables via LSMW, or are you trying to develop a custom program to update standard SAP tables.

The latter may not be a good idea.

Regards,

Rich Heilman

[Former Member]

Hi Rich,

I am trying to develop a custom program to update standard SAP tables. I want to discover how the mapping works in Direct input methods in LSMW and I want to explore the possibility of writing a custom one.

I understand that it is not recommended by SAP but I still want to explore it.

May be just a simple program to upload an Org Unit etc..

Any help would be appreciated!

Regards,

~Mark

[RichHeilman]

The mapping would work simular if you were to use any of the methods, DI, BI, BAPI, IDOC, or even a recording, a structure is used as your input structure and a structure is used in the methods above. You simply tell the system that this field goes here or there.

Regards,

Rich Heilman

[Former Member]

Thanks Rich,

I will give it a try. I believe the target structures are declared in the SXDA2 table?

Is there any documentation that describes the steps involved in this whole process?

Regards,

~Mark

[RichHeilman]

Yes, it does appear that this table contains the data which gives the structures names of the structures used in direct input programs.

Documentation for LSMW is limited, but here are some links.

http://www.erpgenie.com/sap/saptech/lsmw.htm

http://www.sap-img.com/sap-data-migration.htm

http://www.ficoexpertonline.com/downloads/0703.doc

http://help.sap.com/saphelp_nw2004s/helpdata/en/ad/2d54a41d7011d2b42e006094b944c8/frameset.htm

REgards,

RIch Heilman

Message was edited by:

Rich Heilman

[Former Member]

Hi Mark,

I think u have already declared the structure in Data dictionary....write the custom program in se38 for this u can make use of recording or use fuction modules or bapi anything as per ur requirement.

Go to sm30 and in SXDA0 table select any No u desire prefarably starting with 9, giv the name for DX object and short description mention which type like for batch input write B or for Direct input D.

For SXDA1 table give the same DX object name , sub cat as 0,DX program name as of ur custom progrm name, type as B or D, check for active and for program give the ur prgram name.

for SXDA2 table supply all the above info with structure name item as per ur requirement.Min no from 1 to max 99999 and check for active.

for SXDA3 table will maintain the structure relation, if u have more than one structure u need to be maintain a common field.

I think this helps u to develop a custom program......

[Former Member]

Hi Mahaveer,

I tried to setup the way you explained above. It seems to be working. The problem is that even though the target structure that I defined in SXDA2 gets populated during the Conversion step in LSMW but when I do the final step and debug my custom program the structure is empty there.

Do you know what could be causing it not to take the values?

Many Thanks,

~Mark

[Former Member]

Hi Mark,

I am trying to create a custom DI Program to use it in LSMW. If you have done it, Please send me the procedure to do it.

mail : rusidar@gmail.com

Regards,

Rusidar S.