Skip to Content
0

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

Aug 11, 2017 at 03:15 AM

53

avatar image
Former Member

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.

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

1 Answer

Horst Keller
Aug 11, 2017 at 06:33 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded