select single

[Former Member]

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?

[Former Member]

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

[prasanth_kasturi]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.