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

LO data extraction

hi all,

under lo extraction customizing cockpit, when i click on maintain a data source and go to selection criteria and add some firelds and confirm the entries, i get an error message:

<b>Struct. appl. 11 cannot be changed due to setup table -> Long text</b>

...

please help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Sep 19, 2007 at 02:58 PM

    Hi,

    Did you delete the contents of the set up table yet?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 03:02 PM

    Srihari,

    I think setup tables for application component : 11 contains data. delete setup tables(T Code: LBWG) and do changes.

    Hope it Helps

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 05:18 AM

    1st you have to inactive the data source.

    later you have to go for the maintenance tab to select the fields.

    Otherwise this error will be displayed.

    I will send you the Lo Document follow this method.

    First Activate the Data Source from the Business Content using “LBWE”

    For Customizing the Extract Structure – “LBWE”

    Maintaining the Extract Structure

    Generating the Data Source

    Once the Data Source is generated do necessary setting for

    Selection

    Hide

    Inversion

    Field Only Know in Exit

    And the save the Data Source

    Activate the Data Source

    Using “RSA6” transport the Data Source

    Replicate the Data Source in SAP BW and Assign it to Info source and Activate

    Running the Statistical setup to fill

    the data into Set Up Tables

    Go to “SBIW” and follow the path

    We can cross check using “RSA3”

    Go Back to SAP BW and Create the Info package and run the Initial Load

    Once the “Initial delta” is successful before running “delta” load we need to set up “V3 Job” in SAP R/3 using “LBWE”.

    Once the Delta is activated in SAP R/3 we can start running “Delta” loads in SAP BW.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 05:34 AM

    Hi Sri Hari,

    You need to delete the setup tables before you modify the structure in LBWE.. And then you follow the following steps:

    1. Go to tcode LBWE

    2. choose the Data source i.e extractor which suits to ur business scenario.

    3. u need maintain the DS i.e where u can add or remove the fields 4m d extract structure....we can add d fields simply transferring fields from Communication Structure to the Extract Structure.

    4. u have generate the Data Source .

    5. Activate the Data source.

    6. choose which type of update is needed i.e it could be either Direct, Unserialised V3 or Queued delta.

    7. Delete the setup tables by tcode LBWG.

    8. Run statitistical setup by tcode OLI*BW, * depends upon the application say 2-purchasing,11-sales order, 12-shipment, 13-billing....etc.

    goto RSA6 in R/3 system and say transport the DS.

    9.Go to bw system->source system in Modelling say replicate DS and activate the transfer rules and do all d need work on bw side.

    Hope this helps you....

    ***Assign Points*****

    Thanks,

    Gattu

    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.