Skip to Content
-1

Facing a Problem in ABAP CDS view related to join condition

Nov 02, 2017 at 03:25 PM

63

avatar image
Former Member

example is ,

select from vbak as head

inner join vbap as item

inner join konv as cond

on head.knumv = cond.knumv

and item.posnr = cond.kposn and prc.cond_type = cond.kschl

inner join konh as kon

on on kon.knumh = cond.varcond (here i just need first 10 char of this field to be macth).

Can this is possible with CDS view??

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Horst Keller
Nov 02, 2017 at 04:24 PM
0
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the link.But this all operations does not support with the Join on condition.Like in my example i want first 10 char from my on condition cond.varcond .. i have tried of using substring and cast but it doesn't support here.

0

It does support it

define view demo_cds_join1
  as select from spfli
    inner join   scarr on
      spfli.carrid = left( scarr.carrid, 2)
  { ...
0