SEM BCS - Flexible upload using excel

[Former Member]

Dear Gurus,

I upload the RFD using excel.

There 2 kinds of Excel File. First is file that user has to input ( I call it "USER FILE") , and the other is file that have to be uploaded to BCS ( I call it "UPLOAD FILE").

Let say, FSI Account Receiveable has subassignment Trading Partner and Currency. I Have 200 Trading Partner and more than 10 Currency.

So in the "user file", I have to define 200 x 100 rows, only for the Account Receiveable.

Based on "User File", I create a macro to update "upload file" that have to be uploaded to BCS. Let say , if user only inputs 2 rows then the macro only update 2 rows for "upload file".

The question is :

How to make an effisien "user file"? Because I think 2000 rows are not effisien.

Do anyone have a sample excel upload that user have to fill?

If you don't mind , Please Share and advise for the format....

Thanks in advance.

[dan_sullivan · Accepted solution]

One suggestion is to create lists (drop-down) in Excel for the user to choose the trading partner and currency from the available choices. This simplifies the user file.

Also on the user file I've often created a "Save" macro that saves the file both as an XLS file as well as either a CSV or TXT file. Therefore the flat-file is automatically created for upload.

[Former Member · Accepted solution]

Dan,

I cannot predict how many rows that user want to input. It could be only 3 rows but it also could be 20 rows. So if i create lists(Drop-down), do i have to define only 1 row and if users need more than 1 row then users should insert the rows by themselves?

I also concert about the sheet. How many sheet in excel that you have?

Eugene,

I need 2 file because one for user input and the other for upload to BCS.

Because of many combinations for the breakdown category, so I need to define 2000 rows only for one FSI. So I want to simplified the file for user input.

Thanks for both of you.

[Former Member]

Hi Dan,

Thanks for replying.

I have solve this problem. I use macro to insert the rows.

[dan_sullivan]

Regarding the unknown number of rows, simply copy the list(s) for all of the cells in the entire column. When the flat-file is created it ignores these if they remain blank in the spreadsheet.

[Former Member]

Hi,

About user input file -- don't you think that use of the standard BPS entry forms or even BCS data entry layouts might alleviate the end user life?

[Former Member]

Yes, but not all company use sap as their system, so the user input file still be needed to collect the RFD.

[Former Member]

Hi,

ACtually, for me it's not clear why you need 2 types of files and what kind of alleviation do you expect?