topic Re: SAP Query - illegal Join condition in Application Development and Automation Discussions

SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 12:40:59 GMT

Hello,

I am building a report in SAP QUERY by joining together 3 tables. For one field I have an illigal join condition. After analysis I think this is due to the fact that the CHAR lenght of the field in the first table is 18 and the CHAR lenght of the field in the second table is 35.

Questions:

1 Is it possible that this is the reason for my illegal join condition?

2 How can it be solved? Can I overwrite the lenght 'CHAR' in SAP QUERY?

thanx,

Stef

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 12:48:08 GMT

Hello,

This should not be the reason for join. best way you can paste your join query here.

Thanks,

Augustin.

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 12:48:25 GMT

Hi,

Before joining the tables, check whether any common fields are present in the tables so that they can be joined based on those fields.

Go to table DD03L and check for the key fields of both the tables and accordingly go for join

Regards,

Shamma

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 13:15:25 GMT

All,

I tried the table DD03L. I did find an other table where my field had also 35 characters, but I couldn't work with that one, due to the fact that I couldn't link some fields.

Problem remains the same... Any other ideas? Is there perhaps a button to manually overwrite?

But already thanx a lot for help, table suggested is certainly helpful

Stef

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 13:18:14 GMT

Hello Stef,

What is the requirement by the way?

Thanks,

Augustin.

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 13:20:36 GMT

Augustun,

They would like to have detail about the payment transactions set up for a business partner together with the recipient banck chain data.

It is for a master data report

gr,

Stef

Re: SAP Query - illegal Join condition

Pawan_Kesari — Fri, 21 Aug 2009 13:21:22 GMT

In sap query or SQVI join is only possible if both fields have same data type and length.

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 13:22:26 GMT

And is there a work around then?

gr,

Stef

Re: SAP Query - illegal Join condition

Former Member — Fri, 21 Aug 2009 15:11:03 GMT

Hello Stef,

The one possible workaround I can see is creating view on these table.

Other one I think of computing JOIN manually using two different select statement as follow:

1. Get the base data from first table (only select key columns)

2. Use base table in for all entries and select data for second table into internal table

3. Use table created in 2nd select in for all entries and select data from 3rd table.

From performance point of you all select select except base should be executed with FOR ALL ENTRIES

Select only required and key fields.

Internal table you are going to use for selecting data from database tables should contain all the fields involved in JOIN

Check if this can help!

Thanks,

Augustin.

Re: SAP Query - illegal Join condition

Former Member — Mon, 24 Aug 2009 08:18:30 GMT

It worked!

Thanks a lot for answers!

Re: SAP Query - illegal Join condition

Former Member — Wed, 08 Oct 2014 13:44:55 GMT

Hello dear Snyers,

I have the same problem as you had but I couldn't understand the solution steps.
Can you explain these steps in detail?

Re: SAP Query - illegal Join condition

Former Member — Mon, 27 Jul 2015 12:18:12 GMT

This message was moderated.