Select Single

Former Member — Thu, 04 Jan 2007 06:25:04 GMT

I am making a query using sq02.

Select Single * from TSP02

where PJFINAHERR = 1.

<b>IF SY-SUBRC = 0.

myvariable = PJIDENT. 'Primary Key

ENDIF.

</b>

thats the short code.

but after testing the query it outputs multiple but same data.

it outputs:

13229

and so on and so forth.

could you pls. advise?

Thank you in advance.

Re: Select Single

Former Member — Thu, 04 Jan 2007 06:31:02 GMT

see demo code -

tables tsp02.

data myvariable like tsp02-pjident.

Select Single * from TSP02

where PJFINAHERR = 1.

IF SY-SUBRC = 0.

myvariable = tsp02-PJIDENT.

ENDIF.

write: myvariable.