topic Re: JOIN on internal table in Application Development and Automation Discussions

JOIN on internal table

Former Member — Tue, 20 Feb 2007 19:38:18 GMT

Hi can any body give me a sample code on joining 2 internal tables having the common field.

thanks in advance

Re: JOIN on internal table

Former Member — Tue, 20 Feb 2007 19:49:39 GMT

Hi,

Check this example..

I am joining the internal table where VBELN is the common field..

DATA: ITAB_VBAK LIKE VBAK OCCURS 0 WITH HEADER LINE.

DATA: ITAB_VBAP LIKE VBAP OCCURS 0 WITH HEADER LINE.

DATA: V_TABIX TYPE SYTABIX.

SORT ITAB_VBAP BY VBELN.

LOOP AT ITAB_VBAK.

READ TABLE ITAB_VBAP TRANSPORTING NO FIELDS

WITH KEY VBELN = ITAB_VBAK-VBELN

BINARY SEARCH.

IF SY-SUBRC = 0.

Store the row number.

V_TABIX = SY-TABIX.

LOOP AT ITAB_VBAP FROM V_TABIX.

Exit condition for the loop.

IF ITAB_VBAK-VBELN <> ITAB_VBAP-VBELN.

EXIT.

ENDIF.

ENDLOOP.

ENDIF.

ENDLOOP.

Thanks,

Naren

Re: JOIN on internal table

Former Member — Tue, 20 Feb 2007 19:49:47 GMT

Hi KP,

There wr no joins on internal tables. You have to use loop-read-endloop.

loop at itab.

read table itab2 with key field1 = itab-field1.

if sy-subrc = 0.

move itab-field1 = itab_final-field1.

move itab2-field2 = itab_final-field2.

append itab_final.

clear itab_final.

endif.

endloop.

Regards,

Ravi

Re: JOIN on internal table

Former Member — Tue, 20 Feb 2007 19:54:40 GMT

It is only possible through LOOPs and READ WITH KEY.

If you are expecting to use SQL JOINS on internal tables, then this is not possible as ABAP follows OPEN SQL.

Thanks,

Santosh

Re: JOIN on internal table

Former Member — Wed, 21 Feb 2007 06:57:08 GMT

Hi,

SELECT A_{EQUNR B}DATAB B_{ILOAN C}SWERK

INTO TABLE ITEQ

FROM ( EQUI AS A INNER JOIN EQUZ AS B

ON A_{EQUNR = B}EQUNR ) INNER JOIN ILOA AS C

ON B_{ILOAN = C}ILOAN

WHERE A~EQART = 'ESTPL'

AND B~IWERK = 'M011'

AND B~INGRP = 'SLM'

AND B_{DATAB GE SDATE-LOW AND B}DATAB LE SDATE-HIGH

AND C~SWERK IN S_WERK.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: JOIN on internal table

Former Member — Wed, 21 Feb 2007 06:59:02 GMT

a simple select statement:

SELECT a_{mvgr3 b}bezei

FROM tvm3 AS a INNER JOIN tvm3t AS b

ON a_{mvgr3 = b}mvgr3

INTO TABLE lt_tab

WHERE b~spras = 'EN'.

regards,

naren

Re: JOIN on internal table

Former Member — Wed, 21 Feb 2007 07:09:05 GMT

Hi,

s_werks for mvke-dwerk obligatory. " Plant

select marc_{matnr marc}werks marc_{disgr mbew}salk3

into table t_marc

from marc join mbew on ( mbew_{bwkey = marc}werks and

mbew_{matnr = marc}matnr )

where werks in s_werks.

For mor info

http://goldenink.com/abap/select_statements.html

regards

Shiva