How to write a DTP filter routine reading data from a HANA table?

[former_member759577]

Hello gurus,

We have a requirement to implement a DTP filter based on a HANA table. Let's say we have a HANA table that has 2 columns, one column is the DTP field we want to put filter on & other field is a numeric range field. The DTP filter should read this HANA table to generate the filter values. Suppose the table is like

Now I want to filter the DTP_FIELD based on the range values from the RANGE_FIELD in the table like : 10000 - 10999, 11000 - 11999, 12000 - 12999 & so on.

Can you please help me how to do this in DTP routine in BW on HANA?

Kind regards.
Jonas

[ferdtulu]

You have two option; creates either a CDS-View or Cal.View to Comp.Prov.

you can add a DTP-Filter on Comp.Prov (as Source)

[former_member759577]

hi,

Many thanks for the answer, I am on BW on HANA, I don't know if we can do CDS view?

Can you please let me know how can I add composite provider as source in second option when the DTP already has specific source & target?