Skip to Content

How to search for records with a value in one field OR a value in another field?

Nov 17, 2016 at 05:28 PM


avatar image
Former Member


I have to run a daily error report (T code: ZRER) for BOLs in the PRD system. We search based on the SPLC field and the plant field. Sometimes a table will hold the value in one of these fields but not the other. As such, in our standard search using the interface I have to run the search twice: searching once using the SPLC field and a second time using the plant field. Including the values in both the SPLC and plant fields would exclude the records where the value is missing from one of the fields.

Does anyone know of a way to include records based on a search where a value is included in one field OR another field? I know a standard SQL query could do this using OR. But I'm not familiar with using SQL in SAP and I would like to perform the search using the interface (ZRER). Apologies if this has been posted before but I'm still learning the terminology and how to search for answers. Appreciate the help!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers