SAP ABAP - Internal Tables Introduction (LOOP AT & READ TABLE)

In this video I show you the old and new syntax for creating internal tables. I also show you how to get data into these structures as well as read data from them.

For any questions, please leave a comment.

[aamiyana]

Thank you for your channel and content! I'm learning SAP ABAP and finding this very helpful

[maddy]

Hi, Thanks for tutorial on Internal Table. I would like to know, how can I use subquery of another internal table with a internal table and matching the specific field of internal table and the subquery of the internal table using aggregation method - avg.

[sinirik]

Thank you for your video. it's very helpful.

[ThuyLe-kixi]

Hello, I'm new to abap and I finds your video is very easy to understand and informative. I want to ask one thing about using FOR ALL ENTRIES and outer join. I want to get result from table 1, table 2, table 3, with table 1 have f1, f3, f4, f5, table 2 have f1, f2, table 3 have f1, f6, f7. My output is a table with f1, f2, f3, f4, f5, f6, f7. I want to use FOR ALL ENTRIES but it cannot get everything.

[Beyond-the-Camera]

Why can't we use a single field catalog for output using a subroutine instead of doing as you did from lines 24 to 37? And what's the difference between READ TABLE using WITH KEY and the WHERE used in LOOP AT, I am confused

[karlal.]

Can you help me please?
I need to loop and read table with three tables: spfli, sflight and sbook where carrid is 'AA'.
I couldn't with the three tables, only with two tables. Can you help me?
how do i put the sbook?

SELECT carrid connid FROM sflight
INTO TABLE gt_sflight
WHERE carrid = 'AA'.
IF gt_sflight[] IS NOT INITIAL.
SELECT carrid connid countryfr FROM spfli
INTO TABLE gt_spfli
FOR ALL ENTRIES IN gt_spfli
WHERE carrid = gt_spfli-carrid
AND connid = gt_spfli-connid.
ENDIF.
LOOP AT gt_sflight INTO wa_mixed.
READ TABLE gt_spfli INTO wa_spfli
WITH KEY carrid = wa_mixed-carrid
connid = wa_mixed-connid.
APPEND wa_spfli to gt_mixed.
ENDLOOP.