Skip to Content
author's profile photo Former Member
Former Member

extract logic/tables/sequence?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 08:20 PM

    1. For master data like material, the exractors behave all most the same way.

    2. For transaction data, it is diferent for LO comapred to non-LO extractors. for LO transaction data, there are some extra steps you need to do like fillng the set up tables, choosing a delta method, V1,V2, V3.

    3. For delta, like I said in 2 above, it is slighly different for LO extractors.

    There is lots of info on this subject in SDN. Search with key word LO or cockpit will be very useful.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      What I'd like to understand more about is the exact logic of the extraction process, not the actual steps for the end-user.. E.g. which tables are used during the process. When does the function module come into the picture. Which is the relationship between the FM and the extract structure. Where is the extracted data stores etc. etc.

      Is there any good documentaion on the subject?

      Regards,

      F C

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.