Procedure documentationTransferring Service Hierarchies from Microsoft Excel Locate this document in the navigation structure

 

You use this procedure to transfer service hierarchies from a Microsoft Excel sheet to the SRM-MDM Catalog.

The relevant Customizing switch is Service Procurement Enhancements for SRM-MDM Catalog (CAT_701_CTR_UPLOAD),

Prerequisites

  • You have prepared the data to be imported using the XML templates.

  • You have identified the service repository to which the data must be imported, and have been assigned the Administrator role for that repository.

Procedure

  1. Using SAP MDM Import Manager, connect to the service repository using the following data:

    • Type: Excel

    • Remote system: SRM

  2. In the File name field, select the Microsoft Excel file to be exported, and choose Finish.

  3. Choose   File   Open  , and select the map _XLS_Structure.

    Note Note

    Ensure that the source is XLS1, and the destination table is MSS Hierarchy.

    End of the note.

  4. Choose the Import Status tab, and ensure that the status is Ready to Import.

    Note Note

    If the status is Map ‘MSS Hierarchy <Split Hierarchy> field Value(s), proceed as follows:

    1. On the Map Fields/Values tab, select the corresponding map.

    2. Choose   Add   Add Branch as Child  .

    3. Choose the Import Status tab, and ensure that the status is Ready to Import.

    End of the note.

  5. Choose Execute Import.

  6. Repeat steps 3-5 for the following maps:

    • _XLS_Structure_Price

    • _XLS_MSS_ITEM

    • _XLS_MSS_ITEM_PRICE

  7. Using SAP MDM Data Manager, logon to the service repository and ensure that the data has been imported.