Skip to Content
0
Former Member
Dec 10, 2008 at 09:35 AM

Regarding select statement in a standard report

160 Views

Hi all,

Please see the following select statement from standard report RM07DOCS.

select (g_t_fields)

into corresponding fields of table itab

from mkpf inner join mseg

on mkpfmandt = msegmandt

and mkpfmblnr = msegmblnr

and mkpfmjahr = msegmjahr

WHERE MKPF~BUDAT in BUDAT

and MSEG~BWART in BWART

and MSEG~CHARG in CHARG

and MSEG~KUNNR in KUNNR

and MSEG~LGORT in LGORT

and MSEG~LIFNR in LIFNR

and MSEG~MATNR in MATNR

and MSEG~SOBKZ in SOBKZ

and MKPF~USNAM in USNAM

and MKPF~VGART in VGART

and MSEG~WERKS in WERKS

and MKPF~XBLNR in XBLNR

%_HINTS

ORACLE '&SUBSTITUTE VALUES&'.

Can anybody tell me the purpose of writing the last two lines of the above statement and let me know whether it helps in improving the performance of the select statement.

please explain.

Thanks in advance.