lsmw

[Former Member]

i need to upload username and email address using lsmw using tcode su01 using recording.

Few records from excel file are already present so i need to check whether they are present or not. IF not then only i have to upload them. what will be the logic for this and how do i do tht?

[RichHeilman]

If this is a one time deal, I would just let that transaction error out, the system will not allow duplicate usernames. No problem.

REgards,

Rich Heilman

[Former Member]

Its One time transfer.

But my flat file has 2 fields userid and email address.

some records which are already present doesn't have email address so for them i need to enter there.

[Homiar]

Megha,

You can add code in the <i>Begin_of_Record</i> event.

The code would be to check existance of record in SAP table (eg: USR01). If record exits, then use macro <b>SKIP_TRANSACTION</b>. Otherwise let the logic flow through.

But, as Rich mentioned, if this is a one time deal, it shouldn't matter if the records error out !

Regards,

Homiar.