Regarding Select query to select only 1000 records in Internal Table.

[Former Member]

Hello Friends,

Please explain me to how to Select only 1000 records from data base table?

For Example

SELECT * INTO TABLE ITAB OR SELECT * INTO ITAB

FROM EKKO FROM EKKO

WHERE EBLEN IN S_EBLEN. WHERE EBLEN IN S_EBLEN

(Currently i am using) UP TO 1000 ROWS.

ENDSELECT. (I do not want to use)

In this case Internal table may be store more then 1000 records. But i want to select first 1000 records.

Please explain me.

Regards

Amit

[Former Member]

Use Cursors with Packing Size

[Former Member]

Hi Amit,

Try this.

SELECT * INTO table ITAB

FROM EKKO

WHERE EBLEN IN S_EBLEN.

UP TO 1000 ROWS.

Regards,

Vijay

[Former Member]

Hi,

use OPEN CURSOR and CLOSE CURSOR logic and give package size as 1000.

Regards,

Raj Gupta

[sridhar_meesala]

Hi,

TABLES : ekko.

selection-screen begin of block b1 with frame title text_t01.
SELECT-OPTIONS: S_EBELN for ekko-EBELN.
selection-screen end of block b1.

DATA itab TYPE STANDARD TABLE OF ekko.

SELECT *
  FROM ekko
  INTO TABLE itab
  UP TO 1000 ROWS
  WHERE EBELN IN S_EBELN.

Thanks,

Sri.

[Former Member]

SELECT * INTO TABLE ITAB OR SELECT * INTO ITAB

FROM EKKO FROM EKKO

WHERE EBLEN IN S_EBLEN. WHERE EBLEN IN S_EBLEN

UP TO 1000 ROWS.

EXIT.

ENDSELECT.

Put in the EXIT statement and you'll get your first 1000 records only.

[Former Member]

answered