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: 

SQVI - Join tables using similar fields (but not same)

Go to solution
Former Member

‎10-16-2008 3:12 PM

0 Kudos

Hi folks!

I would like to know if there is a way to do a join between two tables thru fields that are similar but not exactly the same. For example, I need to join tables EKKO and CDHDR, where the PO numbers do exist in both the tables (EKKO-EBELN and CDHDR-OBJECTID), but the fields are different. Is it possible to achieve such kind of a join?

Appreciate your help.

Regards,

Anwar.

1 ACCEPTED SOLUTION

Go to solution
JozsefSzikszai
Active Contributor

‎10-16-2008 3:19 PM

0 Kudos

if the length of the fields are different (which I believe is the case now), than it is not possible.

3 REPLIES 3

Go to solution
JozsefSzikszai
Active Contributor

‎10-16-2008 3:19 PM

0 Kudos

if the length of the fields are different (which I believe is the case now), than it is not possible.

Go to solution
Former Member
In response to JozsefSzikszai

‎10-16-2008 3:24 PM

0 Kudos

Thanks for your response Eric. Yes the two fields have different lengths, though their data type is the same (CHAR). One of the fields length is 10, whereas the other is 90.

Edited by: Mohammad Anwar on Oct 16, 2008 4:25 PM

Go to solution
JozsefSzikszai
Active Contributor
In response to JozsefSzikszai

‎10-16-2008 3:28 PM

0 Kudos

> 

 though their data type is the same (CHAR).

unfortunately it is not enough... You have to select separately from the two tables and merge the data somehow in the program.