Purpose
This page explains the standard behavior for item handling by Excel in SRM RFx.
Overview
It is possible to change items by an Excel file in RFx. This functionality is useful if a mass change has to be done.
If an RFx does not contain any items, the maintenance is made by using of templates. Templates can be found on the 3rd tab of the exported Excel file.
The following guide shows how is possible to upload several item in an empty RFx.
- step: Create an RFx with the necessary header data and bidders and without items. Save the RFx.
- step: Export the content of the RFx into an Excel file. Navigate and copy the item template first.
Please note that the item header row is necessary only at the first item. If the header row is copied for the other items they will not be imported. - Copy the partner template and paste under the item line. Partner header row is necessary to add to each item.
- Maintain the mandatory fields.
The following fields should be maintained on item level:
- Document
- Change Option (I – insert, U – update, D – delete)
- Item type (Service or Material)
- Item level
- Product type (01 – Material, 02 – Service)
- Description
- Category ID
- Delivery date
- Delivery time
- Quantity
- Unit
Mandatory fields at partners:
- Document
- Change Option (I – insert, U – update, D – delete)
- Partner function
- Bussiness Partner
- Save the Excel file and open the RFx in Edit mode. Click on ‘Import’ button and choose the Excel file.
See example:
If the Delivery date and time is not specified the fields has to maintained with 00.00.0000 and 00:00:00. If these entries are empty it causes error during the importing.
Related Content
Related SAP Notes/KBAs
KBA 2915390 - Importing an Excel file in SRM Bid Invitation document does not update the RFx document
SAP Note 3155563 - In Excel Download of RFx Response Comparison, field Line Number value is missing.
SAP Note 2383982 - Excel Import in published RFX leads to BBP_FILE023 error
SAP Note 2817900 - Excel download of RFx response comparison - items are sorted in wrong order
SAP Note 2979360 - In Response Comparison excel download, the Supplier Remark field value is split in multiple lines
SAP Note 1360348 - Price details not updated at item level during upload