topic Re: lower case for function in Application Development and Automation Discussions

lower case for function

Former Member — Thu, 03 Jul 2008 07:01:58 GMT

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.

Re: lower case for function

Sandeep_Panghal — Thu, 03 Jul 2008 07:03:54 GMT

Hello,

This should not be the case.

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

Convert to uppercase.

Regards,

Sandeep

Re: lower case for function

Former Member — Thu, 03 Jul 2008 07:04:12 GMT

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

Re: lower case for function

Former Member — Thu, 03 Jul 2008 07:06:45 GMT

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

Re: lower case for function

Former Member — Thu, 03 Jul 2008 07:06:56 GMT

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.

Re: lower case for function

Former Member — Thu, 03 Jul 2008 07:19:01 GMT

Hi,

plz try this :

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

plz reward if useful.

thanks,

dhanashri.

Re: lower case for function

Former Member — Thu, 03 Jul 2008 07:25:06 GMT

TRANSLATE V_NAME TO LOWER CASE.

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

Reward if helpful