Exporting to SAP ECC system

The SAP Export action allows you to use a SAP BAPI to load data from Data Guru into a SAP ECC system. You can map data from a Data Guru table into BAPI interface parameters.

On the Configuration tab:

1. Create join relationships between the Input and Lookup tables.

2. Review the selected SAP function.

3. Assign Data Guru tables to SAP tables.

4. Select the Data Guru table from the dropdown list.

5. The checkbox indicates if the SAP table is assigned to the Data Guru table; remove the checkmark to unassign.

The most common application is to load data from a non-SAP system into a SAP ECC system.

Export to SAP

1. Drag the SAP Export icon onto the design surface.
2. On the Connections tab , enter a Name and a Description to identify the action, then specify the input database and output SAP options:

   Input -

   • For Database Connection, specify the database from which the data is being imported, or choose New Database Connection to establish a connection to another database,
   • For Input Table Name, select the Data Guru being exported to SAP.
   • In Lookup Table Name, optionally select one or more Data Guru tables for lookup. As you select subsequent tables, they are listed in the space below the selection field.

   Output -

   • For SAP Connection, select the SAP to which the data is being exported, or choose New SAP Connection to establish a connection to another SAP.
   • Click the icon next to the selected SAP connection to open the connection.
   • Use the Search tab to select a function -
     • In Search Groups, enter the name of a group to identify all functions available for that group, or enter an asterisk * for all available groups.
     • Click the Search icon to populate the Available Functions list.
     • Highlight the function to be used, and click the Select button.

       The selected function is then displayed in Selected Function, and the Refresh icon is enabled next to it.

     • Click the enabled Refresh icon to populate the SAP tables on the Configuration tab.
   • Other tabs in the Output area include -
     • Documentation – Retrieves available function documentation from SAP.
     • Function Interface – Displays input field and output table meta data.
     • Function Call Parameters – Provides detailed meta data on function input parameters.
3. On the Configuration tab , make the necessary table mappings for the Data Guru input and lookup tables, and then assign the Data Guru tables being exported to the appropriate SAP table:
   • If you are using lookup tables, create field relationship(s) between the target and lookup tables in the Table Mapping area. Drag from a field in the Target table, which contains the rows to be considered, to a field in the Lookup table, which contains rows to be searched. Repeat for all fields being mapped between the two tables, and for additional lookup tables.
   • Selected Function – Displays the name of the function selected on the Connections tab.
   • SAP Table Assignments – For each SAP table to which data is being exported, use Assigned Table to map it to the appropriate Data Guru table.
   • Once a Data Guru table has been mapped, a checkmark appears in the Mapped checkbox next to the table name. To remove an assignment, clear the checkmark from the box.
4. On the Mapping tab , make any necessary changes to the output SAP tables. For SAP Export, the Mapping tab functions differently than on other actions.
   • Base Table Mappings - For the SAP fields listed, select a Mapped Field from the appropriate drop-down to associate it with a field in the Data Guru Base table.
   • Ancillary Table Mappings - Allows you to map fields from the lookup tables to the corresponding fields in the SAP tables.
     • Select a table from the Mapped SAP Table drop-down to populate the lookup Source Fields from Data Guru and the Destination Fields from the BAPI.
     • To map to a Destination Field, drag from Source Fields to the Source Field column in the Mappings area.

     

5. Optionally, on the Performance tab (if enabled in User Preferences), change your settings to control the package size and help prevent connection timeouts during the import of large data result sets. Refer to Change general preferences for additional information.

SAP Export Data Considerations

If your SAP Export is producing errors or not exporting data correctly, verify the following.

• Date values must be in correct format - YYYYMMDD (e.g., 20160931).
• Character input fields must be left-padded with leading zeros.
• Input data is case-sensitive.