Upload Standard Report Data to AL11 Using SUBMIT Program

Most of the Standard report transaction codes do not have the option to upload the report data to the Application server (AL11), it can be achieved by using a wrapper program of the standard Tcode using SUBMIT program.

Blog content:

Take the standard tcode FBL5N. Have the selected input parameters from FBL5N to the selection screen of the wrapper program. There are options to upload to an application server or display.

AL11 transaction in SAP

Img: 1

Function Module

Img: 2

In our case we had certain parameters in the dynamic selections, so we used the Function module FREE_SELECTIONS_RANGE_2_EX to the format which can be used in SUBMIT program

free selection range

Now pass the selection screen parameters to the standard program of FBL5N which is RFITEMAR using the SUBMIT along with dynamic selections.

dynamic sections

Img: 3

To pass the data now from memory to our internal table, need to use a class method CL_SALV_BS_RUNTIME_INFO=> GET_DATA_REF, once we get the report data in the internal table GR_DATA, we can get the required fields and can appended to our local final internal table to display or upload to application server.

Application Server

Img: 4

Used factory method of CL_SALV_TABLE to display

Factory Method

Img: 5

Used OPEN DATASET, TRANSFER, CLOSE DATA SET to upload the data to the Application server.

Application Server

 

Let’s run the program and see if it works…

Submit Program

Conclusion:

We can call any standard program using SUBMIT and export the data from memory. Based on our requirements, we can upload data to an application server, presentation server, or pass it to a function module. for more details visit our website mobolutions

Leave a comment

Your email address will not be published. Required fields are marked *