Skip to Content
avatar image
Former Member

filtering random material types

Hii friends,


I did a read master data and got material type field from material. We have around 50 Materail type now client wants to see only 20 .I cant filter them at dtp as material type is not available in source.i can write a routine and filter them manually but i was told that we create ranges in transformations and filter those material type which are not recquired ..plz explain me how to create ranges for material types as they are random.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 27, 2015 at 02:00 PM

    Hi there

    Is not very clear what you are looking for, who told you that you can create ranges in transformations a BW consultant? You have to clear that. In routine you can do it.

    The only range i can think about is to use DTP filter for material.

    If you have material types to specific range of material numbers then you can do that.

    Thank you


    Add comment
    10|10000 characters needed characters exceeded

    • ok

      But as i understand that has to be done with coding, i cannot think any other solution.

      To create and read a table without abap is not possible.

      So you want to achieve the update with a different abap method or without coding at all?

      BW is an open system and you can achieve the same update with many different ways, if you want to use a specific way the person who told you that, he must give you more information.

      Thank you


  • May 27, 2015 at 03:16 PM

    Hi Ramarao,

    If I understand your requirement correctly here is the procedure to filter material types randomly.

    1. Create one one customer table at SE11 with below fields let say table name ZMAT_EX_RANGE-->(Exclude Values)

    1. Take permission from BASIS team to provide authorization to maintain values for this table like to enter material type value values for excluding
    2. And maintain values
    3. In DTP for material type infoobject write ROUTINE to read values from ZMAT_EX_RANGE and fill the RANGE table values. as like below

       l_t_range-fieldname = 'MAT_TYPE'.

       l_t_range-low = 'MAT_TYPE01'.

       l_t_range-low = 'MAT_TYPE10'.

       l_t_range-option = 'BT'.

       l_t_range-option = 'E'. E --> Exclude, I-Include

       APPEND l_t_range.

    Please do like this.

    you may find more information on google about this.

    Thank you,


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Nanda Anantha

      So Nanda, do we need to create 10 range tables as i need 10 storage locations out of 30? and those storage locations are random. Is it possible if you give me a code for this to write it in endroutine? Please dont mind if i am bothering you. I am learning this wayout to do this.