topic Re: sample code in Application Development and Automation Discussions

sample code

Former Member — Fri, 07 Apr 2006 11:16:46 GMT

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

Re: sample code

Former Member — Fri, 07 Apr 2006 11:51:22 GMT

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

Re: sample code

Former Member — Fri, 07 Apr 2006 12:04:13 GMT

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

Re: sample code

LucianoBentiveg — Fri, 07 Apr 2006 12:09:09 GMT

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.