SAP JCo Account

In this article

Overview

You can use this account type to connect SAP Snaps with data sources that use SAP JCo account. The SAP JCo Account connects to an application server (ASHOST - Application Server Host). Learn more.

Ensure that your SAP instance is configured to work with the Snap Pack.

Prerequisites

None.

Known Issues


Behavior change

The 4.38 GA main27765 Snap Pack version that included the SAP library upgrade introduced the following behavior change:
In JCo 3.1.4, if a decimal number couldn't be stored in a BCD field, it was rounded, resulting in a loss of precision. This behavior was removed in JCo 3.1.9, and instead, a conversion error is raised when this condition is detected.

Here's an example of a conversion error:

Cannot convert value '1035.1532177250149' from type java.math.BigDecimal to type BCD field ZINV_AMT in record ZINVENTORY

Note from SAP documentation mentioned in SAP Note 3446411 (Version: 4, Released On: 04.04.2024):

This happened at calling API method JCoRecord.setValue([name|index], BigDecimal) for a type BCD field or parameter, if the fraction part of the provided java.math.BigDecimal value had too many digits to fully fit into the BCD field. In this case, the provided BigDecimal value was unintentionally rounded instead of throwing an appropriate ConversionException for notifying the caller about the value not fitting into the BCD field. Hence, there might have been an unnoticed loss of precision.

Workaround:

Before passing the parameter value to SAP, modify the value by rounding or truncating to ensure it fits into the target BCD field.

Account Settings

sap-jco-account.png

 

  • Asterisk (*): Indicates a mandatory field.

  • Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the fieldset.

  • Remove icon ( ): Indicates that you can remove fields from the fieldset.

Field Name