Skip to Content

HCI DS , How to restrict data at extract level in HCI DS

Aug 11, 2017 at 08:43 AM


avatar image
Former Member


I would like to restrict data for a table , lets say ekko , before load entire data into HCI DS and then do a filter validation at transform level.

I know that at task-data flow filter level, we can do transformation rules like ekko.bukrs = '1000' , but here entire data will be loaded into HCI DS and then each record would be validated . Instead of this , at Extract level , I want to fetch data from ekko where bukrs =1000.

Has anyone come across this type of requirement.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 15, 2017 at 04:24 PM

Hello Syed,

we have used the required filters in Transform1 using simple query. based on the monitor log, data entering Flow are filtered and only data satisfying the condition enters the flow. I don't think, they download enter table and filter the particular records alone.

if performance is a major concern, Best option will be is to use ABAP Query for extract of data. If you have the filter as BUKRS='1000', the query runs in ECC system. The data enters HCI after applying all the filters inside the ABAP query.

with regards,


10 |10000 characters needed characters left characters exceeded