cancel
Showing results for 
Search instead for 
Did you mean: 

To enable delta in generic data source

Former Member
0 Kudos

Hi,

There is a generic datasource created on top of PRPS & RPSCO tables. Currently the extraction mode is 'full update'.

There is no time stamp field available in RPSCO, Please suggest how can I enable delta?

Accepted Solutions (1)

Accepted Solutions (1)

former_member199691
Active Contributor
0 Kudos

I am not sure if there is link between these two tables. If there is a logical relationship, you can use Creation Date and Chagned date fields in PRPS table or you need to find another table which might have a date or timestamp field related to data in RPSCO table.

Regards,

Gaurav

Answers (4)

Answers (4)

former_member188080
Active Contributor
0 Kudos

Hi,

We can create generic delta datasources and psedo delta as well.

We can create generic delta DS in RSO2.

You should atleast have one time /date field based on which you can define your delta.

Safety interval upper/lower can be defined based on date or time say 1. and based on this data will be fetched from source system .

Also based on setting data will be fetched in BW. there will be some repeat records,so you need to build DSO with overwrite functionality.

also you can have psedo delta in which based on created on and changed on dates you can get records in SAP BW. You can runmultiple IP to achieve this.

and

Former Member
0 Kudos

Hi

Make sure at least you have Numeric pointer or time stamp field in your table to make the data source enable.

If you created view on these two tables, then in RSA6 --> open the data source --> goto edit mode.

here you will delta enable check box --> select this check and you can give the field which has to be used for delta.

If you using FM, then you have to write to code in functional module.

Regards,

Venkatesh

Former Member
0 Kudos

Hi,

You can Also use Numeric pointer option for delta. But with out these three fields it is not possible to delta (how the database stamp the last happening )

You can create another view with combination of delta related field .

Regards,

Satya

Former Member
0 Kudos

Hi Priya,

This is discussed many times please search the forum before you post.

For your reference, you must need at least one field either of type Time Stamp or date or Numeric pointer to setup delta for generic extractor without that delta extraction is not possible.

Regards,

Durgesh.