topic Re: select single in Application Development and Automation Discussions

select single

Former Member — Thu, 15 May 2008 08:48:04 GMT

I am selecting vbeln and fkart from vbrk, since vbeln is a key field i will fetch a single record

I use

select single vbeln fkart from vbrk where ....

How do I use the values vbrk-vbeln and vbrk-fkart for further processing, can I use into clause here?

Re: select single

Former Member — Thu, 15 May 2008 08:49:19 GMT

Hi,

types: begin of t_itab,

vbeln like vbrk-vbeln,

fkart like vbrk-fkart,

end of t_itab.

data: itab type table of t_itab, " internal table

wa_itab type t_itab. " work area

Selecting single field depending on the indexes vbeln and fkart into the work area.

select single vbeln fkart

from vbrk

into wa_itab

where vbeln = vbrk-vbeln

and fkart = vbrk-fkart.

Reward if Helpful

Jagadish

Re: select single

prasanth_kasturi — Thu, 15 May 2008 08:51:49 GMT

hi,

use like this

define a work area

data : begin of wa.

vbeln like vbrk-vbeln,

fkart like vberk-fkart,

end of wa.

select single vbeln fkart from vbrk

into <WA> where ....

and you can acess the values like this wa-vbeln,

wa-fkart.

reward if helpful

prasanth

Re: select single

Former Member — Thu, 15 May 2008 09:03:44 GMT

Hi,

Hope the below link will be helpfull to know more select single statement.

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb3990358411d1829f0000e829fbfe/frameset.htm

Thanks,

Ramya.

Reward if usefull.

Re: select single

Former Member — Thu, 15 May 2008 09:07:08 GMT

hi,

define a work area

select single vbeln fkart from vbrk

into <WA> where ....

and you can acess the values like this wa-vbeln,

wa-fkart.

reward if helpful

Re: select single

Former Member — Thu, 15 May 2008 09:54:58 GMT

Prameters: p_number type vbrk-vbeln.

data:

begin of wa,

vbeln type vbrk-vbeln,

fkart type vbrk-fkart,

end of wa.

select single vbeln fkart

from vbrk

into wa where vbeln eq p_number.

you get the billing type for particular invoice number.