Skip to Content
avatar image
Former Member

SEM BCS - Flexible upload using excel

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Aug 20, 2007 at 08:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Aug 21, 2007 at 11:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20, 2007 at 04:46 PM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2007 at 02:29 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

  • avatar image
    Former Member
    Aug 31, 2007 at 12:46 PM

    Hi Dan,

    Thanks for replying.

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

    Add comment
    10|10000 characters needed characters exceeded