SAP Knowledge Base Article - Public

3100772 - ExecuteFromDB or GetFromDB not retrieving Current Data

Symptom

You are trying to retrieve data recently saved to the database using <query>.ExecuteFromDB() or <business object instance>.GetFromDB() in your ABSL script but the previous data is returned.

Environment

  • SAP Business ByDesign
  • SAP Cloud Applications Studio
  • SAP Cloud for Customer

Cause

The data returned is the state of the instance as read from the database before the start of the current transaction. This means if the data is changed and saved in a separate open transaction, the new data will not be returned in the current transaction.

Resolution

You will need to account for this system behavior in your custom implementation. As a suggestion, a "Refresh" of the screen before execution of the ABSL will ensure the current data will be returned.

See Also

SAP Cloud Application Studio Documentation:

Query Execution (Business Logic)

Get From DB (Business Logic)

Keywords

PDI, SDK, scripting, DB, behaviour , KBA , AP-RC-BDS-SCR , ByDesign Studio Scripting (ABSL) , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud Applications Studio all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions