lower case for function

[Former Member]

hi,

i create a function ,i want the import parameters can distinguish lower case.eg:

FUNCTION ZTEST02.

*"----

---

""Local Interface:

*" IMPORTING

*" VALUE(V_NAME) TYPE ZTEST OPTIONAL

*" EXPORTING

*" VALUE(V_KUNNR) TYPE ZTEST

*"----

---

SELECT SINGLE KUNNR INTO V_KUNNR FROM KNA1 WHERE NAME1 = V_NAME.

ENDFUNCTION.

because the name1 of kna1 have lower case,now ,i can not find the data use select sentence where it is lower case.

what should i do ,thank you.

[Sandeep_Panghal]

Hello,

This should not be the case.

Anyways you can try converting the lower case to upper case using

Convert to uppercase.

Regards,

Sandeep

[Former Member]

change the domain which is associated with the Data element ZTEST to lower case in SE11 or simply use the date element NAME1_GP instead of ZTEST.

Edited by: Rajinikanth G on Jul 3, 2008 9:04 AM

Edited by: Rajinikanth G on Jul 3, 2008 9:05 AM

[Former Member]

it is always better to find the customer by the customer number rather than the name. Because there is a possibility that same name exists for 2 or more customers. Please try to use Kunnr.. rather that name1..

Regards

VIjay

[Former Member]

when you are passing the value in v_name in the function module of your report.

Define the data type of v_name in this manner

parameters:

v_name like kna1-name1 default ' ' OBLIGATORY LOWER CASE.

regards.

Anup.

[Former Member]

Hi,

plz try this :

PARAMETERS:
V_NAME LIKE KNA1-NAME1 DEFAULT ' '  OBLIGATORY LOWER CASE.

plz reward if useful.

thanks,

dhanashri.

[Former Member]

TRANSLATE V_NAME TO LOWER CASE.

This may help you if the db table data only in lowercase.

Reward if helpful