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

R/3 Extraction help

Hello Experts,

I am a newbie to this site, and i need Detailed step-by-step guide for activating and installing a LO Datasource, and extracting the data from r/3.

I would be grateful if you could label the steps for me in order of how they are to be performed, and if possible what to click on to move to the next step, and how to do the actual data load [extraction] .

Thank you for your help in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

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

    Hi,

    Welcome to SDN!!

    Use the "search forum" link on LO extraction and you find lots of posts on the same topic.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

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

    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

    -


    Refer this link for general extraction

    http://help.sap.com/saphelp_bw31/helpdata/en/e3/bddf371aac9f4ae10000009b38f8cf/content.htm

    Regards-

    Siddhu

    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.