on 08-31-2006 4:26 PM
Hello BW Experts,
I have a table in BW tab1, it has a field for amount, data type currency, reference table /BI0/I0CURRENCY, reference field CURRENCY.
trying to generate a datasource for this table. Get an error message saying that amount field refers to another table. so invalid extract structure. it suggests creating a view of the tab1 and /BI0/I0CURRENCY and then create a datasource on that view.
i am not sure how to proceed with this. is there any alternate solutions for this. if not how to create a view between these two tables.
Please suggest.
Thanks,
BWer
It is because the currency field is a unit - this is normal
In R3 you normally have to join WAERS via T001
If you are creating an internal BW datasource then via RSO2 then the followign applies.
Go into SE11 on BW and create a view between your table and /BI0/SCURRENCY
Join them via..
your table.CURRENCY = /BI0/SCURRENCY.CURRENCY
Activate and that's it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.