topic Re: select in Application Development and Automation Discussions

select

Former Member — Thu, 25 Oct 2007 06:08:11 GMT

Hi Experts,

Can we use FOR ALL ENTRIES option and inner join in one select query?

If so can any body let me know the example?

Will it effect to performance?because some times it may needed.

Regards

Re: select

Former Member — Thu, 25 Oct 2007 06:10:01 GMT

Hi,

Yes you can use both into a single query.

Performance wont be affected.


SELECT c~carrname p~connid f~fldate 
       INTO CORRESPONDING FIELDS OF TABLE itab 
       FOR ALL ENTRIES IN IMAIN
       FROM ( ( scarr AS c 
         INNER JOIN spfli AS p ON p~carrid   = c~carrid 
                              AND p~cityfrom = IMAIN-CITYFROM 
                              AND p~cityto   = IMAIN-CITYTO ) 
         INNER JOIN sflight AS f ON f~carrid = p~carrid 
                                AND f~connid = p~connid ).

Best regards,

Prashant

Re: select

Former Member — Thu, 25 Oct 2007 06:12:59 GMT

see the following query...

SELECT crmd_link~guid_hi

bbp_pdacc~set_guid

bbp_pdacc~acc_no

bbp_pdacc~acc_cat

bbp_pdacc~g_l_acct

bbp_pdacc~dist_ind

bbp_pdacc~distr_perc

bbp_pdacc~dist_quan

bbp_pdacc~cost_ctr

bbp_pdacc~wbs_elem_e

bbp_pdacc~order_no

FROM bbp_pdacc INNER JOIN crmd_link

ON bbp_pdacc_{set_guid EQ crmd_link}guid_set

INTO CORRESPONDING FIELDS OF TABLE t_acc_asg

FOR ALL ENTRIES IN t_item_data

WHERE crmd_link~guid_hi EQ t_item_data-guid.

Re: select

former_member386202 — Thu, 25 Oct 2007 06:13:02 GMT

Hi,

Yes we can use both in one query.

ex.

SELECT a~vbeln "Billing document

a~fkdat "Billing date

a~fktyp "Billing category

a~fkart "Billing type

a~vtweg "Distribution channel

a~knumv "Number of doc condition

b~posnr "Billing item

b~matnr "Material Number

b~werks "Plant

b~vgbel "Referance

b~kzwi2 "Subtotal 2

b~wavwr "Cost in document currency

c~kunnr "Partner function

FROM vbrk AS a

INNER JOIN vbrp AS b

ON a_{vbeln EQ b}vbeln

INNER JOIN vbpa AS c

ON b_{vbeln EQ c}vbeln

INTO CORRESPONDING FIELDS OF TABLE it_vbrp

for all entries in it_vbak

WHERE

AND parvw EQ 'ZS'.

regards,

Prashant

Re: select

Former Member — Thu, 25 Oct 2007 06:27:14 GMT

HI Ravi,

Better to use only for all entries. If it is need definately, then only use both because If u use both performancewise it's not good.

This is some simple select query.

SELECT A~MBLNR

A~BWART

A~DMBTR

A~EBELN

A~EBELP

B~BUDAT

FROM MSEG AS A INNER JOIN MKPF AS B

ON A_{MBLNR = B}MBLNR and A_{MJAHR = B}MJAHR

INTO TABLE IT_MSEG

FOR ALL ENTRIES IN IT_EKPO

WHERE EBELN = IT_EKPO-EBELN.

Thanks and Regards,

Surya

Re: select

Former Member — Thu, 25 Oct 2007 06:33:03 GMT

Hi Ravi,

Yes, we can use FOR ALL ENTRIES option and INNER JOIN in one select query.

Example is as follows:

TABLES: MARA , MAKT.

TYPES: BEGIN OF GS_DATA,

MATNR TYPE MARA-MATNR,

END OF GS_DATA,

BEGIN OF GS_DATA1,

MATNR TYPE MARA-MATNR,

MAKTX TYPE MAKT-MAKTX,

WERKS TYPE MAKG-WERKS,

END OF GS_DATA1.

DATA: ITAB1 TYPE STANDARD TABLE OF GS_DATA,

WA1 LIKE LINE OF ITAB1,

ITAB2 TYPE STANDARD TABLE OF GS_DATA,

WA2 LIKE LINE OF ITAB2.

START-OF-SELECTION.

SELECT MATNR INTO CORRESPONDING FIELDS OF TABLE ITAB1 FROM MARA.

SELECT A_{MATNR A}MAKTX B~WERKS

FROM ( MAKT AS A INNER JOIN MAKG AS B

ON A_{MATNR = B}MATNR )

INTO CORRESPONDING FIELDS OF TABLE ITAB2

FOR ALL ENTRIES IN ITAB1

WHERE A~MATNR = ITAB1-MATNR.

No,it does not affect the performance and you can use it wherever required.

Thanks and Regards,

Shilpi

Re: select

Former Member — Thu, 25 Oct 2007 06:41:15 GMT

Hi all,

Thanks