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

[@easysapabap9040]

That’s great to know! I’m glad I could help.

[@user-io6fr3rm5i]

Very helpful video, thanks a lot !

[@siniri2k]

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

[@eks_leexpim8652]

Thank you for your video 🙏🙏

[@codemize6359]

Well done👍

[@maddy8264]

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.

[@ThuyLe-ki9xi]

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.7247]

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.

[@akshaykamble8771]

i want theory