Showing results for 
Search instead for 
Did you mean: 

How To Table_Comparison with SAP BW Target

Former Member
0 Kudos

Hi everyone,

hope you are fine!

I am very new to BODS and do not understand how to use Table_comparison with a SAP BW Target DataStore - if this is possible at all?

We are on SAP BW 7.3 and BODS 4.1.

Source in this scenario is Oracle View.

I saw a lot tutorials how table_comparison works, but how this will be achieve when you have an Oracle view as a source and a SAP BW as a target.

What I did and works is.

- I have created a Job in BODS Designer populating the values from Oracle view to SAP BW

- I am only able to start the Job from SAP BW using an InfoPackage in Full mode, which I have created manually.

     - if I start the job from BODS Designer I am receiving errors - maybe not sufficient rights.

But now I would like to implement a Delta. Therefore I am using the table_comparison.

So the steps would be then:

- Run the init job - so full into SAP BW

- adjust this job and implement the table_comparison

     - create a template table based on the source

          - as there is no option to choose the SAP BW target DataStore in the table_comparison

And what next?

Should I leave the SAP BW Target in the dataflow?

Or should it be replaced bye the template table (as target)?

And do I have to create another Job where the template Target is the Source populating into SAP BW target?

And do I have to adjust the InfoPackage on SAP BW side telling it, that you are now Delta?

Sorry if this is a bit confusing, but I would only understand how target_comparison works for SAP BW target?

Thanks very much in advance for your hints.

It is much appreciated.

bye Ömer

View Entire Topic
Former Member
0 Kudos

Hi everyone,

what I did and seems to be working 😉

I have 2 jobs.

1 jobs include 2 data flows for init.

1 data flow:

source: Oracle view

target: template table - needs to be imported

2 data flow:

source: template table

target: sap bw data source

2 job include 1 data flow for delta.

source: Oracle view

included table_comparison with template table for comparison

target1: template table - to be updated

target2: sap bw data source

this is working fine.

the only thing i am worring is that the template table is growing as there will be initally more than 5 million records expected.

Hope this will be working for anybody else.

Thanks and bye