How is the data file (excel) is passed from a BSP application to a FM?

[Former Member]

Hello Guys,

In the present system that we have, a user interface has been created on Portal (I think IView has been created using a BSP application) which takes a excel file as an input. On the back-end, the file is passed to a Function Module which uploads data to corresponding Internal Tables.

Right now I dont have the debug facility on the portal side, hence I am not able to see how the file is being passed from BSP to FM. Have any of you worked on similar scenarios. If yes, can you tell me in what different ways the file upload can be handled in this particular scenario?

Thanks in advance,

Regards,

Abhishek

[former_member184111]

Hi Abhishek,

Make sure that the iView is created using BSP Application because in BSPs excel fiels can not be uploaded..only CSV files can be processed in BSP applications.

Regards,

Anubhav

[Former Member]

Hi Anubhav,

If I create the IView using the BSP application, then how is the file passed from the front end to the back end. Is it passed as a buffer or a table control?

Can we use ALSM_EXCEL_TO_INTERNAL_TABLE to read this file and upload it to our internal table?

Regards,

Abhishek

[Former Member]

Dear Abishek,

In the BSP application we have an UI element as Fileupload. By using that element we can able to read the Excel file as either CSV or Tab delimited.

It read the file as Xstring. After that you have to use 2 FM's. That are

1.SCMS_XSTRING_TO_BINARY

2.SCMS_BINARY_TO_STRING

Finally, you can get the excel file contents in internal table.

In the standard there is no Excell processor. So we can't use the FM ALSM_EXCEL_TO_INTERNAL_TABLE

Appreciate if its Helpful.

Regards,

Anita Vizhi Arasi B

[former_member184111]

Hi Abhishek,

Have a look at these threads..

[BSP & Excel-I|;

[BSP & Excel-II|;

The FM ALSM_EXCEL_TO_INTERNAL_TABLE can not be used in BSPs..

Regards,

Anubhav