Number of Exclusions in DTP

[Former Member]

Hi Experts,

I am trying add a big exclusion list in DTP filters.

I have already added 1500 entries.

But when I add another 1000 exclusions and activate the DTP and go back to filter to see the exclusion list, I dont find those additional 1000 filters in exclusion.

No specific error message is shown.

Please advise if there is any limit on number of exclusions?

Any alternative mechanism to achieve this?

Appreciate your help on this.

Thanks,

Pratap

[RamanKorrapati · Accepted solution]

hi pratap,

if you required exclusines are in sequence then we an give ranges with exclide option.

if it not allwoing then you can need use end routine to filter them.

just try add 10 more check it. whether they as added or not. if added then keep on increase on check it.

Thanks

[former_member182196]

Hi,

on this area and select not equal to option.

But its a better way, go with abap code in Start or End Routine  and delete or filter.

Regards,

SM

[former_member182470]

Actually exclusions might not work properly. For any reason, you want to do it, then i suggest you to put only 1000 in the exclusions per DTP run. You can run multiple times DTP with different exclusions each 1000.

[KamalMehta]

Hi Suman,

But if in case this needs to be scheduled on periodic basis then can't change the filters manually again and again.

It would be better to code this in start or end routine for required conditions.

Also check if you can define routine i.e. OLAP Variable for i_step < 2 in DTP Filter for your conditions. I mean if you can populate the range table for the same.

Thanks

[Former Member]

Hi Pratap,

I think the best way to use exclusion criteria in the Transformation is in the Start- or End- routine (e.g. between DS and DSO or DSO and Cube). Here you can implement your customer specific exclusion criteria with the help of simple ABAP code.

For example in the end routine  - Delete all Sales Documents were rejected and/or the quotation is no longer valid:

DELETE RESULT_PACKAGE WHERE REJECTN_ST EQ 'C'
OR QUOT_TO LT sy-datum.  

Hope this helps?

Thanks and regards,
Michael