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 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.
- KUNNR, customer number (key).
- NAME1, name; ORT01, city; LAND1, country.
- KNVV, customer sales data.
- Watch out: Reading tables directly instead of using CDS/reports where appropriate.
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.