Maintaining table ZOCRVATPREFIX

[Former Member]

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)?

[Former Member]

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]

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]

Hi Peter,

Thanks for your reply..

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

[Former Member]

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