cancel
Showing results for 
Search instead for 
Did you mean: 

This entry already exists in the following tables 'User-Defined Values' (CSHS) (ODBC -2035) [Message 131-183]

Former Member
0 Kudos

Dear Experts,

We are using SAP B1 9.2 PL02 and we are facing the following issue:

We have created a Master Data UDO, which consists of a Header Table and two Line Tables. On any field of this table, when we applied an FMS, the message "Operation Completed Successfully"appeared, but there was no magnifying glass on the field. We pressed ALT+SHIFT+F2 and no applied FMS appeard. So, we tried again to apply the FMS to the field and the following message appeared: This entry already exists in the following tables  'User-Defined Values' (CSHS) (ODBC -2035)  [Message 131-183]. After that, I could not not remove the FMS from the field as the same message appeared.

We tried to close SAP and reopen it and still no result.

Do you have any insight about the specific issue?

Kind Regards,

Vassilis

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185296
Active Participant
0 Kudos

Hi,

If you have already defined the FMS for the field then Try to enable the user defined value in pickers display and check.

View --> Pickers display --> user defined values.

If you want to delete the created user defined values then select the field then select

Tools --> User defined values.

Regards,

Vinoth

Former Member
0 Kudos

Hello Vinoth,

We have already tried the Pickers Display option and the user defined value is not working just like there was no FMS applied on this field.

Anyway, thank you for your time.

Regards,

Vassilis

former_member325312
Active Contributor
0 Kudos

Hi

Is Fms Working fine in Sql and have u assigned it properly to field .If Yes Can you please paste your FMS Code here

Regards

Jenny

Former Member
0 Kudos

Hello,

The FMS is working properly in SQL, as well as any other field on any form in SAP.

This behavior appears only on the fields of this specific UDO, no matter which FMS we apply.

Regards,

Vassilis