Skip to Content

SapSetData returns #VALUE (problem with using reference cells in formula) - AFO 2.4

Mar 15, 2017 at 01:22 PM


avatar image
Former Member

Hi, Experts!

We're trying to use sapsetdata function to save data that previously were calculated in excel.

Input Query:

SapSetData returns normal value (cell D2) when we hardcode technical keys of info objects and their value. See the figure below. This doesn’t suit for us, because we’ve got a dynamic input schedule and the number of rows (and as a result combination of elements of the info-objects) may vary.

SapSetData returns #value error (cell C2) when we are using reference cells as parameters for info objects technical keys and their values in formula:

Does anybody have guesses why the second variant not working?

P.S. we were using this «how to guide» for our solution -

first.png (11.6 kB)
first.png (12.1 kB)
second.png (56.1 kB)
third.png (24.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers