Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Former Member

‎08-11-2017 4:15 AM

0 Kudos

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.

1 REPLY 1

horst_keller
Product and Topic Expert
Product and Topic Expert

‎08-11-2017 7: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.