-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Mastering SAP ABAP
By :
In OpenSQL in ABAP, we have more advanced possibilities. In this section, we will cover the following topics:
WHERE conditionsWHEREWHEREIN operatorWHERE conditionSELECT SINGLE FOR UPDATEGROUP BYORDER BYUP TO N ROWSSELECT and ENDSELECTFOR ALL ENTRIESThere are many possibilities here. When we are familiar with them, we can write selects in effective ways while retaining the speed of the executing statement.
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...