Generic Delta

[Former Member]

Hi all,

I need soem help in deciding the best option.

Generic delta can be achieved in two ways.

1. Create two Datasources on R/3 side and give two different fields for generic delta

2.Create two infopackages for one datasource.Routine for Selection criteria of those two delta fields.

can anyone suggest which one will be the best option to implement in BI 7.0

Thanks in advance

[Former Member · Accepted solution]

Hi,

I think your option 1) will be the best. But anyway, did you also think about deletions? How do you get deleted records to bw?

regards

Siggi

[Former Member · Accepted solution]

But when I see the process chain , there will be two infopackages, two DTPs in first option

Where as there are two infopackages and one DTP in second option.

Does the first option going to take more time

[Former Member · Accepted solution]

Hi,

going with the second option will not work. You can only define 1 field as the delta field. So how will you track creations or changes? You need two datasources for that.

regards

Siggi

[andr_klos · Accepted solution]

Hello,

I think it is not necessary to create two datasources. If you will implement an datasource by a function module, you can use the field for delta (e.g. date field) for selection of create date and change date. So you have one datasource which can deliver created and changed records.

Example:

Delta-Field: ZDATE.

OPEN CURSOR L_CURSOR AS

SELECT *

FROM Z_TABLE

WHERE ERDAT IN R_ZDATE

OR AEDAT IN R_ZDATE.

So you will get created record and changed records since the last update to BW.

Regards,

André

[rajkumar_kandula]

Hi,

Its better if you prefer the first option.