Efficient Data Retrieval with ABAP Classes: Fetching VBAK Table Range Using Method

 

Fetching a range of data from from VBAK table using a method in USUAL ABAP Class

Requirement :-

  • Create a report and take a range a input from user for Sales Document number.
  • Write the logic in a method of Usual ABAP Class.
  • Call that method in program and display the order details using ALV.

Solution :-

  • Step 1 :- Open the Usual ABAP CLASS in change mode which we have used in the previous part.



  • Step 2 :- give a name to the method and make it as an instance method.



  • Step 3 :- Click on parameters.

  • Step 4 :- provide the importing parameter as p_vbeln and also the associated type for range of vbeln.



    How to find the range table for Sales Order :-

    • Go to se11 and in the data type give the name of the data element of Sales document number.



    • Click on where used list



    • Select table type and click on OK.



    • We can see the list.



  • Step 5 :- Create a structure and corresponding table type which will be passed as external parameter in the method.

    • Structure :-



    • Table type :-



  • Step 6 :- Pass this table into the exporting parameter.



  • Step 7 :- Click on source code.



  • Step 8 :- Write the logic in the method.



Calling the Method inside the Program :-

  • Step 1 :- Create a executable program in ABAP Editor ( SE38).

  • Step 2 :- declare a internal table of the same structure which was created above.



  • Step 3:- Declare a select option for the Sales document number.



  • Step 4 :- Create object for the class where method was created.





  • Step 5 :- call the method.



  • Step 6 :- Use factory method of CL_SALV_TABLE class to display in form of ALV.



Code :-

*&---------------------------------------------------------------------*
*& Report ZAR_USUAL_ABAP_CLASS
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ZAR_USUAL_ABAP_CLASS.

DATA : lt_final type table of ZAR_STRUCTURE_SALES_ORDER.

data : lv_vbeln type vbeln_va.
SELECT-OPTIONS : s_vbeln for lv_vbeln.

START-OF-SELECTION.
DATA(lo_object) = new ZAR_USUAL_ABAP_CLASS( ).

CALL METHOD lo_object->get_range_of_vbak_details
  EXPORTING
    p_vbeln  = s_vbeln[]
  IMPORTING
    lt_table = lt_final
    .

TRY.
CALL METHOD cl_salv_table=>factory
  EXPORTING
    list_display   = IF_SALV_C_BOOL_SAP=>FALSE
  IMPORTING
    r_salv_table   = data(lo_data)
  CHANGING
    t_table        = lt_final
    .
  CATCH cx_salv_msg.
ENDTRY.
lo_data->display( ).

*&-------------------------------------------------------------
*&End of Program
*&----------------------------------------------------------------------------

Execute the Code :-



  • Press F8.


Comments

Post a Comment

Popular posts from this blog

Understanding Different Types of SAP Function Modules: Normal, RFC, and Update

Image
  1. Normal/Regular Function Module :- It can be called inside the system. Here Pass by value + Pass by reference both is fine. 2. RFC Function Modules :- You can call from same system or from another possible. In RFC function module you can only have pass by value. In the same system if you are going to add the DESTINATION NONE’ while calling the RFC then it’ll be called in separate session. 3. UPDATE Function Modules :- This is generally used to update the database record. Update Function Module can be called from the same system. ( Background RFC / trfc / grfc ) This is used to achieve generally the SAP LUW. Some time we use from performance perspective also. When COMMIT WORK gets executed then Update starts getting executed. Important Questions on Update Function Modules :- When Update function Module gets Triggered ? ON COMMIT WORK IF a update function module gets failed, under which transaction we can see that ? OR What is the T-Code for moni
Read more

Unlocking SAP ABAP Secrets: Interactive Classical Reports with GET CURSOR, At User Command, and a Comparison of HIDE Statements

Image
 Welcome back everyone, We were discussing about the interactive classical reports, so let’s continue it. Interactive Classical Reports- GET CURSOR :- In Interactive Classical Reports, GET CURSOR statement is used to create secondary list according to cursor position. The parameter FIELD provides the name of an output field. The parameter VALUE provide the output value. Syntax : GET CURSOR FIELD <lv_field> VALUE <lv_value>. In the above syntax - the field name and field value will be returned in to variables lv_field and lv_value respectively. Requirement :- If you remember, In our last two blog, We have been displaying the order header table in a basic list and order item table in the secondary list. We have used SY-LISEL and HIDE statements to achieve the requirement. Now, we have to use the get CURSOR to achieve the same to same requirement. Code :- ************************************************************* *Start of Program *Declaring Strcutrure
Read more

Mastering ABAP: A Step-by-Step Guide to Function Modules and Groups for Modularized Programming

Image
  Function Modules :- It is a modularization technique. The transaction code to create a function module is SE37. To create a function module, we need to create a function group. Function Group :- Function group is a container for the function modules. The transaction code to create a function group is SE80. A function group can store up to 99 function modules. Requirement :- let’s create a function module for sum of two numbers. 1. Creation of function group :- Step 1 :- Go to SE80 transaction code → Object Navigator. Step 2 :- From the drop down select function group. Step 3 :- Give a name of function group. Step 4 :- press enter. Step 5 :- Click on yes a popup screen will appear. Step 6 :- Give short description → press enter → Assign package and transaction request and press enter. Step 7 :- Right click on function group and click on activate to activate the function group. Step 8 :- You will see two includes, will be added after ac
Read more