Reviewing Sourcing Master Data Interation

Objective

After completing this lesson, you will be able to define how to configure, maintain and import master data required for SAP Ariba Sourcing Integration.

Overview

SAP Ariba Sourcing – Master Data Integration Overview:

  • Master Data consists of general information stored in SAP that is used in SAP Ariba Sourcing solutions to construct Contracts.
  • The SAP Ariba Sourcing solutions provide the integration events for standard data imports from SAP System.
  • Because your SAP System implementation might contain additional data to be included with the SAP Ariba Sourcing solutions for Contracts, you can modify these data imports to include such data.
  • When you import large amounts of Master Data from your SAP System, ensure that you run the master data import task in the background.
  • You can import Master Data by running integrations events manually from SAP Ariba Administrator.
  • When buyers import the Master Data for the first time, SAP Ariba recommends that you choose the Full Load mode.
  • Buyers can use the Incremental Load mode for subsequent run to import Master Data records that have been added, modified, or deleted since the last Master Data import event.
  • Material Master Data contains large volume of information. For best performance, always set filters that specify the criteria based on which you can import smaller subsets.
  • When buyers export Material Master Data, the extract includes Material Master Plant associated data, Material Master Language associated data.
  • When buyers import Cross Application Master Data for Incoterms, the extract includes Incoterms Language associated data.

Sourcing Master Data Integration Overview

Required Master Data

Organizational Data:
  • Plant
  • Plant Purchase Org
  • Company Code
  • Purchase Org
  • Purchase Group
Cross Application Configuration Data:
  • Payment Terms
  • Incoterms
Material Master Data:
  • Material Master
  • Item Category
  • ERP Commodity Code
  • Purchase Info Record (PIR)

Overview

Importing Material Master Data:

  • When users import Material Master data from SAP System to Ariba Sourcing, they can receive classification data such as Class Types, Class Names & Characteristics.
  • The classification value allows users to categorize materials based on their characteristics. Classification data also enables users to search & find materials easily.
  • When users import Material Master data SAP System provides the classification information in the ItemMasterClassificationInfo.csv file.
  • ItemMasterClassificationInfo.csv contains Class & Classification information along with Classification Sequence & Material Number.

Note

This is mainly used for Contracts integration. You can also use it while creating QM / Award.
  • To extract Material Classification data, maintain the following filters in the table ARBCIG_TVARV:
    • CLASS_TYPE
    • CLASS
  • When users import Material Master data from SAP System to Ariba Sourcing, SAP System also sends the Manufacturer Parts List to Ariba Sourcing.
  • The Manufacturer Parts List is similar to the Approved Manufacturer Parts List (AMPL) in SAP System. You can use the Manufacturer Parts List to identify the manufacturers for materials of type Manufacturer Parts (HERS in SAP), the Manufacturer Part Numbers & the corresponding internal part numbers.
  • Ensure that you import the Plant, Plant Purchase Org, Purchase Org & Purchase Group master data before you run the master data import for the Material Master.

Note

TCode – sm30 to add above filters as it is not available in SPRO node.

Activity i: Configure Ariba Sourcing Solutions for Synchronizing Master Data

User needs to perform following activities to configure SAP Ariba Sourcing for synchronizing Master Data:

  1. SAP Cloud Integration Gateway dashboard showing Integration Projects, Supplier Reporting, Transaction Tracker, My Projects, and navigation tabs.
    From the CIG homepage, navigate to the Resources section.
  2. SAP Cloud Integration Gateway Resources tab displaying CIG Certificates, Tenant/Client certificates for Test and Production environments with details.
    Download Keystore / Tenant certificate for the environment you are working on (Test or Prod).
  3. SAP Test Site dashboard showing Event Status, Expiring Contracts, Common Actions, and Manage menu with Administration options highlighted.
    Log in to Ariba Sourcing site & from Manage menu navigate to Administration.
  4. SAP Test Site Administration page showing options like Integration Manager, Site Manager, Master Data Manager, and Toolkit Security highlighted.
    Expand the Integration Manager menu & click Integration Toolkit Security.
  5. SAP Test Site's Integration Toolkit Security configuration for Certificate Authentication, showing certificate details, authentication method, and Save button.
    Select Certificate as the authentication method.
  6. Paste the certificate you have downloaded in step#2.
  7. Click Save.

