cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Types & the Extractors

Former Member

Dear Experts of SAP BW,

I got confused by the terms used in the books.

For Delta Type (PULL) 'E', its said that BW Extractor in Delta Mode writes the records to the Delta Queue. This delta type applies to LIS & CO-PA.

1. 'SAPI reads the selection filter ranges inclusive from all prior initialization runs'. Where is this SAPI mentioned reside? BW or R/3 since both sides have SAPI.

Also, is the selection filtering done via the InfoPackage 'Data Selection' Tab? If so, what is meant by including all previous init run selections? All added up?

2. Is the 'BW Extractor in Delta mode' = 'Application Extractor' = 'Datasource Extractor called in delta mode'?

3. LO uses Delte Type (PUSH) 'D'. This type is used by LO V3 Update & Direct write by FI-AR/AP. Does this type also apply to the other 2 LO Update Methods Queued & Direct? FI-AR/AP uses this type to write Directly. Is this the same as LO's Direct writing to Delta Queue?

Regards,

bworbust

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi bworbust,

where are you reading these sentences ?

However, take a look to SAP tables RODELTAM (here you can find all delta procedures and related properties) and ROOSOURCE (where, for every datasource in your system, you can find which type of delta is associated to)....surfing through these tables I'm seeing that delta type D is not supported by datasources you mentioned...

However, push and pull (delta type) are different datawaerehousing delta concept (not formerly coded by SAP) because in a pull delta a DW pulls data out of a source system, in a push delta a source system push delta records into a DW.

For your second question, I think that BW, application or datasource (this last one seems to be more correct) refer to the same thing...

about initializations...when you make an init run, API reads if previous inits have been performed and if the selection conditions (in your infopackage) don't overlap the previous ones...if not, all (previous and actual) selections are merged in order to manage only one delta queue (it's not possible to have several delta channel for the same datasource/BW destination)...otherwise, you have to delete old init before doing a new one !

Bye,

Roberto

Former Member
0 Kudos

Hi Roberto,

Thanks for your reply.

I quoted from BW340, BW350 course materials.

1. BW340 pg 2-11,12: 'SAPI reads the selection filter ranges inclusive from all prior initialization runs'.

2. BW340 pg 2-12: 'BW Extractor in Delta mode' = 'Application Extractor' = 'Datasource Extractor called in delta mode'?

3. BW340 pg 2-11, BW350 pg 3-21,22: LO uses Delte Type (PUSH) 'D'. This type is used by LO V3 Update & Direct write by FI-AR/AP.

regards,

bworbust

Former Member
0 Kudos

Hi,

for sentences no.1 and 2 no problem, you can refer to my previous reply....for the third one, ok, maybe these documents refer to a SAPI version not installed on my system (and I've never seen before!)

Waiting for some contribution from someone else...

Bye,

Roberto