TSPA table — TSPA Division Master Table
TSPA is the SAP customizing table that stores the valid divisions (Sparte) defined in the system. One row equals one division code. It has no description field of its own; the description sits in a companion text table. TSPA is checked whenever a division code is entered on a sales document, customer sales area, or pricing condition to confirm the code is valid.
TSPA holds the list of divisions configured in SD customizing, the basic building block used to slice a sales organization into product-line groupings such as retail, wholesale, or spare parts. This page covers what the table actually contains, how it is joined against transactional and master data, and the recurring mistake of treating it as a source of business meaning rather than a validity check.
Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 871 words
What it stores
Each row in TSPA represents one division code that has been defined as valid in the client. Division (Sparte) is one of the three legs of the SD sales area, alongside sales organization and distribution channel. The table itself is deliberately thin: it exists to answer the question 'is this division code a real, configured value' rather than to describe what the division means commercially. Divisions get assigned to sales organizations elsewhere, and the human-readable description lives in a separate text table keyed by language. Consultants encounter TSPA almost exclusively during customizing checks, authorization design, or when tracing why a sales area combination is rejected as invalid on a customer or sales document.
Key fields
- MANDT - client, standard first key field on every customizing table in this area
- SPART - division code, the sole business key of the table
How it joins the data model
- VBAK-SPART = TSPA-SPART: validates the division stamped on a sales document header
- KNVV-SPART = TSPA-SPART: validates the division component of a customer's sales area extension
- KONA-SPART = TSPA-SPART: validates the division restriction on a rebate or condition agreement, where the field is used
How to read it safely
TSPA is client-dependent and tiny, typically a handful to a few dozen rows per client, so selectivity is not a concern. There is nothing to restrict on beyond the client itself. The table answers a yes-or-no question about a code's existence; it is not a lookup for meaning. If a description is needed, the join has to go to the language-dependent text table, filtered on the logon language, not to TSPA itself. Do not attempt to infer business rules, sales org assignments, or authorization scope from TSPA alone.
How to prove it in the data
Symptom: a sales order cannot be saved because the sales area sales-org/distribution-channel/division is rejected as not maintained. Select TSPA for the client and the division code entered on the order. If the row is missing, the division itself was never created in customizing, which is a configuration gap, not a master data gap. If the row exists, the actual problem is almost always the sales-area combination in the sales organization structure or the customer's extension to that sales area, not TSPA.
ECC vs S/4HANA
TSPA carried forward into S/4HANA without a change in shape or purpose. Division as a concept is unchanged in S/4HANA's sales area model, and the table continues to be maintained through the same customizing activities as in ECC. No compatibility view replacement is required for this table because it is pure configuration content rather than transactional data subject to the S/4HANA data model simplifications.
Common pitfalls
- Treating a missing division on a sales order as a TSPA problem: TSPA existing does not mean the division is valid for the specific sales organization and distribution channel combination in use; that combination is governed by separate assignment tables, not by TSPA.
- Expecting a description field on TSPA itself: the text lives in a separate language-dependent table, and code that reads TSPA directly for a description will simply come back blank.
- Assuming a division deleted from TSPA cascades into historical documents: existing sales orders, deliveries and billing documents already carry the division as a stored value on their own tables and remain unaffected; only new document creation is blocked.
- Confusing division-level restrictions with distribution-channel or sales-org restrictions when troubleshooting a blocked customer or material: the three legs of the sales area are configured and authorized independently, and TSPA only ever speaks to the division leg.
- Modifying TSPA directly in a productive client to 'fix' an order that will not save: this is customizing content transported through the normal change process, not a data fix, and direct edits in production bypass that process and desynchronize the landscape.
Whose problem this is
Division setup is an SD functional configuration decision, owned by the SD or O2C process consultant during org structure design, usually agreed jointly with FI and controlling since division often maps onto reporting segments. Once live, adding or changing a division is a change request through the normal transport process, not an ad hoc fix applied by a support consultant reacting to a single stuck order.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/tspaERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.