SAP ABAP Table J_1BTREG_CITY (Tax Jurisdiction Codes by Range of Postal Codes)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-LOC-BR (Application Component) Brazil
⤷
J1BA (Package) Localization Brazil
BBPCRM (Software Component) BBPCRM⤷
CRM-LOC-BR (Application Component) Brazil⤷
J1BA (Package) Localization Brazil
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | J_1BTREG_CITY |
Table Relationship Diagram 
|
| Short Description | Tax Jurisdiction Codes by Range of Postal Codes |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  CLIENT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | COUNTRY |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 3 | REGION |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 4 | PSTCD_FROM |
J_1BPSTCDFROM | CHAR10 | CHAR | 10 | 0 | First Postal Code of City | ||
| 5 | PSTCD_TO |
J_1BPSTCDTO | CHAR10 | CHAR | 10 | 0 | Last Postal Code of City | ||
| 6 | TAXJURCODE |
J_1BTXJCD | J_1BTXJCD | CHAR | 15 | 0 | Tax Jurisdiction Code For Brazilian Tax Calculation | J_1BTXJUR |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | J_1BTREG_CITY | CLIENT |  T000 |
MANDT |
KEY | 1 | CN |
| 2 | J_1BTREG_CITY | COUNTRY | T005 |
LAND1 |
KEY | 1 | CN |
| 3 | J_1BTREG_CITY | REGION | T005S |
BLAND |
KEY | 1 | CN |
| 4 | J_1BTREG_CITY | TAXJURCODE | J_1BTXJUR |
TAXJURCODE |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 600 |
