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
NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hi All!
Adding an order to your data fetch from SAP in VB.NET using ERPConnect's ReadTable isn't straightforward. ReadTable is great for grabbing data but not for sorting it like you'd do in a SQL query. It is designed primarily for data extraction and not query manipulation!
- Your solution could be to use a custom SAP Function Module  - requires some development from your SAP team. 
- Or you could Handle less data in each call by adding a filter.
  Can you add a filter on the month and add a loop in your BR? 

  1. You add a filter on month, like Jan to June.
  2. You run this call and it imports Jan to June data (so your volume gets divided by 2 in theory)
  3. You write those values in a data table
  4. You do a second call for data from July to December
  5. You add those value to the data table...

    Obviously you could reduce the volume if you loop with entities, or even doing month by month...

Hope it helps,

Nic