topic wanted select query in Application Development and Automation Discussions

wanted select query

Former Member — Tue, 15 May 2007 13:43:40 GMT

can anyone please send select query for

join statement with for all entries command

Re: wanted select query

Former Member — Tue, 15 May 2007 13:47:20 GMT

Hi,

Check the code for JOIN statement....

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

Re: wanted select query

Former Member — Tue, 15 May 2007 13:49:51 GMT

if not itab1[] is initial.

select a~matnr 
          b~maktx 
          into table itab
          from mara as a inner join 
                 makt as b on
                 a~matnr eq b~matnr
                 for all entries in itab1
                 where a~matnr rq itab1-matnr.

endif.

Re: wanted select query

Former Member — Tue, 15 May 2007 13:52:27 GMT

Hi,

Here is a sample query which i have been used

select matnr maktr from makt into table it_table for all entries in it_mara where matnr = it_mara-matnr.

Reward if useful

Re: wanted select query

Former Member — Wed, 16 May 2007 05:47:34 GMT

hai arun,

SELECT carrid connid cityfrom cityto

INTO CORRESPONDING FIELDS OF line

FROM spfli

FOR ALL ENTRIES IN itab

WHERE cityfrom = itab-cityfrom AND cityto = itab-cityto.

regards,

kavitha.

Re: wanted select query

Former Member — Wed, 16 May 2007 06:12:37 GMT

good

go through this

SELECT likp_{vbeln likp}lifex likp_{bldat likp}wadat likp_{wadat_ist likp}kodat likp~lfart

likp_{kunnr likp}vstel lips_{posnv lips}lfimg lips_{vrkme lips}lgmng lips~meins

lips_{werks lips}lgort lips_{charg lips}vbelv lips_{posnr lips}matnr

lips_{vbeln LIPS}VGBEL LIPS_{VGPOS vbup}kosta vbup_{wbsta vbup}posnr vbup~vbeln

VBAK_{IHREZ VBAK}VBELN VBAP~VBELN

INTO CORRESPONDING FIELDS OF TABLE it_itab

FROM ( likp

INNER JOIN lips

ON lips_{vbeln = likp}vbeln

INNER JOIN vbup

ON vbup_{posnr = lips}posnr

and VBUP_{VBELN = LIPS}VBELN )

left outer join VBAK
on VBAK_{VBELN = LIPS}VGBEL
inner join VBAP
on VBAP_{VBELN = VBAK}VBELN )

WHERE likp~vbeln IN so_vbeln

AND likp~lifex IN so_lifex

AND likp~lfart IN so_lfart

AND likp~kunnr IN so_kunnr

AND likp~vstel IN so_vstel

AND likp~bldat IN so_bldat

AND likp~wadat_ist IN so_wadat

AND vbup~kosta IN so_kosta

AND vbup~wbsta IN so_wbsta

AND LIPS~LFIMG NE 0.

SELECT VBELN IHREZ INTO TABLE T_VBAK

FROM VBAK

FOR ALL ENTRIES IN IT_ITAB

WHERE VBELN = IT_ITAB-VGBEL.

thanks

mrutyun^