topic problem in string operations in Application Development and Automation Discussions

problem in string operations

Former Member — Thu, 01 Feb 2007 10:43:43 GMT

hi,

i am using module pool.in the first screen,i have two fields.in that one fielad is name field.i want to search the records with any charecter given in that field.i used contains,but it is not working,following is the code i am using,can any body help me it is urgent.'

N = strlen( ZCOMM_ULT_PARENT-Z_CUP_NAME ).

SELECT Z_CUP_NAME FROM zcomm_ult_parent INTO TABLE ITAB.

LOOP AT ITAB.

IF ITAB-NAME+0(N) = ZCOMM_ULT_PARENT-Z_CUP_NAME.

IF ITAB-NAME CA ZCOMM_ULT_PARENT-Z_CUP_NAME.

MOVE ITAB TO ITAB1.

APPEND ITAB1.

CLEAR ITAB1.

ENDIF.

ENDLOOP.

MESSAGE E002(Z_BALANCE_SCCARD).

if not itab1[] is initial .

select f_{z_cup_number f}z_class_range_id f~z_class_type_id

f_{seqno f}z_ind_sector f~z_cup_sub_class

p~z_cup_name from zcup_class as f

inner join zcomm_ult_parent as

p on f_{z_cup_number = p}z_cup_number

into corresponding fields of table lt_zcupclass

for all entries in itab1 where Z_CUP_NAME = ITAB1-NAME.

ENDIF.

but it is not working.

Re: problem in string operations

Former Member — Thu, 01 Feb 2007 10:46:48 GMT

Hi ram,

Make the highlighted change:

LOOP AT ITAB.

<b>concatenate '' ZCOMM_ULT_PARENT-Z_CUP_NAME '' into lv_str.</b>

IF ITAB-NAME+0(N) = ZCOMM_ULT_PARENT-Z_CUP_NAME.

MOVE ITAB TO ITAB1.

APPEND ITAB1.

CLEAR ITAB1.

ENDIF.

ENDLOOP.

REgards,

Ravi

Re: problem in string operations

Former Member — Thu, 01 Feb 2007 11:03:29 GMT

Hi Ram,

Or you can directly do this at the select statement level itslef.

concatenate '%' ZCOMM_ULT_PARENT-Z_CUP_NAME '%' into v_zcupname.

SELECT Z_CUP_NAME FROM zcomm_ult_parent INTO TABLE ITAB

where Z_CUP_NAME like v_zcupname.

Regards,

Ravi