How to create datasource based on table/view contains CURR type field ?

[former_member435389]

Hi,

How to create datasource(rso2) based on table/view contrains CURR type field (reference other table ) ?

I tried to create a view join to other table , it not worked.

Tks!

[bhavinvyas · Accepted solution]

Hi,

For BSID source table there is a standard data source available 0FI_AR_4. Please refer this help page,

Accounts Receivable: Line Items

For currency question, you can go to SE11 > BSID > Search for WRBTR in Currency/Quantity tab, here check for reference table and field. for WRBTR, currency WAERS picked from BSID table itself. So if you are only adding this keyfigure field from BSID then select WAERS field as well from BSID else if you have more keyfigure requirement from BSID then simillarly you can search for reference table and join.

But still I would suggest to use standard data source unless you are having special requirement.

Thanks,

Bhavin