Masterdata derivations repeats outcome of previous derivation when no MD

[Former Member]

When I use in a transformation masterdata derivation outcome values are repeated from the previous line when the key is not in the masterdata table I want to derive from. For example 0CS_ORDER = 25 has 0funct_loc = 27.

When in the first line CS_order 25 is used I receive for 0funct_loc the value 27.

When in te second line CS_order is A which does not exist I receive for 0funct_loc also the value 27,I expected ''.

I keep receiving for the next line 27 for 0funct_loc untill the moment a line has a valid 0cs_order.

I expected that when their is no masterdata the masterdata derivation returns no values.

How to solve this not expected behaviour?

[Former Member · Accepted solution]

Do you use master data prefetch?

If so, I'd check notes 1092539, 1233535 and 1236970

Any ABAP routines?

[Former Member · Accepted solution]

Werner thanks for answering.

Yes we use master data lookup with prefetch.

note 123353 part of SAPKW70102

Although the key characteristic is changed in the startroutine, we have SAPKW70105. So this note will not fix trhe problem.

note 1236970 part of SAPKW70105

will not fix the problem because of SAPKW70105.

I hope you have some solutions left.

Kind regards,

Ben

[Former Member · Accepted solution]

What about this?

1227788

"If there is no master data for a key, the attribute of the last record read may be transferred."

Delivered in SAPKW70106.

[Former Member · Accepted solution]

Thank you. That solved the problem.