Asset Master Data Validation

[Former Member]

Hi

We want to try to prevent duplicate entries in Asset Master field Inventory number (INVNR).

Is there a way to use validations to review entries already made in Table ANLA?

Thanks in advance.....

[former_member348872]

Hi

You need to do coding in Validation to achieve this result. Normal validation cannot retrieve and check the values in Assets created in the past. Go to GGB0 / OACV, Give Your prerequisite (like Co code / Transaction code etc) and in "Check" Define new Exit and maintain coding in corresponding Subroutine. Your ABAP should know how to do.

[Former Member]

Hi Bernhard.

Thanks for getting back to me.

Our business is entering Inventory Number in ANLA-INVNR.

When they create a new Asset they want to be sure the Inventory Number entered in ANLA-INVNR has not already been used in a previously created Asset.

They also want this same case for field ANLA-INVZU.

I'm hoping this can be achieved through a validation in TCode GGB0 - but I'm unsure of how to define the lookup element/validation on Table ANLA.

Any ideas?

[former_member205041]

Hi

In this case, the ANLA-SERNR you be the information that you need.

best regards

Bernhard