topic WildCards: in Application Development and Automation Discussions

WildCards:

Former Member — Tue, 29 Aug 2006 18:32:49 GMT

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.

Re: WildCards:

Former Member — Tue, 29 Aug 2006 18:34:33 GMT

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.

Re: WildCards:

RichHeilman — Tue, 29 Aug 2006 18:34:58 GMT

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

Re: WildCards:

RichHeilman — Tue, 29 Aug 2006 18:39:43 GMT

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