3 Replies Latest reply: Oct 14, 2010 10:07 AM by Ingo Hilgefort RSS

SETUP TABLES

Ram babu
Currently Being Moderated

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.

  • Re: SETUP TABLES
    Suni SAP
    Currently Being Moderated

    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

    Set up tables

    Set up tables

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

    Set Up tables..

    lo: delete set up tables: DOUBT

     

    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

  • Re: SETUP TABLES
    Ingo Hilgefort
    Currently Being Moderated

    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

Actions