WildCards:

[Former Member]

Hi All,

I Have a select Statement and have to use a wildcard.

  SELECT SINGLE KUNNR
         INTO (ITTAB-SREP)
         FROM VBPA
           WHERE VBELN = ITTAB-QTNUM
             AND POSNR = ITTAB-QTITM
             AND PARVW = 'Z+'. 

But this doesn't work as supposed. I have data in the table that has PARVW as ZR, ZW, Z1, Z2....and so on.

But i cannot pick up any values from this select statement. What could be the reason for this?

Thanks again.

Jr.

[Former Member]

SELECT SINGLE KUNNR

INTO (ITTAB-SREP)

FROM VBPA

WHERE VBELN = ITTAB-QTNUM

AND POSNR = ITTAB-QTITM

AND PARVW LIKE 'Z_'.

Use underscore for single character and percent for character string.

[RichHeilman]

Please try this.

  SELECT SINGLE KUNNR 
         INTO (ITTAB-SREP)     
         FROM VBPA         
           WHERE VBELN = ITTAB-QTNUM        
             AND POSNR = ITTAB-QTITM    
             <b>AND PARVW like 'Z%'</b>. 

Regards,

Rich Heilman

[RichHeilman]

You can also use a RANGE.

tables: vbpa.

<b>ranges: r_parvw for vbpa-parvw.


r_parvw-sign = 'I'.
r_parvw-option = 'CP'.
r_parvw-low    = 'Z*'.
append r_parvw.</b>

 SELECT SINGLE *  kunnr   
    INTO (ITTAB-SREP)      
        FROM VBPA           
            WHERE VBELN = ITTAB-QTNUM  
              AND POSNR = ITTAB-QTITM    
            <b>  AND PARVW in r_parvw.</b>

Regards,

Rich Heilman