topic Re: Not able to create View Based Generic data source as Base Table field referring other Tables field (Currency/Quantity) in Application Development and Automation Discussions

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

former_member209123 — Fri, 19 Dec 2014 06:24:42 GMT

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

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

Former Member — Fri, 19 Dec 2014 06:55:07 GMT

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

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.

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

former_member209123 — Fri, 19 Dec 2014 06:58:32 GMT

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.

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

Former Member — Fri, 19 Dec 2014 07:24:27 GMT

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

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

former_member209123 — Fri, 19 Dec 2014 09:23:19 GMT

Vishal,

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

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

Former Member — Fri, 19 Dec 2014 11:58:18 GMT

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

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

former_member209123 — Fri, 19 Dec 2014 12:03:43 GMT

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