Skip to Content
avatar image
Former Member

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

Hi,

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers