DTP filter for a particular field and filter the company code based on the field

Hi All,

Greetings for the day !!

I am new to BI , I got stuck with a requirement that we got , can anyone please through some light on this?

Requirement i) Need to filter the company codes based on a field(/bic/zbu_code) . If /bic/zbu_code = ‘2000’ then there will be some company codes in the Active Data table of the DSO. Currently it has been hardcoded with the values that satisfy the zbu_code = 2000.

Also I can see Ranges been hardcoded.

Can anyone help me with a sample code on how to write a routine instead of hardcoding ?

Requirement ii) FM : RSNDI_MD_TEXTS_UPDATE  …Can this FM be used in order to get the texts from R3 and populate the Text tables in BW ?

Thanks

Navya.