Community
Application Development and Automation 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: 
Read only

Illegal InfoSet table join

Former Member

‎2007 Jun 13 8:05 PM

0 Likes
822

Hi All,

I am trying to join 2 tables AEOI and MARA by material number in SQ02 however the join is illegal because the material number in AEOI is an object. I have looked in EAOI as a logical database and am unable to find the material number. Does anyone know of a way to join these 2 tables within SQ02 using some simple ABAP code or similar method?

Many thanks in advance

Hi All,

I am trying to join 2 tables AEOI and MARA by material number in SQ02 however the join is illegal because the material number in AEOI is an object. I have looked in EAOI as a logical database and am unable to find the material number. Does anyone know of a way to join these 2 tables within SQ02 using some simple ABAP code or similar method?

Many thanks in advance

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Jun 13 8:17 PM

0 Likes
711

Sorry...Duplicated post -:(

Message was edited by:

Alvaro Tejada Galindo

Read only

Former Member

‎2007 Jun 13 8:18 PM

0 Likes
711

The problem is that in AEOI the field for material is 40 lenght while in MARA is 18 lenght....For INNER JOINS, the length of both fields must the same....

I'm not good at querys, so can't help you....

Greetings,

Blag.

Read only

Former Member
In response to Former Member

‎2007 Jun 14 3:43 PM

0 Likes
711

Thanks Alvaro, we are already aware of this.