automatic matchcode mapping in table

[Former Member]

Hello experts,

iam facing the following problem:

we have a table with a column datatype NAME1_GP (which has small and big letters), now we want to add a new column as search column (same content like column NAME1_GP but in capital letters) for this purpuse we would like to use datatype MCDD1 (capital letters)

is there a way to tell the new colum to use the content of the old column on table/database level so that we must not change any insert/update source code? again i want that column2 has always the same content than column1 but in capital letters?

Thank u

[Former Member]

Hi Benjamin,

               I dint get exactly what is your requirement because for search help the case sensitiveness is irrelevant. by the way you can do this

                  1.By manually putting code for updating only that field.

                  2.By scheduling other program which updates the field.

                  3.Use trigger at database level for performing the update.

[former_member201275]

just use the same search help for the second field as for the first?

[Former Member]

Hi Benjamin,

    I dint get you. Can you explain with screen shot.

[RaymondGiuseppi]

is there a way to tell the new colum to use the content of the old column on table/database level so that we must not change any insert/update source code?

AFAIK not from SAP side without coding, some triggers can be defined in most database, but that's no longer related to ABAP Development.

Regards,

Raymond

[ThangaPrakash]

Hello Benjamin,

If your table is a custom table and it has Table maintenance generator then you can try with the Events available in the Table Maintenance Generator. Try with event 01.

But this will work when you do Insert/Update any records via transaction SM30.

If Insert/Update is happening via programs then source code of those programs has to be changed.

Regards,

Thanga

[matt]

Please specify your database and I'll move your post there. You need database triggers, so this is not an ABAP question.