SAP ADRSTRPCD Street (section)/postal code: Assignment Table
Overview
ADRSTRPCD is a standard SAP S/4HANA table that stores Street (section)/postal code: Assignment data. There are total 14 fields in the ADRSTRPCD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADRSTRPCD belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Regional Structure (SZRS).
In addition, following links provide an overview of foreign key relationships, if any, that link ADRSTRPCD to other SAP tables and standard CDS views available based on ADRSTRPCD table in S/4HANA 2020.
Techincal Settings of ADRSTRPCD
Below are technical details of the table ADRSTRPCD
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of ADRSTRPCD Fields
The following table gives you an overview of the fields available in ADRSTRPCD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| COUNTRY | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| STRT_CODE | Street Number for City/Street File | STRT_CODE | ADRSTREET | CHAR | 12 |
| HOUSENUM_H | House number - upper limit of an interval | HOUSENUM_H | NUMC | 10 | |
| HSN_SUPP_H | House number supplement - upper limit of an interval | HSN_SUPP_H | CHAR | 4 | |
| HOUSENUM_L | Haouse number - lower limit of an interval | HOUSENUM_L | NUMC | 10 | |
| HSN_SUPP_L | House number supplement - lower limit of an interval | HSN_SUPP_L | CHAR | 4 | |
| HSN_IND | House number ID (even/odd/all) | HSN_IND | NUMC | 1 | |
| POST_CODE | Postal Code | POST_CODE | ADRPSTCODE | CHAR | 10 |
| POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | |
| CITYP_CODE | District code for city and street file | CITYP_CODE | * | CHAR | 8 |
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADRSTRPCD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADRSTRPCD | CLIENT | 1: CN | T000 |
| ADRSTRPCD | COUNTRY | 1: CN | T005 |
| ADRSTRPCD | POST_CODE | C: CN | ADRPSTCODE |
| ADRSTRPCD | REGIOGROUP | 1: CN | ADRREGGRP |
| ADRSTRPCD | STRT_CODE | 1: CN | ADRSTREET |