Regarding sql query

Former Member — Fri, 30 Oct 2009 05:43:04 GMT

Hi Guriji,

I want to fetch the data from Mseg and mkpf table based on condion but it will take time. but are the condion we are written it will take lot of time .Plz tell what we are doing for this.

TABLES: mseg, mkpf.

DATA: BEGIN OF T_ITAB OCCURS 0,

MATNR TYPE mseg-MATNR,

WERKS TYPE mseg-WERKS,

BWART TYPE mseg-BWART,

BUDAT TYPE mkpf-BUDAT,

END OF T_ITAB.

START-OF-SELECTION.

SELECT-OPTIONS: plant FOR mseg-WERKS OBLIGATORY.

select a_{matnr a}werks a_{bwart b}budat into t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and a}bwart = '201' or a~bwart = '261' .

COLLECT t_itab INTO t_itab.

endselect.

loop at t_itab.

WRITE:/ t_itab-matnr, t_itab-bwart, t_itab-budat,t_itab-werks.

endloop.

thanks

Re: Regarding sql query

Former Member — Fri, 30 Oct 2009 05:49:14 GMT

Hi Sachin

Avoid SELECT - END SELECT and select records into an internal table.

This will improve performance.

After this you can loop on the resultant internal table and can COLLECT records.

As per my understanding there is not need to use the collect statement. Please check this at your end.

Also , in place of a_{bwart = '201' or a}bwart = '261' use

a~bwart in ( 201, 261 ).

Hope this help you

topic Regarding sql query in Application Development and Automation Discussions

Regarding sql query

Re: Regarding sql query