Skip to Content
0
Jun 10, 2009 at 02:00 AM

Performance issue ?

34 Views

I have a question sequence of field in select statement is impact with performance or not ? Please see the two select statement as below.

DATA: l_bukrs TYPE bkpf-bukrs,

l_belnr TYPE bkpf-belnr,

l_gjahr TYPE bkpf-gjahr,

l_blart TYPE bkpf-blart.

PARAMETERS: p_bukrs TYPE bkpf-bukrs,

p_belnr TYPE bkpf-belnr,

p_gjahr TYPE bkpf-gjahr.

SELECT bukrs belnr gjahr blart

INTO (l_bukrs,l_belnr,l_gjahr,l_blart)

FROM bkpf

WHERE bukrs = p_bukrs

AND belnr = p_belnr

AND gjahr = p_gjahr.

ENDSELECT.

  • This select statement is low performance if comparing with above select statement

SELECT blart gjahr belnr bukrs

INTO (l_blart,l_gjahr,l_belnr,l_bukrs)

FROM bkpf

WHERE bukrs = p_bukrs

AND belnr = p_belnr

AND gjahr = p_gjahr.

ENDSELECT.