problem with select single statement

[Former Member]

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

[Former Member]

Ya...

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

[Former Member]

Hi,

Try using select single upto 1 row.

Thanks,

Vinod.

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Ya...

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

[RaymondGiuseppi]

So

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

[Former Member]

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

[SuhaSaha]

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

[Former Member]

Hi Krishna,

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

Regards,

Tutun

[Former Member]

Hi

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

[Former Member]

answered..

[Former Member]

hi krishna,

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

thanks

Krishna Dussa