adesso business consulting Stellenangebote
Software Engineer 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 ツ
| (2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 7: | Zeile 7: | ||
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> | |||
=== Existenzprüfung Datensatz === | |||
<syntaxhighlight lang="abap" line start="1"> | |||
SELECT SINGLE @abap_true FROM scarr | |||
WHERE carrid = @carrier | |||
INTO @DATA(exists). | |||
IF exists = abap_true. | |||
ELSE. | |||
ENDIF. | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Aktuelle Version vom 27. Januar 2026, 13:38 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).
Existenzprüfung Datensatz
SELECT SINGLE @abap_true FROM scarr
WHERE carrid = @carrier
INTO @DATA(exists).
IF exists = abap_true.
ELSE.
ENDIF.