topic Re: Table joins?? in Application Development and Automation Discussions

Table joins??

Former Member — Sat, 02 Sep 2006 08:54:55 GMT

Hello Everyone,

Wat is the code for the table join using <u>for all entries</u> statement?how do v join 6 tables using using the above statement...?

Thanking u in anticipation.

Regards,

Sirisha.

Re: Table joins??

Former Member — Sat, 02 Sep 2006 09:21:53 GMT

Please check the same code.

select a_{f1 b}f1 c_{f1 d}f1 e_{f1 g}f1

into table itab

for all entries in ixyz

from a inner join b on a_{f1 = B}f1....etc

Regards

Anurag

Re: Table joins??

Former Member — Sun, 03 Sep 2006 01:57:30 GMT

Hi Sirisha,

You can use the join and for all entries as shown below in the example.

check not t_materials2[] is initial.
sort t_materials2 ascending by matnr werks.
 
SELECT b~matnr b~mtvfp b~werks
       b~dismm b~beskz b~plifz b~disgr
       c~pstat c~mtart c~brgew c~normt z~mtpos
    INTO CORRESPONDING FIELDS OF TABLE t_materials
        FROM marc AS b 
           INNER JOIN mara AS c 
              ON a~matnr = c~matnr
           INNER JOIN mvke AS z
              ON a~matnr = b~matnr 
                 FOR ALL ENTRIES IN t_materials2
                    WHERE b~matnr EQ t_materials2-matnr
                    AND b~werks EQ t_materials2-werks
                    AND b~stawn IN s_stawn
                    AND b~disgr IN s_disgr
                    AND b~mmsta EQ '03'
                    AND c~mtart IN s_mtart
                    AND z~vkorg EQ p_vkorg
                    AND z~vtweg EQ p_vtweg
                    AND z~mtpos IN s_mtpos.

Cheers