![validation rules in sap hana studio validation rules in sap hana studio](http://www.bestsaphanatraining.com/img/bsht-hana-studio-console-screen.jpg)
You should receive the below error message. Login with the role General Leder Accountant: GL_ACCOUNTANT Under General Information enter the following: Go to “Manage Substitution/Validation Rules” Login with the role Configuration Expert – BPC_EXPERT
![validation rules in sap hana studio validation rules in sap hana studio](https://image.slidesharecdn.com/saphanasps10-hanamodeling1-150624212910-lva1-app6892/95/sap-hana-sps10-sap-hana-modeling-2-638.jpg)
Ø General Ledger Accountant: BR_GL_ACCOUNTANT Ø Configuration Expert – Business Process Configuration: BR_BPC_EXPERT
#Validation rules in sap hana studio how to
Let’s see how it looks and how to configure in the Cloud System with 2005 upgrade: The Table Lookup substitution type allows user to choose a source field from a custom business object and uses its value to fill in the target field. The Matches operator can be used to match a string-type field value against a regular expression. With SAP S/4HANA Cloud 2005, The Manage Substitution/Validation Rules app for JVA is enhanced with the new comparison operator Matches and the new substitution type Table Lookup. If the prerequisite rule is met, the system replaces the value entered with other values. As the user enters the value, system validates according to the prerequisite defined by the user. Whereas Substitution rule is set up to substitute the data immediately upon the entry made. It helps to avoid wrong entry at initial stage of posting the transaction. It will succeed to post the transaction only when the data is posted in that specific field as defined in the validation rule. When user is trying to post the transaction and enters data in that specific field, which violates the validation rule, system throws an error message for the user and it will not allow the transaction to post. Why is Validation and Substitution rule important?Īs the user sets the Validation rule, it checks the validation rule defined on specific fields data.