Not able to create View Based Generic data source as Base Table field referring other Tables field (Currency/Quantity)

[former_member209123]

Hi SAP Gurus,

I am trying to create a Data source on a View (single database table - RESB) but some of the fields of the table RESB are reference to other tables field likewise RESB field ROANZ is referring to RC29P table's field ROAME.

I have created View with only one table i.e. RESB. But as these some of the fields (Referring fields) are not available in Base table RESB, I am not able to create generic data source over this view. I am getting error as below:

If anyone has got such issue please guide further and provide solution for the same.

Thanks in advance.

Best Regards,

Demish Maniyar

[Former Member]

Create a view on RESB and RC29P tables and include ROAME field of data type ROAME from RC29P table in that view.

OR

Append structure in RESB table and add field ROAME of data type ROAME in it, then change the reference table as RESB for ROANZ field.

[former_member209123]

If the Table RC29P is included in View I will need a join condition between both the tables. But there are no common fields for the Join in both the tables.

Regarding enhancing the table, we are unable to enhance the database table due to security reasons.

[Former Member]

Try to append it in Extract structure created for generic datasource. Check if it solves your issue.

[former_member209123]

Vishal,

After Appending I need to populate those fields through FM. can you please guide how can i do that?

[Former Member]

Are you creating datasource using Function module or Table/View.

[former_member209123]

Hi Vishal,

I created an append structure in Extract structure and added those required fields in View. This resolved the error and data source is consistent now.

Thanks for the help..!!!

Regards,

Demish