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

How to LO extraction?

Hi guys...can anyone help me out in listing down the steps to conduct a succesful LO extraction...ur replies and insights are anxiously awaited...thank you...

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 11:14 AM

    Hi Samik,

    Refer this link:

    http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

    Also refer to the weblogs by Roberto.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 11:17 AM

    What exactly do you want to extract?

    Most commonly, standard bw extractors from BC are used (2_LIS_02_* for Purchasing and 2_LIS_03_* for Stocks). To customize them in R/3, you should activate them from BC (RSA5), and then customize them in SBIW (Business Information Warehouse->Settings for Application-Specific DataSources->Logistics->Managing Extract Structures->Logistics Extract Structures Customizing Cockpit (LBWE trans))

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 01:04 PM

    Hi Samik

    Follow are the steps for LO Extraction

    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 – 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 – 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 01:07 PM

    Hi Samik

    The following weblogs are useful for LO Extraction

    LO

    Roberto's weblog series

    /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/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

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

    other doc

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328

    Cheers

    Shiva

    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.