topic Re: CASE SENSITIVE in Application Development and Automation Discussions

CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 04:35:58 GMT

hi guys,

The parameter converts the value into UPPERCASE. Is it in Settings that I need to configure? Or is it in BASIS side? How?

I was able to handle this when I code

employee search. but when i used a standard bapi. it converts to uppercase and it doesn't return a record. Of course I can't edit the standard bapi and placed a select-option to ignore the case.

And there are some cases that they require lower case in modifying dbase.

Please guide me. Thanks!

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 04:48:15 GMT

Hi Bayog,

Just declare the parameter as

PARAMETERS PROGRAM LIKE SY-REPID lower case.

Is this what u r looking for ?

and i doesnt think that Database updation will be case sensitive....

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 04:48:53 GMT

Hi,

This is the default setting when you parameters.

This can be overridden using the addition.

... LOWER CASE

Effect

The parameter allows case-sensitive input.

Ex:

PARAMETERS: snode      TYPE pvs_pnode LOWER CASE.

Regards,

Re: CASE SENSITIVE

dani_mn — Fri, 11 Aug 2006 04:52:50 GMT

HI,

use the following function module to change your case from the upper to lower or lower to upper.

EDITOR_LINE_TRANSLATE_CASE

<b>data: a type RSTXP-TDLINE.
data: b type RSTXP-TDLINE.

a = 'ABDCCC'.

CALL FUNCTION 'EDITOR_LINE_TRANSLATE_CASE'
  EXPORTING
    I_LINE            = a
   WANTED_CASE       = 'LOWER'
 IMPORTING
   O_LINE            = b.

   write:/ b.</b>

Regards,

HRA

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 05:42:06 GMT

Thanks guys! But the user's input is mixed-case. Like, Firstname Lastname Jr.

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 05:54:51 GMT

Hi Maui,

Hi,

The additon

... LOWER CASE

Effect

The parameter allows case-sensitive input.

Conisder this code,


REPORT  zztest_sdn_1                                                .


PARAMETERS: name(50) TYPE c LOWER CASE DEFAULT 'ArUn SaMbArGi'.


START-OF-SELECTION.


  WRITE : / name.

Output:

ArUn SaMbArGi

Regards,

AS

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 06:14:12 GMT

Hi Bayog,

Better use this statement

parameters p1 type matnr .

start-of-selection.

TRANSLATE p1 to lower case.

write p1.

This should work...

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 07:36:07 GMT

Thanks guys! but i can't apply this in function modules in creating a record

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 07:40:20 GMT

Hai Bayog,

Could u elaborate in detail what exactly u need..

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 07:48:07 GMT

Hi Sridhar!

I'm doing a bapi where in you will create an employee record. But when I input a name in the parameter it automatically converts the name into UPPERCASE. They want an output of whatever case they input it would reflect in the database.

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 08:53:30 GMT

Hi Bayog,

It is possible u can insert into data base table the way user enters in the input...

If the Domain referring the field of the database table has an option as Lower Case .. then only it allows the way user entered will be updated into database...

First check whether the databse table u r inserting has

SE11 --> enter table --> F7 --> now for field double click the DataElement --> and Double click the Domain --

and check Lower case check box is selected...

If this is selected then whatever is entered in Parameters will be inserted into data base ...

If the domain has Lower case check box selected then u can insert as user enters ( say SaMplE)

Now this works as i tested

Report XYZ.

tables Ztest_1.

PARAMETERS name1 type ZTEST_1-ename lower case.

entered SaMplE

ztest_1-ename = name1.

Insert ztest_1

try once by createin ZTest_1 with files ename and Dataelement and Domain as mentioned

ename refers Dataelement ZXYZ and Lowercase option selected for domain of DE

This definitely will solve u r problem...

if not u r welcome ....

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 09:39:41 GMT

Thanks sridhar!

But can I use this in a function module? the name is in the import param.

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 10:21:49 GMT

Hi Bayog,

Yes u can use this in Function module also...

Try this ...which has successfully done according to u r req.

REPORT ZSDFSD .

tables Ztest_1.

PARAMETERS name1 type ZTEST_1-ename lower case.

entered SaMplE

CALL FUNCTION 'ZTEST125'

EXPORTING

NAME = name1

EXCEPTIONS

RECORDEXISTS = 1

OTHERS = 2

IF SY-SUBRC = 1.

write:/ 'The name already exists'.

ENDIF.

**in FM ZTEST125 source code is

tables ZTESt_1.

ztest_1-ename = NAME.

Insert ztest_1.

if sy-subrc <> 0.

RAISE recordexists.

endif.

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 10:34:50 GMT

Thanks sridhar,

But in a function module, we declare parameter in the import tab where you specify the data type not in codes. And from there, it converts to UPPERCASE. How will I include lower case in the data declaration?

Re: CASE SENSITIVE

Former Member — Fri, 11 Aug 2006 10:37:06 GMT

Thanks sridhar,

I can't use your code 'coz it is already declared in the import parameter.

PARAMETERS name1 type ZTEST_1-ename lower case.

Re: CASE SENSITIVE

sridharreddy_kondam — Fri, 11 Aug 2006 12:12:05 GMT

Hai Bayog,

U can declare in the FM also ...

In se37 --> Import parameters --> parameter name --> name ,type type and asscociated type ZTEST_1-ENAME..

And if not solved pls. do elaborate more what actual u need from the program by calling FM...

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Mon, 14 Aug 2006 08:55:46 GMT

ei sridhar,

Actually I'm doing a FM wherein the import parameter: Name must be entered in LOWERCASE. But then once I hit F8 it conerts to UPPECASE. Is there a data element that I can put in the associated type that it doesn't convert the value into UPPERCASE and will append in the table in LOWERCASE?

Re: CASE SENSITIVE

Former Member — Mon, 14 Aug 2006 09:07:52 GMT

Hey,

Let`s say your fm updates a certain table ZNAMES and field NAME1 has to accept lower cases, then at the domain level check the check box lowercase. This will set the values to be updated in the database table without any conversion of Case as supplied by the FM.

Reward if helpful.

Regards

Re: CASE SENSITIVE

sridharreddy_kondam — Mon, 14 Aug 2006 09:18:39 GMT

Hi Mayog,

Eventhough we assigh to the domain lowercase option it doesnt work...so better option is to use translate statement within the FM..

Try this within the source code of FM...

tables ZTESt_1.

ztest_1-ename = NAME.

translate ztest_1-ename to lower case.

Insert ztest_1.

if sy-subrc <> 0.

RAISE recordexists.

endif.

Regards,

Sridhar

Re: CASE SENSITIVE

Former Member — Mon, 14 Aug 2006 09:50:28 GMT

Im sorry.Not just a lowercase but I want to consider the mixed-case. Like in the Import parameter:

Name: Firstname Lastname.

but when I hit F8.

Name: FIRSTNAME LASTNAME.