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

SETUP TABLES

Hi Gurus,

Why don't we've SETUP TABLE concept in other extractors except LO-COCKPIT.I've asked so many people but can't get the appropriate answer.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 06:15 AM

    Hi,

    Setup Tables are cluster tables. They are used to extract the data from R/3 Tables.(LO Extractors)

    Basically, for entire application like SD , Billing we have got it's own setup Tables...so while filling the set-up tables, we usually fill for the entire application.

    Ex: OLI7BW, is for filling setup Tables for SD application. and OLI9BW T-code is for Billing Application,

    When u fill the setup Tables, the data from different tables..VBAK, VBAP, VBRK, VBRP...etc will come through communication Structures and saved in SetupTables...

    The main advantage of having setup Tables (These are like Cluster Tables ), we can read the data in different levels..Header level as well as Item level.

    when we run init load or Full load in BW, the data will be read from Setup Tables for the first time( Entire data will be read).... and the delta records will be updated to Delta Queue once the v3 jb runs... and we can extract the delta records from Delta Queue.

    once we succefully run the init, we can delete setup Tables also... no probs...

    Filling up the set up tables depends on the datasource.

    there are different T-codes for the respective extract structures

    OLIIBW transaction PM data

    OLI1BW INVCO Stat. Setup: Material Movemts

    OLI2BW INVCO Stat. Setup: Stor. Loc. Stocks

    OLI3BW Reorg.PURCHIS BW Extract Structures

    OLI4BW Reorg. PPIS Extract Structures

    OLI7BW Reorg. of VIS Extr. Struct.: Order

    OLI8BW Reorg. VIS Extr. Str.: Delivery

    OLI9BW Reorg. VIS Extr. Str.: Invoices

    OLIABW Setup: BW agency business

    OLIFBW Reorg. Rep. Manuf. Extr. Structs

    OLIIBW Reorg. of PM Info System for BW

    OLIQBW QM Infosystem Reorganization for BW

    OLISBW Reorg. of CS Info System for BW

    OLIZBW INVCO Setup: Invoice Verification

    OLI7BW is the tcode for Sales Order.

    Have a look at these discussions:

    Set up tables

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

    Blogs of Roberto will be useful as well:

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

    /people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

    /people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

    /people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

    /people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

    Display Setup Table Data:-

    Goto SE11 or SE16 -> MC*SETUP -> F4 you will get all the setup tables choose and display the data

    To check completion of dta loading

    NPRT t-code... Where u can see the entry with ur user and the Run of ur setup..

    Regards,

    Tg

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2010 at 08:07 AM

    HI,

    this forum is related to the SAP BusinessObjects BI Solution Architecture. I would suggest you post your question to the forum for the BW extraction.

    ingo

    Add a comment
    10|10000 characters needed characters exceeded

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.