Hi Carmen
I had to dust off some queries I had. Attached is an example of just pulling material with characteristic name (not description) and the value.
A couple of things:
(1) It just uses KSSK, KLAH, CABN, CABNT and AUSP - the criteria include a range of material numbers of LIKE, plus the Class Name, and you can even go down to the characteristic field name (not description) and value (not description) - field name and value are not language specific, so it might be "SK-Color" or description "Color" is set to "BL" - not the description which may be "Blue" - you'd have to do more work for that
(2) SAP stores data in different fields depending on the type, so I use a formula to pull them into one column - see highlighted column is filled in depending on whether the TEXT or NUMERIC value to the right are filled in and collects them in one column - again highlighted
(3) I wanted to use this output to "flatten" out the results, i.e. one row for a product and then columns for values, so I created a "key" in column A using formulas - see above - SK-2000-Grade will for Material SK-2000 have a Grade of "High"
(4) Once I run the query - I go to the Excel Data tab and click refresh all
above is "flattened version. It has vlookups based on the material # and characteristic field name (not description) - which is the column name - for each column - example
So Material SK-2000 concatenated with Grade will lookup the value and put it into the C column on that row
another example for Color
Table2 is the query output, which is in an Excel table.
I have the formulas repeating for a certain number of rows - but you could expand it so that if the material number is filled in, the formulas will pull in the value into the row.
You may not want to flatten out the results, but I find many people like to see it this way.
FWIW,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------
Original Message:
Sent: 08-14-2024 16:58
From: Carmen Hernandez
Subject: Querying Material - Classification
I knew this one was gonna be hard! I will take a look at this information and let you know if I need any additional assistance.
Thank you!
------------------------------
Carmen Hernandez
Conagra Brands, Inc.
Chicago IL
Original Message:
Sent: 08-14-2024 16:26
From: Sigrid Kok
Subject: Querying Material - Classification
Hi Carmen
That query is a beast, as the keys to join the tables aren't what you think they are.
I did an educational webinar on class characteristics a while back, which is in on the Precisely University here: Educational webinar on class characteristics You can sign up and take a look, if you like.
BTW the custom BAPI we created may be an option for you. It has been updated since the webinar to include retrieving characteristics, even if they have no values.
Here's a slide I showed in that webinar showing the joins:
If you share your Query, I can take a look.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
Original Message:
Sent: 08-14-2024 11:52
From: Carmen Hernandez
Subject: Querying Material - Classification
Hi all,
New to Evolve here, I am trying to create a query to pull the classification and characteristic value of a material but having some trouble getting it to return any records. I did some research and found some good articles but still just stuck on where to go from here. Any suggestions? Any small suggestion will help! Trying to learn as I go.
I have MARA, AUSP, CAWN, CAWNT. However, I read some other articles to add KSSK, KLAH, CABN, CABNT
------------------------------
Carmen Hernandez
Conagra Brands, Inc.
Chicago IL
------------------------------