SAP table LFBW (Vendor master record (withholding tax types) X)
SAP table LFBW has 4 primary key fields being MANDT,LIFNR,BUKRS,WITHT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| WITHT | Indicator for Withholding Tax Type | CHAR | 2 | 0 | T059P | WITHT | |
| WT_SUBJCT | Indicator: Subject to Withholding Tax? | CHAR | 1 | 0 | WT_SUBJCT | ||
| QSREC | Type of Recipient | CHAR | 2 | 0 | T059C | WT_QSREC | |
| WT_WTSTCD | Withholding tax identification number | CHAR | 16 | 0 | WT_WTSTCD | ||
| WT_WITHCD | Withholding Tax Code | CHAR | 2 | 0 | T059Z | WT_WITHCD | |
| WT_EXNR | Exemption Certificate Number | CHAR | 25 | 0 | WT_EXNR | ||
| WT_EXRT | Exemption Rate | DEC | 5 | 2 | WT_EXRT | ||
| WT_EXDF | Date on Which Exemption Begins | DATS | 8 | 0 | WT_EXDF | ||
| WT_EXDT | Date on Which Exemption Ends | DATS | 8 | 0 | WT_EXDT | ||
| WT_WTEXRS | Reason for Exemption | CHAR | 2 | 0 | T059V | WT_WTEXRS |
LFBW foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 LFBW | BUKRS | T001 | Company Codes | BUKRS |
| 1 LFBW | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 1 LFBW | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 LFBW | MANDT | T000 | Clients | MANDT |
| 1 LFBW | QSREC | T059C | Types of Recipient: Vendors per Withholding Tax Type | MANDT |
| 1 LFBW | QSREC | T059C | Types of Recipient: Vendors per Withholding Tax Type | LAND1 |
| 1 LFBW | QSREC | T059C | Types of Recipient: Vendors per Withholding Tax Type | WITHT |
| 0 LFBW | WITHT | T059P | Withholding tax types | MANDT |
| 0 LFBW | WITHT | T059P | Withholding tax types | LAND1 |
| 0 LFBW | WITHT | T059P | Withholding tax types | WITHT |
| 1 LFBW | WT_WITHCD | T059Z | Withholding tax code (enhanced functions) | MANDT |
| 1 LFBW | WT_WITHCD | T059Z | Withholding tax code (enhanced functions) | LAND1 |
| 1 LFBW | WT_WITHCD | T059Z | Withholding tax code (enhanced functions) | WITHT |
| 0 LFBW | WT_WTEXRS | T059V | Reasons for exemption per withholding tax type | MANDT |
| 0 LFBW | WT_WTEXRS | T059V | Reasons for exemption per withholding tax type | LAND1 |