Activity ii: Configure External System

User needs to maintain External System information which corresponds to your backend SAP System. This configuration is required while uploading Master Data. The correlation of System ID-Master Data is used while creating Quote Messages as well as Contracts.

To maintain External System:

  1. Login to your Ariba Sourcing realm as an Administrator; click Manage, click Administration.SAP Test Site dashboard highlighting Manage menu with Administration option, Event Status chart, Common Actions, and Expiring Contracts.
  2. Expand Master Data Manager menu, click External System Configuration.SAP Test Site Administration page showcasing External System Configuration under Master Data Manager with various administrative task options.
  3. Click Create New.SAP Test Site External Systems page under Administration, showing search filters, active status options, and highlighted Create New button.
  4. Provide details in ID & Name fields, click Save (This is your SAP’s Logical System ID.).SAP Test Site External Systems creation page showing ID, Name, Type fields, and highlighted Save button under Administration.

The newly added External System is available:

SAP Test Site External Systems screen displaying created system ID, Name, and Type, with Create New and Actions options available.

Activity iii: Maintain Parameters

User needs to maintain the required parameters for Ariba Sourcing solutions:

  1. Navigate to Integration with Other SAP Components → Ariba Cloud Integration Gateway → Master Data Integration → General Settings → Maintain Parameters using the transaction code SPRO.SAP Display IMG menu navigating to Maintain Parameters under General Settings in SAP Ariba Cloud Integration Gateway.
  2. Expand Maintain Parameters section, click IMG-Activity for Sourcing – the Parameters – Ariba Sourcing Master Data screen appears.SAP Maintain Parameters menu highlighting the Sourcing section under configuration options for Ariba Integration.
  3. Maintain the parameters mentioned in the table in this lesson.SAP Parameters list for Ariba Sourcing Master Data, displaying variable names, fields, variants, and partitions.
  4. Click Save.

Parameters Applicable for SAP Ariba Sourcing

Parameter NameDescriptionSupported Values
DC_WAITTIME

OPTIONAL FIELD

This parameter allows you to specify the wait time between more than one master data export batch task. This is useful when you want to split the large master data export tasks in batches.

Specify the wait time in seconds. The default value is one second.

You must specify a value for this parameter if you have also configured the SPLIT_NOMREC parameter to split the master data export into multiple batches.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM1 (example)
  • Low: Enter the wait time in seconds. 5 (example)
EXTERNAL_SID

MANDATORY FIELD

This parameter allows you to specify the system ID name that you have defined in your SAP Ariba Sourcing system. The value you specify in this field must exactly match the value available on your SAP Ariba Sourcing system.

