Skip to Content
avatar image
Former Member

how to join two tables with an extra character in one of the field

Hello.

I'm new to ABAP language and i want to ask how to join two tables with an extra character in one of the fields.

for example lets name those tables tab1 and tab2. tab1 has field that filled with '0001234/abc' but tab2 filled with '0001234/abc/'.

i cant join them with basic inner join because the tab2 has an extra '/' in it. How can i join those 2 tables?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 11, 2017 at 06:33 AM

    If your release is high enough (see the release news in the ABAP documentation in your system), you can use an appropriate SQL expression as LHS of the ON condition.

    Add comment
    10|10000 characters needed characters exceeded