SEM BCS - Flexible upload using excel
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.