Automate

Hi everyone,

I am attempting to create an SAP MM02 script that has the ability to add, insert and/or delete characteristic values for different classifications. I have it working for add/insert for all values but the issue is with delete. We have characteristic values that are non-unique i.e. the same language code "EN" could be used for different characteristics so it is difficult to search for the correct value and remove it. The way I am doing it now is first searching by characteristic description and then using the "Choose" button to open up a separate screen to then search and uncheck these values (displayed in screenshot below). The issue with this is not all characteristic entry tables work the same with these check boxes in my SAP system so deletion would need to be handled differently across different characteristics. I am also using this delete function mainly for multi-value characteristics so I would need to select certain ones from the list of values.

Does anyone have any suggestions for a script like this? I would prefer to stick with a transaction script recording just to have the option of validation for our users but I could switch to BAPI if this script can't be accomplished like this.

I have attached my current script.

Thanks,

Knavis McGowan

------------------------------
Knavis McGowan
Master Data Specialist
ABBOTT RAPID DX INTERNATIONAL LIMITED
FL
------------------------------

Hi Knavis

Great that you're trying to do something that isn't simple. :)

It looks like you have binoculars in your multi-value selection pop-up, so that could help you find the right row - is that correct?

I have a not great but working query that could help you find materials that have a characteristic value.  I include a range of materials and class name in the criteria, as well as a list of values, but you can simplify them or go a bit nuts.  Just know because of the crazy way SAP setup these table, the joins are not intuitive nor efficient.  However, if it helps you find material characteristics to update, it may be worth it..  Example attached.

I would go the BAPI route, but your approach might work given you have the binoculars to find the characteristic (standard) and the binoculars in the multi-select pop-up.

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------

Thanks for the reply, Sigrid.

I do have binoculars that I am using to search using either the characteristic descriptions or values but the issue was that it was having trouble accurately finding our Country codes in characteristic values i.e. if I searched for "CN" to delete this entry, it would display all values or descriptions that have "CN" within them which can be quite a few. The other option was to search by description first then use this "Choose" button to open up a separate table (displayed in original post) and then search/uncheck the value within this table but not all value tables work this same way so the script became in what characteristics it could delete. 

We ended up changing our SAP config (if only this was an option every time we have a script issue!) for these country codes from a check table to just a list of values so that it would make this deletion method possible. The script can now add, insert or delete characteristic values depending on what is specified by the user.

Thank you for the Query script as well, I will keep this one in mind if I need it in the future.

Thanks!

Knavis McGowan

------------------------------
Knavis McGowan
Master Data Specialist
ABBOTT RAPID DX INTERNATIONAL LIMITED
FL
------------------------------

Original Message:
Sent: 05-17-2024 18:50
From: Sigrid Kok
Subject: Remove/Delete Material Characteristic Value in MM02

Hi Knavis

Great that you're trying to do something that isn't simple. :)

It looks like you have binoculars in your multi-value selection pop-up, so that could help you find the right row - is that correct?

I have a not great but working query that could help you find materials that have a characteristic value.  I include a range of materials and class name in the criteria, as well as a list of values, but you can simplify them or go a bit nuts.  Just know because of the crazy way SAP setup these table, the joins are not intuitive nor efficient.  However, if it helps you find material characteristics to update, it may be worth it..  Example attached.

I would go the BAPI route, but your approach might work given you have the binoculars to find the characteristic (standard) and the binoculars in the multi-select pop-up.

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------

Hi Knavis

Glad to hear you have a fix. 

I would have suggested to search for Chinese the description, instead of CN, the value, although I'm not sure how your binoculars work in the pop-up, since I don't have one (am jealous :) ).

Hope the Query comes in handy some time.

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------

Original Message:
Sent: 05-22-2024 12:30
From: Knavis McGowan
Subject: Remove/Delete Material Characteristic Value in MM02

Thanks for the reply, Sigrid.

I do have binoculars that I am using to search using either the characteristic descriptions or values but the issue was that it was having trouble accurately finding our Country codes in characteristic values i.e. if I searched for "CN" to delete this entry, it would display all values or descriptions that have "CN" within them which can be quite a few. The other option was to search by description first then use this "Choose" button to open up a separate table (displayed in original post) and then search/uncheck the value within this table but not all value tables work this same way so the script became in what characteristics it could delete. 

We ended up changing our SAP config (if only this was an option every time we have a script issue!) for these country codes from a check table to just a list of values so that it would make this deletion method possible. The script can now add, insert or delete characteristic values depending on what is specified by the user.

Thank you for the Query script as well, I will keep this one in mind if I need it in the future.

Thanks!

Knavis McGowan

------------------------------
Knavis McGowan
Master Data Specialist
ABBOTT RAPID DX INTERNATIONAL LIMITED
FL
------------------------------


Original Message:
Sent: 05-17-2024 18:50
From: Sigrid Kok
Subject: Remove/Delete Material Characteristic Value in MM02

Hi Knavis

Great that you're trying to do something that isn't simple. :)

It looks like you have binoculars in your multi-value selection pop-up, so that could help you find the right row - is that correct?

I have a not great but working query that could help you find materials that have a characteristic value.  I include a range of materials and class name in the criteria, as well as a list of values, but you can simplify them or go a bit nuts.  Just know because of the crazy way SAP setup these table, the joins are not intuitive nor efficient.  However, if it helps you find material characteristics to update, it may be worth it..  Example attached.

I would go the BAPI route, but your approach might work given you have the binoculars to find the characteristic (standard) and the binoculars in the multi-select pop-up.

Best Regards,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.