Salesforce

SAP R/3 and SAP A1 - XML (Magic xpi 4.5)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

SAP R/3 and SAP A1 - XML (Magic xpi 4.5)

The SAP R/3 connector supports the XML interface only. Follow these steps to configure the SAP R/3 connector.

  1. Double-click or right-click on the SAP R/3 connector and select Configuration from the context menu to open the SAP R/3 Configuration dialog box. The general fields for the XML configuration are described in the table below:

Property

Description

Connection

Resource Name

This read-only field displays the name of the SAP R/3 resource or dynamic resource that you defined in the Settings dialog box's Resources section and selected for this connector.

Keep Connection Open

Select this check box to indicate whether you want the connection to the SAP R/3 database to remain open once the operation has been completed. You should use this function when the connection to SAP R/3 is done periodically. The default is unchecked.

Note:

Connections to the SAP R/3 database are maintained in a connection pool. A SAP R/3 step in a flow requests an existing open connection from this pool.

If you select the Keep Connection Open check box, the connection is not returned to the pool once the step is finished. Instead, it is used in the next SAP R/3 step on the same thread, or returned to the pool once the thread is finished (which can take some time).

The only scenario where connections should not be returned to the pool is when several calls to the SAP R/3 database are in a transaction. In all other scenarios, used connections should be returned immediately to the pool once the step is finished so that other steps can use them.

  1. You should now select the Operation that you want to execute, as described in the table below:

Property

Description

Operation

Interface Type

Select one of the following from the drop-down list:

  • IDoc

  • RFC

  1. If you selected IDoc as your Interface Type in the previous step, you should now define it, as described in the table below:

Property

Description

Message Type

This allows you to select the relevant Message Type name from a list received from the server.

You can access the Message Types list by clicking . This opens the IDoc Message Type List dialog box. Click Select to select the required IDoc Message Type, or click Cancel to exit the list. Alternatively, you can click Reload to refresh the Message Type list.

IDoc Type

This allows you to select the relevant IDoc Type name from a list obtained from the server by the IDoc Search Form. This list is filtered by Message Type.

You can access the IDoc Types list by clicking . This opens the IDoc Type List dialog box. Click Select to select the required IDoc Type, or click Cancel to exit the list. Alternatively, you can click Reload to refresh the IDoc Type list.

Extension

This allows you to enter an extension name or select from a list of available extensions by clicking .

Transaction ID

This variable allows you to manage a Transaction ID for delivery failures, such as timeout.

You can select a variable to hold the Transaction ID by clicking . This opens the Variables List. Choose the required Alpha variable by clicking Select.

  • When an IDoc is sent, the variable is populated with the transaction ID of the transaction.

  • If the variable is not empty, Magic xpi will use the value as the transaction ID.

The use of this option is for Transaction ID management. For example, if an IDoc is sent but Magic xpi gets back a timeout, then Magic xpi does not know if the IDoc arrived at its destination. To prevent the redundant processing of the same IDoc, Magic xpi, by supplying the previous Transaction ID value, sends the IDoc with the same transaction ID as before.

On the SAP R/3 side, if the IDoc arrived the first time it was sent, the next time Magic xpi sends the IDoc with the same transaction ID, SAP R/3 knows to ignore it.

Result

Store result in

Defines where you want to store the resulting XML file. Select one of the following from the drop-down list:

  • File: Select a file to hold the object data that is returned by SAP R/3.
    Click to open the Expression Editor or click and enter the file path where this information is to be stored.

  • Variable: Select a variable to hold the object data that is returned by SAP R/3.
    Click to open the Variables List. Select a variable where this information is to be stored. The default is C.UserBlob.

Note:

  • If you select Message Type, only IDocs belonging to this group will be available.

  • When you select a specific IDoc by clicking OK, Magic xpi connects to the SAP R/3 server and receives IDoc information which it uses to generate the appropriate schema.

  • The generated interface schema that is used by the Data Mapper is saved in project/SAP-R3/XSD/HostDetails/IDoc directory, where HostDetails is a string built from the connection properties. The name of the file is the same as the IDoc type.

  1. If you selected RFC as your Interface Type in the previous step, you should now define it, as described in the table below:

Property

Description

RFC Group

This allows you to enter the RFC Group, or to select the relevant RFC Group from a list received from the server. You can access the RFC Group List by clicking .

You can leave the RFC Group blank. If you do this, when you select an RFC Name its related group is filled in automatically.

RFC Name

This allows you to enter the RFC Name, or to select the relevant RFC Name from a list obtained from the server by the RFC Search Form. This list is filtered by RFC Group. You can access the RFC Group List by clicking .

Result

Store result in

Defines where you want to store the resulting XML file. Select one of the following from the drop-down list:

  • File: Select a file to hold the object data that is returned by SAP R/3.
    Click to open the Expression Editor or click and enter the file path where this information is to be stored.

  • Variable: Select a variable to hold the object data that is returned by SAP R/3.
    Click to open the Variables List. Select a variable where this information is to be stored. The default is C.UserBlob.

Note:

  • If you select RFC Group, only RFCs belonging to this group will be available.

  • When you select a specific RFC by clicking OK, Magic xpi connects to the SAP R/3 server and receives RFC information which it uses to generate the appropriate schema.

  • The generated interface schema that is used by the Data Mapper is saved in project/SAP-R3/XSD/HostDetails/RFC directory, where HostDetails is a string built from the connection properties. The name of the file is the same as the RFC name.

  • You can see documentation for the SAP R/3 RFC simple and compound nodes in the Properties pane's Additional XML Properties section.

  1. Click OK to complete the process. If a schema does not exist, the required information is retrieved from the server and a schema is created. The configuration information is saved, and the Data Mapper window opens with the selected schema as the Destination. You should define the data required to complete the desired operation in SAP R/3.

Alternatively, you can click Cancel to exit the SAP R/3 Configuration dialog box without saving your settings or modifications.

In addition, you can:

  • Click Refresh XSD to delete the existing schema and create a new one.

Note:

If there is a failure in server connectivity, an error message is displayed, and you remain in the SAP R/3 Configuration dialog box.

Reference
Attachment 
Attachment