Validation rules in FI

By Shiva Kumar Tirumalasetty, Deloitte Consulting India Pvt Ltd

In the SAP R/3 System, nearly all input values are validated by a program or against tables or master files. Since some types of validations cannot be standardized, you can use the validations program to create validations for your specific requirements.

The validation function enables you to check values and ranges of values as they are being entered in the SAP R/3 System. Validation rules are stored in the Rule Manager. As data is entered into the system, the Integration Manager validates the data against the validation rules. Because data is validated before it is actually posted, only valid information is posted to the FI-SL application component.

The system validates account numbers against a master file or checks that a ledger is assigned to a local company code.

You use validations when you want to create a user-defined Boolean statement to validate an entry in a way that is not defined for the standard system.

A validation can consist of up to 999 steps. You can therefore validate data against any number of Boolean statements before the data is posted.

Creating a Validation:

1.       Go to transaction GGB0 and select the application area-Financial accounting from the tree menu. Select the node: Line item.

Click on the “Validation” button available on the application toolbar to create the validation and enter the following details:

Validation name: VB15_V2

Description: Validation for the tax code

Message ID: ZFGL

Call up Point: 2

Application area: FI

Click on ‘Save’.

Note: Validations can be created for all the application areas of FI available on the screen of GGB0 as shown above.

2.       Now click on “Step” button on the application toolbar to create the validation step with the below details:

In the “prerequisites” sub node enter the below condition:  (This validation rule should trigger only for transaction FB01,FB60,FB65,FB02,MIRO,FV60,FV65,FVB0,FBM2,FBV0,FBV2,F-01,F-44,and only for vendor line items(KOART= ‘K’)

(BKPF-TCODE = 'FB01' OR BKPF-TCODE = 'FB60' OR

 BKPF-TCODE = 'FB65' OR BKPF-TCODE = ‘MIRO’ OR

 BKPF-TCODE = 'FB02' OR BKPF-TCODE = 'FBM2' OR

BKPF-TCODE = 'FBV0' OR BKPF-TCODE = 'FBV2' OR

BKPF-TCODE = 'FV60' OR BKPF-TCODE = 'FV65' OR

BKPF-TCODE = 'F-01' OR BKPF-TCODE = 'F-44’) AND

(BSEG-KOART = ‘K’)

Click here to continue...