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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| 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 | 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 | QSREC | T001 | LAND1 | T059C | Types of Recipient: Vendors per Withholding Tax Type | LAND1 |
| LFBW | WITHT | LFBW | MANDT | T059P | Withholding tax types | MANDT |
| LFBW | WITHT | T001 | LAND1 | T059P | Withholding tax types | LAND1 |
| LFBW | WITHT | LFBW | WITHT | T059P | Withholding tax types | 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_WITHCD | T001 | LAND1 | T059Z | Withholding tax code (enhanced functions) | LAND1 |
| LFBW | WT_WITHCD | LFBW | WITHT | T059Z | Withholding tax code (enhanced functions) | WITHT |
| 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 |