Specify the system ID that you have maintained in the Master Data Manager → External System → Configuration page on your SAP Ariba Sourcing system.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (for example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM1 (for example)
  • Low: Enter the System ID of the SAP Ariba Sourcing system. SAPERPSYSTEM1 (for example)
MATERIAL_ONLY_AML

OPTIONAL FIELD

This parameter allows you to filter the Manufacturer Parts List data for a specific material number when you export Manufacturer Parts List from SAP ERP to SAP Ariba Sourcing.

Specify the material number for the item in the Manufacturer Part List.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM2 (example)
  • Low: Enter the material number for the item. HERS (example)
SPLIT_NOMREC

OPTIONAL FIELD

This parameter allows you to split the large master data export tasks in batches.

Specify the number of records that needs to be included in each master data export batch task. You must specify a value for this parameter if you have also configured the DC_WAITTIME parameter and specified the time duration to wait in between one master data export task and the other.

If you do not specify the number of records that must be included for each master data export task, the master data export program could take a considerably long time and could cause timeout errors.

SAP Ariba recommends 40,000 as the maximum value of records you could include in a batch.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (for example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM2 (for example)
  • Low: Enter the number of records that needs to be included in each Master Data export batch task. 36000 (for example)
MATERIAL_CLASSIFICATION

OPTIONAL FIELD

This parameter allows you to set a filter while importing the UNSPC classification data for material items before you run the master data program.

Set the value to X to import the UNSPC classification for material items. If you leave this field blank, the program ARBCIG_MASTER_DATA_EXPORT does not import the UNSPC classification code for material items.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (for example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM2 (for example)
  • Low: Enter X to import the UNSPSC classification data for material items. If you leave this field blank, the program ARBCIG_MASTER_DATA_EXPORT does not import the UNSPC classification code for material items.
ENABLE_CONV_MATERIAL_ONLY

OPTIONAL FIELD

This parameter enables you to import the Material Master value without any preceding zeros.

Set the value to X to import the Material Master value without any preceding zeros.

If you leave this field blank, the ARBCIG_MASTER_DATA_EXPORT program import the Material Master value with the preceding zeros.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (for example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM2 (for example)
  • Low: Enter X to import the Material Master value without any preceding zeros. If you leave this field blank, the program ARBCIG_MASTER_DATA_EXPORT import the Material Master value with the preceding zeros.
IGNORE_PLANT_EXTN

OPTIONAL FIELD

This parameter enables you to import all the Material Master information irrespective of they being extended to a plant.

Set the value to X to import all the Material Master information that are not extended to a plant. If you leave this field blank, the ARBCIG_MASTER_DATA_EXPORT program does not import the Material Masters that are not extended to a plant.

  • Field Name: Leave it blank
  • Number: 0000
  • Variant: Provide a unique variant name for SAP Ariba Sourcing realm. VREALM2 (for example)
  • Partition: Provide a partition name for SAP Ariba Sourcing solution. PREALM2 (for example)
  • Low: Enter X to import the Material Master information that is not extended to a plant. If you leave this field blank, the ARBCIG_MASTER_DATA_EXPORT program does not import the Material Master value that is not extended to a plant.

Activity iv: Maintain Filters

User needs to configure selection criteria to filter the data to export to Ariba Sourcing solutions:

  1. Navigate to Integration with Other SAP Components → Ariba Cloud Integration Gateway → Master Data Integration → General Settings → Maintain Filters using the transaction code SPRO.SAP Display IMG menu highlighting Maintain Filters under General Settings in SAP Ariba Cloud Integration Gateway.
  2. Expand Maintain Filters section & click on IMG-Activity for Sourcing – The Prefilters – Ariba Sourcing Master Data screen appears.SAP Maintain Filters menu highlighting the Sourcing option under configuration for Ariba Integration settings.
  3. Prefilters screen for Ariba Sourcing Master Data showing variable names, field names, types, and partitions.
    Maintain the filters based on your requirements.
  4. Click Save.

Note

The complete list of Filters with its usage is available in SAP Ariba Cloud Integration Gateway Configuration Guide under Working with Master Data → Importing Master Data for SAP Ariba Sourcing & SAP Ariba Contracts section.

Activity v: Import Master Data from SAP System

Users can run the ARBCIG_MASTER_DATA_EXPORT program on SAP System to import Master Data from SAP System to SAP Ariba Sourcing solutions.

Please follow these steps to run the Master Data export program:

  1. Run the TCode SE38.ABAP Editor Initial Screen: Enter transaction /OSE38 and program ARBCIG_MASTER_DATA_EXPORT, then execute.
  2. Enter the program name ARBCIG_MASTER_DATA_EXPORT & click Execute – The Export All Master Data Required For On-Demand Application page appears.
  3. In the Execution Mode section, tick the Test Run check box & specify the directory path for downloading the files in the Dir Path for file download field when you want to run the master data program just to check the contents in the .csv file. When you keep the box unticked, data will be sent to the SAP Ariba Sourcing solution.Export All Master Data screen for On-Demand Application with Execution Mode and SAP Ariba Sourcing options.
  4. In the Solution section, choose Sourcing & Contracts.
  5. In the Load Option section, choose one of the following:
    • Full Load: Imports all the Master Data records that are available for the Master Data type.
    • Incremental Load: Imports the Master Data records that have been updated since the last Master Data export event from the SAP System. You can import Material Master data only using the incremental load option.
    Load option screen for Full or Incremental Load with configuration settings for encoding, variant, partition.
  6. In the Configuration section specify following values:
    • Encoding to be used: The encoding & charset to convert the data in the CIF file. UTF-8 (for example). This is a required field & is case-sensitive.
    • Variant: Specify the unique variant name of your Ariba Sourcing realm. For example, VREALM_2.
    • Partition: Specify the unique site name of your Ariba Sourcing realm. For example, PREALM_2.
  7. In Choose Master Data for Export section, select the events for which you want to export the data.Selection screen for exporting master data including organizational data, configuration data, and material master.
  8. Click Execute to export the selected Master Data to Ariba Sourcing.Export All Master Data screen for SAP Ariba with Incremental Load, Material Master, and resend option.
  9. For the Incremental Load option, only the Material Master option is available for selection. To import Material Master data in the incremental mode, tick Material Master check box.
  10. To resend the Material Master information again, enter the range values for material item.
SAP Ariba Transaction Tracker showing environment, document type, transaction details, and document status.

When the Master Data request gets passed through CIG, the Document Status is displayed as COMPLETED.

SAP Ariba Manage Data Load Requests screen showing external system, status, filters, and load details.

When the Master Data upload request reaches SAP Ariba Sourcing, status reflects as Scheduled.

This is a pre-processing status.

SAP Ariba Manage Data Load Requests showing external system, status, payload timestamp, and activity details.

When the Master Data upload gets processed in SAP Ariba Sourcing, status gets changed to Indexing Success.

Activity vi: Implement BAdI for Purchase Info Records

User needs to implement BAdi as below:

  1. Navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Master Data Integration → Enhancements → Business Add-Ins(BAdIs) BAdIs for Purchase Info Record using the transaction code SPRO.
  2. Implement the BAdi ARBCIG_PURINFREC and use appropriate method from below.
Method NameDescription
MAP_PIRTo map additional fields to a purchase info record.
MAP_PIR_CHANGETo map the changes to the custom fields of a purchase info record.
POST_PROCESSINGTo customize and send a confirmation to SAP Ariba after creating the purchase info record.
CONDITION_MAPConditions used to map additional fields to a purchase info record.
PRE_PROCESS_PIRPre-processing for the pricing scales in PIR creates/changes (>/= EHP7).
POST_PROCESS_PIRPost-processing for the pricing scales in PIR creates/changes (>/= EHP7).

Activity vii: Maintain Field Map for Ariba Sourcing Master Data

Users need to maintain the field map when adding new custom fields for the Master Data in the customized RFC structure.

  • Maintain the field, its structure & the corresponding SAP Ariba field name for the new field in the field map table.
  • This table allows users to maintain the mapping between SAP System fields & Ariba fields for Ariba Sourcing or Ariba Contracts.
  • If you do not maintain the mappings, CIG displays the SAP field name on Ariba Network, Ariba Sourcing & Ariba Contracts.

Note

This is already discussed in Comman Master Data Integration – Maintain Field Map for Master Data and Catalog Upload Request session.

Activity viii: Import Bill of Materials

Users can run the ARBCIG_BOM_REPLICATE program or TCode ARBCIG_BOM_REPL in SAP System to import Bill of Material data from SAP System to Ariba Direct Material Sourcing solutions. Ensure that you have the necessary authorization to run the Master Data program.

Follow these steps to run the Bill of Material replication program:

  1. Run the ARBCIG_BOM_REPLICATE program.SAP ABAP Editor initial screen with program name ARBCIG_BOM_REPLICATE and execution option highlighted.
  2. Check Test Mode when you want to run the program and validate the contents in the .zip file.\u000BEnter the file path, where you want to download the .zip file.Extract BoMs screen for SAP Ariba Solutions with execution mode, extraction mode, and filter options.
  3. In the section Execution Mode, choose one of the following:
    • Full Load: Imports all the BOMs that are available.
    • Incremental Load: Imports the BOMs that have been updated since the last BOM data \u000Bextraction was done (not in Test Mode) from SAP ERP.
  4. Enter the values for Variant and Partition fields.
  5. You can filter the BOMs by Material / BOM Number / Plant / Usage / Alternative.
  6. Click Execute.
Extract BoMs to SAP Ariba Solutions summary, listing payload details, total entries, and save location.
  • If you had checked Test Mode, the BOMs get downloaded in a .zip file on your SAP system. The screen displays the number of BOMs, and the location (your SAP system server) of the .zip file downloaded.
  • If you did not check Test Mode, the ARBCIG_BOM_REPLICATE program exports the BOMs from SAP system to SAP Ariba Product Sourcing via SAP Ariba Cloud Integration Gateway.

    Note

    Check Parallel Processing (Not available in test mode) to expedite the export of BOMs, when you have big list of BOMs to be exported. Enter the packet size.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn