Text Material Preview
© SAP SE AR822 1 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Outline SAP Ariba Cloud Integration Gateway: Overview and Getting Started Master Data Integration Network Integration Transactional Data Integration Migration, Multiple ANIDs, and More © SAP SE AR822 2 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Master Data Integration Common Master Data Integration 1 Procurement Master Data Integration Sourcing Master Data Integration MDNI: Master Data Native Integration 4 3 2 © SAP SE AR822 3 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Common Master Data Integration There are some pre-requisites and limitations for Master Data Integration. Please refer to the CIG Overview Guide & CIG Configuration Guide for more details. Unit 11: Common Master Data Integration This unit cover the configurations of common settings required to import master data in any of the SAP Ariba solution – Procurement or Sourcing. Master data consists of general information that reside on SAP ERP that SAP Ariba uses to build and process data in transactions. Buyers using SAP Ariba Cloud Integration Gateway can seamlessly integrate master data from the SAP system to the SAP Ariba solutions using the following options: Ø Full Load Ø Incremental Load A feature(PL-17883) is available to use both Integration Tool Kit (ITK) & CIG to import master data in following applications. Ø SAP Ariba Procurement Solutions Ø SAP Ariba Strategic Sourcing Solutions This feature is useful during below listed situations: Ø New or existing customers using ITK with multiple ERP systems but like to use CIG for master data import from SAP ERP. Ø Existing customers using ITK with SAP ERP & wish to switch to CIG for master data import. To enable this feature please create an SR or contact SAP Ariba DSC (Designated Support Contact). © SAP SE AR822 4 4© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ Common Master Data Integration © SAP SE AR822 5 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 1: Configure External Commands for Operating System By the end of this lesson, you will be able to: • Configure External Commands for an Operating System © SAP SE AR822 6 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Perquisites / Limitations Prerequisites / Limitations: There are some prerequisites and limitations for Master Data Integration. Please refer to the CIG Overview Guide & CIG Configuration Guide for more details. © SAP SE AR822 7 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure External Commands for Operating System Users need to configure the commands on SAP System & associate them with their Operating System commands. This is a one-time activity & a mandatory configuration. To configure External Commands: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings using the transaction code SPRO. 2. Expand General Settings section & click on IMG-Activity for Configure External Commands for Operating System – The External Operating System Commands screen appears. © SAP SE AR822 8 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure External Commands for Operating System Users need to configure the commands on SAP System & associate them with their Operating System commands. This is a one-time activity & a mandatory configuration. To configure External Commands continued… 3. Click Create – the External Commands screen appears 4. Enter the values as mentioned in the table: © SAP SE AR822 9 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 2: Configure Ariba Incremental Extract Event By the end of this lesson, you will be able to: • Configure Ariba Incremental Extract Event © SAP SE AR822 10 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Incremental Extract Event Users need to configure the incremental extract to run the incremental load for Master Data. This is a one-time activity & a mandatory configuration. To configure Incremental Extract Event: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings using the transaction code SPRO. 2. Expand General Settings section & click on IMG-Activity for Configure Ariba Incremental Extract Event – The Ariba Incremental Extract Event Configuration screen appears. © SAP SE AR822 11 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Incremental Extract Event Users need to configure the incremental extract to run the incremental load for Master Data. This is a one-time activity & a mandatory configuration. To configure Incremental Extract Event continued: 3. Choose the Master Data that you want to configure & click Execute. 4. The Display logs screen appears with the details of the configured master data extract events. You can also see the details using the TCode SLG1 with the object ARBCIG_MASTERDATA and subobject INCREMENT_EVENT. © SAP SE AR822 12 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 3: Configure Ariba Master Data Incremental Field Restrictions By the end of this lesson, you will be able to: • Configure Ariba Master Data Incremental Field Restrictions © SAP SE AR822 13 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions Users need to configure the field restrictions for the incremental load for Master Data. User need to set up the field restrictions manually in the SWEC table. To configure Incremental Field Restrictions: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings using the transaction code SPRO. 2. Expand General Settings section & click on IMG-Activity for Ariba Master Data Incremental Field Restrictions – The Ariba Master Data Incremental Field Restrictions screen appears. This is for sending only the specific field changes to SAP Ariba Apps which are relevant to Ariba Integration. Always make a note of the object type, event & the action type (create, change, or delete) for the selected object. © SAP SE AR822 14 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions continued… 3. Select a Master Data object that you want to extract & click Execute – The Ariba Master Data Incremental Field Restrictions screen appears with the details of the configured restrictions. 4. Press Ctrl + C to copy the content of the page. Note that the content is already selected. © SAP SE AR822 15 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions continued… 5. Run the TCode SWEC – The Change View "Events for Change Document": Overview screen appears. 6. Locate the object with the same object type, event & action type (Create or Change or Delete) © SAP SE AR822 16 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions (continued): 7. Select event line in change mode & double-click Field Restrictions folder in the left pane – The Change View “Field Restrictions”: Overview screen appears. 8. Click Condition Editor. © SAP SE AR822 17 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions (continued): 9. If the directIf you do not specify a value for AUART, you can create purchase orders from any internal order in which the AUART field of the order master data (AUFK): - Is not equal to a space. - Is not marked for deletion (LOEKZ). - Is not already ordered or released. - Variable Name: INTERNAL_ORDER_AUART - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2). - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: For example, 0650. RL_BANK_DETAIL Applicable for SAP Ariba Procurement solutions. This is an optional field. Set this parameter to fetch the bank details of the supplier. If this is not maintained, bank related fields will be empty in the SupplierLocationConsolidated.csv. - Variable Name: RL_BANK_DETAIL - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2). - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify 'X' to fetch the bank details or leave it blank if you do not want to fetch. Activity ii: Maintain Parameters for SAP Ariba Procurement Solutions Importing Master Data for SAP Ariba Procurement © SAP SE AR822 111 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values RL_VENDOR_ADDRESS Applicable for SAP Ariba Procurement solutions. This is an optional field. Set this parameter to fetch the remittance address of the supplier. The address would be updated in two csv file: a. SupplierLocationConsolidated.csv b. RemittanceLocationConsolidated.csv - Variable Name: RL_VENDOR_ADDRESS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify 'X' to fetch the details or leave it blank if you do not want to fetch. SL_VENDOR_ADDRESS Applicable for SAP Ariba Procurement solutions. This is an optional field. Set this parameter to get vendor address. The vendor address would be used in SupplierLocation.csv export. - Variable Name: SL_VENDOR_ADDRESS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify 'X' to fetch the details or leave it blank if you do not want to fetch. BALANCE_SHEET_ACCOUNTS Applicable for SAP Ariba Procurement solutions. This is an optional field. Set this parameter to enable General Ledger Export extract to pull and use balance sheet accounts. - Variable Name: BALANCE_SHEET_ACCOUNTS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify 'X' to fetch the details or leave it blank if you do not want to fetch. Activity ii: Maintain Parameters for SAP Ariba Procurement Solutions Importing Master Data for SAP Ariba Procurement © SAP SE AR822 112 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values VENDOR_ONLY_COUNTPORGS Applicable for SAP Ariba Procurement solutions. This is an optional field. This parameter provides a filter to extract the vendors that are assigned to at least one purchasing organization. - Variable Name: VENDOR_ONLY_COUNTPORGS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify 'X' so that the Master Data Export pulls details of all the vendors. Leave a blank value to export the vendors that are assigned to at least one purchasing organization. WBS_USE_CPD_UPDAT Applicable for SAP Ariba Procurement solutions. Enable this parameter to allow WBS element incremental load extract based on the timestamp value in the CPD_UPDAT field in the PRPS table. The CPD_UPDAT field stores the timestamp value only when the PFP business function related to CPM (Commercial Project Management) is switched on. - Variable Name: WBS_USE_CPD_UPDAT - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2). - Low: Specify 'X' to enable WBS element incremental extract based on the value in the CPD_UPDAT field in the PRPS table. Leave a blank value to extract data based on the date value available in the AEDAT and ERDAT fields in the PRPS table.. Activity ii: Maintain Parameters for SAP Ariba Procurement Solutions Importing Master Data for SAP Ariba Procurement © SAP SE AR822 113 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement To configure selection criteria to filter the data to export to Ariba Procurement 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. 2. Expand Maintain Filters section & click on IMG-Activity for Procurement – The Prefilters – Ariba Procurement Master Data screen appears. 3. Maintain the filters based on your requirements. 4. Click Save The complete list of Filters with it’s usage is available in SAP Ariba Cloud Integration Gateway Configuration Guide under Working with Master Data >>> Importing Master Data for SAP Ariba Procurement Solutions section. Activity iii: Maintain Filters for SAP Ariba Procurement Solutions © SAP SE AR822 114 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Users can filter using the following conditions: ü Equality and inclusion: where Option is EQ & Sign is I. ü Ranges and exclusion: where Option is BT & Sign is E. ü Patterns and comparisons: where Option is CP & Sign is I or E. Importing Master Data for SAP Ariba Procurement Activity iii: Maintain Filters for SAP Ariba Procurement Solutions © SAP SE AR822 115 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement Users can run the ARBCIG_MASTER_DATA_EXPORT program on SAP System to import Master Data from SAP System to SAP Ariba Procurement solutions. Ensure User has the necessary authorization to run the Master Data program. Activity iv: Import Master Data from SAP System to SAP Ariba Procurement Solutions Follow these steps to Run the Master Data export program: 1. Run the TCode SE38 2. Enter the program name ARBCIG_MASTER_DATA_EXPORT , click Execute – the Export All Master Data Required For On- Demand Application page appears © SAP SE AR822 116 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Follow these steps to run the Master Data export program (continued): 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 SAP Ariba Procurement solution. 4. In the Solution section, choose one of the following: • Procure-to-Pay: To import master data for SAP Ariba Buying & Invoicing customers. • Procure-to-Order: To import master data for SAP Ariba Buying customers. This option does not support downloading the RemittanceLocation of Suppliers. Importing Master Data for SAP Ariba Procurement Activity iv: Import Master Data from SAP System to Ariba Procurement Solutions © SAP SE AR822 117 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Follow these steps to run the Master Data export program (continued): 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. Incremental Load option imports only Earmarked Fund for Funds Management solution. Importing Master Data for SAP Ariba Procurement Activity iv: Import Master Data from SAP System to Ariba Procurement Solutions 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 Procurement realm. (example: VREALM_2) • Partition: Specify the unique site name of your Ariba Procurement realm. (example: PREALM_2) • Tick the FPC Enabled check box if you are using multi-ERP setup & in the Site field, specify the name of your Ariba Procurement realm to which you want to export Master Data. © SAP SE AR822 118 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Follow these steps to run the Master Data export program (continued): 7. In Choose Master Data for Export section, select the events for which you want to export the data. Importing Master Data for SAP Ariba Procurement Activity iv: Import Master Data from SAP System to Ariba Procurement Solutions © SAP SE AR822 119 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Follow these steps to run the Master Data export program (continued): 8. To view the Funds Management Data options, tick the Enable Fund Management check box & select the events for which you want to export the data. 9. Click Execute to export the selected Master Data to Ariba Procurement. 10. To export the Master Data in different languages, enter the following program name after you run the TCode SE38: ARBCIG_MASTER_DATA_LANG_EXPORT, provide the Configuration information, select the events for which you want to export the data & click Execute Importing Master Data for SAP Ariba Procurement Activity iv: Import Master Data from SAP System to Ariba Procurement Solutions © SAP SE AR822 120 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement When the master data program runs, the program check whether parameter ENHANCED_PAYMENT_TERMS is maintained on the SAP ERP system. • If its maintained, the master data program sends all the defined values for the day limit associated for the payment term to the SAP Ariba Procurement solutions. • If this parameter is left blank, the master data program does not check for the different day limits for the payment term. User needs to maintain parameters ENHANCED_PAYMENT_TERMS To import payment terms with different day limits with multiple discount percentage values and specific time periods: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings >>> Maintain Parameters using the transaction code SPRO. 2. Expand Maintain Parameters section & click on IMG-Activity for Procurement – the Parameters – Ariba Procurement Master Data screen appears. 3. Maintain the parameter mentioned in the table on next slide. 4. Click Save Activity v. Maintain Parameters to Import Payment Terms Master Data Parameter Name Description Supported Values ENHANCED_PAYMENT_TERMS MANDATORY - to import the additional payment terms master data. Applicable to SAP Ariba Procurement solutions. If you maintain the parameter, the master data program sends all the defined values for the day limit associated for the payment term to the SAP Ariba Procurement solutions. - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. For (example: PREALM_2) - Low: Specify X when you want to include the additional payment terms while importing the payment terms master data.. © SAP SE AR822 121 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement You can run the ARBCIG_BUYER_CATALOG_EXPORT program manually to import Catalog Master Data from SAP system to Ariba Procurement. Ensure that you have the necessary authorization to run the master data program. Prerequisite: Ensure that you have configured incremental extract event & completed Catalog Upload Request in interface setup. Procedure: 1. Run the transaction code SE38 2. Run the ARBCIG_BUYER_CATALOG_EXPORT program 3. Click Execute to import the selected master data. Activity vi. Import Master Data for Catalogs © SAP SE AR822 122 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement Activity vi. Import Master Data for Catalogs © SAP SE AR822 123 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement To maintain the required parameters for Catalog Upload Request: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings >>> Maintain Parameters >>> Catalog Upload Request using the transaction code SPRO 2. Expand Maintain Parameters section, click IMG-Activity for Catalog Upload Request , the screen appears. 3. Maintain the parameters mentioned in the table within this activity. 4. Click Save Activity vii. Maintain Parameters for Catalog Upload Request © SAP SE AR822 124 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values BUYER_CAT_CLASS Applicable for SAP Ariba Procurement solutions. It is mandatory to use this class if you use the commodity code maintained in the Classification view for the full or incremental load of the material master. The ARBCIG_BUYER_CATALOG_EXPORT program displays an error if you do not maintain this class when specifying the Classification Code as Commodity Code option. - Variable Name: BUYER_CAT_CLASS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Example – CL125 BUYER_CAT_CLASS_TYP E Applicable for SAP Ariba Procurement solutions. It is mandatory to use this class type if you use the commodity code maintained in the Classification view for the full or incremental load of the material master. The ARBCIG_BUYER_CATALOG_EXPORT program displays an error if you do not maintain this class when specifying the Classification Code as Commodity Code option. - Variable Name: BUYER_CAT_CLASS_TYPE - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Example-001 BUYER_CAT_INT_CHAR_ NO Applicable for SAP Ariba Procurement solutions. This is a mandatory field, but not for test run. Maintain the Characteristics Name maintained in CL01 transaction for the characteristic value that must be extracted as the commodity code maintained in the Classification view of the material master for a particular class type and class. Use or create a characteristic value of the CHAR data type. The ARBCIG_BUYER_CATALOG_EXPORT program displaysan error if you do not maintain this parameter when specifying the Classification Code as Commodity Code option. - Variable Name: BUYER_CAT_INT_CHAR_NO - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Example-CH0023 Importing Master Data for SAP Ariba Procurement Activity vii. Maintain Parameters for Catalog Upload Request © SAP SE AR822 125 HOME Course Title LOGO HERE @ Copyright. All rights reserved. User needs to maintain the BAdi ARBCIG_BUY_CATALOG_EXPORT in order to enhance the catalog upload request. Steps to maintain BAdi in order to enhance catalog upload request: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Enhancements >>> Business Add-Ins(BAdis) >>> BAdis for Catalog Upload Request using the transaction code SPRO. 2. Expand Maintain Parameters section & click on IMG-Activity for Catalog Upload Request screen appears. 3. Implement appropriate method(from table below) in the BAdi Method Name Description MODIFY_PIR To modify Purchase Info Record details. MODIFY_MATERIAL To modify Material Master details. PUBLISH_CIF To modify the extracted catalog information before it is published to SAP Ariba Cloud Integration Gateway. Importing Master Data for SAP Ariba Procurement Activity viii. Implement BAdi for Catalog Upload Request © SAP SE AR822 126 HOME Course Title LOGO HERE @ Copyright. All rights reserved. User need to schedule the report ARBCIG_BUYER_CATALOG_EXPORT to send catalog information to SAP Ariba Procurement solutions. The report records Purchase Info Record and Catalog Information and ensures that the messages are triggered.: Steps to schedule the job: 1. Run the transaction code SM36. The Define Background Job screen appears. 2. Schedule the Program ARBCIG_BUYER_CATALOG_EXPORT to send catalog data at regular interval. Importing Master Data for SAP Ariba Procurement Activity ix. Schedule Job for Catalog Upload Request © SAP SE AR822 127 HOME Course Title LOGO HERE @ Copyright. All rights reserved. An asset is required to create a Purchase Requisition (PR). In the absence of a valid asset, you can use a dummy asset value to create a PR. You can process a change PR later to update the asset details. To create dummy asset, follow steps as mentioned below: 1. Run the transaction code AS01, the Create Asset: Initial screen page appears. 2. Enter the following information: Ø Asset Class: Asset class is the criterion for classifying fixed assets. Each asset must be assigned to one asset class. (example: 1000) Ø Company Code: Company code is a number code indicating an organizational unit within the accounting system (example: 1000) Ø Number of similar assets: Number of similar assets that you want to create when you save an asset master record. (example: 1) 3. Click Enter, the Create Asset: Master Data page appears. 4. Navigate to the General tab and enter the following information: Ø Description: Enter a description to indicate that it is a dummy asset value. For example, Unspecified. 5. Click Save Importing Master Data for SAP Ariba Procurement Activity x. Create Dummy Asset Value © SAP SE AR822 128 HOME Course Title LOGO HERE @ Copyright. All rights reserved. In SAP ERP, create an end-point of the web service required for asset related inbound transaction messages from CIG. To create an end-point of the web service from within SAP ERP: 1. Run the transaction code SOAMANAGER. SOA Management screen opens up in the browser. 2. In the Service Administration tab, click Web Service Configuration. 3. Choose the following in the Design Time Object Search tab and click Search. Ø In the Object Name dropdown, enter BUYERASSETREQUEST_ASYNC_IN. Importing Master Data for SAP Ariba Procurement Activity xi. Configure SOAMANAGER for Asset Management © SAP SE AR822 129 HOME Course Title LOGO HERE @ Copyright. All rights reserved. To create an end-point of the web service from within SAP ERP (continued): 4. In the search result, the Service Definition: BUYERASSETREQUEST_ASYNC_IN appears. Click BUYERASSETREQUEST_ASYNC_IN. The Details of Service Definition: BUYERASSETREQUEST_ASYNC_IN page appears. 5. Click Transport Settings tab. Enter information for the following fields: • Alternative Access URL: /sap/bc/srt/xip/arba/assetrequisitionexportrequest/002 • Calculated Access URL: Do not modify this URL. • Calculated Protocol: HTTPS • Make Local Call: No Call in Local System 6. Click Save Importing Master Data for SAP Ariba Procurement Activity xi. Configure SOAMANAGER for Asset Management © SAP SE AR822 130 130© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ MDNI: Master Data Native Integration © SAP SE AR822 131 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 1: Overview By the end of this lesson, you will be able to: • Recall supported full-load export master data objects • Recall supported incremental-load export master data objects • Recall Prerequisites © SAP SE AR822 132 HOME Course Title @ Copyright. All rights reserved. Master Data Native Integration • The feature is currently available only with the SAP Ariba Procurement solutions integrated with SAP ERP or SAP S/4HANA on-premise using CIG. • The master data is sent from SAP system to MDNI through CIG in XML format. • The feature allows to export master data from multiple SAP on- premise systems. • The master data exported from each SAP system is identified by a System ID. • The feature uses standard web services in SAP system. • The master data will pass through CIG without any mappings. • Master data upload can be done through full uploads or incremental uploads. • In a full upload, the full object will be uploaded each time. If the object already exists, it will be deactivated before being loaded again. • In an incremental upload, only the incremental changes will be uploaded. If the object does not exist it will be created. • ERP sends an XML file corresponding to the master data object. • To ensure that the file is in a format that allows the SAP Ariba Procurement solutions to consume the data, WSDL files corresponding to each data object need to be uploaded to the Master Data Integration Service. • Uploading WSDL files will be done by Ariba. Customer doesn't have any action ite here. • The WSDL files use the corresponding APIs. This feature supports transfer of master data from SAP ERP or SAP S/4HANA on-premise system to SAP Ariba Procurement solutions using the Master Data Native Interface (MDNI). Highlights: © SAP SE AR822 133 HOME Course Title @ Copyright. All rights reserved. Master Data Native Integration This feature currently supports only full-load export of the following master data objects: ü Company Codes ü Cost Centers ü Plant ü Asset/Asset Class ü Material Group ü Purchasing Organizations ü Exchange Rate ü Purchasing Group ü Internal Order ü Currency ü Plant Purchasing Organization ü Tax Code ü Payment Terms ü Account Assignment Category ü General Ledger Account This feature currently supports incremental-load export of the following master data objects: ü General Ledger Account ü WBS Element ü User © SAP SE AR822 134 HOME Course Title @ Copyright. All rights reserved. Master Data Native Integration Pre-requisites: ü SAP Ariba Procurement solutions is integrated with SAP system using CIG. ü MDNI is integrated with SAP Ariba Procurement solutions. To enable this feature, log a Service Request. ü Download & install SAP Ariba AddOn from SAP Service Market Place. For MDNI, minimum supported SP level of the SAP Ariba AddOn is SP7. ü MDNI feature is configured on SAP Ariba AddOn. ü CIG’s SSL certificate is uploaded in Trust Manager in yourSAP system. ü CIG is enabled in your SAP Ariba Procurement Solutions realm & you have secured P User ID & password information. © SAP SE AR822 135 HOME Course Title @ Copyright. All rights reserved. Master Data Native Integration Limitations: ü MDNI supports only SAP Ariba Procurement solutions. ü FPC (Federated Process Control) is not supported. ü FMD or an extract of a new custom master data object is not supported. ü Adding custom fields to the extracts are not supported. ü Currently an incremental export is supported only for: Ø General Ledger Account Ø WBS Element Ø User © SAP SE AR822 136 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 2: Configuring End-Points By the end of this lesson, you will be able to: • Follow the procedure to configure end points via “Interface Setup” activity to enable the flow of messages between SAP system & MDNI © SAP SE AR822 137 HOME Course Title @ Copyright. All rights reserved. Configuring End Points User needs to configure end points via “Interface Setup” activity to enable the flow of messages between SAP system & MDNI. This is a one-time activity, but user can rerun the program any time there is an update relevant to outbound web services. You can view the status of the report using the TCode SLG1, using the object ARBCIG_INTERFACE and subobject IF_LOGS The Logical Port setting is overwritten each time you run the interface settings for outbound web services. Procedure to configure Interface Setup: 1. Using the transaction code SPRO, navigate to Integration with Other SAP Components >>> SAP Ariba Cloud Integration Gateway >>> Master Data Native Integration >>> Interface Setup. 2. Click IMG-Activity for Configure the Outbound Connections to Send Messages – The Interface Setup for Ariba MDNI screen appears. © SAP SE AR822 138 HOME Course Title @ Copyright. All rights reserved. Configuring End Points Procedure to configure Interface Setup (continued…): 3. Under Interface Setup for Web Service section, perform the following activities: a. Select Data Center b. Under Connection Instances, select one of the following to indicate if the connection is to a Production or Test instance of CIG: • Connect to Cloud Integration Gateway Production Instance • Connect to Cloud Integration Gateway Test Instance c. Under Logon Data, select one of the following types of authentication methods • Select User ID / Password and enter authentication information to connect to SAP Ariba Cloud Integration Gateway. This will be your P User ID & Password. • Select X.509 SSL Client Certificate and choose the Certificate Name (ARIBA, for example). The same certificate used for Certificate Based Authentication need to be added here & it will be stored in SOA Manager 4. Under Interface Setup for Web Service section, perform the following activities (continued…): d. If you are using proxy server, under HTTPs Proxy Options, enter the following values: • HTTP proxy name in the Name of Proxy Host field. For example, proxy.abc.com. • Port name in the Port Number of Proxy Host field. For example, 8080. • User Name for the Proxy Server in the User Name of Proxy Server field. For example, abc_proxy. • Enter the password for the registered user name in the Proxy User Password field. © SAP SE AR822 139 HOME Course Title @ Copyright. All rights reserved. Configuring End Points Procedure to configure Interface Setup (continued…): 4. Choose from the available / supported master data objects to set up web services for the outbound data sent to CIG. 5. Click Execute button. © SAP SE AR822 140 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 3: Configuring Filters & Extracting Master Data By the end of this lesson, you will be able to: • Recall the pre-requisites of defining end points • Follow the procedure to configure filters and extract Master Data This lesson includes the following topics: i. Pre-Requisites ii. Configure Filters © SAP SE AR822 141 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data User can configure filters to extract desired range of data to send to SAP Ariba Procurement solutions. Wide range of filters are available for each supported master data object. Pre-requisites: ü Ensure that the end-points are configured in SAP system to communicate with MDNI. ü Before exporting the following master data extracts, implement the corresponding SAP Notes: Ø Payment Term - Implement the SAP Note: 2690724 – • Issue: Incorrect proxy generation due to the description of Payment Term • Resolution: Commented the logic to fetch the description of Payment Term Ø General Ledger - Implement the SAP Note: 2868158 – • Issue: XML tag IsRelevantForProcurementIndicator was not set as “true” • Resolution: Set the XML tag IsRelevantForProcurementIndicator as “true”. © SAP SE AR822 142 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data Procedure to configure filters: 1. Run the transaction code ARBCIG_MDNI. 2. The SAP Easy Access Master Data Native Interface Transactions screen appears. The screen lists the master data objects that are available for export. 3. Double-click on the master data object you want to export. For example, Company Code. 4. The extract screen for the master data appears. For example, Company Code Extract for MDNI. 5. Click on Fields for Selection. The Dynamic Selection screen appears. 6. Expand the node & you can see fields available for defining filters. 7. Double-click on a required field for which you want to set filters & define values for filtering. This is a standard SAP screen which allows you to either define specific values or ranges or define values to be excluded. © SAP SE AR822 143 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data Procedure to configure filters (continued): 3. Double-click on the master data object you want to export. For example, Company Code. 4. The extract screen for the master data appears. For example, Company Code Extract for MDNI. 5. Click on Fields for Selection. The Dynamic Selection screen appears. © SAP SE AR822 144 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data Procedure to configure filters (continued): 6. Expand the node & you can see fields available for defining filters. 7. Double-click on a required field for which you want to set filters & define values for filtering. This is a standard SAP screen which allows you to either define specific values or ranges or define values to be excluded. 8. Input required filter values. 9. Click on Apply Selected Items. 10. Click on Execute button. © SAP SE AR822 145 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data Procedure to configure filters (continued…): 11. Added filters will be shown on the screen. 12. Click Save, the Variant Attributes screen appears. This is a standard SAP screen. 13. Specify the variant to export master data from SAP system. Example: CC_Extract. 14. Click Save © SAP SE AR822 146 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data Procedure to configure filters (continued…): 15. Check Display Data box & click Execute only to display the XML document of the master data extract. The Display XML Document screen appears. You can check the details of the master data export. 16. When you choose Display Data option, master data records will not be sent to MDNI / SAP Ariba Procurement solutions. 17. Click Execute (without checking Display Data Box) to export master data to SAP Ariba Procurement solutions based on the selected criteria. The Display logs screen appears. Here, you can check the status of the master dataexport. • Message types are distinguished by colored icons: Terminate Error Warning Information © SAP SE AR822 147 HOME Course Title @ Copyright. All rights reserved. Configuring Filters and Extracting Master Data © SAP SE AR822 148 HOME Course Title @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 4: Maintaining Date Time Stamp By the end of this lesson, you will be able to: • Follow the procedure to maintain Date & Time Stamp for an incremental extract of Master Data. © SAP SE AR822 149 HOME Course Title @ Copyright. All rights reserved. Maintaining Date Time Stamp Users need to maintain Date & Time Stamp for an incremental extract of Master Data. Procedure to maintain Date & Time Stamp: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Maintain Date Time Stamp for Master Data using the transaction code SPRO. 2. Click IMG-Activity for Maintain Date Time Stamp for Master Data – the Change View "Date and Time stamp for Master Data": Overview screen appears. 3. Click New Entries & enter the following values: Ø Extract: Select from the list Ø Realm: Enter realm name Ø Date Time Stamp: Add date & time 4. Click Save © SAP SE AR822 150 HOME Course Title @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 5: Configuring Schedule Jobs By the end of this lesson, you will be able to: • Schedule separate jobs for each master data object to send to SAP Ariba Procurement solutions at desired intervals. © SAP SE AR822 151 HOME Course Title @ Copyright. All rights reserved. Configuring Schedule Jobs User can schedule separate jobs for each master data object to send to SAP Ariba Procurement solutions at desired intervals. Procedure to schedule a job using SAP’s standard job scheduler: 1. Run the transaction code SM36. The Define Background Job screen appears. 2. Click on Job Wizard. 3. On the Create a job screen, Click Continue. © SAP SE AR822 152 HOME Course Title @ Copyright. All rights reserved. Configuring Schedule Jobs Procedure to schedule a job using SAP’s standard job scheduler (continued): 4. On the General job information screen, define a job name. For example, Company Code Extract; define Job Class, for example, A – High priority & then click Continue. 5. On the Job definition: Job step screen, select ABAP program step & then click Continue. 6. On the ABAP program step screen, define ABAP Program Name. For example, ARBCIG_MDNI_COMPANYCODE & in the Variant field, select the variant for that specific master data object you created earlier. For example, CC_Extract & then click Continue. 7. On the Multi-step option screen, click Continue. © SAP SE AR822 153 HOME Course Title @ Copyright. All rights reserved. Configuring Schedule Jobs Procedure to schedule a job using SAP’s standard job scheduler (continued): 8. On the Job definition: Start conditions screen, select a condition. For example, Date/time & then click Continue. 9. On the Definition of start at date/time screen, define Scheduled Start date & time. Additionally, you have an option to define Periodic jobs by checking Period checkbox & then click Continue. © SAP SE AR822 154 HOME Course Title @ Copyright. All rights reserved. Configuring Schedule Jobs Procedure to schedule a job using SAP’s standard job scheduler (continued): 10. If you want to define Periodic jobs by checking Period checkbox, on the Period Definition screen you need to select frequency. For example, Weekly & then click Continue 11. On the Set job screen, click Complete © SAP SE AR822 155 HOME Course Title @ Copyright. All rights reserved. Configuring Schedule Jobs Program names to be used while scheduling jobs: • ARBCIG_MDNI_ACCOUNTCATEGORY • ARBCIG_MDNI_ASSET • ARBCIG_MDNI_COMPANYCODE • ARBCIG_MDNI_COSTCENTER • ARBCIG_MDNI_CURRENCY • ARBCIG_MDNI_EXCHANGERATE • ARBCIG_MDNI_GLACCOUNT • ARBCIG_MDNI_INTERNAL_ORDER • ARBCIG_MDNI_MATERIALGROUP • ARBCIG_MDNI_PAYMENTTERMS • ARBCIG_MDNI_PLANT • ARBCIG_MDNI_PLANT_PURORG • ARBCIG_MDNI_PURCHASING_GROUP • ARBCIG_MDNI_PURCHASING_ORG • ARBCIG_MDNI_TAXCODE • ARBCIG_MDNI_USER • ARBCIG_MDNI_WBS © SAP SE AR822 156 HOME Course Title @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 6: Implementing BAdIs for MDNI By the end of this lesson, you will be able to: • Customize master data extracts • Implement BAdI to customize the master data information before export. © SAP SE AR822 157 HOME Course Title @ Copyright. All rights reserved. Implementing BAdIs for MDNI Customizing master data extracts: Add custom field in SAP Ariba Procurement solutions Upload the WSDL in MDNI Regenerate proxy & WSDL Implement respective BAdI in SAP ECC or SAP S/4HANA On-Premise © SAP SE AR822 158 HOME Course Title @ Copyright. All rights reserved. Implementing BAdIs for MDNI The BAdI ARBCIG_MDNI allows you to customize the master data information before export. To implement BAdI: 1. Using the transaction code SPRO, navigate to Integration with Other SAP Components >>> SAP Ariba Cloud Integration Gateway >>> Master Data Native Integration. 2. Click IMG-Activity for BAdI's for MDNI programs – the BAdI Implementations screen appears. 3. Click Create Implementation to start implementing the BAdI – ARBCIG_MDNI © SAP SE AR822 159 HOME Course Title @ Copyright. All rights reserved. Implementing BAdIs for MDNI Use the following methods to enhance the BAdI – ARBCIG_MDNI: Method Name Description ENHANCE_COMPANYCODE Enhance Company Code details ENHANCE_PLANT Enhance Plant details ENHANCE_PURORG Enhance Purchase Organization details ENHANCE_PLANTPURORG Enhance Plant Purchase Organization details ENHANCE_PURGROUP Enhance Purchasing Group ENHANCE_WBS Enhance WBS Element ENHANCE_GL Enhance General Ledger ENHANCE_ACCCAT Enhance Account Assignment Category ENHANCE_CURRENCY Enhance Currency ENHANCE_MATERIALGROUP Enhance Material Group ENHANCE_TAXCODE Enhance Tax Code ENHANCE_ASSET Enhance Asset ENAHNCE_PAYMENTTERMS Enhance Payment Terms ENHANCE_INTERNALORDER Enhance Internal Order ENHANCE_EXCHANGERATE Enhance Exchange Rate ENHANCE_COSTCENTER Enhance Cost Center ENHANCE_USER Enhance User © SAP SE AR822 160 HOME Course Title @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 7: Configuring SAP Ariba Procurement Solutions for MDNI By the end of this lesson, you will be able to: • Describe what is required from Ariba Support in order for the SAP Ariba Procurement realm to be configured for MDNI © SAP SE AR822 161 HOME Course Title @ Copyright. All rights reserved. Configuring SAP Ariba Procurement solutions for MDNI To have your SAP Ariba Procurement realm configured for MDNI a Service Request must be raised with Ariba Support. In the background, the following activities will take place: 1. Establishing connectivity between MDNI & your SAP Ariba Procurement realm. 2. Exchanging CIG certificate with MDNI. No Endpoint creation is required in your SAP Ariba Procurement realm. © SAP SE AR822 162 LOGO HERE @ Copyright. All rights reserved. Section Complete Congratulations! You have now completed this Section!text entry mode is not configured for your user interface, perform the following steps: Ø Click Utilities>>>Settings Ø On the Condition Editor: Personal Settings page, select Direct text entry (traditional mode) Ø Save the configuration © SAP SE AR822 18 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions (continued): 10. Click New rows to include the content for field restriction. Ensure that the number of rows you add is equal to the number of rows of content that you copied in Step#4. 11. Click column for Expression 1 & paste the copied content for field restrictions. © SAP SE AR822 19 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Master Data Incremental Field Restrictions To configure Incremental Field Restrictions (continued): 12. Click Back & enter the Transport Request number. Click Save. © SAP SE AR822 20 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 4: Configure Ariba Event Linkages By the end of this lesson, you will be able to: • Configure Ariba Event Linkages © SAP SE AR822 21 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Object Category Object Type Event Receiver Type Receiver Call Receiver Function Module BOR Object Type ARBCIG0012 COSTCENTERCHANGED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG0012 COSTCENTERCREATED CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG0012 COSTCENTERDELETED DELETE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1001 CREATED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1006 CREATED CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1006 VIEWCREATED CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1022 ASSETCHANGED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1022 ASSETCREATED CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1022 ASSETDELETED DELETE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3006 CHANGEGL CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3006 CREATEGL CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3006 DELETEGL DELETE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3060 ONCREATE CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3060 STATUSCHANGED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG3060 UPDATED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIGLFA1 VENDORCHANGED CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIGLFA1 VENDORCREATED CREATE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIGLFA1 VENDORDELETED DELETE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIGUSER CLONED USER_CHANGE Function Module ARBCIG_CHANGEDOC BOR Object Type ARBCIG1001 CREATED CHANGECAT Function Module ARBCIG_DOC_CHANGES BOR Object Type ARBCIG1006 VIEWCREATED CREATECAT Function Module ARBCIG_DOC_CHANGES BOR Object Type ARBCIG3003 STARTVEEKPLAMATNRDEL CHANGECAT Function Module ARBCIG_DOC_CHANGES BOR Object Type ARBCIG3003 STARTVENDORMATNRDEL CREATECAT Function Module ARBCIG_DOC_CHANGES BOR Object Type ARBCIG3060 STATUSCHANGED CHANGECAT Function Module ARBCIG_DOC_CHANGES Configure Ariba Event Linkages © SAP SE AR822 22 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Event Linkages To configure Event Linkages: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings using the transaction code SPRO. Configure Ariba Event Linkages Users need to link the incremental extract events with the corresponding function module. This is required to capture any changes occurring in Master Data record(s) & store it in a CHANGE LOG table for incremental extract event of that particular master data object. © SAP SE AR822 23 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Event Linkages To configure Event Linkages continued… 2. Expand General Settings section & click on IMG- Activity for Ariba Event Linkages – The Change View Event Type Linkages: Overview screen appears. 3. Click New Entries & enter the values mentioned in the table on next slide. © SAP SE AR822 24 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba Event Linkages To configure Event Linkages continued… 4. For Event delivery , choose Using tRFC. 5. Check the Linkage Activated checkbox (for all the entries mentioned in the table). 6. Click Next Entry to enter the information for the next record. Once all records are entered, click Save. © SAP SE AR822 25 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 5: Configure Ariba User HR Event Linkage By the end of this lesson, you will be able to: • Configure Ariba User HR Event Linkage © SAP SE AR822 26 HOME Course Title LOGO HERE @ Copyright. All rights reserved. If you get the error message: No Entry exists in T777IBO table, maintain the following entry in the T777IBO table: Object Type Infotype Update Operation Sequence Number Object Type Function Module P 0001 UPD 0 ARBCIG1065 ARBCIG_HRPM_CHANGE_DOCS P 0002 UPD 0 ARBCIGTNT ARBCIG_HRPM_CHANGE_DOCS P 0105 DEL 0 ARBCIGEMPL ARBCIG_HRPM_CHANGE_DOCS P 0105 INS 0 ARBCIGEMPL ARBCIG_HRPM_CHANGE_DOCS P 0105 UPD 0 ARBCIGEMPL ARBCIG_HRPM_CHANGE_DOCS OT Object Type Text IT Object type Name P Person 0001 ARBCIG1065 Add a meaningful name Configure Ariba User HR Event Linkage © SAP SE AR822 27 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba User HR Event Linkage Users need to configure this if they need to send User Master Data with Incremental Load option. To configure HR Event Linkages: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings using the transaction code SPRO. 2. Expand General Settings section & click on IMG-Activity for Ariba User HR Event Linkage – the Change View HR-CA: Event Linkage for Customer: Overview screen appears. © SAP SE AR822 28 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Ariba User HR Event Linkage To configure HR Event Linkages (continued): 3. Click New Entries & enter the values mentioned in the table on page#23. 4. Click Next Entry to enter the information for the next record. Once all records are entered, click Save. © SAP SE AR822 29 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 6: Configure Connection Parameters By the end of this lesson, you will be able to: • Configure Connection Parameters © SAP SE AR822 30 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Connection Parameters Users need to add the realms for each Ariba solution that can be used to process master data events. This is needed to define Realm Name & Ariba Solution relationship in order to determine the appropriate target URL. To configure Connection Parameters: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Connection Parameters for Master Data using the transaction code SPRO. 2. Click on IMG-Activity for Connection Parameters for Master Data – The Change View "Direct Connectivity Parameters": Overview screen appears. © SAP SE AR822 31 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure Connection Parameters To configure Connection Parameters (continued): 3. Click New Entries & enter the following values: Ø Solution: Select a solution name from the list. Ø Realm: Add a realm name. Ø P: Select the checkbox if this is a parent realm. Ø Wait Time: Add time in seconds to wait to connectto the gateway. Do not enter values for Logical Port Name. 4. Click Save. © SAP SE AR822 32 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 7: Maintain System ID By the end of this lesson, you will be able to: • Maintain System ID for Master Data © SAP SE AR822 33 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain System ID This is to map the SAP vendors which are already existing in SAP Ariba Procurement solutions. Users need to map the SAP Ariba Procurement solution’s unique System ID to the SAP vendor. This configuration is required only if you import master data for suppliers. To maintain System ID: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Maintain System ID for Master Data using the transaction code SPRO. 2. Click on IMG-Activity for Maintain System ID for Master Data – The Change View "System ID For Customers": Overview screen appears. 3. Click New Entries & enter the following values: Ø System ID: Enter the system ID of Ariba Procurement solutions for the Supplier. SID499 (for example) Ø Vendor: Enter SAP Vendor code. 4. Click Save. © SAP SE AR822 34 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 8: Maintain Date & Time Stamp By the end of this lesson, you will be able to: • Maintain Date & Time Stamp for Master Data © SAP SE AR822 35 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Date & Time Stamp Users need to maintain Date & Time Stamp for an incremental extract of Master Data. To maintain System ID: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Maintain Date Time Stamp for Master Data using the transaction code SPRO. 2. Click on IMG-Activity for Maintain Date Time Stamp for Master Data – The Change View "Date and Time stamp for Master Data": Overview screen appears. © SAP SE AR822 36 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Date & Time Stamp To maintain System ID (continued): 3. Click New Entries & enter the following values: Ø Extract: Select from the list Ø Realm: Enter realm name Ø Date Time Stamp: Add date & time 4. Click Save. © SAP SE AR822 37 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 9: Maintain User Profiles for User Master Data By the end of this lesson, you will be able to: • Maintain User Profiles for User Master Data © SAP SE AR822 38 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain User Profiles for User Master Data Users need to maintain use roles mapped to each solution. To maintain User Profiles: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Maintain User Profiles for User Master Data using the transaction code SPRO. 2. Click on IMG-Activity for Maintain User Profiles for User Master Data – The Change View "Table to hold the user roles mapped to groups": Overview screen appears. 3. Click New Entries & enter the following values: Ø Solution: Select the solution name from the list Ø Role: Select the user role to be mapped with the solution Ø Realm: Enter realm name 4. Click Save. © SAP SE AR822 39 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 10: Maintain Field Map for Master Data and Catalog Upload Request By the end of this lesson, you will be able to: • Maintain Field Map for Master Data and Catalog Upload Request © SAP SE AR822 40 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Field Map for Master Data and Catalog Upload Request To maintain Field Mappings: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Enhancements using the transaction code SPRO. Users need to maintain mappings between custom field in SAP System & SAP Ariba solution’s custom field for Master Data & Catalog extracts. (This is an optional activity. Do not change the default values.) •In SAP ERP, the fields are always in upper case but in SAP Ariba solutions, it is in mixed case. •Custom table ARBCIG_FIELDMAP is maintained to map the SAP System & SAP Ariba Procurement solutions system’s field values. © SAP SE AR822 41 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Field Map for Master Data and Catalog Upload Request To maintain Field Mappings (continued): 2. Expand Enhancements & click on IMG-Activity for Maintain Field Map for Master Data and Catalog Upload Request – The Change View "Table to maintain mapping of SAP to Buyer fields": Overview screen appears. 3. Click New Entries & enter the following values: Ø Solution: Select the solution name from the list for which you are mapping the field Ø Structure: Add a structure name. ARBCIG_BP_LANG_STR (For example) Ø Field SAP: Add the SAP ERP field name that you want to map. BUDGETPDTX (For example) Ø Field Ariba: Add the Ariba solution field name to which you want to map. Name (For example) 4. Click Save. © SAP SE AR822 42 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 11: Schedule a Job for Master Data Export By the end of this lesson, you will be able to: • Schedule a Job for Master Data Export © SAP SE AR822 43 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Schedule a Job for Master Data Export Users can schedule a job to export Master Data from SAP System to SAP Ariba solutions. This is an optional activity. Scheduling a job is a standard SAP process & not specific to CIG integration with SAP. Thus, it is not described in detail here. Ensure that you have configured the ARBCIG_MASTER_DATA_EXPORT program before scheduling the export job. To schedule a job: 1. Run TCode SM36 – The Define Background Job screen appears. 2. Schedule the program: Ø ARBCIG_MASTER_DATA_EXPORT Ø ARBCIG_BUYER_CATALOG_EXPORT © SAP SE AR822 44 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 12: Implement BAdIs for Master Data Export By the end of this lesson, you will be able to: • Implement BAdIs for Master Data Export © SAP SE AR822 45 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Implement BAdIs for Master Data Export Users can implement BAdIs to enhance the Master Data Upload Request as required. Available in the ARBCIG_MASTER_DATA_EXPORT program. To maintain BAdI: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> Enhancements >>> Business Add-Ins(BAdIs) using the transaction code SPRO. 2. Expand Business Add-Ins(BAdIs) & click on IMG-Activity for one of the followings as per your requirements: Ø BAdIs for Master Data Export – BAdI Name: ARBCIG_MASTERDATA Ø BAdIs for Catalog Upload Request – BAdI Name: ARBCIG_BUY_CATALOG_EXPORT Ø BAdIs for Purchase Info Record – BAdI Name: ARBCIG_PURINFREC 3. Implement the BAdI. The methods that you can implement are listed in SAP Ariba Cloud Integration Gateway Configuration Guide. © SAP SE AR822 46 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 13: Resend Master Data or Catalog Upload Request By the end of this lesson, you will be able to: •Resend Master Data or Catalog Upload Request © SAP SE AR822 47 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Resend Master Data or Catalog Upload Request In the event users want to resend the Master Data or Catalog Upload Request (except Bill of Materials) to SAP AribaSolutions, it can be done using this utility. To resend Master Data or Catalog Upload Request: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration using the transaction code SPRO. 2. Click on IMG-Activity for Resend Master Data or Catalog Upload Request – The Resend Batch Extracts to Cloud Integration Gateway screen appears. © SAP SE AR822 48 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Resend Master Data or Catalog Upload Request To resend Master Data or Catalog Upload Request…(continued…): 3. Enter the following values: Ø File Name: Select the archived file. Ø Variant: Provide the variant if you want to resend the Sourcing Master Data. Ø Partition: Provide the partition if you want to resend the Sourcing Master Data. 4. If you want to delete the archived files, enter the following values: Ø Archive Directory: Select the directory where the files are archived. Ø Till Date: Select a date. Archived files before this date would be removed. 5. Click Execute. © SAP SE AR822 49 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 14: Maintain Parameters By the end of this lesson, you will be able to: • Maintain parameters for more than one SAP Ariba solution © SAP SE AR822 50 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Parameters Users need to maintain the required parameters for more than one SAP Ariba solution. To maintain parameters for more than one SAP Ariba solution: 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 SE AR822 51 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Parameters To maintain parameters for more than one SAP Ariba solution continued: 2. Expand Maintain Parameters & click on IMG-Activity for Cross Application – The Parameters – Cross Application Master Data screen appears. 3. Click Modify & maintain the parameter mentioned in the table on next slide. 4. Click Save. © SAP SE AR822 52 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Parameters Parameter Name Description Supported values LANGUAGE Applicable for SAP Ariba Procurement solutions & SAP Ariba Sourcing. Set this parameter to display descriptions in languages other than English. Leave it blank to display the descriptions in English. - Variable Name: LANGUAGE - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions or SAP Ariba Sourcing in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions or SAP Ariba Sourcing in SAP ERP. For example, PREALM_2. - Low: Example - DE TEMP_DIRECTORY Applicable for SAP Ariba Procurement solutions and SAP Ariba Sourcing. This is a mandatory field, but not for test run. Set this parameter to specify the temporary filepath in the application server to save CSV files. When you execute the master data, the CSV files are zipped and sent to SAP Ariba Procurement solutions from this location. - Variable Name: LANGUAGE - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions or SAP Ariba Sourcing in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions or SAP Ariba Sourcing in SAP ERP. For example, PREALM_2. - Low: Example - C:/users/Ariba © SAP SE AR822 53 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 15: Maintain Filters By the end of this lesson, you will be able to: • Maintain filters for more than one SAP Ariba solution © SAP SE AR822 54 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters Users need to configure selection criteria to filter Master Data records to import for more than one SAP Ariba solution. User can filter the Master Data records using following conditions: Ø Equality & Inclusion: where Option is EQ & Sign is I. Ø Ranges & Exclusion: where Option is BT & Sign is E. Ø Patterns & Comparisons: where Option is CP & Sign is I or E. © SAP SE AR822 55 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters Parameter Name Description Supported Values PLANT_EXPORT Configure a selection criteria to filter the plant information to export. - Variable Name: PLANT_EXPORT - Field Name: Field name that designates the plant information in the table T001W. - Type: Enter S as the selection category. - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. For example, PREALM_2. - Sign: Enter I. - Option: Enter EQ. - Low: Enter the filter value for the criterion you set for field. - High: Blank if the option is not BT. PLANT_PURCHASE_EXPORT Configure a selection criteria to filter the plant and purchase organization information to export. - Variable Name: PLANT_PURCHASE_EXPORT - Field Name: Field name that designates the plant and purchase organization information in the table T024W. - Type: Enter S as the selection category. - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. For example, PREALM_2. - Sign: Enter I. - Option: Enter EQ. - Low: Enter the filter value for the criterion you set for field. - High: Blank if the option is not BT. PURCHASE_GROUP_EXPORT Configure a selection criteria to filter the purchase group information to export. - Variable Name: PURCHASE_GROUP_EXPORT - Field Name: Field name that designates the purchase group information in the table T024. - Type: Enter S as the selection category. - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. For example, PREALM_2. - Sign: Enter I. - Option: Enter EQ. - Low: Enter the filter value for the criterion you set for field. - High: Blank if the option is not BT. © SAP SE AR822 56 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters © SAP SE AR822 57 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters Parameter Name Description Supported Values PURCHASE_ORG_EXPORT Configure a selection criteria to filter the purchase organization information to export. - Variable Name: PURCHASE_ORG_EXPORT - Field Name: Field name that designates the purchase organization information in the table T024E. - Type: Enter S as the selection category. - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. For example, VREALM_2. - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. For example, PREALM_2. - Sign: Enter I. - Option: Enter EQ. - Low: Enter the filter value for the criterion you set for field. - High: Blank if the option is not BT. © SAP SE AR822 58 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters To maintain filters for more than one SAP Ariba solution: 1. Navigate to Integration with Other SAP Components >>> Ariba Cloud Integration Gateway >>> Master Data Integration >>> General Settings >>> Maintain Filters using the transaction code SPRO. 2. Expand Maintain Filters & click on IMG-Activity for Cross Application – The Prefilters – Cross Application Master Data screen appears. © SAP SE AR822 59 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Maintain Filters To maintainfilters for more than one SAP Ariba solution (continued): 3. Click Modify & maintain the filters based on your requirements. Refer to the values mentioned in the table of this lesson. 4. Click Save. © SAP SE AR822 60 60© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ Sourcing Master Data Integration © SAP SE AR822 61 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 1: Overview By the end of this lesson, you will be able to: • List required master data for SAP Ariba Sourcing integration • Recall basic integration recommendations © SAP SE AR822 62 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. © SAP SE AR822 63 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Sourcing Master Data Integration Overview 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 Required Master Data © SAP SE AR822 64 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. 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. TCode – sm30 to add above filters as it is not available in SPRO node. © SAP SE AR822 65 HOME Course Title LOGO HERE @ Copyright. All rights reserved. © SAP SE AR822 66 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 2: Importing Master Data By the end of this lesson, you will be able to: • Configure, maintain and import master data required for SAP Ariba Sourcing Integration This lesson includes the following topics: i. Configure Ariba Sourcing Solutions for Synchronizing Master Data ii. Configure External System iii. Maintain Parameters iv. Maintain Filters v. Import Master Data from SAP System vi. Implement the BAdi for Purchase Info Records vii. Maintain Field Map for Ariba Sourcing Master Data viii. Import Bill of Materials © SAP SE AR822 67 HOME Course Title LOGO HERE @ Copyright. All rights reserved. User needs to perform following activities to configure SAP Ariba Sourcing for synchronizing Master Data: 1. Download Keystore / Tenant certificate from the Resources page in the CIG. 2. Log in to SAP Ariba Sourcing site, navigate to Administration, click Integration Manager 3. Click Integration Toolkit Security 4. Select Certificate as the authentication method 5. Paste the certificate you have downloaded in step#1 6. Click Save Activity i: Configure Ariba Sourcing Solutions for Synchronizing Master Data © SAP SE AR822 68 HOME Course Title LOGO HERE @ Copyright. All rights reserved. To maintain External System: 1. Login to your Ariba Sourcing realm as an Administrator; click Manage, click Administration 2. Expand Master Data Manager menu, click External System Configuration 3. Click Create New 4. Provide details in ID & Name fields, 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. © SAP SE AR822 69 HOME Course Title LOGO HERE @ Copyright. All rights reserved. The newly added External System is available: Activity ii: Configure External System © SAP SE AR822 70 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. 2. Expand Maintain Parameters section, click IMG-Activity for Sourcing – the Parameters – Ariba Sourcing Master Data screen appears 3. Maintain the parameters mentioned in the table in this lesson. 4. Click Save Activity iii: Maintain Parameters © SAP SE AR822 71 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported 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 specifyin 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) Activity iii: Maintain Parameters Parameters Applicable for SAP Ariba Sourcing © SAP SE AR822 72 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values 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_CLASSIFICATI ON 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. Activity iii: Maintain Parameters Parameters Applicable for SAP Ariba Sourcing (continued)… © SAP SE AR822 73 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values ENABLE_CONV_MATERIAL_O NLY 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 iii: Maintain Parameters Parameters Applicable for SAP Ariba Sourcing (continued)… © SAP SE AR822 74 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. 2. Expand Maintain Filters section & click on IMG-Activity for Sourcing – The Prefilters – Ariba Sourcing Master Data screen appears. 3. Maintain the filters based on your requirements. 4. Click Save Activity iv: Maintain Filters The complete list of Filters with it’s 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. © SAP SE AR822 75 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Please follow these steps to run the Master Data export program: 1. Run the TCode SE38. 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. 4. In the Solution section, choose Sourcing & Contracts. 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 Procurement solutions. © SAP SE AR822 76 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Steps to run the Master Data export program (continued): 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. 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. Activity v: Import Master Data from SAP System © SAP SE AR822 77 HOMECourse Title LOGO HERE @ Copyright. All rights reserved. Steps to run the Master Data export program (continued): 8. Click Execute to export the selected Master Data to Ariba Procurement. 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. Activity v: Import Master Data from SAP System © SAP SE AR822 78 HOME Course Title LOGO HERE @ Copyright. All rights reserved. When the Master Data request gets passed through CIG, the Document Status is displayed as COMPLETED When the Master Data upload request reaches SAP Ariba Sourcing, status reflects as Scheduled. This is a pre-processing status. When the Master Data upload gets processed in SAP Ariba Sourcing, status gets changed to Indexing Success. Activity v: Import Master Data from SAP System © SAP SE AR822 79 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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 Name Description MAP_PIR To map additional fields to a purchase info record. MAP_PIR_CHANGE To map the changes to the custom fields of a purchase info record. POST_PROCESSING To customize and send a confirmation to SAP Ariba after creating the purchase info record. CONDITION_MAP Conditions used to map additional fields to a purchase info record. Activity vi: Implement BAdI for Purchase Info Records © SAP SE AR822 80 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. Activity vii: Maintain Field Map for Ariba Sourcing Master Data © SAP SE AR822 81 HOME Course Title LOGO HERE @ Copyright. All rights reserved. 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. 2. Check Test Mode when you want to run the program and validate the contents in the .zip file. Enter the file path, where you want to download the .zip file. 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 extraction 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 Activity viii: Import Bill of Materials © SAP SE AR822 82 HOME Course Title LOGO HERE @ Copyright. All rights reserved. • 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. Activity viii: Import Bill of Materials © SAP SE AR822 83 83© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ Procurement Master Data Integration © SAP SE AR822 84 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 1: Overview By the end of this lesson, you will be able to: • List the Prerequisites to integrating SAP Ariba Procurement solution Master Data • Identify limitations to integrating SAP Ariba Procurement solution Master Data • Recognize Required Master Data This lesson includes the following topics: • Overview • Prerequisites • Limitations • Required Master Data © SAP SE AR822 85 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Procurement Master Data Integration Overview • Master Data consists of general information stored in SAP that is used in SAP Ariba Procurement solutions to construct Requisitions, Receipts, or Invoices. • The SAP Ariba Procurement 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 Procurement solutions for Purchase Orders, Receipts & Invoices, 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. © SAP SE AR822 86 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Buyers using the SAP Ariba Procurement solutions integrated with SAP System can do the following: ü Perform a simplified master data integration for Supplier, Supplier Location, Payment Terms, Remittance Location & User data between the SAP Ariba Procurement solutions & SAP System ü Integrate Master Data from SAP System to SAP Ariba Procurement solutions system seamlessly through CIG. ü Run the Incremental Load while running the master data events directly. ü Integrate master data from SAP System to SAP Ariba Procurement solutions in a Federated Process Control-enabled environments. © SAP SE AR822 87 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Following Master Data events are supported in different languages: ü Account Category Language ü Cost Center Language ü ERP Commodity Code Language ü General Ledger Language ü Tax Code Language ü Payment Terms Language © SAP SE AR822 88 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Prerequisites: ü Ensure that you implement the following SAP notes before importing the master data to avoid runtime error: Ø 1402826 - Supplement to Note 548131 Ø 1716777 - Runtime error IMPORT_WRONG_END_POS when displaying class ü Required authorizations are defined in SAP system. ü Create user groups in the SAP Ariba Procurement solutions with the SAP ERP role names. ü Maintain the required configurations for common Master Data. © SAP SE AR822 89 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Limitations: • SAP Ariba Procurement solutions integrated with SAP System does not support a Supplier Location linked to multiple Vendors. • The legacy Supplier Export task is no longer supported. You must use the Export Supplier Data (Consolidated File) task. © SAP SE AR822 90 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Required Master Data: ü AccountAssignment Categories ü Accounting Field Display Status ü Asset Accounts ü Cost Centers ü Company Codes ü Currency Conversion Rates ü ERP Commodity Codes ü Fund Management Data ü General Ledger Accounts ü Internal Orders ü Payment Terms ü Plants ü Plant-Purchase Orgs. ü Purchasing Groups ü Purchasing Orgs. ü Supplier related data ü Tax Codes ü User & User Groups ü WBS Elements Fund Management Data (applicable only for Real Time Budget Check feature): ü Funds ü Funds Center ü FM Area ü Functional Area ü Commitment Item ü Earmarked Fund ü Budget Period Grant © SAP SE AR822 91 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Importing Supplier Data SAP System downloads supplier data in the SupplierConsolidated.csv for the following: ü Suppliers available in the LFA1 (Vendor Master Table). ü Suppliers that are not marked for deletion for a given Purchase Organization. ü Suppliers that do not have a centrally imposed purchasing block. ü Suppliers that are not blocked for any function © SAP SE AR822 92 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Importing Purchase Org-Supplier Combo Data SAP System downloads Supplier & Purchasing Orgs associated with each supplier in the PurchaseOrgSupplierCombo.csv for the following: • Suppliers available in the LFM1 (Vendor Master Record Purchasing Organization Data). • Suppliers that are not marked for deletion for a given Purchase Organization. • Suppliers that do not have a centrally imposed purchasing block. © SAP SE AR822 93 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Supplier Location Data Buyer users need to maintain either the SL_VENDOR_ADDRESS parameter or SL_PARTNER_TYPE prefilter before downloading the Supplier Location data else the download would result in an error. Here is the example of how SAP Ariba Procurement solutions integrated with SAP, processes the Supplier Location: Supplier Purchase Organization Supplier Location 1 Supplier Location 2 ABC Supplier 1000 1004 1005 3000 1006 1007 © SAP SE AR822 94 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Supplier Location Data (continued)- Scenario 1: When you import the Supplier Location data, SAP Ariba Procurement solutions integrated with SAP System displays the Supplier Location for ABC supplier as 1004, 1005, 1006 and 1007 in the downloaded CSV file. Scenario 2: When ABC Supplier is blocked for Purchase Organization 1000, SAP Ariba Procurement solutions integrated with SAP System only displays the Supplier Location as 1006 and 1007 in the downloaded CSV file. © SAP SE AR822 95 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Remittance Location Data: • Buyer users need to maintain filters while downloading Remittance Locations by specifying the following parameters: • Maintain at least one of the parameters – RL_VENDOR_ADDRESS or RL_PARTNER_TYPE. • Maintain the RL_VENDOR_ADDRESS filter to download Supplier as Remittance Location when you want to download the supplier as the remittance location. For more information on limitations for Supplier Location & Remittance Location, please refer to SAP Ariba Cloud Integration Gateway Overview Guide. • When you maintain only the filter for the Supplier Location Address SL_VENDOR_ADDRESS & do not maintain the Supplier Location & Remittance Location for the Supplier, Ariba AddOn Master Data extract program considers the Supplier as the Supplier Location & Remittance Location. • When you maintain the Supplier Location but do not maintain the Remittance Location, Ariba AddOn Master Data extract program considers the Supplier Location as the Remittance Location. • When you do not maintain filters for RL_VENDOR_ADDRESS & RL_PARTNER_TYPE, Ariba AddOn master Data extract program displays an error stating that you have not maintained filters for the Remittance Location. © SAP SE AR822 96 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Payment Terms Data: • Payment Terms indicate the negotiated discount between a buying organization & supplier for a specified number of days before payment is due. • When you extract the Payment Terms data from SAP System, Ariba AddOn Master Data extract program downloads only the Normal Payment Terms; the Installment Payment terms are excluded. © SAP SE AR822 97 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview User & User Group Data: • Buyer users need to create user groups in the SAP Ariba Procurement solutions with the SAP System Role Names using the import event Import User Group Mapping. • When you export user data, the information available in the TCode SU01 is exported to the SAP Ariba Procurement solutions. The HR information for the Cost Center, Company Code & the Locale is also exported. • The locale is the concatenation of HR Nationality plus the HR Language (info type 0002). The Ariba AddOn extract program does not export information about users maintained in the HR Info tables. © SAP SE AR822 98 HOME Course Title LOGO HERE @ Copyright. All rights reserved. SAP Ariba Procurement Master Data Integration Overview Incremental Load Events The following incremental change transactions operations for the Master Data export tasks are supported: Object Create Change Block Unblock Lock Unlock Delete Undelete Supplier Y Y Y Y N/A N/A Y Y User Y Y N/A N/A Y Y Y N Asset Y Y Y Y N/A N/A Y N Cost Center Y Y N/A N/A Y Y N N General Ledger Y Y Y Y N/A N/A Y Y WBS Element Y Y N/A N/A Y Y Y Y Internal Order Y Y N/A N/A Y Y Y Y © SAP SE AR822 99 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 2: Importing Master Data in Multi-ERP By the end of this lesson, you will be able to: • Complete an Incremental-load export of Master Data to multi-ERP-enabled systems • Complete a full-load export of Master Data to multi-ERP-enabled systems • Describe how segregation of Supplier & User Master Data elements may be employed for specific sites. © SAP SE AR822 100 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data in Multi-ERP Environment Master data integration between SAP System & the SAP Ariba Procurement solutions supports export of Master Data to the SAP Ariba Procurement solutions in multi-ERP-enabled environments. • Buyers using the SAP Ariba Procurement solutions integrated with SAP System can enable Master Data integration for multi-ERP-enabled systems & specify the site or realm to which they want to export the Master Data. • To export Master Data for multi-ERP-enabled systems, on SAP ERP you must select FPC ENABLED option in the window Export All Master Data Required for On-Demand Applications. • You can specify the name of the site to which you want to export the Master Data in the Site field. In a multi-ERP-enabled environment, you can export the same set of Master Data to multiple sites. © SAP SE AR822 101 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data in Multi-ERP Environment You can export the following Master Data from SAP System to multi-ERP-enabled systems: ü Organizational Data ü Accounting Data ü Cross-application Configuration Data ü Supplier Related Data ü User Related Data SAP ERP supports both full-load and incremental-load export of the Master Data. Note: Make sure that before exporting the Supplier Related & User Related Master Data, you maintain parameter CHANGELOG_RETENTION_DAYS in ARBCIG_TVARV table. © SAP SE AR822 102 HOME Course Title LOGO HERE @ Copyright. All rightsreserved. Importing Master Data in Multi-ERP Environment Incremental export of Master Data to multi-ERP-enabled systems: SAP System uses a combination of the following three variables to ensure that the incremental Master Data is available to all sites to which you want to do incremental exports: ü Site Information ü Date & Time Stamp ü Retention Period When you do an incremental export to a multi-ERP-enabled system, SAP System tags each of the records that you export with the date & time of the export and the name of the site to which you export the record. • SAP System then uses the Site Information & Date & Time Stamp to identify the records to be exported when a new incremental export is triggered. • You can configure the CHANGELOG_RETENTION_DAYS to specify the number of days you want SAP ERP to retain the change records in the table ARBCIG_CHANGEDOC. When the configured retention period expires, SAP ERP clears the change log. • If FPC ENABLED option is selected without maintaining a value for CHANGELOG_RETENTION_DAYS, SAP System returns an error when you access the Master Data export program. © SAP SE AR822 103 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data in Multi-ERP Environment Segregation of Supplier & User Master Data elements for specific sites: • You can segregate various elements of the Supplier & User Master Data & send subsets or supersets based on the specific requirements. • You can choose to export either the User or the User Group Master Data, or both. • You can choose to segregate the Supplier Master Data into various Master Data elements based on the specific requirements of the site to which you export the Supplier Master Data. The Supplier Master Data segregation options include Supplier Location, Supplier Purchase Organization & Remittance Location. • The parent and child differentiation applies only to User & Supplier Master Data events. © SAP SE AR822 104 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data in Multi-ERP Environment When FPC enabled is not selected When FPC enabled is selected © SAP SE AR822 105 HOME Course Title LOGO HERE @ Copyright. All rights reserved. About This Lesson @ Copyright. All rights reserved. Lesson 3: Importing Master Data for SAP Ariba Procurement By the end of this lesson, you will be able to: • Configure and import Master Data in SAP Ariba Procurement solution(s) This lesson covers the configurations & settings required to import Master Data for SAP Ariba Procurement solution(s): i. Configure SAP Ariba Procurement Solutions for Synchronizing Master Data ii. Maintain Parameters for SAP Ariba Procurement Solutions iii. Maintain Filters for SAP Ariba Procurement Solutions iv. Import Master Data from SAP System to Ariba Procurement Solutions v. Maintain Parameters to Import Payment Terms Master Data vi. Import Master Data for Catalogs vii. Maintain Parameters for Catalog Upload Request viii. Implement BAdi for Catalog Upload Request ix. Schedule Job for Catalog Upload Request x. Create Dummy Asset Value xi. Configure SOAMANAGER for Asset Management © SAP SE AR822 106 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement Configure SAP Ariba Procurement for synchronizing Master Data: 1. Download Keystore / Tenant certificate from the Resources page in the CIG 2. Login to SAP Ariba Procurement site, navigate to Core Administration, click Integration Manager 3. Click Integration Toolkit Security Activity i. Configure SAP Ariba Procurement Solutions for Synchronizing Master Data © SAP SE AR822 107 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Configure SAP Ariba Procurement for synchronizing Master Data (continued): 4. Select Certificate as the authentication method 5. Paste the certificate you have downloaded in step#1 6. Click Save Activity i. Configure SAP Ariba Procurement Solutions for Synchronizing Master Data Importing Master Data for SAP Ariba Procurement © SAP SE AR822 108 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Importing Master Data for SAP Ariba Procurement To maintain the required parameters for SAP Ariba Procurement 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. 2. Expand Maintain Parameters section & click on IMG-Activity for Procurement – The Parameters – Ariba Procurement Master Data screen appears. 3. Maintain the parameters mentioned in the tables within this activity. 4. Click Save Activity ii: Maintain Parameters for SAP Ariba Procurement Solutions © SAP SE AR822 109 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values CHANGELOG_RETENTION_DAYS Applicable for SAP Ariba Procurement solutions. This is a mandatory field for exporting master data to multi-ERP-enabled systems. You need not maintain this parameter if you have a single ERP system. Set this parameter to specify the number of days you want SAP ERP to retain the change records log in the table ARBCIG_CHANGEDOC. When the configured retention period expires, SAP ERP clears the change log. - Variable Name: CHANGELOG_RETENTION_DAYS - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Example – 10 CURR_CONV_BANK_RATE Applicable for SAP Ariba Procurement solutions. It is mandatory to maintain one of these parameters: - CURR_CONV_BANK_RATE - CURR_CONV_EURO_RATE Set this parameter to maintain bank rate for currency conversion. - Variable Name: CURR_CONV_BANK_RATE - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify "B" to maintain bank rate. Leave it blank if you want to specify Euro rate. CURR_CONV_DAYS_PAST Applicable for SAP Ariba Procurement solutions. This is an optional field to fetch historical currency conversion details. Specify the number of days old historical currency conversion information to fetch. - Variable Name: CURR_CONV_DAYS_PAST - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Example, specify 10, to fetch ten days old information. Activity ii: Maintain Parameters for SAP Ariba Procurement Solutions Importing Master Data for SAP Ariba Procurement © SAP SE AR822 110 HOME Course Title LOGO HERE @ Copyright. All rights reserved. Parameter Name Description Supported Values CURR_CONV_EURO_RATE Applicable for SAP Ariba Procurement solutions. It is mandatory to maintain one of these parameters: - CURR_CONV_EURO_RATE - CURR_CONV_BANK_RATE Set this parameter to maintain euro rate for currency conversion. - Variable Name: CURR_CONV_EURO_RATE - Field Name: Leave it blank - Number: 0000 - Variant: The unique variant name for the SAP Ariba Procurement solutions in SAP ERP. (example: VREALM_2) - Partition: The unique site name for the SAP Ariba Procurement solutions in SAP ERP. (example: PREALM_2) - Low: Specify "Euro" to maintain Euro rate. Leave it blank if you want to specify bank rate. INTERNAL_ORDER_AUART Applicable for SAP Ariba Procurement solutions. This is an optional field. This parameter specifies the order type of internal orders. SAP ERP can use the internal orders to create a purchase order of the order types that is not specified in this parameter.
More content from this subject
A Complete Guide to the IAPP CIPT Exam- Osta ekologisk ullmatta netistä _ SE Mattor
- Trusted Medical Billing Company to Maximize Your Practice Revenue
- C_ACTIVATE05-demo
- EX442 Dumps with Comprehensive Answer Indicators - Study Savvy
- Refine Your Preparation with the Benefit of EX183 Dumps PDF
- EX403 Dumps with Exhaustive Answer Answers - Ready Wiser
- EX436 Dumps with Itemized Answer Guides - Train Savvy
- Optimize Your Preparation with the Support of EX280 Dumps PDF
- Get Leading with Amended EX288 Dumps 2025 Automatic Save
- GCP-GC-REP Exam Questions Best Preparation Source
- GCP-GCX Exam Questions Greatest Preparation Supply