topic Re: select into a variable ??? in Application Development and Automation Discussions

select into a variable ???

Former Member — Thu, 22 Nov 2007 11:10:27 GMT

hi i want to do

select xxx from xxx

into variable

for all entries in table

i know i can't do that since puting the data into a variable won't work in for all entries. i tried with up to 1 row or select single but i won't work

plzzz mee urgent help

Re: select into a variable ???

former_member195698 — Thu, 22 Nov 2007 11:14:54 GMT

If your requirement is to select any single record, and as you said its not taking SELECT SINGLE, For entries in the table (used for for all entries ) why don't you try this.

A) Get the first record in the table and then Fire your select single query

B) Loop at the table

Fire Select single query, if it is successful

exit the loop.

endloop.

Re: select into a variable ???

Former Member — Thu, 22 Nov 2007 11:17:22 GMT

Hi,

If u want to put the data into a variable use

Select single FIELDNAME from TABLENAME into variable name

where condition.

Regards,

Vani.

Re: select into a variable ???

former_member404244 — Thu, 22 Nov 2007 11:21:00 GMT

Hi.

Inorder to achieve ur requirement u have to do like this

loop at itab.

select single werks from marc into v_werks

where matnr = itab-matnr.

endloop.

Reward if helpful.

Regards,

Nagaraj

Re: select into a variable ???

Former Member — Thu, 22 Nov 2007 11:22:02 GMT

Select single FIELDNAME from TABLENAME into variable name

where condition.

that's what i say i can't fo cozzz

Select single FIELDNAME from TABLENAME into variable name

for all entries TABLEx

where tablename = table x.

Re: select into a variable ???

Former Member — Thu, 22 Nov 2007 11:22:55 GMT

hi,

select single is working, may be u gave wrong data type

data : m type string.

select single matnr from mara into m.

write: / m.

regards,

pavan

Re: select into a variable ???

Former Member — Thu, 22 Nov 2007 11:23:02 GMT

See this example.....

PARAMETERS p_city TYPE spfli-cityfrom.

TYPES: BEGIN OF entry_tab_type,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

END OF entry_tab_type.

DATA: entry_tab TYPE TABLE OF entry_tab_type,

sflight_tab TYPE SORTED TABLE OF sflight

WITH UNIQUE KEY carrid connid fldate.

SELECT carrid connid

FROM spfli

INTO CORRESPONDING FIELDS OF TABLE entry_tab

WHERE cityfrom = p_city.

SELECT carrid connid fldate

FROM sflight

INTO CORRESPONDING FIELDS OF TABLE sflight_tab

FOR ALL ENTRIES IN entry_tab

WHERE carrid = entry_tab-carrid AND

connid = entry_tab-connid.

Re: select into a variable ???

Former Member — Thu, 22 Nov 2007 11:26:06 GMT

Hi newbie82,

have you given the type for the selection-screen field??

just have a look at this code,

tables: vbak.

data: wa_vbak-vkorg(4).

data: wa_vbak-vbeln type vbak-vbeln.

select-options: s_vbeln for wa_vbak-vbeln.

SELECT single vkorg

INTO wa_vbak-vkorg FROM vbak

WHERE

vbeln in s_vbeln.

WRITE: / wa_vbak-vkorg.

hope this works.

Re: select into a variable ???

Former Member — Fri, 23 Nov 2007 09:32:44 GMT

solve thx