Importing master data for catalogs is a crucial process that enables businesses to efficiently manage and update product information. Whether you are setting up a new catalog or updating an existing one, importing master data for catalogs into SAP Ariba Procurement solutions can save time and effort while ensuring accuracy. In this lesson, we will explore the steps involved in importing master data for catalogs and discuss best practices to ensure a successful import.
Catalogs are text files that describe the products and services that a supplier offers. Suppliers can create catalogs for any product or service, regardless of how it is measured, priced, or delivered. Buying organizations search by company type, industry type, and product type to find catalogs that offer the product or service they need. They then download and import catalogs into their procurement application. Buyers can access catalogs through their procurement solutions to view what is offered and make purchases.
The SAP Integration Suite, managed gateway for spend management and SAP Business Network allows buyers to integrate catalog data from an SAP ERP or SAP S/4HANA (on premise) to SAP Business Network seamlessly. Customers can extract the catalog data from the Purchase Information Records and Materials Master records to create catalog items in a CIF file and send it to SAP Business Network and SAP Ariba Procurement solutions.
The catalog data extracted from the Purchase Information records and Materials Master records are saved as catalog items in a CIF file. The CIF file contains both mandatory and optional fields that suppliers can use while maintaining the catalog files.
With the Managed Gateway, buyers can import and handle CIF catalog files in SAP Ariba Procurement solutions using the following scheduled tasks:
- The Catalog Syndication Scheduled Task runs every 2 hours. It picks up the CIF catalog files received from SAP Integration Suite, managed gateway for spend management and SAP Business Network and processes them.
- The Catalog Syndication Delete Processed and Old Unprocessed Catalog Files Scheduled Task runs every 24 hours. It reviews the CIF catalog files received from SAP Integration Suite, managed gateway for spend management and SAP Business Network. This task also deletes processed catalog files that are older than 24 hours and unprocessed catalog files that are older than 5 days.
Hint
For additional information, refer to the following section of the SAP Integration Suite, managed gateway for spend management and SAP Business Network overview guide:Working with Master Data >
Import Master Data for SAP Ariba Procurement Solutions >
Integrate Catalogs >
Prerequisites and Limitations
You can create variants to run the Schedule Job for Catalog Upload Request multiple times for the full and incremental load. The variants can have different catalog filters and options that are required while running the Schedule Job for Catalog Upload Request. You can either schedule a job for Catalog Upload Request or manually import catalog master data.
You can use either the ARBCIG_BUYER_CATALOG_EXPORT program or the ARBCIG_BUYER_CATALOG_REPORT program to send catalog information to SAP Ariba Procurement solutions.
The ARBCIG_BUYER_CATALOG_EXPORT program forwards catalog information first to SAP Business Network before sending it to SAP Ariba Procurement solutions.
Whereas, the ARBCIG_BUYER_CATALOG_REPORT program sends catalog information directly to SAP Ariba Procurement solutions, which improves system performance.
The ARBCIG_BUYER_CATALOG_EXPORT program or the ARBCIG_BUYER_CATALOG_REPORT program processes the Purchase Information Records and the Material Master records while extracting the data to create catalog items in the CIF file.
While extracting data for an incremental load, the ARBCIG_BUYER_CATALOG_EXPORT program or the ARBCIG_BUYER_CATALOG_REPORT program records all changes done to existing data for Material Master and Purchase Info Records.
When these records are flagged for deletion on the SAP ERP or SAP S/4HANA (on premise) system, these changes are recorded in the catalog CIF file. The column Delete in the CIF file contains the value T (True) to indicate that there has been a change to the catalog item on the SAP ERP or SAP S/4HANA (on premise) system.
Hint
For additional information, refer to the following section of the SAP Integration Suite, managed gateway for spend management and SAP Business Network Overview Guide:
Working with Master Data >
Import Master Data for SAP Ariba Procurement Solutions >
Integrate Catalogs >
Prerequisites and Limitations
New values or changes done in the purchase information record or the material master records can be uploaded on SAP Business Network and SAP Ariba Procurement solutions. Buyers must run the incremental load to upload the new values to an existing catalog .CIF file.
You can specify a date period while running the incremental load to download data that has been changed or newly created during the date period. You must ensure that you use the existing catalog subscription name for each incremental load you run for an existing catalog.
To maintain the SAP Ariba field names in the SAP system, SAP Ariba Account Administrator must first create these custom fields with the required SAP Ariba field name on their SAP Ariba Procurement solutions. These new custom SAP Ariba fields can be mapped to the SAP fields in the ARBCIG_FIELDMAP table using the Maintain Field Map for Master Data and Catalog Upload Request activity on SPRO.
If you add catalog fields to the customized RFC structure, add the field, its structure, and the corresponding SAP Ariba field name using the Maintain Field Map for Master Data and Catalog Upload Request activity to have a preferred column name in the CIF files.
The CIF file created on the SAP ERP or SAP S/4HANA (on premise) system contains additional fields. You must maintain the SAP Ariba field names for the following fields using the Maintain Field Map for Master Data and Catalog Upload Request activity:
Field Name | Description |
---|---|
MATNR | SAP ERP Material Number |
WERKS | Plant |
EKORG | Purchase Organization |
ESOKZ | Purchase Info Category. For example, Standard, Subcontracting, Pipeline and Consignment. |
LABST | Valuated Unrestricted-Use Stock |
INFNR | Purchase Information Record |
Prerequisites
You can run the ARBCIG_BUYER_CATALOG_EXPORT program manually to import catalog master data to SAP Ariba Procurement solutions. Ensure that you have the necessary authorization to run the master data program.
Prerequisites:
Ensure the following:
- You have necessary General Settings configurations in place, such as Configure Ariba Incremental Extract Event, Configure Ariba Master Data Incremental Field Restrictions, and Configure Ariba Event Linkages for the Buyer Catalog Upload Request.
- You have selected "Catalog Upload Request" and "Catalog Status Response" while executing Interface Setup program for SAP Ariba Procurement under General Settings section of SAP Ariba Procurement Integration.
Hint
For more information about prerequisites 1 and 2, refer to learning.sap.com and review:
- Unit 2 of Common Configurations for Master Data Integration in the Learning Journey, Exploring the Features of SAP Integration Suite, managed gateway for spend management and SAP Business Network.
- Unit 4 of Configuring General Settings in Managed Gateway for Spend and Network Add-On in the Learning Journey, Administering SAP Integration Suite, managed gateway for spend management and SAP Business Network.
Steps to Import Master Data for Catalogs
Follow these steps to execute the ARBCIG_BUYER_CATALOG_EXPORT program:
- Run the transaction code SE38.
- On the ABAP Editor: Initial Screen, enter the program name ARBCIG_BUYER_CATALOG_EXPORT and choose Execute.
- On the Buyer Catalog Export page, input the following fields, as appropriate. Refer to the table provided in this lesson for guidance.
- Catalog Subscription Name
- Currency
- Charset
- Code Format
- Comments
- Supplierid Domain
- United Nations Unit of Measures
- Variant
- Partition
- Catalog Filters
- Storage Location Filter
- Product Hierarchy or Classification Code as Commodity Code
- Load Option
- Auto Publish
- Test Run
- SAP Business Network Buyer ID
- SAP Business Network Supplier ID
- Email Notification to Buyer
- To export the selected catalog data, choose Execute.
Field Name | Description |
---|---|
Catalog Subscription Name | This is a required field. The catalog subscription name is a unique identifier in SAP Ariba for the catalog. Ensure that you do not change the existing name for the catalog subscription while running the full or incremental load. All new versions of the catalog continue to have the same catalog subscription name. You must ensure that you use the existing catalog subscription name for each incremental load you run for an existing catalog. |
Currency | This is a required field. The default currency for unit prices for the items in the catalog. The default value is USD. Change the currency value as necessary. |
Charset | This is a required field and is case-sensitive. The encoding and charset to convert the data in the CIF file. For example, UTF-8. |
Code Format | This is a required field. You must specify the UNSPSC format. |
Comments | The comments for the catalog. |
Supplierid Domain | This is a required field. Provide the domain for the SupplierID. Ensure that you specify the SupplierId_Domain that you maintain for the supplier on the SAP Ariba Procurement solutions. For example, SUPPLIERID_DOMAIN:DUNS |
United Nations Unit of Measure | This is a required field. Select this option if you want to send the catalog in the UNUOM format. |
Variant | Specify the unique variant name for the SAP Ariba Procurement solutions defined in your SAP system. For example, VREALM_2. |
Partition | Specify the unique partition name for the SAP Ariba Procurement solutions defined in your SAP system. For example, PREALM_2. |
Catalog Filters | Specify the values for the following filters as per your requirement:
|
Storage Location Filter (Only for MRO Inventory Customers) | You need select this option only if you are adopting Stock Reservation feature. Select this option if you want to export information for only the specified set of storage locations as part of the Catalog Master Data export to SAP Ariba Procurement solutions. Prerequisite for selecting this option is to maintain the ENABLE_MRO_INVENTORY parameter |
Product Hierarchy or Classification Code as a Commodity Code | Contains two options: Product Hierarchy: This option allows you to download the commodity code maintained in the product hierarchy field present in the basic data view of the material master on the SAP system. Classification Code: Choose this option if you want to use the commodity code maintained in Classification view for the full or incremental load. If you use this option, you must also specify additional parameters. |
Load Option | Contains the following options: Full Load: Allows you to extract all the Purchase Information records and Materials Master records. You can run the full load more than one time. Update Catalog subscription: Choose this option only when you want to update an existing catalog subscription entirely using the full load. Ensure that you do not use this option the first time to create a new catalog subscription. Incremental Load: Allows you to extract only the changed or updated records. You can optionally specify the date from that you require the records to be extracted from the SAP system. |
Auto Publish | This option allows you to automatically publish the catalog: True: Choose this option to automatically publish the catalog. This is the default option. When you enable this option, the CatalogUploadRequest file contains the value "TRUE" in the AutoPublish enabled field. False: Choose this option if you do not want to automatically publish the catalog. When you enable this option, the CatalogUploadRequest file contains a blank value in the AutoPublish enabled field. |
Test Run | Select the Test Run option if you wish to verify the data in the CIF file before exporting it to SAP Ariba Procurement solutions. When you select this option, you need to specify a directory path in the Dir Path for file download field to download the files on the SAP’s application server. Ensure that the application server directory exists with the necessary permissions before running the catalog import. In the Test Run mode, the catalog CIF file is not exported to SAP Ariba Procurement solutions. ARBCIG_BUYER_CATALOG_EXPORT program validates the file path that you specify and a folder "Catalog" is automatically created to store the catalog CIF file. If the file path is invalid, the ARBCIG_BUYER_CATALOG_EXPORT program displays an error. |
SAP Business Network Buyer ID | Specify the SAP Business Network ID of the Buyer. |
SAP Business Network Supplier ID | Specify the SAP Business Network ID of the Supplier. |
Email Notification to Buyer | Enter the email address of the Buyer. |