Skip to Content
0

BI-IP: How to validate entry before saving?

Oct 25, 2017 at 10:42 AM

155

avatar image
Former Member

Hello SAP Community,

Good day.

We have a requirement where in the user must not be able to enter a past date. If the user enters a past date, it should not save and create an error message. We are using analysis for office for the input forms. The date tagged as a characteristic as keyfigure. Creating validations via macro is not ideal for them.

The idea we have in mind is to do this via fox and run the sequence along with Save button on analysis. However, as mentioned we are using characteristic as keyfigure which is not supported in BI-IP when formula is used. We're looking for suggestions on how to achieve this requirement.

Thank you in advance!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 28, 2017 at 04:24 PM
0

Hi Prakash,

You could allow it to save but post save action, run a planning sequence which contains a fox planning function. This fox planning function should call a FM which in turn runs a process chain. The process chain should contain a self transformation DTP wherein you compare sy-datum with the values in that particular keyfigure and if it less than sy-datum, make it blank.

But yes, no error will be thrown to the end user.

Refer below link on how to start process chain via fox planning function :

https://blogs.sap.com/2015/07/08/how-to-trigger-a-process-chain-using-a-planning-function-in-sap-design-studio/

Regards,

Mihir

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Appreciate this response, Mihir. However, I'm afraid this will not work as they want the validation to be done right away. Multiple users will be accessing and saving new data at the same time and this also means triggering the process chain multiple times for validation.

0
Former Member

Hi Prakash,

A custom ABAP or UI5 form is the only thing I can think of then where in you can put all validations. You can push the query data into a table via a DTP leading into a Open hub (database table output not csv file). Via odata services connect the ABAP/UI5 form to that table.

This definitely requires different set of skills. Do let me know if you find a better way of achieving this.

Regards,

Mihir

0