Problem with zero records

[Former Member]

Hi,

we are using the technique to run functions on delta records which is described by SAP in the how to paper. It is basically deriving a delta indicator = X for any record changed in the layout, and then adjusting the filter dynamically to those records having an X at the moment.

It works ok as such. The only thing is: As described in the how to paper, you end up having zero records in your database with delta = X.

But one problem remains: If you enter a zero in the layout, you get a zero record on delta = X in your database, but you cannot work with this record at all. For example: We want to catch the event that a user on purpose enters a zero in a cell, and in this case we want to perform some FOX function (replacing a certain key figure with 0,01). This does not work, because I never can catch the zero-record, even though it creates a record in the database.

Many thanks for your help!

Andreas

[Former Member · Accepted solution]

Hi Andreas,

a workaround for this kind of problem is that the user does not enter a 0 in his keyfigure, but keys in e.g. a 1 in a seperate keyfigure which has the meaing "set the other keyfigure to 0". This way you would see the record (which is no longer a zero record now (because the separate keyfigure is not equal to 0)) in your planning function and you can act accordingly.

Hope this helps...

Matthias Nutt

SAP Consulting Switzerland

[Former Member · Accepted solution]

Hi,

yes, that was sort of our worst case fallback if nothing else helps. Telling the users that they cannot enter a zero but that they need to do some detour is not really nice, especially as they were used to other tools which can handle zeros....

But thanks anyway!

Andreas