topic Re: String comparision in Application Development and Automation Discussions

String comparision

Former Member — Thu, 01 Nov 2007 14:56:24 GMT

Hi Gurus,

I have one variable 'Date' which is having value '10'. And I want to match this variable in where condition like this.

LOOP AT ITAB.

SELECT SINGLE KALTG FROM PA2001

INTO ITAB-KALTG

WHERE PERNR = ITAB-PERNR

AND BEGDA = DATE. "my variable havin value 10

MODIFY ITAB.

ENDLOOP.

NOW in this condition BEGDA is having some date like '01.10.2007' . Now I want to match that 'Date' variable to PA2001-BEGDA's only month. That means if BEGDA have 10th month then get record only like this.

Means my variale value '10' should match with only BEGDA 's 10 which is month and in midle of that BEGDA Date.

Thanks and Regards .

Pradip Pawar.

ABAP Consultant

Re: String comparision

Former Member — Thu, 01 Nov 2007 14:58:41 GMT

Hi,

Do like below :

LOOP AT ITAB. 
SELECT SINGLE KALTG FROM PA2001
INTO ITAB-KALTG
WHERE PERNR = ITAB-PERNR
AND BEGDA+4(2) = DATE. "Do this Change in your program
MODIFY ITAB.
ENDLOOP.

Thanks,

Sri.

Re: String comparision

Former Member — Thu, 01 Nov 2007 15:01:27 GMT

then you need to take a DATE type range and populate with that month's 1st date and last date in that range with BT option. Then use that range in select as below

SELECT SINGLE KALTG FROM PA2001

INTO ITAB-KALTG

WHERE PERNR = ITAB-PERNR

AND BEGDA in DATE_range.

Re: String comparision

Former Member — Thu, 01 Nov 2007 15:14:42 GMT

DATA: l_begda_month TYPE string.

l_begda_month = '____10__'. "<---YYYYMMDD use of underscore instead of %

SELECT SINGLE KALTG FROM PA2001
INTO ITAB-KALTG
WHERE PERNR = ITAB-PERNR
AND <b>BEGDA LIKE l_begda_month</b>.

Re: String comparision

Former Member — Thu, 01 Nov 2007 15:17:00 GMT


DATA: l_begda_month TYPE string.
 
l_begda_month = '____10__'. "<---YYYYMMDD use of underscore instead of %
 
SELECT SINGLE KALTG 
   FROM PA2001
   INTO ITAB-KALTG
   WHERE PERNR = ITAB-PERNR AND 
         BEGDA LIKE l_begda_month.