topic Re: table search in Application Development and Automation Discussions

table search

Former Member — Wed, 09 Jan 2008 11:26:01 GMT

i have created a table, it contains firstname and last name of type (char 250).

When I try to search the values which are existed in the field it is not giving the records in se11.

for example, there are values in this table firstname- xyz

lastname -abc.

in Se11 when I enter firstname - xyz and/or lastname -abc.

This is not showing the corresponding record which is already there.

can anyone help me here?

firstname and lastname of type (char 250). no domain associated with this.

is there any solution for this?

Re: table search

Former Member — Wed, 09 Jan 2008 11:31:23 GMT

Hi Sri,

Can you please tell me how you entered these values in your custom table ?

Thanks,

Urmila

Re: table search

Former Member — Wed, 09 Jan 2008 11:35:28 GMT

Hi,

the values are coming from a portal and thru a SAP report.

and I observed when I enter the value in the input screen and trying to execute.. it is converting to upper case..

I dont know why..

any help?

Re: table search

Former Member — Wed, 09 Jan 2008 11:41:58 GMT

In search,just try giving xyz or abc and check if it helps.

Regards,

Bhavin

Re: table search

Former Member — Wed, 09 Jan 2008 11:52:43 GMT

I tried with that only.. and also with wild card characters.. ex. xyz*

any other solution(s)?

Re: table search

franois_henrotte — Wed, 09 Jan 2008 14:30:54 GMT

the fields should be defined as being case sensitive

let me recommend you to define your fields with a shorter length than 250 and to create a full definition in DDIC

if you don't want to create a new type, you can use TEXT60 for example

Re: table search

Former Member — Fri, 11 Jan 2008 05:29:00 GMT

Hi Sri,

It is because, you have saved data in the table in lower case. But, whenever you enter a character value in selection screen, by default it will convert it into upper case. Hence, the search fails.

To solve this, you have to use a data element with a domain for the field in your table. And, in the domain you are creating, check the check box 'Lowercase' in the tab 'Definition', which is very important. Activate both the domains and the data elements.

After doing this, even if you enter the characters in lower case in the selection screen, the search will be successful and will show you the correct records. And, your problem will be solved.

Award points if helpful

Regards

Vidhya

Re: table search

Former Member — Fri, 11 Jan 2008 19:35:56 GMT

Hi Sri,

The data is being saved in lower case.

But in the selection screen it is converting to upper case and when you search for the data,the search will not give any result.

You will have to create a domain and a data element and assign them to the required field in the table. While creating the domain, you will find a tab by name Definition

There you will find a check box by name 'Lowercase'

Check that check box and activate.

Reward points if helpful.

Regards,

Kashyap