topic Re: Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Tue, 03 Jul 2007 03:20:39 GMT

Hi,

I need to join two tables VBEP and LIPS using fields VBELN , POSNR in VBEP and

VGBEL and VGPOS from LIPS

Help me to sort out the problem.

Regards,

Vimal

Re: Inner Join

Former Member — Tue, 03 Jul 2007 04:17:38 GMT

Hi,

Select <fldfrom_vbep_and_lips>
into table itab
from vbep
inner join vbap on vbep-vbeln = vbap-vbeln and vbepposnr = vbap-posnr
inner join lips on vbap-vbeln = lips-vgbel and vbap-posnr = lips-vgpos
where <condition>.

For this create a itab with same as filed list and type.

Jogdand M B

Re: Inner Join

mohammed_moqeeth — Tue, 03 Jul 2007 04:24:06 GMT

Hello Vimal,

Please find the below code to join VBEP & LIPS:

Hi Vimal,

Please find the below code for joining VBEP & LIPS:

TABLES: vbep, lips.

DATA: BEGIN OF itab OCCURS 0,

vbeln TYPE vbeln,

posnr TYPE posnr,

vgbel TYPE vgbel,

vgpos TYPE vgpos,

END OF itab.

SELECT-OPTIONS: s_vbeln FOR vbep-vbeln.

SELECT vbep~vbeln

vbep~posnr

lips~vgbel

lips~vgpos

INTO CORRESPONDING FIELDS OF TABLE itab

FROM vbep INNER JOIN lips

ON vbep_{vbeln = lips}vbeln AND

vbep_{posnr = lips}posnr

WHERE vbep~vbeln IN s_vbeln.

LOOP AT itab.

WRITE:/ itab-vbeln,

itab-posnr,

itab-vgbel,

itab-vgpos.

ENDLOOP.

Reward Points..for all helpful answers.

Moqeeth.