SAP Table KNBW
Customer master record (withholding tax types) X
KNBW (Customer master record (withholding tax types) X) 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 KNBW to other SAP tables.
KNBW table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||
|
WITHT
Indicator for withholding tax type
|
WITHT | T059P |
CHAR
|
2 | 0 | |||||||
|
WT_WITHCD
Withholding tax code
|
WT_WITHCD | T059Z |
CHAR
|
2 | 0 | |||||||
|
WT_AGENT
Indicator: Withholding tax agent?
|
WT_WTAGT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WT_AGTDF
Obligated to withhold tax from
|
WT_AGTDF |
DATS
|
8 | 0 | ||||||||
|
WT_AGTDT
Obligated to withhold tax until
|
WT_AGTDT |
DATS
|
8 | 0 | ||||||||
|
WT_WTSTCD
Withholding tax identification number
|
WT_WTSTCD |
CHAR
|
16 | 0 | ||||||||
|
WT_EXNR
Exemption certificate number
|
WT_EXNR |
CHAR
|
15 | 0 | ||||||||
|
WT_EXRT
Exemption rate
|
WT_EXRT |
DEC
|
5 | 2 | ||||||||
|
WT_EXDF
Date on which exemption begins
|
WT_EXDF |
DATS
|
8 | 0 | ||||||||
|
WT_EXDT
Date on which exemption ends
|
WT_EXDT |
DATS
|
8 | 0 | ||||||||
|
WT_WTEXRS
Reason for exemption
|
WT_WTEXRS |
CHAR
|
2 | 0 | ||||||||
KNBW foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNBW | BUKRS | KNBW | MANDT |
T001
Company Codes
|
MANDT |
| KNBW | BUKRS | KNBW | BUKRS |
T001
Company Codes
|
BUKRS |
| KNBW | KUNNR | KNBW | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNBW | KUNNR | KNBW | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNBW | MANDT | KNBW | MANDT |
T000
Clients
|
MANDT |
| KNBW | WITHT | T001 | LAND1 |
T059P
Withholding tax types
|
LAND1 |
| KNBW | WITHT | KNBW | WITHT |
T059P
Withholding tax types
|
WITHT |
| KNBW | WITHT | KNBW | MANDT |
T059P
Withholding tax types
|
MANDT |
| KNBW | WT_WITHCD | KNBW | WT_WITHCD |
T059Z
Withholding tax code (enhanced functions)
|
WT_WITHCD |
| KNBW | WT_WITHCD | KNBW | MANDT |
T059Z
Withholding tax code (enhanced functions)
|
MANDT |
| KNBW | WT_WITHCD | T001 | LAND1 |
T059Z
Withholding tax code (enhanced functions)
|
LAND1 |
| KNBW | WT_WITHCD | KNBW | WITHT |
T059Z
Withholding tax code (enhanced functions)
|
WITHT |