SAP Table KNAT
Customer Master Record (Tax Groupings)
KNAT (Customer Master Record (Tax Groupings)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNAT to other SAP tables.
KNAT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||
| TAXGR | Category indicator for tax codes | TAXGR | T007C | CHAR | 3 | 0 | ||
| SBJDF | Subjected from | J_1ASBJDF | DATS | 8 | 0 | |||
| SBJDT | Subjected until | J_1ASBJDT | DATS | 8 | 0 | |||
| EXNR | Number of exemption certificate | J_1AEXNR | CHAR | 15 | 0 | |||
| EXRT | Exemption rate | J_1AEXRT | DEC | 5 | 2 | |||
| EXDF | Start date of exemption | J_1AEXDF | DATS | 8 | 0 | |||
| EXDT | End date of exemption | J_1AEXDT | DATS | 8 | 0 | |||
KNAT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| KNAT | KUNNR | KNAT | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNAT | KUNNR | KNAT | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNAT | MANDT | KNAT | MANDT | T000 | Clients | MANDT |
| KNAT | TAXGR | 'D' | T007C | Groupings for tax codes | KOART | |
| KNAT | TAXGR | KNAT | TAXGR | T007C | Groupings for tax codes | TAXGR |
| KNAT | TAXGR | KNAT | MANDT | T007C | Groupings for tax codes | MANDT |
