05-15-2008 9:48 AM
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?
05-15-2008 9:49 AM
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
05-15-2008 9:51 AM
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
05-15-2008 10:03 AM
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.
05-15-2008 10:07 AM
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
05-15-2008 10:54 AM
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.