SELECT: Unterschied zwischen den Versionen

Aus SAP Wiki ツ
 
Zeile 1: Zeile 1:
[[Kategorie:Schlüsselbegriffe]]
[[Kategorie:Schlüsselbegriffe]]
=== Dynamisches SELECT Abfrage ===
=== Dynamische SELECT Abfrage ===
==== WHERE ====
==== WHERE ====
<syntaxhighlight lang="abap" line start="1">
<syntaxhighlight lang="abap" line start="1">

Aktuelle Version vom 9. März 2022, 12:02 Uhr

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).