cancel
Showing results for 
Search instead for 
Did you mean: 

DTP filter value automation

Former Member
0 Kudos
629

Hi Experts,

I need to load data to a cube from R/3 for a particular Fiscal year period. In my datasource there comes a field 0FISCPER. Now in DTP filter everytime I give required period and load data.

Now we have to automate the process through process chain. So I need this selection of period in DTP filter to be automatic based on system date. Is there any way to achieve this? May be through routine or something?

Please advise me or give me any document for this.

Thanks,

Akshay

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please check the document. It will help you.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80b2db87-639b-2e10-a8b9-c1ac0a44a7a6

Thanks,

Indrashis

Answers (3)

Answers (3)

former_member199691
Active Contributor
0 Kudos

you can write a routine like this;

Data:Year(4) type n.

read table l_t_range with key

fieldname = 'FISCYEAR'.

l_t_range-iobjnm = 'FISCYEAR'.

l_t_range-fieldname = 'FISCYEAR'.

l_t_range-low = sy-datum+0(4).

l_t_range-option = 'EQ'.

l_t_range-sign = 'I'.

l_idx = sy-tabix.

*....

if l_idx <> 0.

modify l_t_range index l_idx.

else.

append l_t_range.

endif.

p_subrc = 0.

Regards,

Gaurav

Former Member
0 Kudos

Hi Akshay,

If you want to populate the filters in DTP dynamically, you can achieve this by writing routine.

check the below article

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0a5e58d-1117-2d10-13a7-fa10c2cf2...

Regards,

Venkatesh

Former Member
0 Kudos