SRM 4.0 - Upload function of Bid Invitations (Bidding Engine)

[former_member286985]

Hello,

I am currently working on the Bidding Engine in SRM 4.0

I would very much like to use the Download/Upload function in Bid Invitations, but for now I have the feeling it doesn’t work.

I tested it by downloading a Bid Invitation and changing just one info like an item quantity or description. I put “U” (for “Update”) in the corresponding cell of the “Change” column. I also held the bid invitation in SRM before returning to it to upload the modified Excel-file.

When I upload the Excel file, I don’t have any error messages, but no changes are done either.

Does anyone of you have an idea how I could make it work?

Thanks!

Andrea

[Former Member]

Hi Andrea,

have a look into Note 790860. It describes how the "mystery" of Up/Download

works. It is pretty basic, but it works. You need to add / change lines using the

change codes A = Add, U = Update, I = Insert.

Users do not like it, why some companies developed their own excel macros

to manage the up/download. For this Note 812884 gives some help.

Cheers,

Claudia

[former_member286985]

Thank you for your answer Claudia, but unfortunately these notes do not resolve my problem. I used "U" for the change from the start, but I guess there is something else...

[Former Member]

Hi,

Please do the following things.

Excel updown/download is very flexible functionality.

(BADI : BBP_PD_DOWNLOAD)

1. You can change the format (how the document should be downloaded, which fields : Control variants in BBPC_UP_DOWNLOAD table)

2. You can also upload file (your own format : implement parsing method)

3. You can add your own fields. (APPEND_UPLOAD_DATA)

We are working on one such scenario for Contract Upload.

You can also check the following notes.

There is a SAP Note on downloading BID file.

Note 734060 - SRM: Upload and download of documents using MS Excel

They have given one example in this note.This is a consulting note,you will find it

Two more notes which can help you

734060

734946

I hope it will help.

BR,

Vijay Mittal

Plz award the points for help.

[former_member286985]

Thanks a lot, but unfortunately these notes do not help...

Andrea

[Former Member]

Hi Andrea,

you need to maintain a line for each change you make. So e.g. for "U",

enter a new line with the content you want to update. Just an change

of type of line does not make it. It is a line by line approach; that's why

I said, the download/upload function is not quite comfortable.

There will also not be any error messages cause of this.

Cheers,

Claudia

[Former Member]

Hi,

Can you use the upload to create new lines or entirely new documents in bids and contracts?