Skip to Content
0

Asset Master Data Validation

Feb 08 at 04:39 PM

58

avatar image
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.....

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Bernhard Kirchner
Feb 09 at 07:56 AM
0

Hi

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

best regards

Bernhard

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 09 at 09:27 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
MaDhU ReDdY Feb 09 at 06:51 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded