topic Re: Maintaining table ZOCRVATPREFIX in Application Development and Automation Discussions

Maintaining table ZOCRVATPREFIX

Former Member — Thu, 31 Jan 2008 07:27:44 GMT

Hi All,

I need to add an entry to the table ZOCRVATPREFIX where company code is primary key but 2 common mail addresses must be maintained.

Can any one you suggest me any idea for adding 2 entries with a single company code(primary key)?

peter_langner — Thu, 31 Jan 2008 07:47:23 GMT

Hi,

this ist not possible. Each riow has to have a unique primary key. You hav two possible solutions:

1. if the email-adress is unique, then you can declare the field which contains the Email-adress as wwell as a orimary key, or

2. you add a running number as aprimary key to distinguish between n Email adresses.

I hope, that helps you.

Peter

Former Member — Thu, 31 Jan 2008 09:13:33 GMT

Hi Peter,

Thanks for your reply..

Could you please expalin the second solution that you have provided?

Former Member — Fri, 01 Feb 2008 05:02:57 GMT

Hi,

You can also add the two email ids to the same record in the table, by having two email fields. Each record will be like:

BUKRS; EMAIL1; EMAIL2

Regard,

Sai