The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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...
JackLacava
OneStream Employee
OneStream EmployeeThis 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.