Problem in Foreign key creation

[Former Member]

Hi,

I have a requirement where I need to create a foreign key in a ztable which points to the SPRAS field of table T002.Now this requires that the domain of this custom field should be the same as SPRAS. But domain SPRAS has got a conversion exit.For my case, I need to have different conversion exit for the customer field.

So can you please suggest how I can achieve both the things:-

1.Creating a PK-FK relatioship with the table field T002-SPRAS

2. Create a conversion-exit at the domain level of the custom field.

Thanks,

Samrat

[Former Member]

Hi,

I am confused with your requirement.

Lets understand why we have conversion exit ..

Conversion Exit 1

Ex: Input -- 'EN' Conversion exit would change it to 'E' and store in DB

Conversion Exit 2

Ex: Input -- 'EL' Conversion exit would change it to 'E' and store in DB

so 2 conversion exit perform 2 separate task...Right !!!

Now lets assume that your zfield uses conversion exit 2 and t002 uses conversion exit 1.If you create a foreign key to zfield to spras of t002

Input - 'EL' conversion exit will convert it to 'E' and it refers to 'E' of T002 ( but 'E' in t002 is actually 'EN'.

Isnt this wrong ??

I hope i did not confuse you.

Cheers,

KD