2

I have the table with field title_medi which contains two rows like Mr. and Ms.

Also I have input field called title with search help of title_medi. When I'm selecting Mr. in the search help it gets displayed in the textfield.

If I compare that text field value with the database field. I'm getting an error.

But when I debug and see the value is somewhat getting converted to all uppercase like MR. not as exactly in the table.

Could you please help me out with this?

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Siva
  • 3,458
  • 8
  • 25
  • 26

4 Answers4

5

In order to solve this you have 2 options:

  1. Go to the domain of the table field and check Lower case check this
  2. Use TRANSLATE ABCD TO LOWER CASE before making the comparison check this
Draken
  • 3,134
  • 13
  • 34
  • 54
sepo
  • 394
  • 1
  • 8
1

additional info

In HR, possible quality (Mr, Ms...) are stored in table t522. Corresponding texts are stored in T522T. The data element is ANREX, associated with the domain of same name. This domain is lower case enabled.

moreover, this also give you the person's gender.

Draken
  • 3,134
  • 13
  • 34
  • 54
PATRY Guillaume
  • 4,287
  • 1
  • 32
  • 41
1

I checked the data element but that is also been checked with the lower case. So what i did is i have checked the check-box for upper/lower case attribute in screen painter for the concern field. It works fine

Draken
  • 3,134
  • 13
  • 34
  • 54
Siva
  • 3,458
  • 8
  • 25
  • 26
0

Use LOWER CASE addition to PARAMETERS, if you refer to selection screen input field.

PARAMETERS: p_matnr LIKE mara-matnr LOWER CASE.

I don't know which version OP was using as this is really old question, but this addition is available at least since ABAP 700 SP05

Suncatcher
  • 10,355
  • 10
  • 52
  • 90