OPTION_NOT_VALID running table extractions error after an SAP Update

Error:


After updating the SAP System, you get the error OPTION_NOT_VALID when running table extractions or when doing a lookup within an Xtract component.

Reason:


This error comes up with some changes in the structure of the function module RFC_READ_TABLE in newer SAP Systems. 

Solution:


Apply SAP Note 2246160 (and related SAP Note 3139000)  to the SAP System (at least version 11 of that Note is needed). 
The function module RFC_READ_TABLE in SAP gets corrected to the old behavior and is downward compatible again. 
When using ERPConnect, make sure to remove the field MANDT from a WHERE clause, in case you should use one.

Creation date: 6/24/2022 9:37 AM      Updated: 11/25/2022 10:43 AM