on 09-19-2007 3:57 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Srihari,
I think setup tables for application component : 11 contains data. delete setup tables(T Code: LBWG) and do changes.
Hope it Helps
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you delete the contents of the set up table yet?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.