SAP KNA1
KNA1 is a key SAP table in SD/FI. It stores general customer master data, the client-level attributes of a customer common across sales areas and company codes. (In S/4HANA, customers are Business Partners, with KNA1 updated via CVI.)
KNA1 is the SAP customer master table at the general, client-level layer, keyed by customer number KUNNR, with name, city, country, account group and VAT number. Sales-area data sits in KNVV and company-code data in KNB1. In S/4HANA you maintain the customer as a Business Partner in BUT000, and Customer-Vendor Integration keeps KNA1 in step.
- KUNNR, customer number (key).
- NAME1, name; ORT01, city; LAND1, country.
- KNVV, customer sales data.
- Watch out: KNA1 is general data, so a customer can exist here and still not be orderable in a sales area.
What it stores
It stores general customer master data, the client-level attributes of a customer common across sales areas and company codes. (In S/4HANA, customers are Business Partners, with KNA1 updated via CVI.)
Key fields
- KUNNR, customer number (key).
- NAME1, name; ORT01, city; LAND1, country.
- KTOKD, account group.
- STCEG, VAT registration number.
Keys and relationships
KUNNR is the key. KNA1 holds general data; sales-area data is in KNVV, and company-code (accounting) data in KNB1. In S/4HANA these are maintained via the Business Partner and kept in sync by Customer-Vendor Integration.
Working with it
KNA1 remains the general customer table, but in S/4HANA you maintain customers as Business Partners (BUT000 and related), which update KNA1/KNVV/KNB1 behind the scenes. View its structure in SE11 and its data (with authorization) in SE16N.
Common pitfalls
- Reading tables directly instead of using CDS/reports where appropriate.
- Ignoring header/item relationships.
- Performance: querying large tables without indexed selection.