topic Re: join between 2 different field, in Application Development and Automation Discussions

join between 2 different field,

Former Member — Mon, 26 Oct 2009 09:57:52 GMT

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.

Re: join between 2 different field,

Former Member — Mon, 26 Oct 2009 10:07:51 GMT

Hello

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

Re: join between 2 different field,

ThomasZloch — Mon, 26 Oct 2009 10:08:06 GMT

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

Re: join between 2 different field,

Former Member — Mon, 26 Oct 2009 10:14:15 GMT

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

Re: join between 2 different field,

Former Member — Mon, 26 Oct 2009 10:14:35 GMT

Thanks

post close