2022 Mar 31 3:35 PM
Hi all;
I struggle with reading this code block:
SELECT x, y, z
FROM A
INTO TABLE @DATA(lt_A)
FOR ALL ENTRIES IN @lt_x
WHERE x = @lt_x-x
AND y= @lc_y.
I would like to understand the sense of this coding . @ lt_ and lt_ ...usage etc.
Any help would be appreciated.
Kind Regards.
2022 Mar 31 7:53 PM
Hi,
please check the following links for more details and documentation:
https://archer4sap.com/sap-abap-7-51_v1/comma-and-escaping-variable/
https://blogs.sap.com/2017/02/17/why-the-new-open-sql-syntax-is-better/
I hope this helps you 🙂
Kind regards
Jens
2022 Mar 31 6:56 PM
You can find explanations about @ in the ABAP documentation in the chapters "Host Variables" and "Host Expressions" (and also related to ABAP SQL Strict Syntax).
2022 Mar 31 7:53 PM
Hi,
please check the following links for more details and documentation:
https://archer4sap.com/sap-abap-7-51_v1/comma-and-escaping-variable/
https://blogs.sap.com/2017/02/17/why-the-new-open-sql-syntax-is-better/
I hope this helps you 🙂
Kind regards
Jens
2022 Apr 01 6:18 AM
Thank you so much . It looks really helpful.
Have a nice day!jzaehringer
2022 Apr 01 6:22 AM
You‘re welcome 🙂
Please mark this topic as solved.
Have a nice day too!
KR Jens
2022 Apr 01 8:18 AM
Greetings sumeyye_1634.
It basically fetches all the records from table A that match the records from the inner table @lt_x.
Regards.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |