Use the following rules and guidelines when you configure SAP sources:
When you configure an SAP source, configure row limits using the advanced source properties available on the scheduling page of the task wizard. Row limits on the data filters page of the task wizard are not enabled for SAP sources.
Do not use tables as SAP Table sources if the sources have circular primary key-foreign key relationships.
Define relationships for multiple sources after the data preview displays the data.
Data sorting does not apply on cluster or pool table fields.
You can use
Data Integration
variables and ABAP variables in simple data filters for SAP tables. Do not use ABAP syntax in simple data filters for SAP tables.
You can use ABAP variables and ABAP syntax in advanced data filters for SAP tables. Do not use
Data Integration
variables in advanced data filters for SAP tables.
Use the $LastRunTime variable to filter data based on the start date and time in GMT time zone of the last task that ran successfully or ended with a warning in the Secure Agent.
Due to an SAP limitation, tasks that require a read longer than 30 minutes can fail. You might use one or more of the following suggestions if you encounter this problem:
Use the SAP advanced source properties to limit the number of rows to be read.
Configure a data filter to reduce the number of rows to be read.
Reduce the number of output fields for the task.
Configure the SAP parameter rdisp/max_wprun_time to allow more time for the read. For more information, see the SAP documentation.
To increase the amount of records that the Secure Agent can retrieve at one time, you can increase the Java heap memory for the Secure Agent. To do this, edit the Secure Agent. In the System Configuration Details section, select DTM and set the JVMOption1 property to the following value: Xmx512m. Click OK to save the change and restart the Secure Agent. Adjust the value for the JVMOption1 property based on the amount of records you want to retrieve and the available memory on the Secure Agent machine.
For a lookup on an SAP object, configure the lookup to return less than 20 rows. Tasks might fail if the lookup returns more than 20 rows.
A lookup on an SAP object does not return matching rows if the lookup comparison value is NULL.
Consider the following rules when you configure a mapping to read from CDS views:
When you select a CDS view as an SAP source object in a mapping, you cannot preview the data.
When you configure a mapping with a lookup transformation to look up records in CDS views with parameters, only uncached lookup is supported.
Delta extraction does not apply if you select a CDS view as an SAP source object.
Do not use completely parameterized or advanced filters for CDS view parameters.
Do not use the CLNT field optional parameter in a mapping.
To establish communication from the SAP system with the Secure Agent using the IP address of the NAT gateway, you need to add the DTM property named SapTableReaderNatIpAddress for the Secure Agent and specify the NAT IP address as the value.
When you run an SAP Table Reader mapping, even though the mapping runs successfully, the system log of the SAP system displays the CPIC error.
To avoid the CPIC error at the SAP system, see KB article
000176711.
Before an SAP Table connection can make a call to RFC_READ_TABLE in SAP, verify that the following SAP Note is available in the SAP server:
2246160 - Enhancements to the RFC_READ_TABLE function module
ASK INFAPreview
