topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 26 Sep 2007 11:44:47 GMT

hi,

without using the INTO clause how to write a select statement.

i tried like

tables: ekpo.

select ebeln ebelp from ekpo where ebeln = user given ebeln.

but it gives an error message that i have to use into clause.

Is there any other way to go wright with the above select statement.

Regards,

Phyrose.

Re: select statement

Former Member — Wed, 26 Sep 2007 11:47:04 GMT

hi camila,

U r writing Abap code for fetching ebeln and ebelp from ekpo.

Then u have to store it in an internal table.

U cannot go ahead without using INTO clause.

select ebeln ebelp from ekpo into itab where ebeln = user given ebeln.

Pls reward if helpful.

Re: select statement

Former Member — Wed, 26 Sep 2007 11:49:51 GMT

Hi ,

Use single in this query n check and use the table which is defined into tables as in INTO.

give point if helpfull.

Message was edited by:

vikrant shukla1

Re: select statement

former_member404244 — Wed, 26 Sep 2007 11:51:48 GMT

Hi,

u have to do like this..

tables: ekpo.

select single * from ekpo where ebeln = user given ebeln.

reward points if u find useful..

Regards,

Nagaraj

Re: select statement

Former Member — Wed, 26 Sep 2007 11:53:48 GMT

Hi Phyrose ,

If you are specifying the field names then you will have to use into clause , since you dont want to use into clause then you select all the fields from the table using select *.

here is an sample

select single * from ekpo where ebeln = v_ebeln.

Regards

Arun

Re: select statement

Former Member — Wed, 26 Sep 2007 11:56:37 GMT

Hi,

INsted of INTO clause u can go for APPENDING it will append the data into an internal table it_mara

select matnr

werks

from marc

appending table it_mara

up to 10 rows.

Regards

Manikumar

Re: select statement

Former Member — Wed, 26 Sep 2007 12:00:51 GMT

hi,

you are not using single in this statement because of that it needs it_table to store data.

write query as:

tables: ekpo.

select single ebeln ebelp from ekpo where ebeln = user_entry.

Re: select statement

dev_parbutteea — Wed, 26 Sep 2007 12:37:15 GMT

Hi all,

i suppose that the fllowing statement cannot be used in SAP ECC 6.0:

select single ebeln ebelp from ekpo where ebeln = user_entry.

In SAP ECC 6.0, it is mandatory to specify into .

Regards.

Re: select statement

Maciej_DomagaBa — Wed, 26 Sep 2007 14:09:51 GMT

if u don't want INTO definitely u can try with the following syntax:

select .... from ...

endselect.

it's a kind of loop that each pass is processed for each record returned by select

Re: select statement

Former Member — Thu, 27 Sep 2007 06:46:26 GMT

hi camila,

go throuth this code.

tables: vbak.

select single * from vbak where vbeln = user given vbeln.

but if u want to display the data i.e vbeln u should use internal table .

ie..

TABLES: vbak.

DATA: BEGIN OF g_t_itab OCCURS 0,

ebeln LIKE ekpo-ebeln,

ebelp LIKE ekpo-ebelp,

END OF g_t_itab.

SELECT ebeln ebelp FROM ekpo INTO TABLE g_t_itab WHERE ebeln = '4215712'.

LOOP AT g_t_itab.

WRITE:/ g_t_itab-ebeln,

g_t_itab-ebelp.

ENDLOOP.

please reward points if helpfull.

with regards,

radhika kolluru.