Mastering SAP ABAP

WHERE conditions

In the WHERE condition, we can make it a requirement that fields need to have some values. The important thing here is that when we have STRING or RAWSTRING plus LCHR and LRAW, we cannot use this field in WHERE. Creating WHERE with the mandt fields is not possible, as the client automatically handles this, but this automatization can be deactivated using CLIENT SPECIFIED after the FROM clause. However, this is only the most basic possibility of the WHERE condition.

In SELECT, we can use dynamic parameters. When creating the code with the exact values of the WHERE condition, we rarely know exactly what values we need. In such a case, dynamic values would be helpful. They might be found, for example, on some screens:

SELECT ...