How to Use Re-Order Button on Mapping Tool?

Introduction #

‘Re-Order Mapping’ is located on the Mapping Tool, which allows you to reorder mapping records by sequence. This change also prevents users from reordering records in Data Mapping. When the button is used, the sequence field is reorganized during the callout of the record, and the resulting payload records are sorted in ascending sequence numbers. These improvements result in a more efficient and organized data payload sequence structure.

How Re-Order Field Mapping and Callout With SAP CPI Adapter?  #

In this lesson, you will learn how to reorder the mapping fields of the outbound interface and perform the manual process using the SAP CPI Adapter, as shown below:

Pre-requisite #

• Create new Integration
• Create an SAP CPI Outbound Adapter

• Create Message Type
• Create a new Outbound Interface
• Link the Message Type and Adapter with the interface

• Do Mapping

Here is just an example: we have mapped ‘MyAccount’ Message Type to the Account sObject and ‘MyContact’ Message Type to the Contact sObject. The current Mapping order is as follows:

• MyAccount
  • AccountNumber
  • BillingCity
  • BllingCountry
  • Name
  • MyContact
    • Email
    • FirstName
    • LastName
    • Phone

• Re-Order Field Mapping
  • Re-Order Field Mapping of MyAccount Message Type
    • Click the Re-Order Mapping button
    • Select ReOrder Fields on ‘Choose a Option:‘. There are different types of reordering: Reorder Fields and Reorder Node. Reorder Fields allows you to sort fields while selecting Reorder Node allows you to sort nodes.
    • From the dropdown list of ‘Target Object‘, select the node for which you want to change the field sequence. For example, select ‘MyAccount‘. To choose a sub-node, click on the arrow right sign to expand the list.

[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″]By default, the target object will have a ‘rootNode’ even if our business message type does not have it. This is used to store fields without nodes and to wrap all mapping nodes and fields[/su_box]

Now the MyAccount sub-node of the rootNode will be displayed.

• • • To reorder fields, select a row and move it up or down to the desired position in the order.

MyAccount Mapping Fields Before Re-Order	MyAccount Mapping Fields After Re-Order
AccountNumber	AccountNumber
BillingCity	Name
BllingCountry	BillingCity
Name	BillingCountry

 

• • Re-Order Field Mapping of MyContact Message Type
    • Select the ‘MyContact’ sub-node on ‘Target Object’.
    • To reorder fields, select a row and move it up or down to the desired position in the order.

MyContact Mapping Fields Before Re-Order	MyContact Mapping Fields After Re-Order
Email	LastName
FirstName	FirstName
LastName	Email
Phone	Phone

 

• • • After clicking the Save button, the pop-up screen will close and the re-ordered mapping will be saved into Data Mapping.

• • • Afterward, click the Save button to save the mapping record.
• You can make callouts using the developer console, manual processing, or scheduled processing.
  • Now, we will show you execute Interface with manual processing
    • You need to filter your records to be callout on Filter Query on SOQL Query for the Filter sObject section

• • • Go to Interface Detail Pages
    • Click on the Manual Process Button
    • Select “Use the SOQL statement on the interface to select the sObject?“
    • Click Send Button

• • • After clicking Send Button, it will alert the message “The Interfaces__c has been executed. Please check the message monitor”
• After the execution is complete, messages will be created. Please go to Message Monitoring to check them.

Finally, the payload is generated based on the mapping order.