11 - ABAP Programming - Classical Reports - Multiple Database Tables(FOR ALL ENTRIES IN) Part4

-Declaring a Final Internal Table of 6 Columns.
-Moving the data of Header Internal table and Item Internal table in to Final Internal Table Using APPEND.
-Displaying the Data From Final Internal Table.

[@renukaghosh510]

Sir.. you don't know what you are!!... you are really 'MESSENGER OF GOD ' for those who new to SAP ..SIR a request to you please start 'FIELD SYMBOL '... Thank you SIR

[@sapabapbyrahulmehta]

Thank you very much for your kind Feedback. Sure Field-Symbols , I will cover as a part of ABAP Programming in the upcoming days.

[@bablu6945]

Sir, you cleared my concept of loop and read execution logic... Thanks a lot..

[@sapabapbyrahulmehta]

Most Welcome Arindam.

[@saisshekar4167]

Sir , Could you please explain us this concept by using 4 tables .So it will be more understandable.
You are way of teaching is excellent.

[@sapabapbyrahulmehta]

Hello Sai - Please refer the playlist of Project Case Studies. There I explained with 3 tables - VBAK, VBAP and MAKT.
th-cam.com/play/PLM3lhmHjSeIRh0kwuQXWx4IO2vuogr9Ng.html&si=BgZv45VJrRy9BG6b

[@charan3059]

Why you are looping lt_data? There is only one matching record right. Can we go with read statement for this.

[@sapabapbyrahulmehta]

Hello Charan - The input to the program is using select-options, so we can pass multiple inputs - means multiple order numbers, so we need to go for loop only.

[@pranjalgunjal8453]

Sir, what if we use loop for item table first and then use read table in that loop for header table, will that work?

[@sapabapbyrahulmehta]

Hello Pranjal - Yes we can, but we can do this only if it is mandatory that for every order number the item data is mandatory. Example - Suppose order number 1 is in header table, but not in item table. If you put a loop on item table, order number 1 will never appear in the output. So it depends upon the scenario. Anyways, once you move forward, it is fully explained in detail.

[@pranjalgunjal8453]

@@sapabapbyrahulmehta Ok Sir, Understood. Thank you.

[@user-sw3hv4hw9y]

Hello, sir I am getting an error "lwa_data1 cannot be converted to the row type of lt_data1. The reverse is also not possible." What should I do??

[@sapabapbyrahulmehta]

Your internal table and work area must be of same type. Check the type of your internal table and work area.
Either you are passing different structure for internal table and work area or you are using TYPE TABLE OF with both.
Just cross check the video, you will get the answer.

[@itsPranjalMalviya]

Hi Rahul if i have 4 tables , then should i use 4 loops if i have more than 1 matching record?

[@sapabapbyrahulmehta]

Yes - For One Matching Record in the Dependent table - READ Table , More than one matching record - LOOP.

[@user-tn5pg8xm8i]

Can I give loop statement to item table I’ll give read statement header table what should happen is it correct or not ….can we do like this…

[@sapabapbyrahulmehta]

It will result in to data loss. if the entry is in header table, but not in item table. Suppose there is a order number 10 in header table but not in item table. When we loop on item, it will not appear in the output.

[@shrutichakraborty2919]

Can we use 'loop' for item table and 'read table' for header table?

[@sapabapbyrahulmehta]

Once you proceed, I explained that part as well. You will automatically get the answer.

[@user-ey3bj7hj9b]

Sir if we not use for all entries then also it will fetch the records then y we are using for all entries.

[@sapabapbyrahulmehta]

Please send your code of without using FOR ALL ENTRIES IN. I will explain based upon the code, so you will be able to understand in an effective manner.

[@bhushangayake2840]

Hello sir, if I've four tables and I am using the for all entries then in that case do I use 4 loops or is it okay if I use one loop and three read statements inside the loop?

[@sapabapbyrahulmehta]

Hello Bhushan, It is totally depends upon the data of the table. If you are sure that you have exactly one matching record for the condition which you are passing, then you can go for read table, else you need to opt loop.

[@bhushangayake2840]

@@sapabapbyrahulmehta OK thanks sir

[@rupeshrupi9331]

sir shall we do same process using subroutines?

[@sapabapbyrahulmehta]

Hello Rupesh - The Subroutine is a modularization technique, It is totally your wish you want to use function module or Subroutines.

[@rupeshrupi9331]

sir but how can we write the same program using subroutine I tired a lot, but iam getting only header table data

[@sapabapbyrahulmehta]

@@rupeshrupi9331 Please refer the video no -29 to 35 in the Modularization Techniques playlist, I explained the same example.
th-cam.com/play/PLM3lhmHjSeISM5OwWjUxLdjNWPqqOVivz.html&si=sCBpI9Yu0KOb7Moy

[@InsaneGamer-lq6wc]

Hi Sir can we get you coaching on real time experience

[@sapabapbyrahulmehta]

The question is not clear to me as in maximum videos I explained the real project work itself.

[@InsaneGamer-lq6wc]

@@sapabapbyrahulmehta I have gone through your videos I already have knowledge on basic ABAP I want to learn more can I get coaching from you

[@sapabapbyrahulmehta]

@@InsaneGamer-lq6wc Thank you for connecting, but I don't provide trainings.

[@InsaneGamer-lq6wc]

@@sapabapbyrahulmehta thank you sir can I get your number I need some inputs and guidance from you.

[@user-ey3bj7hj9b]

Sir if we not use for all entries then also it will fetch the records then y we are using for all entries.

[@sapabapbyrahulmehta]

Reverted to your comment.