SAP table J_1BTREG_CITY (Tax Jurisdiction Codes by Range of Postal Codes)
SAP table J_1BTREG_CITY has 6 primary key fields being CLIENT,COUNTRY,REGION,PSTCD_FROM,PSTCD_TO,TAXJURCODE.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| COUNTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| REGION | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| PSTCD_FROM | First Postal Code of City | CHAR | 10 | 0 | J_1BPSTCDFROM | ||
| PSTCD_TO | Last Postal Code of City | CHAR | 10 | 0 | J_1BPSTCDTO | ||
| TAXJURCODE | Tax Jurisdiction Code For Brazilian Tax Calculation | CHAR | 15 | 0 | J_1BTXJUR | J_1BTXJCD |
J_1BTREG_CITY foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 J_1BTREG_CITY | CLIENT | T000 | Clients | MANDT |
| 1 J_1BTREG_CITY | COUNTRY | T005 | Countries | MANDT |
| 1 J_1BTREG_CITY | COUNTRY | T005 | Countries | LAND1 |
| 0 J_1BTREG_CITY | REGION | T005S | Taxes: Region (Province) Key | LAND1 |
| 1 J_1BTREG_CITY | TAXJURCODE | J_1BTXJUR | Tax Jurisdiction Codes For Brazilian Tax Calculation | CLIENT |
| 1 J_1BTREG_CITY | TAXJURCODE | J_1BTXJUR | Tax Jurisdiction Codes For Brazilian Tax Calculation | COUNTRY |
| 1 J_1BTREG_CITY | TAXJURCODE | J_1BTXJUR | Tax Jurisdiction Codes For Brazilian Tax Calculation | TAXJURCODE |