Formatted searches and queries

[Former Member]

Hi,

Created 2 formatted searches that update 2 udfs on the BP Master Data with the latest payment date and amount and visually I can see both fields are populated on screen. However, when I run a query on the table OCRD and include the 2 udfs, values returned are Null, unless I make a change to the BP and press update.

Is there a way of being able to report via query manager on the 2 udfs without having to update all BP records?

Thanks,

Jon

[Johan_H · Accepted solution]

Hi Jon,

The short and sour of it is no.

Formatted searches will ever only display data on the screen. That means that they will not even be activated if you do not open the form they are on, and the data provided by them has to be saved to the database by a user, as you have already discovered.

What you can do, is create an SQL job (in MS SQL Server Management Studio) to update the udfs. Please note that SAP will generally discourage you from using direct sql write operations (update, insert, delete), but if you limit them to update only user defined fields, and/or user defined tables, you will not lose support.

Regards,

Johan

[Former Member · Accepted solution]

Hi Johan, thanks for the update.