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 ...

 Welcome back everyone, In our last blog we were discussing about Classical Reports. So , let’s create a program on some complex scenario than yesterday. Requirement :- 1. Suppose we have our Order header and Order item table. 2.Now, On the selection screen, we want to take input as order number using select options, make select option as mandatory and also write select option in a box. 3. On the basis of above input, we want to display the below output :- 4. Use the below logic :- Solution :- I think we are clear with the requirement, So let’s develop a classical report Process :- Step 1 :- Create a executable Program in ABAP Editor. Step 2 :- Create the type structure for both header and item table and also declare a final type structure to display the output. Step 3 :- Declare the internal table and work area for the above three type structure. Step 4 :- Defining a block for selection screen and writing select option in it. Step 5 :- Go to tex...