- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Illegal InfoSet table join
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Illegal InfoSet table join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2007 8:05 PM
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
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2007 8:17 PM
Sorry...Duplicated post -:(
Message was edited by:
Alvaro Tejada Galindo
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2007 8:18 PM
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.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2007 3:43 PM
