Automate

Original Message:
Sent: 1/5/2021 10:50:00 AM
From: sigrid kok
Subject: RE: Read and Maintain Material Master Record Classification

Hi Marco - the object number in KSSK is long because it's used for many objects in SAP, not just material characteristics.  It does contain the material number, otherwise the query would not have worked.  It may not run as efficiently, but it does work.  Give it a try.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 01-05-2021 02:46
From: Marco
Subject: Read and Maintain Material Master Record Classification

Hi Sigrid,

Thank you, that information is helpful. There is one problem in Query Mode: How can I match table KSSK with table MARA-MATNR? The attribute OBJEK delivers an long number but this is not the real material number of the objekt.

Regards,
Marco
Original Message:
Sent: 01-04-2021 13:41
From: sigrid kok
Subject: Read and Maintain Material Master Record Classification

Hi Marco,

There is a template to update class characteristics on the community site here:  https://community.winshuttle.com/sap-module-templates/viewdocument/change-material-class-001-charact?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

You can either use a Transaction script, BAPI or Query to extract them.  It depends on whether all materials will have the same one(s) or not.  If not, then a Query is best.  Note that SAP stores character, numeric and currency in separate fields.    Attaching an example Query for material characteristics based on one class, in case that gets you started.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 01-04-2021 12:18
From: Marco
Subject: Read and Maintain Material Master Record Classification

Hello,

I need support in following cases:
- Read classification information from material master record via bulk, for many material numbers, by query or skript with  Winshuttle
- Maintain classification via bulk with a skript, e.g. MM02

You have some best practice ideas?
I am using Winshuttle Studio 12.1.1

Regards,
Marco

Marco,

I have had need to interrogate the classification information for the material master and found that using a script similar to the mm02 script example from WS to be helpful.  In the case of the script they provide, if you change the mapping direction on line 37 (expert view) from "upload to SAP" to "download from SAP", the script will return the existing values for the material and characteristics in the 001 class.

If you need to look at another class, then you can change the program.  If you are looking at the same characteristic(s) for a large number of materials, you can also "hard code" the characteristics into the program and not use a loop but just repeat the call for the characteristic with each characteristic and return the characteristic value in a different column.  If you need additional information, let me know and I'll see what I can show you (sometimes it can be a little tricky).


------------------------------
Gail Ball | Engineering Data Management|
Rockwell Automation | [City] |

Original Message:
Sent: 01-04-2021 12:18
From: Marco
Subject: Read and Maintain Material Master Record Classification

Hello,

I need support in following cases:
- Read classification information from material master record via bulk, for many material numbers, by query or skript with  Winshuttle
- Maintain classification via bulk with a skript, e.g. MM02

You have some best practice ideas?
I am using Winshuttle Studio 12.1.1

Regards,
Marco