# SAP PM Catalog and Code Group Design Worksheet > Source: https://netray.co/tools/sap-pm-catalog-code-group-design-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan code groups and codes for damage, cause, object part and activity, so failure data becomes something you can analyze. ## Category sap ## Erp SAP ECC / S/4HANA ## Industry Manufacturing ## Audience - SAP PM consultant - Reliability engineer - Maintenance planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Catalog type **Key:** cat **Type:** select **Options:** - B Object part - C Damage - 5 Cause - A Activity - 2 Task #### Applies to equipment class **Key:** class **Type:** text #### Code group **Key:** group **Type:** text #### Code **Key:** code **Type:** text #### Code text (max 40 characters) **Key:** text **Type:** text #### Expected events per year **Key:** freq **Type:** number #### Typical repair (hours) **Key:** mttr **Type:** number #### Typical cost per event **Key:** cost **Type:** number **Format:** currency #### Annual cost exposure **Key:** annual **Type:** number **Expr:** freq * cost **Format:** currency #### Annual repair hours **Key:** hours **Type:** number **Expr:** freq * mttr **Format:** hours **Rows:** **Cat:** B Object part **Class:** Pump **Group:** PUMP-PARTS **Code:** 0010 **Text:** Mechanical seal **Freq:** 0 **Mttr:** 0 **Cost:** 0 **Cat:** C Damage **Class:** Pump **Group:** PUMP-DMG **Code:** 0010 **Text:** Leakage **Freq:** 6 **Mttr:** 4 **Cost:** 450 **Cat:** C Damage **Class:** Pump **Group:** PUMP-DMG **Code:** 0020 **Text:** Vibration high **Freq:** 3 **Mttr:** 6 **Cost:** 800 **Cat:** 5 Cause **Class:** Pump **Group:** PUMP-CAUSE **Code:** 0010 **Text:** Wear, normal **Freq:** 5 **Mttr:** 0 **Cost:** 0 **Cat:** 5 Cause **Class:** Pump **Group:** PUMP-CAUSE **Code:** 0020 **Text:** Misalignment **Freq:** 2 **Mttr:** 0 **Cost:** 0 **Cat:** A Activity **Class:** Pump **Group:** PUMP-ACT **Code:** 0010 **Text:** Replace seal **Freq:** 6 **Mttr:** 4 **Cost:** 450 **Totals:** #### Total annual cost exposure **Key:** annual **Agg:** sum **Format:** currency #### Total annual repair hours **Key:** hours **Agg:** sum **Format:** hours **Notes:** Catalogs are maintained with code groups (QS41) and codes (QS51 style maintenance), then combined into catalog profiles assigned to equipment or functional location types. Keep text within the 40-character code text limit and confirm transaction names in your release. ## Content **Intro:** Failure data is only useful if the codes were well chosen before anyone started using them. This worksheet helps you draft the code groups and codes for each equipment class, with a way to see which failure modes matter most. **Sections:** #### How to use the worksheet **Body:** Work class by class, starting with the equipment that causes the most downtime. For each, define object parts (what failed), damage (how it showed up), cause (why) and activity (what was done). Give each code group a short name and each code a clear text of up to 40 characters. Add estimated events per year and a cost per event, and the sheet ranks cost exposure. That tells you which codes deserve the most careful definition. Export the list and use it as your configuration load sheet. **Bullets:** - Keep 5 to 15 codes per group, more makes operators guess - Make damage codes observable symptoms, not diagnoses - Keep cause codes distinct from damage codes #### How catalogs work in SAP PM **Body:** Catalog types in plant maintenance include object parts, damage, cause, activities and tasks. Within a type you create code groups, and within a group the codes. A catalog profile then determines which code groups are offered for a given technical object, so a pump operator sees pump codes and not conveyor codes. Codes are chosen on notifications and in order confirmations, so the same list feeds both fault reporting and the maintenance history you analyse later. #### Common mistakes **Body:** Common faults are a long, generic list shared across all equipment, an Other code that absorbs most records, and cause codes that mirror damage codes. Another is changing the codes after a year of data, which splits the history. Start with a pilot class, review the usage of each code after three months and merge or retire codes with no hits before adding the next class. **Cta:** If you already have years of free-text notifications, Netray can classify them against a draft code list on your own servers, read-only, so you can test the codes before configuring them. **Faq:** #### What catalog types exist in SAP PM? **Answer:** Standard catalog types include B for object parts, C for damage (problems), 5 for causes, A for activities and 2 for tasks. Plants can define others, so check your configuration. #### How many codes should a group have? **Answer:** Keep it short enough that a user can scan it quickly, often under 15. If a group needs more, split it by equipment class or by failure area. #### Can I change codes later? **Answer:** You can add codes at any time. Changing the meaning of an existing code corrupts history, so retire it and create a new one instead of reusing the number. #### What is a catalog profile? **Answer:** It is a configuration object that decides which code groups are offered on a notification for an object, and is assigned in the technical object or notification type settings. ## Search terms sap pm catalog codes design, sap damage cause code list, sap qs41 code group template, failure code library template, failure mode codes maintenance excel, sap pm catalog profile design, failure coding structure --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json