Skip to Content
avatar image
Former Member

BI-IP: How to validate entry before saving?

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2017 at 04:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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