Skip to Content
0
Former Member
Feb 07, 2012 at 04:45 PM

Please explain this behaviour of blank Ranges

1981 Views

Need some light on using blank ranges in select queries for full key. I know they improve performance...just need to know how because I can't explain it when people ask me how!!!

Or are there any unwanted effects that can't just be spotted by naked eye

For ex.

SELECT VBELN FROM VBAK INTO TABLE IT_VBAK UP TO 1000 ROWS.

GET RUN TIME FIELD START.

  SELECT * FROM VBAP
    INTO TABLE IT1
      FOR ALL ENTRIES IN IT_VBAK
        WHERE VBELN = IT_VBAK-VBELN.

GET RUN TIME FIELD STOP.

ONE = STOP - START.
CLEAR: START, STOP.

GET RUN TIME FIELD START.


  SELECT * FROM VBAP
    INTO TABLE IT2
      FOR ALL ENTRIES IN IT_VBAK
        WHERE VBELN = IT_VBAK-VBELN
          AND POSNR IN R_POSNR.

GET RUN TIME FIELD STOP.

TWO = STOP - START.

I got

ONE = 8.

TWO = 3.