Skip to Content
0

SQ02 joining fields with different data type (Illegal join conditions)

Feb 12 at 12:00 AM

203

avatar image
Former Member

Hi All,
I want to join HRP1000->SOBID (ID of Related Object) to HRP1000A->OBJID (Object ID). This HRP1000A is an alias table for HRP1000.

But because OBJID and SOBID are different data type, I am getting an 'Illegal join conditions' - Message No.AQQIS_CNTRL035 error.

Is there anyway I can join this two fields from these two tables in my infoset query ? Thanks for your help and reply. ( I am pretty new in this area.. so please let me know if you need clarification)

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

1 Answer

David Liu
Feb 12 at 02:22 AM
1

Hello,

Review the workaround solution of KBA:

1911885 - Error: Illegal join conditions with message AQQIS_CNTRL035 when using the query join definition

1. You can create a view in SE11 and link these two tables. Please note this approach does not work for every situation.

2. You can create the Infoset for table A and add table B as "additional table"

3. If you add "additional fields" to the infoset of table A for every field of the table B that you want to use.

These fields have to be filled by own "additional coding", own SELECT- Statements.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks David. I will give this a go.

0
Former Member

I can't access the link ! not sure why ! can it be copy and pasted here please or send me by email to shipu13@hotmail.com

0

Then you can try to check the KBA 1911885 directly from SAP support site.

0