Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question