3663719 - Why is my extraction of table JCDS from the 'Start Mining for Make to Stock in SAP S/4HANA 'accelerator taking so long to finish/failing?

Why is my extraction of table JCDS from the 'Start Mining for Make to Stock in SAP S/4HANA 'accelerator taking so long to finish/failing?

The extraction is taking so long/ throwing a timeout due to the use of the STARTSWITH function in the JCDS tables SQL filter in the Source Data 'plan-to-fulfill_make-to-stock_s4h'. The function carries out the filtering on the client side, meaning that we send the SQL extraction query to the source system, and the source system collects all the table data, and then runs the filter on each row. This is a very inefficient way to extract data.

We recommend that you create a Data View/Table Object in your source system which stores the table data that is a result of the SQL filter. Therefore, you will only need to extract that new Data View/Table Object.

process, intelligence, jcds, extract, slow, long, make, stock, fullful, plan, s4/hana , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem