topic select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 03 Jul 2008 06:17:10 GMT

Hello ,

Is it true that select single statement select single field from the database table . i want to confirm this i have read some where, that select sinlge can fetch single field from the database table.

regards

Fozia

Re: select statement

Former Member — Thu, 03 Jul 2008 06:19:14 GMT

Re: select statement

Former Member — Thu, 03 Jul 2008 06:19:43 GMT

it does not select the single field but the entire line or the fileds as mentioned by you....

Re: select statement

Former Member — Thu, 03 Jul 2008 06:21:06 GMT

HI ,

Select single selects single row of data from database table .

If give you single * from from vbak where something .

In will select single row of into the wa with all fields of table vbak .

If specify some fields it will select those fields only.

Please reward if useful.

Re: select statement

Former Member — Thu, 03 Jul 2008 06:21:09 GMT

Select single fetches one record from the data base not single field

In case of any queries you can revert back

Regards

Hitesh

Re: select statement

Former Member — Thu, 03 Jul 2008 06:21:57 GMT

Hi,

Select Single selects a single record from database table .

there can be any number of fields.

Best regards,

Brijesh

Re: select statement

Former Member — Thu, 03 Jul 2008 06:26:47 GMT

if you use SELECT SINGLE MATNR

then it will fetch the only MATNR filed value that to single value which u give in where condition

it will search in the data base if the record found in the 1st line it self it won't go for the further selection and gives directly

SELECT SINGLE means hit the data base and get the 1st record which satisfies the where condition

Re: select statement

Former Member — Thu, 03 Jul 2008 06:34:49 GMT

Hi Hitesh,

actually i am preparing for the certification. in one of the practise papers, the answers r given like that i'll type the question

select single can

1. select single record from the database table

2. " " internal ".

3. " " field " database ".

4. " " intranal ".

n the answers r given as 1, 3.

thnx

regards

Fozia

Re: select statement

Subhankar — Thu, 03 Jul 2008 06:41:01 GMT

select single can

1. select single record from the database table

2. " " internal ".

3. " " field " database ".

4. " " intranal ".

Your answer is 1(select single record from the database table)

It select one record not one field

Re: select statement

Former Member — Thu, 03 Jul 2008 06:48:26 GMT

Hi,

you can use it to fetch a single record or single vlaue depending on the select statement you write.

SELECT SINGLE fieldname INTO l_var From DTAB WHERE fieldname EQ po_field.

This statement wil get single value,This is mainly used for validation purpose.

*SELECT SINGLE * From Dtab into Itab where fieldname EQ po_field.*

This statement wil get a single Record.

Regards,

Raj.