Describing MDNI- Master Data Native Integration

Objective

After completing this lesson, you will be able to explain configuration processes related to MDNI- Master Data Native Integration.

Master Data Native Integration

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) service.

Highlights:

  • The feature is currently available mainly with the SAP Ariba Procurement solutions integrated with SAP ERP or SAP S/4HANA on-premise using CIG. With SAP Ariba Sourcing solutions currently only Product Master Data integration is supported.
  • 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 applications 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 item here.
  • The WSDL files use the corresponding APIs.

Note

Though you can export master data from multiple SAP on-premise systems, end-to-end integration of multi-erp scenario is not currently supported with 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

Pre-requisites:

  • SAP Ariba solutions are integrated with SAP system using CIG.
  • MDNI service is integrated with SAP Ariba applications. 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 your SAP system.
  • CIG is enabled in your SAP Ariba applications realm & you have secured P User ID & password information.

Limitations:

  • FPC (Federated Process Control) or multi-ERP integration is not supported.
  • FMD (Flex Master Data) 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

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 ComponentsSAP Ariba Cloud Integration GatewayMaster Data Native IntegrationInterface Setup.Display IMG screen showing navigation to Master Data Native Integration under Integration with Other SAP Components for interface setup.
  2. Click IMG-Activity for Configure the Outbound Connections to Send MessagesThe Interface Setup for Ariba MDNI screen appears.Display IMG screen highlighting Configure the Outbound Connections to send messages under Master Data Native Integration section.
  3. Under Interface Setup for Web Service section, perform the following activities:
    1. Select Data Center.
    2. 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
    3. 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. 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.
    Interface Setup Program for SAP Ariba MDNI showing data center selection, connection settings, logon data, and HTTP proxy options.
  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.

Configuring Filters and Extracting Master Data

User can configure filters to extract desired range of data to send to SAP Ariba applications. 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"

Procedure to Configure Filters:

  1. Run the transaction code ARBCIG_MDNI.SAP Easy Access screen showing transaction code ARBCIG_MDNI entered in the command field for accessing related features.
  2. The SAP Easy Access Master Data Native Interface Transactions screen appears. The screen lists the master data objects that are available for export.SAP Easy Access screen displaying Master Data Native Interface Transactions menu with various listed options like Company Code and GLAccount.
  3. Double-click on the master data object you want to export. For example, Company Code.SAP Easy Access screen showing Master Data Native Interface Transactions menu with the Company Code option highlighted.
  4. The extract screen for the master data appears. For example, Company Code Extract for MDNI.Company Code Extract for MDNI screen showing Fields for Selection option with Dynamic Selections folder for Company Codes.
  5. Click on Fields for Selection. The Dynamic Selection screen appears.
  6. Expand the node & you can see fields available for defining filters.Company Code Extract for MDNI screen showcasing dropdown under Dynamic Selections with fields like Company Code, City, Currency.
  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 screen for extracting company codes, showing dynamic selections with input fields and apply options.
  8. Input required filter values.
  9. Click on Apply Selected Items.
  10. Click on Execute button.
  11. Added filters will be shown on the screen.SAP interface showing Company Code Extract for MDNI with two active filters and display data option.
  12. Click Save, the Variant Attributes screen appears. This is a standard SAP screen.SAP Variant Attributes screen displaying fields for variant settings, technical names, and selection screen options.
  13. Specify the variant to export master data from SAP system.

    Example: CC_Extract.

    SAP Variant Attributes screen with fields for variant name, description, screen assignment, and save options.
  14. Click Save.
  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.SAP Company Code Extract for MDNI screen with active filters and Display Data checkbox selected.
  16. When you choose Display Data option, master data records will not be sent to MDNI / SAP Ariba applications.SAP Display Logs screen showing details of company code data extraction with log message text displayed.
  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 data export.

  • Message types are distinguished by colored icons:

SAP Display Logs screen showing details of company code data extraction with log message text displayed.
SAP screen displaying an XML document for company code replication with detailed tags and data.

Configuring MDNI Incremental Extract Events

