Skip to Content
0
Former Member
Feb 28, 2007 at 07:31 PM

extract logic/tables/sequence?

18 Views

Hello,

I'm curious about the sequence in which different kinds of extraction take place leading to data loading into the BW system (either master- or trans. data).

Is this a correct assumtion:

1. Masterdata: during execution of the info package, the function module (alternatively, a view is used as source and no function module is needed) of the called data source goes into the source tables (ex. MARA), returns the data via the rules of the extract structure (incl. appends/user exits).

2. Trans. data init:during execution of the info package, the function module (alternatively, a view is used as source and no function module is needed) of the called data source goes into the source tables (GLPCA), returns the data via the rules of the extract structure (incl. appends/user exits). After the load, a delta table is generated. Within f.e. SD, you have to generate and fill a setup table in order to be able to load th init.

3. Trans data delta: new postings are added to the delta table (in PCA this happens automatically while in f.e. SD, you have to schedule this procedure) from which the new postings are fetched (via function module or view) on execution of the info package in BW.

Is this the way it works in general? Are there any good documents on this topic? Please mail to fc.sapbi@gmail.com

Regards,

F C

Message was edited by:

F C