SELECT - Versionsgeschichte

M1ch3lde: /* Existenzprüfung Datensatz */

2026-01-27T12:38:20Z

Existenzprüfung Datensatz

← Nächstältere Version		Version vom 27. Januar 2026, 14:38 Uhr
Zeile 17:		Zeile 17:
	ELSE.		ELSE.
	ENDIF.		ENDIF.
	</syntaxhighlight		</syntaxhighlight>

M1ch3lde am 27. Januar 2026 um 12:38 Uhr

2026-01-27T12:38:06Z

← Nächstältere Version		Version vom 27. Januar 2026, 14:38 Uhr
Zeile 10:		Zeile 10:

	=== Existenzprüfung Datensatz ===		=== Existenzprüfung Datensatz ===
			<syntaxhighlight lang="abap" line start="1">
	SELECT SINGLE @abap_true FROM scarr		SELECT SINGLE @abap_true FROM scarr
	WHERE carrid = @carrier		WHERE carrid = @carrier
Zeile 16:		Zeile 17:
	ELSE.		ELSE.
	ENDIF.		ENDIF.
			</syntaxhighlight

M1ch3lde am 17. Dezember 2024 um 18:20 Uhr

2024-12-17T18:20:56Z

← Nächstältere Version		Version vom 17. Dezember 2024, 20:20 Uhr
Zeile 8:		Zeile 8:
	WHERE (lv_where_clausel).		WHERE (lv_where_clausel).
	</syntaxhighlight>		</syntaxhighlight>

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

M1ch3lde: /* Dynamisches SELECT Abfrage */

2022-03-09T11:02:51Z

Dynamisches SELECT Abfrage

← Nächstältere Version		Version vom 9. März 2022, 13:02 Uhr
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">

M1ch3lde am 9. März 2022 um 11:02 Uhr

2022-03-09T11:02:37Z

← Nächstältere Version		Version vom 9. März 2022, 13:02 Uhr
Zeile 6:		Zeile 6:
	lv_where_clausel = 'addrnumber = @lt_userdata-addrnumber AND ( name1 LIKE @lv_comp_srch OR mc_name1 LIKE @lv_comp_srch )'.		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>		</syntaxhighlight>

M1ch3lde am 9. März 2022 um 11:02 Uhr

2022-03-09T11:02:12Z

← Nächstältere Version		Version vom 9. März 2022, 13:02 Uhr
Zeile 2:		Zeile 2:
	=== Dynamisches SELECT Abfrage ===		=== Dynamisches SELECT Abfrage ===
	==== WHERE ====		==== WHERE ====
			<syntaxhighlight lang="abap" line start="1">
	DATA(lv_comp_srch) = \|%{ me->_gv_mcomp }%\|.		DATA(lv_comp_srch) = \|%{ me->_gv_mcomp }%\|.
	~~<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 )'.		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).</syntaxhighlight>		WHERE (lv_where_clausel).
			</syntaxhighlight>

M1ch3lde am 9. März 2022 um 11:01 Uhr

2022-03-09T11:01:54Z

← Nächstältere Version		Version vom 9. März 2022, 13:01 Uhr
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>

M1ch3lde: Die Seite wurde neu angelegt: „Kategorie:Schlüsselbegriffe === Dynamisches SELECT Abfrage === ==== WHERE ==== DATA(lv_comp_srch) = |%{ me->_gv_mcomp }%|. lv_where_clausel = 'addrnumber…“

2022-03-09T11:01:26Z

Die Seite wurde neu angelegt: „Kategorie:Schlüsselbegriffe === Dynamisches SELECT Abfrage === ==== WHERE ==== DATA(lv_comp_srch) = |%{ me->_gv_mcomp }%|. lv_where_clausel = 'addrnumber…“

Neue Seite

[[Kategorie:Schlüsselbegriffe]]
=== 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).