Skip to Content
0
Former Member
Dec 03, 2008 at 06:45 PM

Mulitple values in field in custom table separated by commas....

33 Views

Hello,

I have a requirement where I am matching the status of invocie maintained in field called 'VALUE' in custom table with the actual status of invoice. If the status matches, I am carruing out certain logic.

Now, following logic works if there is just one value stored in field VALUE.

SELECT SINGLE * from ZCUSTOM into WA_ZCUSTOM WHERE
                                                           NAME = 'STATS'.
                                        
 IF WA_RBKP-RBSTAT = WA_ZCUSTOM-VALUE.
      WRITE:/ 'Match Found'.
 ENDIF.

But in my case, the data in field VALUE of ZCUSTOM table can contain multiple values (Ex: VALUE = 3,4,5) separated by commas. So, if the actual invocie status matches any of those values, I should perfom geven logic.

Cansome throw some light ?

Regards,

Rajesh.

Edited by: Rajesh Thomas on Dec 3, 2008 7:45 PM