internal tables

[Former Member]

how can i restrict the no of records to 1000 in an internal table?

can i use upto n rows clause in SELECT statement with WHERE clause?

[Former Member]

Hi

option1:

You can use Select up to n rows.

Option2:

You can use select with packet size 1000 once you see their are 1000 entries in your table.

Option3:

Select reocrds in an internal table and then filter it out for first 1000 reocrds by looping.

Option 1 is them most prefered one in your case.

Regards

Neha

[Former Member]

Hi Vamsi,

You can use to restrict the internal table by UP TO 1000 ROWS.

SELECT * FROM MARA
INTO TABLE IT_MARA
UP TO 1000 ROWS.

Thanks,

Chidanand

[Former Member]

Hi,

If you don't need to do other conditions, you can use up to 1000 rows in the select statement.

Regards,

Chris Gu

[Former Member]

Hello,

You can use the select statement with option UPTO 1000 Rows.

This will be the better solution.

Thanks.

[Former Member]

MY REQUIREMENT IS DIFFRENT..SELECT + WHERE + UPTO

[Former Member]

>

> MY REQUIREMENT IS DIFFRENT..SELECT + WHERE + UPTO

It will work.Did you try ?

REPORT  ZVAMSI.
data:i_mara TYPE STANDARD TABLE OF mara.
SELECT * from mara into TABLE i_mara UP TO 1000 rows where AENAM = 'JONY' .

[Former Member]

Hi,

select kunnr

from kna1

into table it_kna1

where kunnr GE '100'.

loop at it_kna1 into wa_kna1 up to 1000 rows.

write : / wa_kna1-kunnr.

endloop.

[Former Member]

>

> Hi,
>      select kunnr
>               from kna1
>              into table it_kna1
>              where kunnr GE '100'.
> 
> loop at it_kna1 into wa_kna1 up to 1000 rows.
> write : / wa_kna1-kunnr.
> endloop.

Looks like your Syntax check is turned off.

[Former Member]

Hi,

select kunnr

from kna1

into table it_kna1

where kunnr GE '100'.

loop at it_kna1 into wa_kna1 up to 1000 rows.

write : / wa_kna1-kunnr.

endloop.

[Former Member]

Hi,

Use upto

Tks,

Krishna..