Skip to Content
avatar image
Former Member

Material classification issue

Hi Experts,

I'm having difficulties finding a solution for a request at my company.

Business is asking for a material class "Marketing drives" where they can assign different drives to certain materials.

The data for these drives (key, description and validitiy period) are comming from a Z-table. Now, the class is created and I created one characteristic for the class which is linked to the key of the check table via the "other value check".

The issue I have now is that the business also wants to see the description in the material class. In normal cases, I would create a second characteristic and make a dependency but I do not know how that would work because I would need to go and make a select from the Z-table.

Can anyone give me some ideas?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 20, 2015 at 10:45 AM

    Hi Tom,

    you cannot do this with a check table. You have to use a function module instead. Please have a look at note 1155969 - there you can find an example.

    Regards,

    Sandra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ritesh Dube

      Hi Ritesh,

      Unfortunatly it does not seem to work.

      What I have done: Link FM Z_CHECK_MKT_DRIVE to char 1.

      FUNCTION Z_CHECK_MKT_DRIVE.

      *"----------------------------------------------------------------------

      *"*"Local Interface:

      *"  IMPORTING

      *"     REFERENCE(CHARACT_NO) TYPE  ATINN

      *"     REFERENCE(CHARACT) TYPE  ATNAM

      *"     REFERENCE(VALUE) TYPE  ATWRT

      *"  EXPORTING

      *"     REFERENCE(DESCRIPTION) TYPE  ATWTB

      *"----------------------------------------------------------------------

        DATA: lv_value TYPE atwrt.

        select single zdesc from ZEAG_MKT_DRIVES into description

          where prog_key = value.

      ENDFUNCTION.


      I do not see an option somewhere to change the value of Char2 in this FM.


      In the classification tab nothing happens when I select a value in char 1 (marketing_drive).

      Someone an idea?

      pic1.jpg (46.7 kB)
  • May 19, 2015 at 12:26 PM

    Dear,

    Are you using "material variants"? Have you assigned in basic data-2 of material master for client specific and for plant specific at MRP-3 view.

    If you are using with class type 300, you can see the description of the characteristic.

    Regards,

    Pardhu

    Add comment
    10|10000 characters needed characters exceeded