Triggering SAP BODS jobs with conditions from SAP BW without Process Chains

If there is a Source System is BW, We can trigger the SAP BODS jobs from SAP BW through Process Chains but there is an another way to trigger them from SAP BW and we can filter the data as well. This is useful for the SAP BODS Jobs when client needs to filter the data.

Pre-requirements:

1. First we need to know connection is available between SAP BW and SAP BODS or not. 
2. If it is there we need to create the DTP ( Data Transfer Process ) and then create an InfoPackage.

             

Data Transfer Process (DTP) :-

            In order to create a DTP, Choose the OpenHub Destination and need to find OpenHub table in it. OpenHub Table --> Create Data Transfer Process, you will get a window and in that click on ✔ (Continue).

 

Steps to Create an InfoPackage.

InfoPackage:-

Process of creating an InfoPackage in BW, choose the DataSources and create a Datasource for our Job. DataSource --> ‘Create InfoPackage…’ after clicking on it you will get one window that is shown below.

We need to mention the InfoPackage Description and then Click on Save.

After that you will get one window and in that window choose Local Object.

And then Choose Tab as ‘3^rd Party Selections’.

Check the Repository and JobServer which is shown above and set the required values there.

After that Choose the SAP BODS Job name at Jobname filed. Then click on Check. 

Then Click on Save . After saving the InfoPackage the InfoPackage is ready for execution.

Filtering:

We can filter the data based on client requirement. Which is mentioned below.

Go to certain OpenHub and double click on DTP --> Filter.

Then Set the filters which are required and then click on Continue and Save it.

Click on Execute. After executed it the data is loaded into table with filter conditions.

Choose the DataSources and find your InfoPackage in that and choose the option as Schedule-->Start. After Started the InfoPackage the SAP BODS  will run. 

 We can Execute the SAP BODS job from SAP BW without Process Chain by using above process.