DTP Filter to exlclude Blank Materials

[sap_cohort]

Hi, I have a Direct (no psa) Flat File Data Load via DTP into my InfoCube. Now I want to filter out any records with Blank Materials. When I go to set the filter in the DTP it seems it only allows me to INCLUDE selections and not EXCLUDE selections.

Any ideas how I can EXCLUDE Blank Materials from my Direct Flat File Load using the DTP? Or any other ideas?

Thanks!

[Former Member]

In DTP under Filters for Material Field do the followin

g:

Right Click and Select Options -> Select Not Equal To -> Give Space in the Material Text box.

This will excluse blank materials from loading.

Regards,

Vijay

[sap_cohort]

In this context only Single Value appears as an option....

[sap_cohort]

Thanks for the information. I just thought of a solution by deleting the records in the Transformation Start Routine...

Thanks again

[Former Member]

You can try - include an interval that excludes all invalid materials including BLANKS.

It cna be "0000001" to "999999"..or "a" to "Z"

[Former Member]

hello,

In the DTP filter, you have the option of writing a routine to perfom some logic...

u can try to exclude some materialks there..

for the sample code check:

data: l_idx like sy-tabix.

read table l_t_range with key

fieldname = '/BIC/ZEMPNAME'.

l_idx = sy-tabix.

*....

l_t_range-iobjnm = 'ZEMPNAME'.

l_t_range-FIELDNAME = '/BIC/ZEMPNAME'.

l_t_range-sign = 'I'.

L_T_RANGE-OPTION = 'EQ'.

l_t_range-LOW = 'RAJ'.

l_t_range-HIGH = 'RAJ'.

if l_idx 0.

modify l_t_range index l_idx.

else.

append l_t_range.

endif.

Reagrds,

Dhanya