Users need to configure the incremental extract for General Ledger to run the incremental load export.

This is a one-time activity & a mandatory configuration.

To configure Incremental Extract Event for General Ledger:

  1. Navigate to Integration with Other SAP ComponentsAriba Cloud Integration GatewayMaster Data Native IntegrationGeneral Settings using the transaction code SPRO.SAP Display IMG screen displaying Master Data Native Integration menu with highlighted Configure Extract Events option.
  2. Expand General Settings section & click on IMG-Activity for Configure Ariba Master Data Native Interface Extract Events – The Ariba Incremental Extract Event Configuration screen appears.
  3. Choose the "General Ledger" & click Execute.SAP Ariba Incremental Extract Event Configuration screen with General Ledger selected for export configuration.
  4. The Display logs screen appears with the details of the configured master data extract event.SAP Display Logs screen showing configuration events for General Ledger Incremental Extract with message details.

Configuring MDNI Incremental Field Restrictions

Users need to configure the incremental extract for General Ledger to run the incremental load export.

This is a one-time activity & a mandatory configuration.

To configure Incremental Field Restrictions for General Ledger:

  1. Navigate to Integration with Other SAP ComponentsAriba Cloud Integration GatewayMaster Data Native IntegrationGeneral Settings using the transaction code SPRO.SAP Display IMG screen highlighting Master Data Native Integration and Incremental Field Restrictions configuration.
  2. Expand General Settings section & click on IMG-Activity for Configure Ariba Master Data Native Interface Incremental Field Restrictions – The Ariba Field Restriction screen appears.
  3. Choose the required "General Ledger" extract object & click Execute – The Ariba Field Restrictions screen appears with the details of the configured restrictions.SAP Ariba Field Restrictions screen with Data Extracts field populated with SACH for configuration.
  4. Press Ctrl + C to copy the content of the page. Note that the content is already selected.SAP Ariba Field Restrictions screen displaying expressions and conditions for data extract configuration rules.
  5. Run the TCode SWEC – The Change View "Events for Change Document": Overview screen appears.SAP Change View: Events for Change Document screen showing event configurations for create, change, delete.
  6. Scroll to locate the object with the same object type, event & action type (Create or Change or Delete).SAP Change View Events for Change Document screen displaying highlighted SACH events for configuration.
  7. Select event line in change mode & double-click Field Restrictions folder in the left pane – The Change View "Field Restrictions": Overview screen appears.SAP Change View Events for Change Document screen highlighting SACH events and Field Restrictions option.
  8. Click Condition Editor.SAP screen displaying Field Restrictions with options for configuring condition editor and field values.
  9. If the direct text entry mode is not configured for your user interface, perform the following steps:
    • Click UtilitiesSettings.
    • On the Condition Editor: Personal Settings page, select Direct text entry (traditional mode).
    • Save the configuration.
    SAP condition editor screen for Field restriction for ANLA with logical operators and expressions.
    SAP Condition Editor: Personal Settings screen with options for user interface and technical settings adjustments.
  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.SAP screen for Change Condition showing combined field restrictions with expressions and operators.
  11. Click column for Expression 1 & paste the copied content for field restrictions.
  12. Click Back & enter the Transport Request number.SAP Field Restrictions screen prompting for a workbench request with request ID and description.
  13. Click Save.SAP Events for Change Document screen displaying business object types with actions for create, change, delete.

Configuring 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 ComponentsAriba Cloud Integration GatewayMaster Data Native IntegrationApplication Specific Settings using the transaction code SPRO.SAP Display IMG screen showing configuration path for Master Data Integration and Ariba User HR Event Linkage.
  2. Expand User section & click on IMG-Activity for SAP Ariba User HR Event Linkage – The Change View HR-CA: Event Linkage for Customer: Overview screen appears.
  3. Click New Entries.SAP HR-CA Event Linkage for Customer screen displaying options for adding new entries and configurations.
  4. Create a record with the values mentioned in the table on next slide & click Save.SAP screen showing Infotype Operation and Event Data details for adding new entries and configurations.
  5. Click Next Entry to enter the information for the next record.
  6. Once all records are entered, click Save.SAP New Entries screen showing a list of infotype operations, events, and function module mappings.
Object TypeObject Type TextInfotype (IT)Update OperationSequence NumberObject TypeFunction Module
PPerson0001INS0ARBCIG1065ARBCIG_HRPM_CHANGE_DOCS
PPerson0001UPD0ARBCIG1065ARBCIG_HRPM_CHANGE_DOCS
PPerson0002UPD0ARBCIGTNTARBCIG_HRPM_CHANGE_DOCS
PPerson0105DEL0ARBCIGEMPLARBCIG_HRPM_CHANGE_DOCS
PPerson0105INS0ARBCIGEMPLARBCIG_HRPM_CHANGE_DOCS
PPerson0105UPD0ARBCIGEMPLARBCIG_HRPM_CHANGE_DOCS

Infotypes:

0001 – Organizational Data

0002 – Personal Data

0105 – Communication Data (User ID)

If you get the error message: No Entry exists in T777IBO table, maintain the following entry in the T777IBO table:

OTObject Type TextITObject typeName
PPerson0001ARBCIG1065Add a meaningful name

Maintaining 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 ComponentsAriba Cloud Integration GatewayMaster Data Native IntegrationApplication Specific SettingsUserMaintain User Profiles for User Master Data using the transaction code SPRO.SAP IMG configuration screen for Master Data Integration and User Profiles setup selection option.
  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.SAP screen to edit user roles mapped to groups, highlighting New Entries button option.
  4. 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 Ariba solutions realm / site name.
    SAP screen showing newly added user role entries with a save button highlighted in red.
  5. Click Save.

Maintaining Parameters to Export Product Master to MDNI

You can extract Product Master Data (Material Master Data) from SAP system to MDNI using CIG. From MDNI, Product Master is integrated with SAP Ariba Master Data Service.

SAP Ariba applications can import Product Master Data from SAP Ariba Master Data Service. This capability can co-exist with the capability of extracting Material Master Data using the existing master data export report, ARBCIG_MASTER_DATA_EXPORT.

To use this capability to integrate Product Master from SAP system to MDNI using CIG, you must maintain the CHANGEDOC_RETENTION_DAYS parameter.

This parameter allows you to configure the validity period for retaining changed material documents in the ARBCIG_CHANGEDOC table. Maintaining this parameter is necessary to use the existing method of exporting master data using the ARBCIG_MASTER_DATA_EXPORT report along with exporting product master using the ARBCIG_MDNI_PRODUCTMASTER report.

Procedure to maintain the parameter:

  1. Navigate to Integration with Other SAP ComponentsAriba Cloud Integration GatewayMaster Data Native IntegrationApplication Specific SettingsProduct Master using the transaction code SPRO.SAP IMG screen for Master Data Native Integration, highlighting Application Specific Settings and Parameters.
  2. Click on IMG-Activity for Maintain ParametersThe Parameters – Product Master screen appears.
  3. Click Modify.SAP screen for modifying product master parameters, highlighting Modify button for retention settings.
  4. Maintain the values as shown in the table below & click Save.SAP screen for updating product master retention days, highlighting save icon and updated value.
Parameter NameDescriptionSupported values
CHANGEDOC_RETENTION_DAYS

Set the retention period to keep changed material documents in the ARBCIG_CHANGEDOC table.

You do not need to maintain this parameter if you are not exporting product master to MDNI.

Variable Name: CHANGEDOC_RETENTION_DAYS

Field Name: Leave it empty.

Number: 0000

Low: Enter the validity period in days (for example, 5) for which you want to retain the changed material documents in the ARBCIG_CHANGEDOC table.

Maintaining Date Time Stamp

Note

After you maintain the CHANGEDOC_RETENTION_DAYS parameter, you must maintain the extract, Product Master (Material Master – MDNI) in the Date and Time Stamp for Master Data table to export master data to MDNI using the ARBCIG_MDNI_PRODUCTMASTER report.

