Substring of a column in a join condition of database view

1.7k views Asked by At

I need to create an SAP Database view for EKPO table with some other tables. And need to get EBELN column's first three chars like Substring(EBELN,0,3)

1

There are 1 answers

0
Suncatcher On

No, this is impossible.

Even in CDS views, according to rules for ON operands, user-defined and standard function calls are prohibited:

No path expressions or other expressions or function calls can be specified.