I want to do a JOIN with a Like Operator.
SELECT s~*,t~BUKRS, t~BUTXT FROM smmain as s inner join t001 as t ons~VARIANTE LIKE t~BUKRS into CORRESPONDING FIELDS OF TABLE @et_entitysetwhere UNAME = '755285'.
Unfortunately the Workbench tells me, that only Data type C is allowed for this. Even though, the fields are already data type C.
How can I do this LIKE Operation with table fields?