Skip to Content
avatar image
Former Member

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


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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,


    Add comment
    10|10000 characters needed characters exceeded