topic Re: internal tables in Application Development and Automation Discussions

internal tables

Former Member — Mon, 24 Nov 2008 03:10:10 GMT

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?

Re: internal tables

Former Member — Mon, 24 Nov 2008 03:42:11 GMT

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

Re: internal tables

Former Member — Mon, 24 Nov 2008 03:47:37 GMT

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

Re: internal tables

Former Member — Mon, 24 Nov 2008 03:51:39 GMT

Hi,

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

Regards,

Chris Gu

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:01:58 GMT

Hello,

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

This will be the better solution.

Thanks.

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:13:17 GMT

MY REQUIREMENT IS DIFFRENT..SELECT + WHERE + UPTO

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:18:56 GMT


> 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' .

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:20:56 GMT

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.

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:23:26 GMT


> 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.

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:30:56 GMT

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.

Re: internal tables

Former Member — Mon, 24 Nov 2008 04:37:31 GMT

Hi,

Use upto

Tks,

Krishna..