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.