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

Regarding Extraction

Hai all,

I am new to BW. I have a doubt in extraction of R/3 data.

when do we go for RSA5?

will there be data in the setup tables initially while we r first extracting the data from R/3 to BW? or we need to load the setup tables using SBIW.

what is difference bw queued delta, direct delta, unserialized V3?

Is Serailized V3 is available in 3.5 or not.

I had refered the documents, but i am still in a confusion.

pls help me out.

thnks,

Phani

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 06:59 PM

    Hi,

    Check this blogs from Roberto for Logistics Extraction:

    /people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

    LOGISTIC COCKPIT DELTA MECHANISM - Episode two: V3 Update, when some problems can occur...

    LOGISTIC COCKPIT DELTA MECHANISM - Episode three: the new update methods

    LOGISTIC COCKPIT - WHEN YOU NEED MORE - First option: enhance it !

    LOGISTIC COCKPIT: a new deal overshadowed by the old-fashioned LIS ?

    Set up table definition:

    Setup table is store the historical data, where as the delta records are updated in delta queue not to set up table.

    So once historical data is loaded you can delete the contents of the set up table.

    name is extract sturcture of your data source + setup

    also data is taken from setup table when an init / full/ full repair load is done.

    so in order to take ur records from the table delete the setup table(LBWG) and initialize it with ur records.

    You can find the contents SE16

    Filling set up tables

    transac LBWG

    + SBIW -> Logistics -> Managing Transfer Information Structures-> Setup of Statistical Data-> Application-Specific Setup of Statistical Data

    Set up tables

    view of set up tables data in se11??????????

    LBWQ is the extraction queue and RSA7 is delta queue. Data is sent to delta queue from extraction queue through collective job scheduled in transaction LBWE.

    when we want to extract the data using LO Cockpit, the data will be come to the extraction queue first and from there it will processed to the delta queue. SO lbwq works as a outbound queue.

    If the update mode is Unserialised V3 then as soon as the document is posted it comes update table which you can see in Tr. Code SM13. After the jonb is scheduled the records come to RSA7 i.e delta queue from which BW pulls the data

    If you use u201CQueued Deltau201Dupdate method then the data moves to Extraction queue(LBWQ). Then run Collective update to move the data from LBWQ into Delta Queue (RSA7). Then schedule the data using the infopackage by selecting Delta Load in the update tab.

    So in If you are going to do Setup table filling, delete the data from LBWQ.

    The usage of Extraction queue(LBWQ) comes in to picture in delta loading. But actually system starts collecting the data (whenever there is document creation in R/3) after activating the EXtraction structure.

    Steps to Be Performed

    We know that there are 4 types of delta extraction that are available in LO. If you use u201CQueued Deltau201Dupdate method then the data moves to Extraction queue(LBWQ). Then run Collective update to move the data from LBWQ into Delta Queue (RSA7). Then schedule the data using the infopackage by selecting Delta Load in the update tab.

    Here is Roberto's weblog:

    LOGISTIC COCKPIT - WHEN YOU NEED MORE - First option: enhance it !

    /people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

    LOGISTIC COCKPIT DELTA MECHANISM - Episode three: the new update methods

    check these out as well...

    LBWQ - T code is for what?

    what-is-lbwq

    Regards,

    Habeeb

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hai habeebuddin,

      Thanks for ur reply. I found ur answers very helpful. But, i need some more clarifications.

      > So once historical data is loaded you can delete the contents of the set up table.

      > name is extract sturcture of your data source + setup

      also data is taken from setup table when an init / full/ full repair load is done.

      > so in order to take ur records from the table delete the setup table(LBWG) and initialize it with ur records.

      > You can find the contents SE16.

      As u told we can delete the setup tables after historical data loading,

      what is the need for deletion of setup tables, although we r getting the data that comes later into Delta Queue.

      And in SE16 how can i see the data of the setup tables. I checked it with Eg: MC11VA0HDRSETUP. But it is not showing any data in that?

      Are the setup tables are cluster tables and can we see the data of these cluster tables?

      thanks,

      Phani

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 05:54 PM

    Hi Phani,

    Please search the forum before you post.

    All the answers to your questions are available in the forums.

    Cheers,

    Kedar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 09:01 AM

    Hi,

    While doing LO extraction in BW, its mandatory to fill the setup table first and load in to BW. You can fill the setup table by SBIW transaction or direct transaction OLI*BW. There are different types of updates in BW :

    1. Direct Delta --> Once the new records are updated in Table then the extraction data will be transferred directly to Delta Queue and then from Delta queue data is transferred to BW system once u send infopackage delta request to R/3.

    2. Queued Delta --> In this Data is extracted to extraction Queue first and from their data is transferred to Delta Queue by means of a update collective run in V3 update and from Delta queue data is transferred to BW system once u send infopackage delta request to R/3.

    3. Unserialised V3 update --> Generally we dont prefer this option because of unserialisation, since their a chance to miss the documents posted.

    And V3 update is a program in R/3 system that schedules batch jobs to update the extract structure to datasource collectively.

    Regards

    S@s!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Setup table is used for loading the data(Initial loads). Once you have established the Delta, there is no need to fill the setup tables.

      With regard to your question of where to check the setup table data, you have to goto RSA3 transaction (R/3 side) and look for the data by selecting the datasource name.

      Hope this helps.

      Regards,

      Sreenivas.

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.