adesso orange🍊Stellenangebote:
Software Engineer Trainee · Senior
| (Senior) Cloud Software Engineer BTP
(Senior) Consultant Technologie · Consultant ABAP
Werkstudent Softwareentwicklung · Fiori / UI5 · Consulting · Application Management
SELECT: Unterschied zwischen den Versionen
Aus SAP Wiki ツ
Zeile 1: | Zeile 1: | ||
[[Kategorie:Schlüsselbegriffe]] | [[Kategorie:Schlüsselbegriffe]] | ||
=== | === 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).