validation for product price

[praveenreddy_bk]

Hi All,

1)Please provide me  links for  how to create validation.
2) can anybody provide code for productprice validation.
a) it should not b  -ve number, alpha numeric number , string , ZERO ...etc while uploading data  to import manager from excel sheet.

Thanks in Advance

Regards,

Praveen

[Former Member]

Hi,

Say you have field name PRODUCT PRICE

Try this validation,

HAS_ALL_CHARS(PRODUCT PRICE, "0", "9") AND IF(LEN(PRODUCT PRICE)=1, PRODUCT PRICE Not Equal Operator 0))

Select the FIELDS, OPERATORS and FUNCTIONS FROM DROP DOWN.

Select the Not Equal Operator symbol from OPERATORS DROP DOWN. I am not able to write it down here. so write Not Equal Operator in above expression.

This validation states that your PRODUCT PRICE has only NUMERIC values.

It fails for -ve Number, alpha numeric number, string and it if it has value 0.

Set Property Automatic Execution = Error for adding new records into MDM data Manager.

Refer page 242 to 259 in MDM Data Manager Reference GUIDE.

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/72b8aaa42301bae10000000a42189b/MDMDataManager71.p...

Kindly let me know if you still face any issue.

Thanks and Regards,

Mandeep Saini

[former_member205403]

Hi,

This document contains some good examples..Old one but good one.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed52...

Regards,

Shiv