Hello everyone,
I have a query with customer contacts. Those contacts have a reason code.
The technical name of the reason code consists of the reason group en the reason code.
For example: ZE0004/ZK04 (ZE0004 is reason group, ZK04 is reason code)
The reason code ZK04 is an old one, and cannot be used anymore.
Instead a new reason got the same code, but with another reason group; ZE0006/ZK04.
User only desire ZE0004/ZK04 in the query for records prior to this change. But since ZE0006/ZK04 exists I cannot select the first in the query.
As a result, the query shows the customer contacts with reason code ZE0006/ZK04,which is the wrong one!
How am I able to restrict the reason code to ZE0004/ZK04 and only see the results for this reason code?