Skip to Content
avatar image
Former Member

Formatted searches and queries

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 02 at 07:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded