# SAP Cost Center Hierarchy Upload Worksheet (Excel Template) > Source: https://netray.co/tools/sap-cost-center-hierarchy-upload-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Lay out cost centers and their parent groups in one sheet, check lengths, and export the file for your upload tool. ## Category sap ## Erp SAP ECC and S/4HANA ## Audience - SAP FICO consultant - Data migration lead - Controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Parent cost center group **Key:** group **Type:** text #### Cost center **Key:** cc **Type:** text #### Name (max 20 chars) **Key:** name **Type:** text #### Description (max 40 chars) **Key:** descr **Type:** text #### Company code **Key:** ccode **Type:** text #### Profit center **Key:** pc **Type:** text #### Category **Key:** cat **Type:** select **Options:** - Production - Material - Administration - Sales - R and D - Service #### Person responsible **Key:** resp **Type:** text #### Valid from **Key:** valid **Type:** date #### Planned annual cost **Key:** plan **Type:** number **Format:** currency **Rows:** #### Machining **Group:** PLANT1000 **Cc:** 1000100 **Descr:** Machining department Plant 1000 **Ccode:** 1000 **Pc:** PC1000 **Cat:** Production **Resp:** J Rao **Valid:** 2026-01-01 **Plan:** 640000 #### Assembly **Group:** PLANT1000 **Cc:** 1000200 **Descr:** Assembly department Plant 1000 **Ccode:** 1000 **Pc:** PC1000 **Cat:** Production **Resp:** M Okafor **Valid:** 2026-01-01 **Plan:** 410000 #### Maintenance **Group:** PLANT1000 **Cc:** 1000300 **Descr:** Plant maintenance Plant 1000 **Ccode:** 1000 **Pc:** PC1000 **Cat:** Service **Resp:** S Patel **Valid:** 2026-01-01 **Plan:** 185000 #### Finance **Group:** ADMIN **Cc:** 1000900 **Descr:** Finance and controlling **Ccode:** 1000 **Pc:** PC9000 **Cat:** Administration **Resp:** L Chen **Valid:** 2026-01-01 **Plan:** 260000 #### Field sales **Group:** SALES **Cc:** 1000800 **Descr:** Field sales and service **Ccode:** 1000 **Pc:** PC8000 **Cat:** Sales **Resp:** T Brown **Valid:** 2026-01-01 **Plan:** 330000 **Totals:** #### Total planned cost **Key:** plan **Agg:** sum **Format:** currency **Summary:** #### Average planned cost per center **Key:** avg_plan **Expr:** sum_plan / count **Format:** currency **Notes:** Check your own length limits: a cost center number is up to 10 characters, name 20, description 40, and a cost center group name up to 12. Profit centers and categories must already exist. The example rows are fictional. Confirm the layout with your upload tool (LSMW, LTMC or the Fiori migration app). ## Content **Intro:** Cost center master data is easy to get wrong in a migration: a wrong parent group, a missing profit center or a name that is too long all fail at upload. This worksheet lays out the fields in one place so the controller and the data team can agree on the structure before anything is loaded. **Sections:** #### How to use the worksheet **Body:** Add one row per cost center. Fill the parent cost center group for the standard hierarchy node it belongs to, the company code, profit center, category and responsible person. The planned annual cost column helps you sense check the structure against budget. Export to Excel or CSV and map columns to your upload tool. Keep the column order stable between iterations of the migration. #### Designing the hierarchy **Body:** In SAP, cost centers are arranged in the standard hierarchy of the controlling area, maintained through cost center groups (KSH1, KSH2). Every cost center must be in exactly one node of that hierarchy. Alternative groups can be built for reporting. A practical structure uses plant or business unit at the top, department below, and individual cost centers at the leaf. Avoid putting cost centers directly under the root. #### Fields that cause the most rework **Body:** The category decides which activities and allocations are allowed. The profit center drives segment reporting and is mandatory in S/4HANA. The validity date must not be earlier than the controlling area start. Currency comes from the company code. Responsible person is free text but used for workflow and reports. Lock indicators can block postings, so leave them blank in the first load. #### Common mistakes **Body:** Loading cost centers before the groups exist, or the groups before the controlling area. Using spaces or special characters in IDs. Reusing a cost center number with different meaning in two company codes. Setting a very early valid-from date so every period before go-live shows empty data. Changing the hierarchy during cutover. **Cta:** If you are migrating or cleaning up cost center structures and want checks run automatically before upload, Netray can build a validation tool for your file. **Faq:** #### Can I upload cost centers and the hierarchy together? **Answer:** Normally cost centers are loaded first and the groups after, or both in a single migration object depending on the tool. In S/4HANA the migration cockpit has a cost center object and a separate one for the hierarchy. #### How long can a cost center ID be? **Answer:** A cost center number is up to 10 characters in the standard system. Many companies use a numeric scheme with a plant or entity prefix, but long IDs are harder to maintain in reports and cutover files. #### What does the category control? **Answer:** The cost center category groups centers by function, such as production or administration, and can restrict which activity types and allocations may be posted. It is often used as a reporting filter. #### Do I need a profit center on every cost center? **Answer:** In S/4HANA the profit center is a required assignment for sound segment reporting. In ECC it is optional unless new General Ledger is active, in which case it is needed for balance sheet by profit center. ## Search terms sap cost center upload excel, sap cost center master data template, sap cost center hierarchy upload, ksh2 cost center group, ks01 mass upload, sap cost center standard hierarchy, cost center data migration template, sap cost center load file --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json