Skip to Content
0
Former Member
Jan 22, 2013 at 04:16 PM

Text File having 3 Lakh Rows to be Uploaded in Internal Table through ABAP and Data to be processed to get concise final entries

490 Views

Dear ABAP Gurus ,

Greetings for the Day Ahead !

I have a Requirement in which there are around 3 lakh rows in a excel file and having 4 columns to be uploaded in a internal table through ABAP programming .

My observations till today are that there are these Function Modules which can help me :

1.TEXT_CONVERT_XLS_TO_SAP

2. KCD_EXCEL_OLE_TO_INT_CONVERT

3. ALSM_EXCEL_TO_INTERNAL_TABLE

4. gui_uplaod

ALSM_EXCEL_TO_INTERNAL_TABLE--- Only 65536 rows can be uploaded in one go .


Plz correct me whereever i am wrong .

I think the behavior of first 2 FMs TEXT_CONVERT_XLS_TO_SAP & KCD_EXCEL_OLE_TO_INT_CONVERT is also similar regarding the no of rows limitation .

I want to know if this approach would be correct to accomplish this task .Approach is as follows :

1.Converting the excel file to Tab delimited text file by saving it .txt format by going in file option in excel .

2.Uploading it using GUI_UPLOAD using HAS_FIELD_SEPARATOR importing parameter of GUI_UPLOAD as 'X'.

Is this approach correct for uploading 3 Lakh Rows ?? Or should some other option should be tried ?

Once it is uploaded in internal table , i have to process the data to get concise rows according to logic which has been decided .

ABAP Gurus , I would be thankful if sample code is provided for my requirement of 3 lakh Rows as the requirement is urgent and timeline is tight .

Thanks in Advance .

Rgds ,

D Singh