SAP ADRDIF_ST Street Difference Table for Quarterly Adjustment Table
Overview
ADRDIF_ST is a standard SAP S/4HANA table that stores Street Difference Table for Quarterly Adjustment data. There are total 35 fields in the ADRDIF_ST table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADRDIF_ST belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Address Management (SZAD).
In addition, following links provide an overview of foreign key relationships, if any, that link ADRDIF_ST to other SAP tables and standard CDS views available based on ADRDIF_ST table in S/4HANA 2020.
Techincal Settings of ADRDIF_ST
Below are technical details of the table ADRDIF_ST
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADRDIF_ST Fields
The following table gives you an overview of the fields available in ADRDIF_ST
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT | 3 |
| CONSNUMBER | Unique Sequential Number for Creating Difference Data | ADDIFNMBR | NUMC | 10 | |
| STCODE_OLD | Previous Street Key | ADDIFSTCOD | * | CHAR | 12 |
| HSNHGH_OLD | Previous Upper House Number Range Limit | ADDIFHNHGH | NUMC | 10 | |
| SUPHGH_OLD | Previous House Number Supplement - Upper Limit | ADDIFSUPH | CHAR | 4 | |
| HSNLOW_OLD | Previous Lower House Number Range Limit | ADDIFHNLOW | NUMC | 10 | |
| SUPLOW_OLD | Previous House Number Supplement - Lower Limit | ADDIFSUPL | CHAR | 4 | |
| HSNIND_OLD | Previous House Number Flag (even/odd/all) | ADDIFHNIND | NUMC | 1 | |
| CTCODE_OLD | Previous City Key | ADDIFCTCOD | * | CHAR | 12 |
| CTNAME_OLD | Previous City Name | ADDIFCTNAM | CHAR | 40 | |
| STNAME_OLD | Previous Street Name | ADDIFSTNAM | CHAR | 60 | |
| ORIGIN | Record Creation Type (Difference Table) | ADDIFORIGN | CHAR | 1 | |
| LANGU | Language Key | SPRAS | * | LANG | 1 |
| CITY_CODE | City Code for City/Street File | CITY_CODE | * | CHAR | 12 |
| CITY_NAME | City | AD_CITY1 | CHAR | 40 | |
| CITY_EXT | City name extension | CITY_EXT | CHAR | 30 | |
| STATUS | Processing Type of a Data Record in RSADRLSM02 | ADR_STATUS | CHAR | 1 | |
| STRT_CODE | Street Number for City/Street File | STRT_CODE | * | CHAR | 12 |
| STREET | Street | AD_STREET | CHAR | 60 | |
| STREET_SHR | Long abbreviation of street name (22 chars) | STREET_SHR | CHAR | 22 | |
| STREET_S15 | Short abbreviation of street name (15 chars) | STREET_S15 | CHAR | 15 | |
| POST_CODE | Postal Code | POST_CODE | * | CHAR | 10 |
| CITYP_CODE | District code for city and street file | CITYP_CODE | * | CHAR | 8 |
| CITY_PART | District | AD_CITY2 | CHAR | 40 | |
| HOUSENUM_H | House number - upper limit (LSM Workbench interface only) | AD_LSM_HNH | CHAR | 10 | |
| HSN_SUPP_H | House number supplement - upper limit of an interval | HSN_SUPP_H | CHAR | 4 | |
| HOUSENUM_L | House number - lower limit (LSM Workbench interface only) | AD_LSM_HNL | CHAR | 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 | |
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | * | CHAR | 8 |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | |
| STRTYPEAB | Street type abbreviation | STRTYPEAB | * | CHAR | 2 |
| POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | |
| MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR | 25 |
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 ADRDIF_ST