Delta Concept For Data Source

[sachin_kulshrestha2]

Hi All,

!!!!!!!!!!!Make my concept clear Guys!!!!!!!!!!

Lets take a datasource 2LIS_04_P_ARBPL when any transaction is done in production planning the data is gathered in extract structure and when collective update is run (queue delta) then data comes to Bw Delta queue(RSA7). Datasource has function module which actually fetches the data when the request comes from BIW.

Query: Is the functional module which is an actual engine to datasource, and send data to BW, fetches the data from where??? Is it from delta queue or from actual tables.

Thanks

Sachin K

[sachin_kulshrestha2]

Anil,

If it is so then if you see the functional module for that datasource you will find the logic access directly the table also why is it so????

Sachin K

[Former Member]

Function module is used to get data from different tables and putting in structure that is extract structure...this will have records when the program/function module/datasource is running/executing...

it is not possible to get data from directly tables to the extract struc/datasource for bw....

lakhes of records will get created for some tables like bseg/bsek...is it possible to get these data to bw directly....no no..it is not possible....bcos of these function module are coming here....

let me know if you have issues/correct me if i wrong....

thanks,/mahantesh

[Former Member]

Hi,

If so, I guess, The function module is taking the reference from RSA7 to select the records from base table.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Mahantesh,

with referenct ot your statement:

<i>tables like bseg/bsek...is it possible to get these data to bw directly....no no..it is not possible....bcos of these function module are coming here....</i>

When BW wants the delta data for Account documents, it will not fetch from BSEG or RSA7. It will take the help of one intermediate table BWFI_AEDAT.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Anil!

<i>If so, I guess, The function module is taking the reference from RSA7 to select the records from base table.</i>

The delta queue actually contains all the transaction data (not just references).

A (generic) function module pulls the data from the delta queue and it is then posted to BW.

How and when the data is written into the delta queue depends on the update mode you select in transaction LBWE. If you use 'queued delta' the transaction data is collected in a queue (which you can access via TA LBWQ) and then written into the delta queue (RSA7) by a job (which can be scheduled in TA LBWE). If you use direct delta, the transactional data is written into the delta queue 'on-line', i.e. when an R/3 user creates, changes, or deletes a document in R/3.

The mechanism that actually posts the data into LBWQ (for queued delta) or RSA7 (for direct delta) is part of the LIS in R/3 and is not just used for BW extraction purposes.

Hope this helps...

Kind regards,

Christian