Skip to Content
0
Former Member
Sep 10, 2007 at 06:54 AM

order--performance

30 Views

Does the below situation will effect performance..order in table is different from query??

in query order:

SELECT bukrs belnr gjahr monat blart bldat budat

cpudt usnam tcode bktxt awkey

INTO TABLE ibkpf FROM bkpf

WHERE bukrs IN bukrs

AND belnr IN belnr

AND gjahr IN gjahr

AND monat IN monat

AND blart IN blart

AND tcode IN tcode.

In the table order:

MANDT key

BUKRS key

BELNR key

GJAHR key

BLART

BLDAT

BUDAT

MONAT

CPUDT

CPUTM

AEDAT

UPDDT

WWERT

USNAM

TCODE