Skip to Content

Data Extraction to flat files can be made in different ways but  extraction of data in Debug mode using EXIT_SAPLRSAP_001 sap exit is more efficient,less consumption of memory and time.

The Common Challenge that we go through in RSA3 is Memory and the Amount of data inside the Database 

For example lets take 0FI_GL_4,the table used are BSEG and BKPF .This Datasource Generally contains huge Data and when you execute the datasource , the system takes a lot of time and at the end it generates short Dump. the Dump is as shown below.

image

In order to over come the above challenge,  lets start up with Extraction using Debug Mode.

Detailed Steps:
Please follow the below steps…

Step1 

Log on to the ECC system . go to Transaction Code SE37 give the Function module name EXIT_SAPLRSAP_001.

Get into the function module and set a break point on the INCLUDE ZXRSAU01 Structure and exit from the screen.

image

Step2

Now Go to the Transaction Code RSA3.

image

Give the Datasource name 0FI_GL_4.

Increase the Data Records / Calls to 999999 and Display Extr. Calls to 1 because we can see all the data in single Data packet and can easily extract all the data to a flat file. 

Now press Execute (F8) since we have  already set a break point ,after a Few minutes the screen gets into the Debug mode and stops. At this time the data is ready for extraction inside the internal table C_T_DATA in a single Packet.

Step3

In the ABAP Debugger Screen, Type C_T_DATA[] as show bellow and press Enter.

Now it will show the total number records inside the datasource , here in this example the total number of records is 815572.

image

Step4

Double Click on the C_T_DATA, now we can view the entire data of the Datasource as shown below.

In case if the number of records are more than 999999 we should increase the DisplayExtr Calls to 2. and extraction is done in two different packets one after the other.

we have captured whole Data inside the internal table C_T_DATA,from the internal table we need to export it to a flat file using the icon save as excel sheet as shown in the figure below.

 image

Step5 

Press Continue and save the data in a difftent name, here the name of the file is 0FI_GL_04_All_Data.

image

The system takes some time to get saved inside the local machine. wait for few minutes and then open the file which is saved in the local system.

The Output looks as below Shown.

image

Note : This extraction is advisable to install Microsoft Office 2007

Because in Microsoft 2003 the  Number of rows is  Limited to 65536

But in Office 2007 Excel supports more than 1 Million Records

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply