# SAP Routing Upload Worksheet (Excel)

> Source: https://netray.co/tools/sap-routing-upload-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable worksheet to stage routing operations before upload, with computed lot time per operation and an export to Excel or CSV.

## Category

sap

## Erp

SAP S/4HANA

## Industry

Discrete Manufacturing

## Audience

- SAP PP consultant
- Process engineer
- Data migration lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Material

**Key:** material

**Type:** text

#### Plant

**Key:** plant

**Type:** text

#### Operation

**Key:** op

**Type:** text

#### Work center

**Key:** work_center

**Type:** text

#### Control key

**Key:** ctrl_key

**Type:** select

**Options:**

- PP01
- PP02
- PP03
- PP98
- PP99

#### Operation text

**Key:** desc

**Type:** text

#### Base qty

**Key:** base_qty

**Type:** number

#### Setup (min)

**Key:** setup_min

**Type:** number

#### Machine (min per base qty)

**Key:** run_min

**Type:** number

#### Typical lot

**Key:** lot_size

**Type:** number

#### Lot time (min)

**Key:** lot_min

**Type:** number

**Expr:** setup_min + run_min * lot_size / base_qty

**Format:** number

**Rows:**

**Material:** FG-100245

**Plant:** 1010

**Op:** 0010

**Work center:** SAW01

**Ctrl key:** PP01

**Desc:** Cut bar stock

**Base qty:** 1

**Setup min:** 20

**Run min:** 1.5

**Lot size:** 100

**Material:** FG-100245

**Plant:** 1010

**Op:** 0020

**Work center:** CNC12

**Ctrl key:** PP01

**Desc:** Turn and drill

**Base qty:** 1

**Setup min:** 45

**Run min:** 4.2

**Lot size:** 100

**Material:** FG-100245

**Plant:** 1010

**Op:** 0030

**Work center:** DEBUR1

**Ctrl key:** PP01

**Desc:** Deburr

**Base qty:** 1

**Setup min:** 5

**Run min:** 0.8

**Lot size:** 100

**Material:** FG-100245

**Plant:** 1010

**Op:** 0040

**Work center:** INSP01

**Ctrl key:** PP01

**Desc:** Final inspection

**Base qty:** 10

**Setup min:** 10

**Run min:** 6

**Lot size:** 100

**Material:** FG-100310

**Plant:** 1010

**Op:** 0010

**Work center:** CNC12

**Ctrl key:** PP01

**Desc:** Mill housing

**Base qty:** 1

**Setup min:** 60

**Run min:** 6.5

**Lot size:** 50

**Material:** FG-100310

**Plant:** 1010

**Op:** 0020

**Work center:** ANOD

**Ctrl key:** PP99

**Desc:** Anodize (external)

**Base qty:** 1

**Setup min:** 0

**Run min:** 0

**Lot size:** 50

**Totals:**

#### Total lot time (min)

**Key:** lot_min

**Agg:** sum

**Format:** number

**Summary:**

#### Total lot time (hours)

**Key:** lot_hours

**Expr:** sum_lot_min / 60

**Format:** decimal

#### Operations staged

**Key:** ops

**Expr:** count

**Format:** integer

**Notes:** Staging layout only. Map columns to your upload method (LSMW, migration cockpit or BAPI_ROUTING_CREATE) and confirm the field names and control keys in your system. Mark external operations with your external processing control key.

## Content

**Intro:** Routing data is one of the most error prone parts of an SAP implementation or migration. This worksheet helps you stage operations in Excel format before you load them, with a computed lot time so engineers can sanity check each line.

**Sections:**

#### How to use the worksheet

**Body:** Enter one row per operation, grouped by material, with plant, operation number, work center, control key, base quantity and standard values. The Lot time column calculates setup plus machine time for a typical lot. Review the totals with process engineering, then export to Excel or CSV and map columns to your load tool. Use it to find missing work centers, zero run times and wrong base quantities before they reach SAP.

**Bullets:**

- Keep operation numbers in steps of 10
- Use base quantity 1 unless the time is per batch
- Check external operations have no internal times

#### Standard values and the lot time formula

**Body:** In SAP, operation time is the standard value multiplied by the order quantity divided by the base quantity. Setup is charged once per lot, while machine and labor time scale with quantity. The worksheet uses setup plus run time times lot size divided by base quantity. Compare the result to what the shop floor reports. Large differences usually mean the unit of measure or base quantity is wrong.

#### Fields you must get right

**Body:** Each operation needs a valid work center in the plant and a control key that matches how you schedule, cost and confirm it. Routing usage and status are set on the header, with production usage and a released status needed for orders to pick up the routing. Group counters distinguish alternative sequences. Missing a control key or work center is a common reason for failed uploads.

#### Common mistakes

**Body:** Times entered in the wrong unit, for example hours when the work center expects minutes, inflate capacity load by a factor of 60. Using per piece times with a base quantity of 100 doubles or halves loads. Skipping a status release means order creation finds no usable routing.

**Bullets:**

- Confirm the unit of the work center formula
- Validate a sample of 20 routings against shop reality
- Load in a test client first

**Cta:** If you are migrating thousands of routings, we can build checks that compare your staged data to legacy ERP data and flag outliers before the load, with human review.

**Faq:**

#### Can I upload this file directly into SAP?

**Answer:** Not as is. It is a staging layout. You map the columns to your chosen method, such as LSMW, the S/4HANA migration cockpit or a BAPI based program, and match the exact field names and formats your system expects.

#### What control key should I use?

**Answer:** Control keys are configured per system. PP01 is commonly delivered as a standard routing control key for internal operations, while an external processing key is used for subcontracting. Confirm the keys in your own configuration.

#### How are standard values scaled in SAP?

**Answer:** SAP multiplies the standard value by the order quantity and divides by the base quantity. Setup is typically a fixed value per lot while machine and labor values scale with quantity. Formulas on the work center can modify this.

#### Why does the lot time look wrong?

**Answer:** Check base quantity and units first. A base quantity of 100 with a per piece time overstates the load a hundred fold. Also check that setup is not entered per piece.

## Search terms

sap routing upload excel, sap routing lsmw template, sap ca01 routing data template, sap routing data migration worksheet, sap routing operations excel format, sap work center control key pp01, sap routing setup time run time upload

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json