CDS View with Join length mismatch

[arsul_parshuram]

Hi Dear Friends,

I am trying to create CDS view with below tables and joins.

Tables:

/scdl/db_refdoc and LIPS

my inner join conditions

inner join lips as li on li.vbeln = refdoc.refdocno and li.posnr = refdoc.refitemno

I am facing below error

ABAP 7.5

Kindly advice me further on above error. My analysis as below.

1-> Functions are not supported while join condition's in CDS.

2-> Offset is not working while join conditions in CDS.

3-> Created another CDS view with Item as Alias by using CAST with REFITEM_PO as 6 NUMC, but after joining with new created field no data in result set.

4-> CDS Table function not tried yet..

Do we have any solution on above conditions...

Regards,

Arsul

[retired_member]

Read the documentation about possible conditions

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abencds_cond_expr_types.ht...

[diwaneamit]

Write a subselect query with string function somewhat like below:

inner join lips as li on li.vbeln = refdoc.refdocno and li.posnr IN (select right(refitemno_po,6) from /scdl/db_refdoc where <write down your condition>).

Regards,

Amit Diwane

[chalapareddi2]

It is working with Table Function