sample code

[Former Member]

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

[Former Member]

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

[Former Member]

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

[LucianoBentiveg]

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.