cancel
Showing results for 
Search instead for 
Did you mean: 

Process chain to trigger automatically after file arrives in AL11.

Former Member
0 Kudos

Hi All,

There is a text file(.txt) which comes from mainframes team every Sunday between 11 AM to 6 PM and gets placed in AL11 inbound directory following which we manually trigger a process chain which uses this file.

The requirement is that this chain should trigger automatically after the file arrives in AL11 in BW.

Is it necessary for the mainframe team to send another control file or some other file in addition to the text file to trigger this process chain..?

Is there any other way the process chain can be triggered in BW without any changes required from the mainframe team.

Additional information:

Also I came to know that this can happen through some system command statements using SM49 we can schedule this chain.

Else can some ABAP Program code be used to make this process automatic?

Please help me.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear,

Let me make it more clear

The event process will only trigger the process chain if the preceeding event is finished.But if you want to trigger the process chain automatically when ever the flat file is placed in AL11(Al11 is nothing but the application server it just looks like a portal or a folder )when you place a file in the application server or AL11 depending on the recent time stamp the process chain has to trigger for that you need to maintain a program with the help of Abap.

The other way around is write a program that checks the Al11 for the specific mentioned path at regular intervals so when there is a check the programm will trigger the process chain .

Also you can create an event as said in the discussion and keep that variant in the start variant of the start process and you can make a condition in program saying that when the time stamp is changed trigger the respective variant.

Hope this helps

Former Member
0 Kudos

Hi all,

I need an ABAP program to be inserted in the process chain.

This ABAP program should pick the flatfile from local workstation and paste in the Application server.

I have an ABAP program which runs succesfully when i execute it manually, However if i keep it in PC it is not working.

please suggest me solutions for my requirement.

Thanks & Regards,

Kavitha

Former Member
0 Kudos

This message was moderated.

haripriya_pampana
Contributor
0 Kudos

Hi ,

we ha same requirement in our project.

we created Ztransaction and linked the process chain to that ztransaction.and gave authorization to the particular user for that transaction.

User placess the file in server and execute the transaction , then the process Chain will star and the file loads into the BW.

we took abaper help to create the trnsaction.

Thanks

HP

Former Member
0 Kudos

Hi,

Thank you!

But in my case, user doesnot know the SAP system.

They just put file to Al11 directory. I need to find a way to trigger my PC as soon as file reaches the directory.

BR

Adlin

Former Member
0 Kudos

Hi,

Thank you!

But in my case, user doesnot know the SAP system.

They just put file to Al11 directory. I need to find a way to trigger my PC as soon as file reaches the directory.

BR

Adlin

KamalMehta
Advisor
0 Kudos

Hi Adlin ,

In my previous Projects we were doing this .

1. Current Project has Control M for scheduling all the BW Batch Jobs for Process Chains etc. Control M is mainly used for scheduling the various jobs . Our Process chain Start variant has Event which is triggered from Control M when ever the file comes at the application year .Basically there are Control M Jobs defined to check whether the file is available or not .One the File if there it would trigger the BW Event which in turn would trigger the Process Chain like wise.

2. Similary in one of my previous Project we had Redwood to take care of all such dependencies and all the BW Jobs were scheduled from Redwood.

Hope it helps.

Thanks

Kamal

Former Member
0 Kudos

Hi,

We have created simple flat file datasource with Adapter property set to "Load Text-Type File from Local workstation" in extraction. this is PI interface.

It gives an option to preview the data in datasource itself. Then mention the file path from AL11 in infopackage. put immediate option in start variant of PC.

also contact BASIS team for an connection issue.

Former Member
0 Kudos

Hi,

Who is maintaining this communication channel. Ask your Basis or PI team.

They can help you in this situation because you do not have control to this file.

As said above, once the file is placed in AL11; an event should be triggered which schedules your process chain.

Your part in this is to create an event and give it to the start variant of process chain.

XI/PI team can write an ABAP code to trigger the event once the file is placed in AL11.

Regards,

Sunil

sukdev_koner2
Participant
0 Kudos

The process chain has a start variant. In that start variant, you make it as 'AFTER EVENT'. Create an user-defined event in SM64/ SM62 and put this event name and parameter name at start variant.

Now when the file is available in Appl Server by mainframe, please use an os command to trigger that event. Then the pc will start automatically.

I did not face the same situation but pleae try this out.

Former Member
0 Kudos

Hi Sukdev,

Thanks for your reply but my question is how will the event trigger when the file arrives. Please be more clear..

Your response is hghly appreciated.

sven_mader2
Active Contributor
0 Kudos

Hi,

How do you put the file in AL11?

you can start the event also from the operation system => ask your basis adminisatrator. create a script.

Sven

Former Member
0 Kudos

Hi Sven,

The file comes in AL11 from another team from another company and not my company.. please suuggest me a solution without needing any changes to be made from the source team.

I need a event to trigger in BW after the file arrives in AL11.

Former Member
0 Kudos

Hi,

You can do the following, in your process chain change the start variant and make it event dependent. Now you can do the following,

1) Create a table in SE11 which will have fields like Process chain name and execution date as primary fields. This table will be used further for checking purpose.

2) Now create a ABAP program as shown in below given article, in this program in addition to raising an event you will have to read the file from app server.

3) If program can read file from app server means you will raise an event and make entry in above table for preventing further execution of process chain. If program can't read file from app server then program will simply end without doing anything.

4) Now you can schedule this program after every hour or 30 min. as per your requirement, the program will first check if the process chain execution entry exists in the above 'Z' table or not. If entry exists means the process chain has been already executed and the program will be terminated.

5) You can use FM to read data from app server. You need to be careful while placing file on app server, because it has to be different naming convention or something else to identify that the current day file is available.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a01cc44a-5aac-2d10-3eaa-a3bbf645d25c?QuickLink=index&overridelayout=true]

Regards,

Durgesh.

Former Member
0 Kudos

Hi Durgesh,

Thanks a lot firstly for your response.

I want to clarify a few points in this.

Please correct me if wrong also please tell if the below points are possible.

The file name is same and it comes on every sunday. however i thought that while writing ABAP program we can have an additional condition to check for todays sysdate which will pick the file fpr particular day.

Is there a possibilty that the program will not be checking the file every 30 mnutes but will trigger only once after the arrival after file in AL11. Please suggest me if i can use system command (SM49) to achieve this.

Former Member
0 Kudos

Hi Collins,

How did you resolve the issue>

Can you guide me please?

Thanks!

BR

Adlin