9 - ABAP Programming - Classical Reports - Multiple Database Tables(FOR ALL ENTRIES IN) Part2

-Open SQL Query to Fetch Data from Order Header Table.
-Explanation to fetch data from Dependent, Foreign and Item Tables.
-Full Explanation of IS NOT INITIAL.
-Use SY-SUBRC = 0 OR Internal table IS NOT INITIAL condition to fetch data from dependent tables.

[@shrutichakraborty2919]

Crystal clear

[@sapabapbyrahulmehta]

Thank you very much.

[@cookingsecrets1078]

Ap bahat acha padhate ho sir...i. Following you since 1 week's

[@sapabapbyrahulmehta]

Thank you very much.

[@nazilariaz9476]

👏👏

[@chetansalunkhe9192]

Hi sir,
As we can - WRITE statement in 3 event- top of page, end of page, start of selection, so in this case which write statement will trigger first while executing the pgm.?

[@sapabapbyrahulmehta]

Firstly TOP-OF-PAGE Write, then Start-of-selection Write, then End-of-page Write.

[@chetansalunkhe9192]

@@sapabapbyrahulmehta I tried this scenerio, but I can see first start of selection write statement is triggering first, could you please check

[@sapabapbyrahulmehta]

@@chetansalunkhe9192 It will not trigger, It will just recongnize first Write statement, then control will automatically go to TOP-OF-PAGE and then control will return to START-OF-SELECTION, if you are using TOP-OF-PAGE. If you are not using TOP-OF-PAGE then definitely it will trigger the write statement of START-OF-SELECTION. Please refer the video of TOP-OF-PAGE in the same playlist, where I explained in the debugging Mode. Video no - 49,50,51.

[@debayanichakraborty7219]

can we do inner join based on the input value?

[@sapabapbyrahulmehta]

Hello Debayan, once you proceed further in the playlist, you will find inner join videos.