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.
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.
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
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.
Thank you for your channel and content! I'm learning SAP ABAP and finding this very helpful
That’s great to know! I’m glad I could help.
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.
Well done👍
Very helpful video, thanks a lot !
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.
Thank you for your video. it's very helpful.
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
Thank you for your video 🙏🙏
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.
i want theory