Welcome to Amrit's World of SAP

 Welcome back everyone, We have started to discuss about joins in the last blog, So let’s continue it. In our last blog, we were using for all entries, and for using for all entries, We had seen that we had to write multiple select queries to fetch data from multiple tables. Now we will see how we can get data from multiple tables using joins. Q. Whether we should use for all entries or we should use joins to get data from multiple tables ? Ans :- When we are working on traditional database systems (like Oracle, DB2, Sybase ), we should use for all entries in i.e. We will write individual queries to fetch data from multiple tables. But for HANA database we should prefer Joins. Q. Why we should not use Joins in traditional databases ? Ans :- It is because when we use joins, it fetches data from multiple tables and because of that load on the traditional database system is high and therefore, we should prefer for all entries in but HANA is a very powerful database and we can use

 Welcome back everyone, So basically we were discussing about internal table operations in our last blog. So let’s continue it. Internal Table Operations - SORT :- It is to sort the internal table. If we are not specifying anything, then by default it sorts in the ascending order. If we want to sort in descending order, then we need to specify the keyword descending. Practical implementation :- ************************************************* *Start of Program SORT lt_header BY order_number. "here we have not specified "anything, then by default it " will sort in ascending order. *Printing data LOOP AT lt_header INTO ls_header. WRITE :/ ls_header-order_number, ls_header-payment_mode. ENDLOOP. *End or Program ******************************************************** Output :- Sorting in Descending Order :- ************************************************* *Start of Program SORT lt_header BY order_number DESCENDING. *Printing data LOOP AT lt_header INTO

 Welcome back everyone, So basically we have started with internal table operations in our last blog. So let’s continue it. Internal Table Operations - Loop :- Loop allows you to execute a group of statements multiple times. Loop at <itab> where stands for internal table. Loop is used to read the records one by one from the internal table. Practical Implementations :- *********************************************************** *Start Of Program *Using loop LOOP AT lt_header INTO ls_header. WRITE :/ ls_header-order_number, ls_header-payment_mode. ENDLOOP. *End of Program. ************************************************************ Output :- Internal Table Operations - DELETE :- Delete is used to delete the records from the internal table. There are two ways to perform delete operations. Delete based on where condition. Delete based on index. Delete based on where condition :- ********************************* *Start of Program *Using delete to delete