Importing Bill of Material to SAP Ariba Product Sourcing​

Objective

After completing this lesson, you will be able to import Bill of Materials (BOM) data from SAP ERP or SAP S/4HANA on-premise to SAP Ariba Strategic Sourcing Solutions​.

Importing Bill of Material

Importing the Bill of Materials (BOM) from the SAP system to SAP Ariba Product Sourcing involves several key steps, including data extraction, transformation, and loading into SAP Ariba Product Sourcing. Using SAP Integration Suite, managed gateway for Spend Management and SAP Business Network solution, you can effectively import BOM data from the SAP system to SAP Ariba Product Sourcing, ensuring a streamlined and integrated procurement process.​

Follow these steps to import Bill of Materials (BOM) data from the SAP system to SAP Ariba Product Sourcing:

  1. On the SAP Easy Access screen, run the transaction code SE38 and choose Enter.Image depicting the SAP Easy Access screen and running transaction code SE38.
  2. On the ABAP Editor: Initial Screen, enter ARBCIG_BOM_REPLICATE in the Program field and choose Execute.​Image depicting the execution of the ARBCIG BOM REPLICATE program.On the Export BoMs to the SAP Ariba Solutions screen, you will have multiple options to select and fields where you must enter the necessary values or information. Let’s discuss each one in more detail.
  3. If you want to verify the data in the CSV files before exporting them to SAP Ariba Product Sourcing Solutions, in the Execution Mode section, check the Test Run box. When you check the box, you must provide a directory path on the SAP application server to download the ZIP files, such as c:\temp. Ensure that the application server directory exists with the necessary permissions before running the master data import.

    Note

    The master data files are not exported to SAP Ariba Product Sourcing Solutions in the Test Run mode.​
  4. In the Solution section, select the radio button for Sourcing.Image of the Extract BOMs to SAP Ariba Solutions screen with the Execution mode and Solution sections highlighted.
  5. In the Extraction Mode section, select one of the following:
    1. Full Load: The Full Load option exports all the Bill of Materials (BOMs) that are available.​
    2. Incremental Load: In the Incremental Load option, only those BOMs will be exported that have been updated since the last BOM data extraction was done (not in Test Mode) from the SAP system.​

      Note

      The date and time range is not mandatory. If it is left blank, the program considers the From Date and Time of the last instance of the program run. TheTo Date is the current date and time.​
      Image of the Incremental Load section of the Extract BOMs to SAP Ariba Solutions screen.
  6. In the Variant and Partition section, provide the necessary details:
    1. Enter the Variant value. For example, VREALM_1.
    2. Enter the Partition value. For esample, PREALM_1.
    The values you enter for Variant and Partition must match with the values you have defined for Ariba Sourcing Integration in the Map the Variant and Partition for SAP Ariba solutions configuration of Global Settings.Image of the Variant and Partition section of Extract BOMs to SAP Ariba Solutions screen.

    Hint

    For more information on how to maintain mapping variants and partitions configuration, refer to Unit 2 of Configuring Global Settings for Managed Gateway Spend&Network Add-On in the Learning Journey, Administering SAP Integration Suite, managed gateway for spend management and SAP Business Network here at learning.sap.com.​
  7. In the Execution Filter Options section, input the values as appropriate for the filter criteria:
    1. Material
    2. BOM Number
    3. Plant
    4. Usage
    5. Alternative
    Image depicting the Extraction Filter Options.
  8. In the Parallel Processing Options, provide the necessary details to expedite the export of BOMs. This is an optional setting when you have a long list of BOMs to be exported.​
  9. Once all the necessary values are maintained, to export the BOMs data to the SAP Ariba Product Sourcing Solutions, choose Execute.Image of the filter criteria for the Extraction filter options.

    Upon executing the export event, you get the log details. You can also view the logs via transaction code SLG1.

    Image of the log details.

Bill of Material request then passes through the Managed Gateway. You can view the status in the Transaction Tracker either by providing the specific date and time or by filtering the results with the Document Type BOMReplicateRequest. The document Status is displayed as Completed.

Image of the transaction tracker and the status displayed as completed.

To check the status of BOM data upload in your SAP Ariba Strategic Sourcing site or realm, log in as an Administrator, navigate to the Product Sourcing Manager menu, and choose Message Queue.

Image of Product Sourcing Manager Administration and Message Queue.

On the Message Queue page, filter the results by Message queue type = INBOUND and Type = BOM Replication. You can additionally provide the From date and To date as filter criteria.​

Once the BOM Replicate upload is successful, the status is displayed as Success.

Image of the message queue with relevant information.

Log in to track your progress & complete quizzes