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

[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)

[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)

[DavidLY]

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.

[Former Member]

Thanks David. I will give this a go.

[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 [email protected]

[DavidLY]

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