topic Re: automatic matchcode mapping in table in Application Development and Automation Discussions

automatic matchcode mapping in table

Former Member — Fri, 28 Aug 2015 07:30:43 GMT

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

Re: automatic matchcode mapping in table

Former Member — Fri, 28 Aug 2015 12:21:50 GMT

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.

Re: automatic matchcode mapping in table

former_member201275 — Fri, 28 Aug 2015 12:24:23 GMT

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

Re: automatic matchcode mapping in table

Former Member — Fri, 28 Aug 2015 12:31:27 GMT

Hi Benjamin,

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

Re: automatic matchcode mapping in table

RaymondGiuseppi — Fri, 28 Aug 2015 12:45:37 GMT


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

Re: automatic matchcode mapping in table

ThangaPrakash — Fri, 28 Aug 2015 15:18:08 GMT

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

Re: automatic matchcode mapping in table

matt — Tue, 01 Sep 2015 04:32:52 GMT

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