Join 2 tables based on a pattern in graphical calculation views

[former_member404189]

I have a scenario where i have to join the table RBKP and SWWWIHEAD.

pass RBKP.BELNR to SWWWIHEAD.WI_TEXT as SWWWIHEAD.WI_TEXT=*BELNR*

eg: BELNR=5600101,WI_TEXT=abcd5600101xyz.

I know this is possible in scripted calculation view using "LIKE",But is there any possibility to achieve the same in graphical calculation view?

Thanks in advance.

[former_member607745]

It is not possible while joining two tables graphically.Alternatively try creating a calculated column using SUBSTR("SWWWIHEAD.WI_TEXT",5,11) and then join this column further with BELNR.

However this might give a performance issue because as per the standard rules ,no join should happen on calculated columns.