SAP Query - illegal Join condition

[Former Member]

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

[Former Member]

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

[Former Member]

Hello,

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

Thanks,

Augustin.

[Former Member]

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

[Former Member]

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

[Former Member]

Hello Stef,

What is the requirement by the way?

Thanks,

Augustin.

[Former Member]

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

[Pawan_Kesari]

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

[Former Member]

And is there a work around then?

gr,

Stef

[Former Member]

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.

[Former Member]

It worked!

Thanks a lot for answers!

[Former Member]

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?

[Former Member]

This message was moderated.