Skip to Content
0
Former Member
Aug 19, 2007 at 12:53 PM

help to do code in elgant way

13 Views

hi

i have to do a 2 selects one is above i get in pro_type value

like if value is F1or F2 or F3

i have to do the next select from table ZZEVER_NEW1

if i get in pro_type like X0 or XE or XI or XS

i have to ZZEVER_NEW2

and so on

what is the elgant and short way to do taht

SELECT SINGLE prart

FROM prps

INTO pro_type

WHERE pspnr = ps_posnr.

Regards