Forum Discussion

BabuJayaraman's avatar
BabuJayaraman
New Contributor II
2 years ago

SAP connector

We have been using the SAP connector for fetching the GL data and few other information like units and install base. The connectors were working fine until Oct 2023. We noticed duplicate and/or missi...
Data Integration
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

This is really a question for Theobald Software, makers of the ERPConnect library that the connector leverages. The https://help.theobald-software.com/en/erpconnect/special-classes/reading-sap-tables-directly-with-readtable doesn't indicate anything related to Order By; in fact, https://kb.theobald-software.com/release-notes/ERPConnect-6.1.0.html, indicating to use .WhereClause instead. I don't know which version of ERPConnect you have installed.

It also looks like your code is using a SAP function Z_XTRACT_IS_TABLE, of which several versions can be found online - some supporting ORDERBY as parameter and some that don't.

I don't know enough about SAP to tell you more than that; unless someone else comes in, you might have to open a case with Support.

Btw, next time you'd like to post some code here (which you're welcome to!), please have a look at this post, describing how to do it in the best way.