Abap keywords

[sumeyye_1634]

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.

[sumeyye_1634]

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.

[Sandra_Rossi]

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).

[Jeansy]

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

[sumeyye_1634]

Thank you so much . It looks really helpful.

Have a nice day!jzaehringer

[Jeansy]

You‘re welcome 🙂

Please mark this topic as solved.

Have a nice day too!

KR Jens

[former_member1116073]

Greetings sumeyye_1634.

It basically fetches all the records from table A that match the records from the inner table @lt_x.

Regards.