generic datasource creation error

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