Skip to Content
avatar image
Former Member

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

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 12 at 02:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded