04-07-2006 12:16 PM
Hi All!
Require a sample code for the following.
I have to get vttk-tknum based on the following condition
Select single vbeln from vbfa into vbfa where vbelv=likp-vbeln and posnv='000001' and vbtyp_n=8
Regards
Pavan
04-07-2006 12:51 PM
hi,
do this..
Select single vbeln
from vbfa
into vbfa-vbeln
where vbelv= likp-vbeln
and posnv= '000001'
and vbtyp_n= '8'
and vbtyp_v = 'J'.
Regards
vijay
04-07-2006 12:51 PM
hi,
do this..
Select single vbeln
from vbfa
into vbfa-vbeln
where vbelv= likp-vbeln
and posnv= '000001'
and vbtyp_n= '8'
and vbtyp_v = 'J'.
Regards
vijay
04-07-2006 1:04 PM
Hi,
You can try by...
Select single vbeln
from vbfa into vbfa-vbeln
where vbelv=likp-vbeln
and posnv='000001'
and posnn='000001'
and vbtyp_n=M
regrads
Rakesh
04-07-2006 1:09 PM
SELECT SINGLE vbeln
INTO nrotransp
FROM vbfa
WHERE vbelv EQ likp-vbeln
and posnv EQ '000001'
and vbtyp_n EQ 8.
SELECT SINGLE tknum
INTO lc_tknum
FROM vttk
WHERE tknum = nrotransp.