SAP Table LFBW
Vendor master record (withholding tax types) X
LFBW (Vendor 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 LFBW to other SAP tables.
LFBW table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||
|
WITHT
Indicator for withholding tax type
|
WITHT | T059P |
CHAR
|
2 | 0 | |||||||
|
WT_SUBJCT
Indicator: Subject to withholding tax?
|
WT_SUBJCT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
QSREC
Type of recipient
|
WT_QSREC | T059C |
CHAR
|
2 | 0 | |||||||
|
WT_WTSTCD
Withholding tax identification number
|
WT_WTSTCD |
CHAR
|
16 | 0 | ||||||||
|
WT_WITHCD
Withholding tax code
|
WT_WITHCD | T059Z |
CHAR
|
2 | 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 | T059V |
CHAR
|
2 | 0 | |||||||
LFBW foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| LFBW | BUKRS | LFBW | MANDT |
T001
Company Codes
|
MANDT |
| LFBW | BUKRS | LFBW | BUKRS |
T001
Company Codes
|
BUKRS |
| LFBW | LIFNR | LFBW | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| LFBW | LIFNR | LFBW | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| LFBW | MANDT | LFBW | MANDT |
T000
Clients
|
MANDT |
| LFBW | QSREC | T001 | LAND1 |
T059C
Types of Recipient: Vendors per Withholding Tax Type
|
LAND1 |
| LFBW | QSREC | LFBW | WITHT |
T059C
Types of Recipient: Vendors per Withholding Tax Type
|
WITHT |
| LFBW | QSREC | LFBW | QSREC |
T059C
Types of Recipient: Vendors per Withholding Tax Type
|
QSREC |
| LFBW | QSREC | LFBW | MANDT |
T059C
Types of Recipient: Vendors per Withholding Tax Type
|
MANDT |
| LFBW | WITHT | LFBW | WITHT |
T059P
Withholding tax types
|
WITHT |
| LFBW | WITHT | LFBW | MANDT |
T059P
Withholding tax types
|
MANDT |
| LFBW | WITHT | T001 | LAND1 |
T059P
Withholding tax types
|
LAND1 |
| LFBW | WT_WITHCD | T001 | LAND1 |
T059Z
Withholding tax code (enhanced functions)
|
LAND1 |
| LFBW | WT_WITHCD | LFBW | WITHT |
T059Z
Withholding tax code (enhanced functions)
|
WITHT |
| LFBW | WT_WITHCD | LFBW | WT_WITHCD |
T059Z
Withholding tax code (enhanced functions)
|
WT_WITHCD |
| LFBW | WT_WITHCD | LFBW | MANDT |
T059Z
Withholding tax code (enhanced functions)
|
MANDT |
| LFBW | WT_WTEXRS | LFBW | MANDT |
T059V
Reasons for exemption per withholding tax type
|
MANDT |
| LFBW | WT_WTEXRS | T001 | LAND1 |
T059V
Reasons for exemption per withholding tax type
|
LAND1 |
| LFBW | WT_WTEXRS | LFBW | WT_WTEXRS |
T059V
Reasons for exemption per withholding tax type
|
WT_WTEXRS |