If you also want to use the report, ARBCIG_MASTER_DATA_EXPORT for exporting master data, you must maintain the extract, Material Data as well in the Date and Time Stamp for Master Data table.

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 ComponentsAriba Cloud Integration GatewayMaster Data Native Integrationusing the transaction code SPRO.SAP IMG screen for Master Data Native Integration, highlighting Maintain Timestamp for Native Interface option.
  2. Click on IMG-Activity for Maintain Timestamp for Master Data Native Integration – The Change View "Date and Time stamp for Master Data": Overview screen appears.
  3. Click New Entries.SAP screen for maintaining timestamps, highlighting New Entries button to add date and time data.
  4. Enter the following values:
    • Extract: Select from the list.
    • Realm: Enter realm name.
    • Date Time Stamp: Add date & time in YYYYMMDDHHMMSS format.
    SAP screen for adding master data timestamps, showing entries for Extract, Realm, Partition, and Datetime.
  5. Click Save.

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.SAP SM36 transaction interface with Define Background Job, Job Wizard, and navigation steps highlighted.
  2. Click on Job Wizard.
  3. On the Create a job screen, Click Continue.SAP Job Wizard interface with Create a job, description text, and Continue button highlighted.
  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.General job information screen in SAP showing job name, job class, and Continue button highlighted.
  5. On the Job definition: Job step screen, select ABAP program step & then click Continue.Job definition screen in SAP highlighting ABAP program step, Continue button, and job step options.
  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.ABAP program job step screen in SAP highlighting program name, variant field, and Continue button.
  7. On the Multi-step option screen, click Continue.Multi-step jobs screen in SAP highlighting the option to add additional steps and Continue button.
  8. On the Job definition: Start conditions screen, select a condition. For example, Date/time & then click Continue.Job definition: Start conditions screen in SAP highlighting start options, Date/time, and Continue button.
  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.Definition of start at date/time screen in SAP showing scheduled start, period checkbox, and Continue.
  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.Period definition screen in SAP showing job periodicity options, Weekly selected, and Continue button.
  11. On the Set job screen, click Complete.Set job screen in SAP summarizing job details with Complete button highlighted to finalize process.

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_TAXCODE
  • ARBCIG_MDNI_USER
  • ARBCIG_MDNI_WBS

Implementing BAdIs for MDNI

Customizing master data extracts:

Process flow for custom field integration between SAP ECC/S4HANA and SAP Ariba Procurement solutions.

Note

Though you can customize master data objects in your SAP system using BAdIs, end-to-end integration of custom fields & uploading WSDL in MDNI service is not currently supported with Master Data Native Integration.

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 ComponentsSAP Ariba Cloud Integration GatewayMaster Data Native Integration.SAP IMG screen showing Master Data Native Integration and BAdI's for MDNI programs configuration options.
  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 IMG screen displaying BAdI Implementations for ARBCIG_MDNI with Create Implementation button highlighted.

Use the following methods to enhance the BAdI – ARBCIG_MDNI:

Method NameDescription
ENHANCE_COMPANYCODEEnhance Company Code details
ENHANCE_PLANTEnhance Plant details
ENHANCE_PURORGEnhance Purchase Organization details
ENHANCE_PLANTPURORGEnhance Plant Purchase Organization details
ENHANCE_PURGROUPEnhance Purchasing Group
ENHANCE_WBSEnhance WBS Element
ENHANCE_GLEnhance General Ledger
ENHANCE_ACCCATEnhance Account Assignment Category
ENHANCE_CURRENCYEnhance Currency
ENHANCE_MATERIALGROUPEnhance Material Group
ENHANCE_TAXCODEEnhance Tax Code
ENHANCE_ASSETEnhance Asset
ENAHNCE_PAYMENTTERMSEnhance Payment Terms
ENHANCE_INTERNALORDEREnhance Internal Order
ENHANCE_EXCHANGERATEEnhance Exchange Rate
ENHANCE_COSTCENTEREnhance Cost Center
ENHANCE_USEREnhance User
ENHANCE_PRODUCTMASTEREnhance Product Master

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.