Data Extraction of BI datasource from ECC into flat files using Debug mode.
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.
In order to over come the above challenge, lets start up with Extraction using Debug Mode.
Please follow the below steps…
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.
Now Go to the Transaction Code RSA3.
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.
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.
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.
Press Continue and save the data in a difftent name, here the name of the file is 0FI_GL_04_All_Data.
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.
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