Skip to Content
0
Aug 28, 2023 at 01:55 AM

Val Rule not working

72 Views Last edit Aug 29, 2023 at 06:30 PM 2 rev

Hello SAP Team, Need your inputs for setting up validation rule

Requirement: Users should not be able to enter "|" Pipe delimiter in Text Field for Company Code "ABC" & Vendor Recon "999999"

Issue: I have setup the validation rule as below, but it is only working when "|" is entered in text field without entering any other text in that field. In actual business scenario Pipe Delimiter is entered as "text |" OR "text| text"

Need your inputs how to setup "check" rule, which should pickup validations when text is having (a) Only pipe delimiter Eg: "|" (b) combination of pipe & text Eg: "Testing | testing"

Validation Rule:

Prerequisite: (sets used here)

Company Code IN CO_CODES AND

G/L Account IN RECON_GL

Check:

Text <> ' |'

Message:

Pipe delimiter is not allowed to enter in text field.