SELECT

Dynamische SELECT Abfrage

WHERE

DATA(lv_comp_srch) = |%{ me->_gv_mcomp }%|.
lv_where_clausel = 'addrnumber = @lt_userdata-addrnumber AND ( name1 LIKE @lv_comp_srch OR mc_name1 LIKE @lv_comp_srch )'.
SELECT * FROM adrc INTO TABLE @DATA(lt_companynames) FOR ALL ENTRIES IN @lt_userdata
                                                      WHERE (lv_where_clausel).

Existenzprüfung Datensatz

 SELECT SINGLE @abap_true FROM scarr
                          WHERE carrid = @carrier
                          INTO @DATA(exists).
 IF exists = abap_true.
 ELSE.
 ENDIF.

Inner Join

    SELECT SINGLE
      FROM I_Product AS p
             INNER JOIN
               I_ProductStorage_2 AS s ON s~Product = p~Product
      FIELDS p~Product,
             p~CrossPlantStatus,
             p~ProductGroup,
             s~MinRemainingShelfLife
      INTO CORRESPONDING FIELDS OF @ms_product.