Skip to Content
0

Formatted searches and queries

May 01 at 01:42 PM

35

avatar image
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

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

1 Answer

Best Answer
Johan Hakkesteegt May 02 at 07:10 AM
0

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

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

Hi Johan, thanks for the update.

0