# Negative decimal values are parsed as NULL on SAP ERP provider

**URL:** <https://community.cdata.com/t/negative-decimal-values-are-parsed-as-null-on-sap-erp-provider/306>\
**Category:** Data Sources\
**Tags:** article, sap-erp, rfc\_read\_table, z\_custom\_read\_table\
**Created:** [August 2, 2023, 2:47pm UTC](https://community.cdata.com/t/negative-decimal-values-are-parsed-as-null-on-sap-erp-provider/306 "2023-08-02T14:47:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dardi\_R](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@Dardi\_R](https://community.cdata.com/u/Dardi_R)\
**Post date:** [August 2, 2023, 2:47pm UTC](https://community.cdata.com/t/negative-decimal-values-are-parsed-as-null-on-sap-erp-provider/306/1 "2023-08-02T14:47:29Z")

</div>

_RFC\_READ\_TABLE_ is a read data function implemented by SAP to read content from SAP Tables. CData connectors for SAP ERP use this function to read data by default as it comes shipped with every SAP instance. This function is known to have issues on certain scenarios; one of them being incorrect parsing when dealing with negative decimal numbers which have the same number of digits as their declared length.

_ **e.g ON SAP** :_ 358,15698- (decimal 9,5) → _ **AFTER RFC READ** :_ \*8,15698 -

This bad output causes the connector to parse it as NULL or empty (or empty value, depending on the [InitialValueMode](https://cdn.cdata.com/help/RYJ/jdbc/RSBSAP_p_InitialValueMode.htm) connection property).

To resolve this issue, you will need to set the _ **ReadTableFunction** _ connection property to Z\_CUSTOM\_READ\_TABLE or Z\_CUSTOM\_READ\_TABLE752 and perform the configuration mentioned in the following documentation:

[CData JDBC Driver for SAP ERP - Using a Custom Read Table Function](https://cdn.cdata.com/help/RYJ/jdbc/pg_rfcreadtable.htm)