Executing LSMW project with Conditions

[Former Member]

Hello Experts,

I have developed LSMW for uploading busines partner data into CRM 5.0 system. It is working great as expected.

I was also able to set its execution from SXDA workench by scheduling the run. However there is a change in business requirement. We have a ETL layer (Informatica) in between the legacy and SAP. Please note there is no SAP connector for informatica. Informatica outputs a flat file on unix server and my LSMW picks it up and processs. The requirment is to have handshaking between ETL and CRM.

For all future delta loads(Changes) of Business partners, there would be a Indicator file on the unix. Whenever the scheduled job runs, the LSMW program is suppose to look if the indicator file is present or not. If it finds the indicator file then it should pick the actual data file from the server and process it. and after successfull data load it should delete the ind file. If no indicator file is present then do nothing.

Could any one of you can give me an idea about how to implement this handshaking ?

I will appreciate your help in this regards.

Thanks,

Vallabh.

[Former Member]

Hello Experts,

I have developed LSMW for uploading busines partner data into CRM 5.0 system. It is working great as expected.

I was also able to set its execution from SXDA workench by scheduling the run. However there is a change in business requirement. We have a ETL layer (Informatica) in between the legacy and SAP. Please note there is no SAP connector for informatica. Informatica outputs a flat file on unix server and my LSMW picks it up and processs. The requirment is to have handshaking between ETL and CRM.

For all future delta loads(Changes) of Business partners, there would be a Indicator file on the unix. Whenever the scheduled job runs, the LSMW program is suppose to look if the indicator file is present or not. If it finds the indicator file then it should pick the actual data file from the server and process it. and after successfull data load it should delete the ind file. If no indicator file is present then do nothing.

Could any one of you can give me an idea about how to implement this handshaking ?

I will appreciate your help in this regards.

Thanks,

Vallabh.

[Former Member]

Since the LSMW is working fine, I will not prefer changing that. Instead, write a small program that looks for this file and if found, trigger an event using the function module BP_EVENT_RAISE. Change your LSMW job definition to 'trigger after event' instead of a specific time of the day. You can create user events in SM62 and use that in the definition of your job.

[Former Member]

Hi Srinivas Adavi,

Thankyou so much for your valuable suggestion.

I did have something similar in mind and your answere has given me that required boost.

Just one more thing..may be its a dumb question...

I did created a custom event and created a program to raise that event and all that.

Now i want to schedule a job thru SM36. While doing this i have to give a ABAP program name in step 1, which needs to be executed when that event is raised.

What program name should i give for LSMW ?

I know while creating LSMW application it does create a ABAP program in the background. But in that case should i give the Read progam name or conversion program name or both?

OR is there any other process to schedule LSMW run ?

Please Kindly help.

Thanks,

Vallabh.

[Former Member]

Sorry for the delay in answering. Yes you can schedule a LSMW project object as a job. You can run/schedule program /SAPDMC/SAP_LSMW_INTERFACE for scheduling any LSMW object as a job.

Create a variant for this program and use that for defining your job. You should not use the program name that is generated as that name will change.

[Former Member]

Srinivas,

Great !! I did it the way you said and it worked perfectly ok.

Thank you so much for your help. Let me know if i have to do something to get you added some points.

Will keep in touch.

Regards,

Vallabh.

[Former Member]

Glad to be of help.