10 - ABAP Programming - Classical Reports - Multiple Database Tables(FOR ALL ENTRIES IN) Part3

[@jayaramv1882]

most underrated channel for abap and your explanton is fabulous .

[@sapabapbyrahulmehta]

Thank you for your feedback.

[@Oncein_a_million]

Keep doing it, very good videos....

[@sapabapbyrahulmehta]

Thank you.

[@orugantisivakrishna5373]

Your videos are very helpful to me sir. Keep doing

[@sapabapbyrahulmehta]

Thank you bhai.

[@SAP_USER]

Hello sir, in 1st query instead of where aren't we suppose to put ON, and could you please clarify when to use WHERE or ON while select option?

[@sapabapbyrahulmehta]

Hello - Please check your question. We always use WHERE to pass the condition. If it is a select-option, we use IN while passing the where condition. We use = if it is a parameter. We never use ON. ON is used in case of JOIN.

[@SAP_USER]

@sapabapbyrahulmehta thankyou sir for clarification

[@sateeshbalapanuru7539]

Hi sir, For for all entries concept do we need compulsory same coulmn in both the tables?

[@sapabapbyrahulmehta]

Hello Sateesh - Column name can be different, but matching column is mandatory. It might be the case - VBELN(column name) of first table equal to SALESDOC(column name) of second table.

[@sairahulreddy9127]

In second table equal to operator can accept single value but how it is considering 3 values cannot we use in operator here

[@sapabapbyrahulmehta]

= and IN is based upon Parameters and Select-options. In the second query, we are not using parameters and select-options. We are passing the First Internal table order number data as a input to Order number column of second table.

[@bhushangayake2840]

Hello sir, I've written the FOR ALL ENTRIES code for 4 tables. But in my server there is no data in table. So I just want to check my code. Can I send it to you? or do I upload that code here?

[@pavithraveeramani6963]

the second select statement made my entire internal table null except for the feild it updated

[@sapabapbyrahulmehta]

Hello - The question is not clear to me. Please elaborate.

[@pavithraveeramani6963]

4:39 the select statement within the if condition copied the values of onl and oin into the internal table but emptied other column odate.

[@anirudhreddy8756]

bro y cant we just write "where ono IN s_ono" in 2nd table becoz s_ono also 1,2,3 and lt_data-ono also 1,2,3

[@sapabapbyrahulmehta]

Hello Anirudh - Just Think a Scenario in which someone deleted the order number 4 from Header Table, but did not delete Order Number 4 from Item Table. So by the logic written by you - Second query will return Order Number 4 and it is a wrong result , but If we fetch based upon Header, 4 will never appear in the output, as it is not in the header table.

[@anirudhreddy8756]

@@sapabapbyrahulmehta oh ya ✌🏼 thanks bro. Am from CSE background am applying for jobs with 3yrs fake experience ....after watching all your videos can I clear interviews ?🥲

[@bhavik-bhuva-86]

did you cleared? @@anirudhreddy8756