How to make Data Validations

[Former Member]

Hi All,

I have a business requirement to validate the data entered by user & write an error message if the data is not valid. for example, if the user tries to modify the existing data, we need to check if the date specified by the user is in the current quarter or not. If it falls in the current quarter (we are storing the dates in a table, so that we can refer to that table while validating) we need to save the data else need to throw an error message.

Is there a way to do this in character relation ships using derive or do we need to use Fox formula in a planning function. Appreciate your help.

I am new to IP and could not find any how to documents or similar topics. Please suggest.

Thanks in Advance

[Former Member]

Hi All,

Thanks for your responses. I was able to accomplish this creating a characterstic relationship through exit (Derive) method & by following the below thread for posting error message.

http://scn.sap.com/thread/1205105

[former_member5472]

Hi,

I think your requirement is more about restricting the data set to get saved in DB based on condition.

The best way to approach is to use Data Slice of Type Exit.  You can customize your message as per your requirement.

Thanks

prat

[Former Member]

Dear Spring,

The data validation can be done either in source system or during the transformations.

In Source system:

• We can achieve this by writing the function module while data extraction.

In BW/BI system:

• After data has loaded into PSA, then (From PSA to Data Target) we can write the transformation (in this case for each packet, start routine calls and deletes the invalid data; Invalid data stores in one table and valid data can be stored in target info provider.)
• ODS can be used for data validation and staging purpose!
• The Invalid data can be shown to users in any of the cases.

Hope it helps you!!

Regards

Kiran N

[MGrob]

Hi Kiran

This is a integrated planning related question and not datawarehousing issue..

Martin

[Former Member]

Sorry ...

Thanks martin..

Regards

Kiran N

[MGrob]

Hi

Easiest is if you create a FOX and then call a FM where you do the verification of your date.

hope that helps

Martin

[Former Member]

Hi,

actually it depends on what you want to validate:

- closed Periods are regulary protected by a data slice. If you try to change/remove an existing record or add a new record in a dataslice protected selection system will give an error message

- Characteristic combinations Customer/Customer Group Relation for example. are validated via characteristic relationships

- keyfigure based (like check that average is between min and max or whatever) and mixed validations can be validated via fox formulas or exit functions

Regards,

Nils