topic Customer search in Application Development and Automation Discussions

Customer search

Former Member — Thu, 19 Jun 2008 16:21:40 GMT

HI gurus,

I have customers number like 2, 21, 22 and 23...

my code:

DATA: BEGIN OF LT_CUST OCCURS 0,
        KUNNR LIKE KNA1-KUNNR,
        NAME1 LIKE KNA1-NAME1,
      END OF LT_CUST.

PARAMETERS: I_CUST LIKE KNA1-kunnr.

REPLACE ALL OCCURRENCES OF '*' IN I_CUST WITH '%'.
SELECT KUNNR NAME1 FROM KNA1 INTO TABLE LT_CUST WHERE KUNNR LIKE I_CUST.

LOOP AT LT_CUST.
WRITE: / LT_CUST-KUNNR, LT_CUST-NAME1.
ENDLOOP.

when i pass 2 as parameter then i get 2 in basic list.

When i pass 2* as parameter, i am not getting any values.

when i pass *2 as parameter, i am getting 2 in basic list, thats fine.

how to achieve 2* as search parameter and the result is 2, 21, 22 and 23.

Giri

Re: Customer search

valter_oliveira — Thu, 19 Jun 2008 16:32:29 GMT

Hello,

That's a normal result. Go to tcode SE16, choose table KNA1, and make the same testing. The result will be the same.

This happens because of the CONVERTION routine. There is no field with patern '2*'.

To achive your goal, test with '000000002', instead of '2'.

Regards.

Valter Oliveira.

Re: Customer search

Former Member — Thu, 19 Jun 2008 16:34:16 GMT

Giri,

try this...

give the parameter value in range...

CUTOMER_RANGE2-SIGN = 'I'.
        CUTOMER_RANGE2-OPTION = 'CP'.
        CUTOMER_RANGE2-LOW = CUSTOMER_NUMBER.
        APPEND CUTOMER_RANGE2.


      SELECT KUNNR NAME1 FROM KNA1
                         INTO CORRESPONDING FIELDS OF TABLE
                         LT_KNA1
                         WHERE KUNNR IN CUTOMER_RANGE1.

hope this will solve ur problem,

Regards

Syed

Re: Customer search

Former Member — Thu, 19 Jun 2008 17:02:34 GMT

Hi Giri,

You should get the expected output with that code, please check again and let me know. If the problem is resolved please close the thread.

Yugandhar.