How to give a range or List option in Validation/Substitution

[Former Member]

Hi,

I am not aware of of giving a list option or range option while defining a Validation or substitution.

For example:

1. <b><u>List:</u></b> I want the pre-requisite to check Company Code = a constant value say 1000 but it should check only for few selected document types like KR, RE, SA, RV etc.

2.<u><b> Range</b></u> : It should check only for vendors between range 100000 to 999999.

So what needs to be done for meeting my these requirements.

Plz suggest.

Points will be suitable rewarded for replies.

regards

AVM

[JozsefSzikszai · Accepted solution]

hi AVM,

1. One option is to simply mention all possible values, for document types like:

BKPF-BLART = 'KR' OR

BKPF-BLART = 'RE' OR

BKPF-BLART = 'KR' OR

etc.

the other option is to create a set, where you put all values. The set you can create in GS01 transaction. When it is ready you can put into the validation like this:

BKPF-BLAT IN name_of_set

2. Here I would simply do like this:

BSEG-LIFNR >= '0000100000' AND BSEG-LIFNR <= '0000999999'

but you can combine as well:

( BSEG-LIFNR >= '0000100000' AND BSEG-LIFNR <= '0000999999' ) OR

( BSEG-LIFNR >= '0001000000' AND BSEG-LIFNR <= '0001999999' )

(Pls. not I entered the vendor numbers in internal format (10 digits with leading zeros))

you just have to take care with the conditions and the brackets.

hope this helps

ec