adesso business consulting Stellenangebote
Software Engineer Trainee · Senior
| (Senior) Cloud Software Engineer BTP | Senior Frontend Software Engineer SAP BTP
| (Senior) Consultant Technologie
Werkstudent Softwareentwicklung · Consulting
SELECT: Unterschied zwischen den Versionen
Aus SAP Wiki ツ
Die Seite wurde neu angelegt: „Kategorie:Schlüsselbegriffe === Dynamisches SELECT Abfrage === ==== WHERE ==== DATA(lv_comp_srch) = |%{ me->_gv_mcomp }%|. lv_where_clausel = 'addrnumber…“ |
Keine Bearbeitungszusammenfassung |
||
| Zeile 3: | Zeile 3: | ||
==== WHERE ==== | ==== WHERE ==== | ||
DATA(lv_comp_srch) = |%{ me->_gv_mcomp }%|. | 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 )'. | <syntaxhighlight lang="abap" line start="1">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 | SELECT * FROM adrc INTO TABLE @DATA(lt_companynames) FOR ALL ENTRIES IN @lt_userdata | ||
WHERE (lv_where_clausel). | WHERE (lv_where_clausel).</syntaxhighlight> | ||
Version vom 9. März 2022, 13:01 Uhr
Dynamisches 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).