topic Re: problem with select single statement in Application Development and Automation Discussions

problem with select single statement

Former Member — Thu, 15 Apr 2010 13:54:59 GMT

Hi ,

I am debugging one z program..

Though Select Single statement is there, it is fetching 4 th record from standard data base table ..

can any one help me on this...

Re: problem with select single statement

Former Member — Thu, 15 Apr 2010 13:58:01 GMT

Hi,

Try using select single upto 1 row.

Thanks,

Vinod.

Re: problem with select single statement

Former Member — Thu, 15 Apr 2010 14:03:53 GMT

I am nt supposed to change the code..Just I am analysing the data..

Re: problem with select single statement

RaymondGiuseppi — Thu, 15 Apr 2010 14:09:45 GMT

If you do not give the full key list or a sort criterion there is no guarantee relative to the order of the records returned by a SELECT statement in Open SQL, neither for the choice of a record in a SELECT SINGLE.

Regards,

Raymond

Re: problem with select single statement

Former Member — Thu, 15 Apr 2010 14:11:50 GMT

Ya...

In that Select single statement, in where condition they dont have mentioned primary key ....

Re: problem with select single statement

RaymondGiuseppi — Thu, 15 Apr 2010 14:13:43 GMT

Open SQL/SQLJ does not allow to process the result set of a SELECT * in a single-row query. The reason is that Open SQL does not guarantee the order of the columns. It may be different at runtime and at design time.

Regards,

Raymond

Moderator message - next time, please note where you are quoting from (help.sap.com here)

Edited by: Rob Burbank on Apr 15, 2010 2:11 PM

Re: problem with select single statement

Former Member — Thu, 15 Apr 2010 18:06:48 GMT

Select single should be use if you have full primary keys else use select up to one rows.

Re: problem with select single statement

SuhaSaha — Thu, 15 Apr 2010 18:37:47 GMT

To add to Raymond's explanation:

If SELECT SINGLE selects more than one line from the database, the first line that is found is entered into the resulting set

(source: [http://help.sap.com/abapdocu_70/en/ABAPSELECT_CLAUSE_LINES.htm])

And the first record found by the SELECT query might not be 4th record of the DB table. Also note that the table records you see in SE16 are sorted & at the actual DB level the order of records might be different.

BR,

Suhas

Re: problem with select single statement

Former Member — Fri, 16 Apr 2010 05:16:28 GMT

Hi Krishna,

Use select single if you get all the primary key in where cluse, otherwise use select upto 1 rows.

Regards,

Tutun

Re: problem with select single statement

Former Member — Fri, 16 Apr 2010 06:26:33 GMT

Use this SELECT FLD1 FLD2 ELD3 FLD4 FROM Tab INTO ITAB where <Condition> ,

might be because you are selecting lot of data , so hav to use Where condition . try it out , also chk the same fields are define in internal table , and chk the order also , u ll get

Regards

Sarath P G

Re: problem with select single statement

Former Member — Wed, 12 May 2010 15:14:27 GMT

answered..

Re: problem with select single statement

Former Member — Wed, 12 May 2010 17:53:03 GMT

hi krishna,

pass all the primary key fields in the select single statement....

thanks

Krishna Dussa