Skip to Content
0
Oct 16, 2020 at 03:08 PM

JOIN error in CDS view. HANA name mismatch underscore?

89 Views Last edit Jun 23, 2021 at 03:07 PM 2 rev

Hi All,

I have defined a very simple CDS view in Eclipse. It joins CDS view ZMYORDERLINES with external view ZMYDOCS:

The CDS activates just fine but when I open it in SE11 it says the View is not in the database:

After some investigation I found that you can force the view to be created using SE14.

OSS 2421686

When I use SE14 to try and create the view it short dumps with error saying the table column in the JOIN does not exist:

I have played around with different naming conventions but nothing works. The only thing that I can think of is that it expects the JOIN to use the HANA Name _mydocs.SalesDocument rather than _mydocs.sales_document. i.e. without the underscore!

But I cannot use the HANA name as this gives a syntax error in the JOIN statement. I tried with double quotes but it removes them

"_mydocs.SalesDocument" =_ord_line.OrderNumber

Has anyone come across anything like this before? It has baffled me.

Che

Attachments

7sxly.png (16.9 kB)
qimmd.png (3.5 kB)
dxfzp.png (12.4 kB)
gjccr.png (5.2 kB)