Posts

Showing posts with the label Left Outer Join

Mastering SAP ABAP: Enhancing Reports with Left Outer Join, Column Labels, and Formatting Techniques

Image
 Welcome back everyone, We have implemented inner join in our last blog, So let’s continue it. Requirement :- Suppose, there are 7 elements in header table and for only 5 elements of header table, we have elements in item table. Now, the Customer wants that the matching data between should be displayed, also rest elements of header table should be displayed in the output. Solution :- In that scenario, we will use left outer join. Code :- *********************************************************** *Start of Program *Declaring the final type structure TYPES: BEGIN OF ty_final, order_number TYPE zar_order_number, order_date TYPE zar_order_date, payment_mode TYPE zar_payment_mode, total_amount TYPE zar_total_amount, currency TYPE zar_curency, order_item_number TYPE zar_order_item_number, item_cost TYPE zar_total_amount, END OF ty_final. ********************************

Mastering ABAP Reports: Building a Classical Report with Input Selection and Data Retrieval from Order Header and Item Tables

Image
 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 text el