topic Re: Select in Application Development and Automation Discussions

Select

Former Member — Tue, 20 May 2008 07:38:12 GMT

Hi all

I have a report as mentioned below.But i want to select only the first 2 record from the table without using control-break statments.Please help.

Vijay

Re: Select

Former Member — Tue, 20 May 2008 07:41:16 GMT

Hi,

Use PACKAGE SIZE.

SELECT *
        INTO TABLE (internal table)
        FROM (Standard table)
             PACKAGE SIZE 2
       WHERE (Condition).
       ENDSELECT.

Regards

Kannaiah

Re: Select

Former Member — Tue, 20 May 2008 07:45:09 GMT

select * from <table> into table itab upto 2 rows ...

Re: Select

Former Member — Tue, 20 May 2008 08:33:44 GMT

Hi,

Use like this

select * from mara into it_mara

up to 1 rows

where matnr = '000000000100000174'.

append it_mara.

endselect.

If its useful reward points

Re: Select

rainer_hbenthal — Tue, 20 May 2008 08:47:37 GMT

In a relational database no "first" record exists. first second last is only relevant if you do a sorting. Just using package size or up to n rows is not sufficient, you need a sort to tell if you need the two actual values (sorting by date) or whatever. Without having a sort in the select clause you can not assure what values are the first ones.