Skip to Content
0
Former Member
Oct 21, 2010 at 11:14 AM

Filtering of data while reading with "RSDRI_INFOPROV_READ" from infocube.

67 Views

Hi all,

I am working with a function module "rsdri_infoprov_read" to read data from multi provider. Here i am facing a problem with the parameter 'i_t_range' - select options, I have filled elements of this parameter, but regardless of my selection it brings some more data from cube. It would be so helpful for me if somebody can can have a look at it. The value apppending to i_t_range is as shown below,

  • plant is the selectio screen input.

LOOP AT s_plant.

g_s_range-chanm = 'GCSLOCT'.

g_s_range-sign = 'I'.

g_s_range-compop = 'EQ'.

g_s_range-low = s_plant-low.

APPEND g_s_range TO g_t_range.

ENDLOOP.

  • material is the selectio screen input for which product.

LOOP AT i_t_materials.

g_s_range-chanm = 'GCSMATE'.

g_s_range-sign = 'I'.

g_s_range-compop = 'EQ'.

g_s_range-low = i_t_materials-sub_type.

APPEND g_s_range TO g_t_range.

ENDLOOP.

  • version is the planning book version constant.

g_s_range-chanm = 'GCSPLVER'.

g_s_range-sign = 'I'.

g_s_range-compop = 'EQ'.

g_s_range-low = version.

APPEND g_s_range TO g_t_range.

ENDLOOP.

  • week is the selectio screen input for period.

g_s_range-chanm = '0CALWEEK'.

g_s_range-sign = 'I'.

g_s_range-compop = 'BT'.

g_s_range-low = s_period-low.

g_s_range-high = s_period-high.

APPEND g_s_range TO g_t_range.

It should fetch data for the plant which i given in s_plant-low(select option) only but it returns other plants too in the output internal table e_t_data.So it effects the perfomance and here i need to fliter the other plants while reading itself.

This is for plant, but coming to other inputs like material,version and period into the i_t_range table and for which it returns the corrct values only.The problem's with the plant input selection only.

I hpe you guys can easilyhelp me with this,,

thanks in advance for all.

Regards

ashir ck