join between 2 different field,

[Former Member]

Hi to everybody

I should join the table EQUI and AUSP. Below the code, but I get a mistale because the fileds 'objek' and 'equnr 'don't have same type and same lenght.

Theare are some techique to find the solution?

*joi between equi and ausp

SELECT * FROM ausp

INTO CORRESPONDING FIELDS OF lt_asup

FOR ALL ENTRIES IN lt_equi

WHERE objek = lt_equi-equnr.

APPEND lt_asup.

ENDSELECT.

Thanks a lot in advance.

[Former Member]

Hello

Try to use field EQUI-CUOBJ instead of EQUI-EQUNR.

[ThomasZloch]

You could add a helper field in lt_equi with the format of ausp-objek and fill this with the equnr values before the selection.

Thomas

[Former Member]

Hi,

I just saw the tables EQUI and AUSP.

The field OBJEK in table AUSP is Char of length 50.

The field EQUNR in table EQUI is Char of length 18.

According to your code you would have already selected the EQUI-EQUNR in an internal table. Now move these entries to another internal table with a field EQUNR which is declared as Char of length 50.

Now when you use your select statement both the fields would have the same type and length.

Hope this helps.

Thanks,

Harini

[Former Member]

Thanks

post close