topic Re: select single&select single* in Application Development and Automation Discussions

select single&select single*

Former Member — Thu, 21 Jun 2007 14:48:41 GMT

hai,

i want to know differance b/w select single&select single* please explain me with an example.

Re: select single&select single*

suresh_datti — Thu, 21 Jun 2007 14:50:01 GMT

<a href="https://forums.sdn.sap.com/search!default.jspa?objID=f50">Answer</a>

~Suresh

Re: select single&select single*

Former Member — Thu, 21 Jun 2007 14:57:34 GMT

Hi vikram,

SELECT SINGLE*:

The result of the selection should be a single entry. If it is not possible to identify a unique entry, the system uses the first line of the selection.

DATA wa TYPE spfli.

SELECT SINGLE * FROM sflight INTO wa

WHERE

carrid = 'LH ' AND

connid = '0400' AND

fldate = '20010228'.

FLDATE = '19950228'.

WRITE: / wa-carrid, wa-connid, wa-fldate, seatsfree.

SELECT SINGLE:

Selecting the required fields,instead of selcting all the fields

TYPES:begin of itab,

carrid type sflight-carrid,

connid type sflight-connid,

fldate type sflight-fldate,

seatsfree type sflight-seatsfree,

end of itab.

data:wa type itab.

SELECT SINGLE carrid connid fldate seatsfree FROM sflight INTO wa

WHERE

carrid = 'LH ' AND

connid = '0400' AND

fldate = '20010228'.

FLDATE = '19950228'.

WRITE: / wa-carrid, wa-connid, wa-fldate, seatsfree.

reward points if useful

regards

rami

Re: select single&select single*

Former Member — Thu, 21 Jun 2007 15:00:11 GMT


SELECT *

Gathers all fields from the table....


SELECT FIELD1 FIELD2 FIELD3

You specify which fields you want to gather -;)

Greetings,

Blag.