# SAP Variant Table Maintenance Worksheet > Source: https://netray.co/tools/sap-variant-table-maintenance-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Lay out valid characteristic combinations for a variant table, with lead time and price class per row, before you maintain the table in SAP. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP VC consultant - Product data steward - Configuration engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Row **Key:** row_id **Type:** text #### MOTOR_TYPE **Key:** motor **Type:** select **Options:** - AC - DC - Servo #### VOLTAGE **Key:** voltage **Type:** select **Options:** - 24V - 230V - 400V #### ENCLOSURE **Key:** enclosure **Type:** select **Options:** - IP54 - IP65 - IP67 #### Valid combination **Key:** valid **Type:** select **Options:** - Yes - No - Review #### Price class **Key:** price_class **Type:** number #### Lead time **Key:** lead **Type:** number **Unit:** days #### Lead time (weeks) **Key:** lead_wk **Type:** number **Expr:** ceil(lead / 7) **Format:** integer **Rows:** **Row id:** 1 **Motor:** AC **Voltage:** 400V **Enclosure:** IP54 **Valid:** Yes **Price class:** 1 **Lead:** 14 **Row id:** 2 **Motor:** AC **Voltage:** 400V **Enclosure:** IP65 **Valid:** Yes **Price class:** 2 **Lead:** 21 **Row id:** 3 **Motor:** DC **Voltage:** 24V **Enclosure:** IP67 **Valid:** Yes **Price class:** 3 **Lead:** 28 **Row id:** 4 **Motor:** DC **Voltage:** 400V **Enclosure:** IP54 **Valid:** No **Price class:** 0 **Lead:** 0 **Row id:** 5 **Motor:** Servo **Voltage:** 230V **Enclosure:** IP65 **Valid:** Review **Price class:** 4 **Lead:** 35 **Totals:** #### Longest lead time **Key:** lead **Agg:** max #### Rows **Key:** row_id **Agg:** count **Notes:** Column headers use the characteristic names you plan to put in the variant table structure (a DDIC structure, maintained with the variant table tools). Rows marked No are documented for the design record and are not loaded. ## Content **Intro:** A variant table in SAP stores the allowed combinations of characteristic values and is read by dependencies such as constraints and procedures. Designing it in a spreadsheet first saves rework, because every row is a business decision about what you can build and ship. This worksheet keeps that decision visible. **Sections:** #### How to use it **Body:** Rename the characteristic columns to match your variant table structure, then add one row per combination you have discussed. Mark each row Yes, No or Review. Use the price class and lead time columns for attributes you plan to return from the table to the configuration (for example through a procedure that reads the table). Export to Excel and use it as the source for the upload file or for manual entry. **Bullets:** - Start with the full cross product, then remove invalid rows - Keep No rows in the sheet as a record of the decision - Never leave Review rows when you freeze the design - Check each characteristic value exists in the class before loading #### How variant tables are used **Body:** A variant table is defined as a table structure whose fields reference characteristics, and its content is maintained by table. A constraint can restrict selection to rows in the table, so the user can only pick combinations that exist. A procedure or function can look up values from the table, such as a price class. Rows that are not in the table are simply not selectable, so a missing row is a build limitation, not a data error. #### Reading and validating the result **Body:** The count and maximum lead time give a quick sense of the table size and the worst case delivery promise. Compare the valid row count to the cross product of the value counts. If the table holds only a small fraction, consider whether a constraint on separate characteristics would be easier to maintain than a large table. #### Common mistakes **Body:** Teams often change a characteristic value text but leave the old value in the table, which breaks the match. Others load a table with values that are not allowed in the class, or maintain the table in a development client and forget to transport its content, since table content is data and travels separately from the structure. **Cta:** If your variant tables are large and drift from the engineering rules, we can help build a read-only check of table content against classes. **Faq:** #### What is a variant table in SAP? **Answer:** A variant table holds valid combinations of characteristic values in a table whose columns are linked to characteristics. Dependencies can restrict selections to those rows or look up values from them. #### Which transaction maintains variant table content? **Answer:** Variant tables are created with CU60 and their content is maintained with CU61, with display in CU62. The structure is based on a dictionary table structure that you define first. #### How do I load many rows at once? **Answer:** Prepare the rows in Excel with the exact column order of the structure, then use the standard upload from the table maintenance or an import program. Always test in a quality client first. #### Should I use a variant table or a constraint? **Answer:** Use a table when combinations are arbitrary business decisions. Use a constraint or precondition when the rule can be expressed as logic. Tables are easier to read, logic is easier to maintain at large scale. ## Search terms SAP variant table, SAP CU60 variant table, SAP variant table excel, SAP variant table template, SAP VC valid combinations, SAP variant table upload, SAP CU61 maintain table, SAP variant configuration table design --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json