Skip to Content
avatar image
Former Member

lo extraction step by step

hi xperts,

Could any body send some important docs on step by step procedure for LO EXTRACTION.

I have gone through the forum especially with roberts blogs about LO EXTRACTION,but i need step by step procedure.Can any body help me with that.

thanks in advance.

Message was edited by:

samatha reddy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 14, 2007 at 06:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2007 at 11:59 AM

    Pls go thru the steps:

    LO-EXTRACTION

    • T-Code: LBWE

    • First we need to check which data source suits the client's

    requirements in LBWE.

    • Check whether it is in Active version/Modified version. If it is

    in M version go to RSA5 and select our data source and press on

    Transfer. Then go to RSA6 and see whether the datsource is been

    transferred.

    • If the datasource is already in active version then we need to

    check whether the datsource is already extracting data in to BW.

    • If the datasource is extracting the data then we need to check the

    data existence in Setup tables (use SE11 to check the setup tables

    data. For every extract structure one and only one setup table is

    generated whose technical name is Extract structure name+ setup, for

    eg. If extract structure name is MC11VAOHDR then set up tables name

    is MC11VAOHDRSETUP) and Extraction Queue (LBWQ) and Update tables

    (SM13) and Delta Queue (RSA7). If data exists in any of these T-

    codes we need to decide whether we need the data in BW or not. If we

    need the extract it as we do in LO-Extraction below. I f we don't

    need delete the data.

    The dataflow from R/3 into BW:

    • We nee to generate the extract structure by selecting the fields

    from the communication structure in LBWE.

    • Generate the datasource and select the selection fields,

    cancellation fields, hide fields that we want.

    • Replicate it into BW. Then we need to attach Info source(Transfer

    rules/communication structure) to the datasource. We got 3 methods

    to attach the infosource..

    1) Business content:: Business content automatically proposes the

    transfer rules and communication structure, we don't have to do

    anything manually.

    2) Application proposal: Here too proposal is done but some objects

    will be missing which we need to assign in the transfer rules.

    3) Others: here we need to create the transfer structure, rules,

    comm. Strct from the scratch.

    • Modeling like infocube, Infosurce attachment,….

    • Then activate the extract structure.

    • We need to fill the setup tables for the first time loading. In

    filling the setup tables we can select between Full load and delta

    initialization loads.

    Filling Set up table:

    T Code : SBIW

    Settings for Application-Specific DataSources (PI)->Logistics--

    >Managing Extract Structures>Initialization>Filling in the Setup

    Table -->Application-Specific Setup of Statistical Data --> in that

    Youcan perform the Setup (Example : SD-Sales Orders - Perform Setup)

    and execute .. or else direct T Code : OLIBW ( means based on your

    application like sales order/billing/ purchase etc)• For setup

    tables T-Code is OLI*BW where * equals to application number like 02

    fro purchasing,08 for shipment…..

    • First we need to decide whether we want delta loads to be

    performed in the future. If we want to do delta loads, then we need

    to go for Delta Initialization process or else do full load.

    • When we perform setup tables extraction, since setup tables are

    cluster tables, we can't see the data in the setup tables. So we go

    for Extractor checker (RSA3) just to see the setup tables data

    (full/delta initialization).

    • Then create infopackage and select Full or Delta initialization in

    Update tab and schedule it.

    • Delete the setup tables data by using LBWG.

    • Now we need to do delta loads.

    • Delta load data flow differs with various delta update methods. We

    got 3 delta update methods as u know.

    • If we select "Queued Delta"update 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.

    • If we select "Direct delta" then the delta data moves into RSA7

    directly.

    • If we select "Unserialized V3" method then the data goes

    into "Update tables(SM13)", then run Collective update to move the

    data from SM13 into RSA7. Schedule the data using infopackage.

    • If we click on Maintenance, we can generate the extract structure.

    • If we click on 2LIS_02_CGR button, then we we can generate data

    source

    • Inactive under Update column: we can make a extract structure as

    active or inactive.

    • If we click on Job control button the we can maintain the

    collective update parameters like, start time, and is it hourly once

    or dialy once ……

    • If we click on Queued delta button under Update mode then we can

    select among 3 delta update methods.

      • Only Full/Delta initialization data loads only moves into setup

      tables. Delta load data doesn't move into setup tables.

      **RSA3 contains only setup table's data

        • Only Delta update data moves into RSA7/LBWQ/SM13 no full/delta

        initialization loads data.

        $$ Assign points dude if f really helps you $$

        Hope it helps you.

        Add comment
        10|10000 characters needed characters exceeded

      • avatar image
        Former Member
        Jul 07, 2010 at 05:49 AM

        Please follow the below steps,

        Here is LO Cockpit Step By Step

        LO EXTRACTION

        - Go to Transaction LBWE (LO Customizing Cockpit)

        1). Select Logistics Application

        SD Sales BW

        Extract Structures

        2). Select the desired Extract Structure and deactivate it first.

        3). Give the Transport Request number and continue

        4). Click on `Maintenance' to maintain such Extract Structure

        Select the fields of your choice and continue

        Maintain DataSource if needed

        5). Activate the extract structure

        6). Give the Transport Request number and continue

        - Next step is to Delete the setup tables

        7). Go to T-Code SBIW

        8). Select Business Information Warehouse

        i. Setting for Application-Specific Datasources

        ii. Logistics

        iii. Managing Extract Structures

        iv. Initialization

        v. Delete the content of Setup tables (T-Code LBWG)

        vi. Select the application (01 u2013 Sales & Distribution) and Execute

        - Now, Fill the Setup tables

        9). Select Business Information Warehouse

        i. Setting for Application-Specific Datasources

        ii. Logistics

        iii. Managing Extract Structures

        iv. Initialization

        v. Filling the Setup tables

        vi. Application-Specific Setup of statistical data

        vii. SD Sales Orders u2013 Perform Setup (T-Code OLI7BW)

        Specify a Run Name and time and Date (put future date)

        Execute

        - Check the data in Setup tables at RSA3

        - Replicate the DataSource

        Use of setup tables:

        You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.

        Full loads are always taken from the setup tables

        Regards,

        phani.

        Add comment
        10|10000 characters needed characters exceeded

      • avatar image
        Former Member
        Oct 28, 2009 at 07:34 AM

        HI samatha..

        Go thru this link

        Regards

        Sridath..

        Add comment
        10|10000 characters needed characters exceeded