SAP Table J_1BTXWITH
Withholding Tax Calculation: Rates and Collection Codes
J_1BTXWITH (Withholding Tax Calculation: Rates and Collection Codes) 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 J_1BTXWITH to other SAP tables.
J_1BTXWITH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | 0 | |||||||
| GRUOP | Tax Group for Dynamic Tax Exceptions | J_1BTXGRP | J_1BTXGRUOP | NUMC | 2 | 0 | ||||||
| VALUE | Dynamic Key Field | J_1BVALUE | CHAR | 20 | 0 | |||||||
| VALUE2 | Dynamic Key Field | J_1BVALUE2 | CHAR | 20 | 0 | |||||||
| VALUE3 | Dynamic Key Field | J_1BVALUE3 | CHAR | 20 | 0 | |||||||
| VALIDFROM | Date from which the tax rule is valid | J_1BTXDATF | CHAR | 8 | 0 | |||||||
| VALIDTO | Date to which the tax rule is valid | J_1BTXDATT | CHAR | 8 | 0 | |||||||
| COLL_GEN | Official Withholding Tax Collection Code - General | J_1BWHTCOLL_GEN | T059Z_WITHCD2 | CHAR | 16 | 0 | ||||||
| RATE_GEN | General Withholding Tax Rate (PIS+COFINS+CSLL+IR) | J_1BWHTRATE_GEN | DEC | 6 | 2 | |||||||
| COLL_PIS | Official Withholding Tax Collection Code - PIS | J_1BWHTCOLL_PIS | T059Z_WITHCD2 | CHAR | 16 | 0 | ||||||
| RATE_PIS | PIS Withholding Tax Rate | J_1BWHTRATE_PIS | DEC | 6 | 2 | |||||||
| COLL_COFINS | Official Withholding Tax Collection Code - COFINS | J_1BWHTCOLL_COFINS | T059Z_WITHCD2 | CHAR | 16 | 0 | ||||||
| RATE_COFINS | COFINS Withholding Tax Rate | J_1BWHTRATE_COFINS | DEC | 6 | 2 | |||||||
| COLL_CSLL | Official Withholding Tax Collection Code - CSLL | J_1BWHTCOLL_CSLL | T059Z_WITHCD2 | CHAR | 16 | 0 | ||||||
| RATE_CSLL | CSLL Withholding Tax Rate | J_1BWHTRATE_CSLL | DEC | 6 | 2 | |||||||
| COLL_IR | Official Withholding Tax Collection Code - IR | J_1BWHTCOLL_IR | T059Z_WITHCD2 | CHAR | 16 | 0 | ||||||
| RATE_IR | IR Withholding Tax Rate | J_1BWHTRATE_IR | DEC | 6 | 2 | |||||||
| J_1BWHTACC_RB | Origin of Real Withholding Tax Calculation Base | J_1BWHTBASE_NF | CHAR | 1 | 0 |
Possible values
|
||||||
J_1BTXWITH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| J_1BTXWITH | COLL_COFINS | J_1BTXWITH | CLIENT | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | MANDT |
| J_1BTXWITH | COLL_COFINS | J_1BTXWITH | COUNTRY | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | LAND1 |
| J_1BTXWITH | COLL_COFINS | J_1BTXWITH | COLL_COFINS | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | WITHCD2 |
| J_1BTXWITH | COLL_CSLL | J_1BTXWITH | COUNTRY | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | LAND1 |
| J_1BTXWITH | COLL_CSLL | J_1BTXWITH | COLL_CSLL | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | WITHCD2 |
| J_1BTXWITH | COLL_CSLL | J_1BTXWITH | CLIENT | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | MANDT |
| J_1BTXWITH | COLL_GEN | J_1BTXWITH | CLIENT | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | MANDT |
| J_1BTXWITH | COLL_GEN | J_1BTXWITH | COUNTRY | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | LAND1 |
| J_1BTXWITH | COLL_GEN | J_1BTXWITH | COLL_GEN | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | WITHCD2 |
| J_1BTXWITH | COLL_IR | J_1BTXWITH | CLIENT | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | MANDT |
| J_1BTXWITH | COLL_IR | J_1BTXWITH | COUNTRY | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | LAND1 |
| J_1BTXWITH | COLL_IR | J_1BTXWITH | COLL_IR | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | WITHCD2 |
| J_1BTXWITH | COLL_PIS | J_1BTXWITH | COLL_PIS | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | WITHCD2 |
| J_1BTXWITH | COLL_PIS | J_1BTXWITH | CLIENT | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | MANDT |
| J_1BTXWITH | COLL_PIS | J_1BTXWITH | COUNTRY | T059Z_WITHCD2 | Entity Table: Additional Official Withholding Tax Code | LAND1 |
| J_1BTXWITH | GRUOP | J_1BTXWITH | CLIENT | J_1BTXGRUOP | Dynamic Determination of Tax-Related Master Data | MANDT |
| J_1BTXWITH | GRUOP | J_1BTXWITH | GRUOP | J_1BTXGRUOP | Dynamic Determination of Tax-Related Master Data | GRUOP |
