Question Re: Unique value restriction for an extension field in CRM and CX Q&A

Unique value restriction for an extension field

raul-gonzalezg — Tue, 07 Jul 2020 22:28:01 GMT

Hi,

Is it possible to create an extension field in which I can validate that its uniqueness? That is, its value must not be repeated in the corresponding object, in this case I want to use this feature at opportunity's header level, to enter manually an own control ID and validate that it is not repeated when it is registered.

Regards,

Raúl

Re: Unique value restriction for an extension field

arun02_12 — Wed, 08 Jul 2020 03:47:54 GMT

Dear raul_gonzalezg,

You would need a Custom number range to achieve something like this

https://blogs.sap.com/2018/05/04/generate-custom-number-range-in-c4c-thru-sap-cloud-application-studio/
https://blogs.sap.com/2019/09/18/how-to-create-a-id-field-in-bco-which-behaves-as-counter/

https://answers.sap.com/questions/11579884/automatic-id-generation.html

Best Regards,

Arun

Re: Unique value restriction for an extension field

raul-gonzalezg — Wed, 08 Jul 2020 21:07:22 GMT

Hi Arun,

Thanks for your comments, in this case we want to control this ID manually, but we want to validate its uniqeness.

¿Is it possible to validate this via rules & validations in create/edit screen? ¿or this implies a development at programming code level?

Regards,

Raúl

Re: Unique value restriction for an extension field

arun02_12 — Thu, 09 Jul 2020 06:31:08 GMT

Dear raul_gonzalezg,

Rules & validations will check and validate the field values only within the BO instance. You can't compare values between instances.
If this is a manually entered field , you can only achieve such a functionality through PDI implementation.

BR

Arun

Re: Unique value restriction for an extension field

raul-gonzalezg — Thu, 09 Jul 2020 15:53:47 GMT

Hi Arun,

Thanks for your help.

Regards,

Raúl.