Connecting ERP Vendor Fields to Supplier Management Questionnaires​

Objective

After completing this lesson, you will be able to connect the questionnaire answers to fields in the SAP Ariba unified vendor database model through field mapping

Connecting Vendor Fields to Supplier Management Questionnaires

SAP Ariba Supplier Management Solutions uses questionnaires to gather information about suppliers. You can directly connect the answers to those questions to the fields in the SAP Ariba unified vendor database model through field mapping. The answers are then replicated to the corresponding fields in the integrated SAP system. SAP Ariba recommends collecting specific types of information in the supplier request with questions mapped to corresponding database fields. Data collected in this way synchronizes to an integrated SAP MDG-S system.

Likewise, data replicated from the integrated SAP system is stored in corresponding fields in the SAP Ariba unified vendor model and populated in mapped fields in SAP Ariba Supplier Management solutions questionnaires.

To map a question to a vendor database field, a template creator adds questions to a supplier form, questionnaire, or internal survey in one of the supplier management project templates and adds the vendor field to the Supplier Field Mapping field on the Add Question page. Several field mapping values are used only internally in SAP Ariba Supplier Management projects. Still, most values correspond directly to vendor field names in the SAP business partner model.

SAP Ariba Supplier Management solutions do not support storing multiple values, such as various bank account numbers, tax IDs, or addresses, for the same underlying fields.

Note

The Supplier Management Setup and Administration Guide provides more information on mapping questionnaire answers to vendor database fields in supplier management projects, following the defined best practices. Navigate to:

Supplier Management Form and Questionnaire Setup>About Adding Content to a Supplier Form or Questionnaire > About Adding Questions to Supplier Forms and Questionnaires>Question Field Mapping section.

To create a supplier or vendor record in SAP MDG-S, you need to set default values for certain fields. These default values serve as the initial inputs for vendor database fields in supplier records created in SAP Ariba Supplier Lifecycle and Performance. Proper integration with SAP MDG-S requires specific settings for these default values, which represent minimum best practices and integration requirements.

You can set default values by importing a CSV file that defines them. The Default Field Values section of SM Administration offers a comprehensive list of vendor database fields and allows you to download your current default settings or upload new ones. Members of the SM Ops Administrator and SM ERP Administrator groups have the ability to download sample files and import the default definition CSV file in this section.

For integrations with SAP MDG-S, the following default values are required:

Vendor Database FieldRequired Default ValueNotes

vendor.vendorInfoExt.releasedIndicator

TRUE 

vendor.vendorInfoExt.reconciliationPeriodCounterValue

1 

vendor.roleExt.roleCode and vendor.vendorInfoExt.numberRangeIntervalBusinessPartnerGroupCode

One or more values associated with the account group (vendor.vendorInfoExt.maintenanceProfileCode) selected for the supplier in a supplier management questionnaire such as the supplier request.

To set these default values, define them using vendor.vendorInfoExt.maintenanceProfileCode as a condition field. For example:

name,value,vendor.vendorInfoExt.maintenanceProfileCode vendor.roleExt.roleCode(FLVN01),FLVN01,KRED vendor.roleExt.roleCode(FLVN01),FLVN01,LIEF vendor.vendorInfoExt.numberRangeIntervalBusinessPartnerGroupCode(0001),0001,KRED vendor.vendorInfoExt.numberRangeIntervalBusinessPartnerGroupCode(0002),0002,LIEF

Note

More information on how to set default values for vendor database fields can be found in the Supplier Management Setup and Administration Guide. Navigate to:

Supplier Data Integration with SAP Systems>Default Values for Vendor Database Fields>Setting Default Values for Vendor Database Fields section.

Log in to track your progress & complete quizzes