ADRDIF_ST is a standard SAP table in SAP ECC (or) S/4HANA which stores Street Difference Table for Quarterly Adjustment data. There are total 35 fields in ADRDIF_ST table.This blog post provides key technical details of SAP table ADRDIF_ST, including its availability across SAP S/4HANA versions and the list of CDS views for ADRDIF_ST table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | SAP Technology – Business Services: Address Management (SZAD) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRDIF_ST Table Fields
The following is the list of fields that are available in SAP ADRDIF_ST table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | * | CLNT (3) |
| CONSNUMBER | Unique Sequential Number for Creating Difference Data | ADDIFNMBR | NUMC10 | NUMC (10) | |
| STCODE_OLD | Previous Street Key | ADDIFSTCOD | STRT_CODE | * | CHAR (12) |
| HSNHGH_OLD | Previous Upper House Number Range Limit | ADDIFHNHGH | NUMC10 | NUMC (10) | |
| SUPHGH_OLD | Previous House Number Supplement – Upper Limit | ADDIFSUPH | TEXT4 | CHAR (4) | |
| HSNLOW_OLD | Previous Lower House Number Range Limit | ADDIFHNLOW | NUMC10 | NUMC (10) | |
| SUPLOW_OLD | Previous House Number Supplement – Lower Limit | ADDIFSUPL | TEXT4 | CHAR (4) | |
| HSNIND_OLD | Previous House Number Flag (even/odd/all) | ADDIFHNIND | HSN_IND | NUMC (1) | |
| CTCODE_OLD | Previous City Key | ADDIFCTCOD | CITY_CODE | * | CHAR (12) |
| CTNAME_OLD | Previous City Name | ADDIFCTNAM | TEXT40 | CHAR (40) | |
| STNAME_OLD | Previous Street Name | ADDIFSTNAM | TEXT60 | CHAR (60) | |
| ORIGIN | Record Creation Type (Difference Table) | ADDIFORIGN | ADDIFORIGN | CHAR (1) | |
| LANGU | Language Key | SPRAS | SPRAS | * | LANG (1) |
| CITY_CODE | City Code for City/Street File | CITY_CODE | CITY_CODE | * | CHAR (12) |
| CITY_NAME | City | AD_CITY1 | TEXT40 | CHAR (40) | |
| CITY_EXT | City name extension | CITY_EXT | TEXT30 | CHAR (30) | |
| STATUS | Processing Type of a Data Record in RSADRLSM02 | ADR_STATUS | ADR_STATUS | CHAR (1) | |
| STRT_CODE | Street Number for City/Street File | STRT_CODE | STRT_CODE | * | CHAR (12) |
| STREET | Street | AD_STREET | TEXT60 | CHAR (60) | |
| STREET_SHR | Long abbreviation of street name (22 chars) | STREET_SHR | TEXT22 | CHAR (22) | |
| STREET_S15 | Short abbreviation of street name (15 chars) | STREET_S15 | TEXT15 | CHAR (15) | |
| POST_CODE | Postal Code | POST_CODE | POST_CODE | * | CHAR (10) |
| CITYP_CODE | District code for city and street file | CITYP_CODE | CITYP_CODE | * | CHAR (8) |
| CITY_PART | District | AD_CITY2 | TEXT40 | CHAR (40) | |
| HOUSENUM_H | House number – upper limit (LSM Workbench interface only) | AD_LSM_HNH | TEXT10 | CHAR (10) | |
| HSN_SUPP_H | House number supplement – upper limit of an interval | HSN_SUPP_H | TEXT4 | CHAR (4) | |
| HOUSENUM_L | House number – lower limit (LSM Workbench interface only) | AD_LSM_HNL | TEXT10 | CHAR (10) | |
| HSN_SUPP_L | House number supplement – lower limit of an interval | HSN_SUPP_L | TEXT4 | CHAR (4) | |
| HSN_IND | House number ID (even/odd/all) | HSN_IND | HSN_IND | NUMC (1) | |
| COMMU_CODE | Municipality key | COMMU_CODE | COMMU_CODE | CHAR (15) | |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | REGIOGROUP | * | CHAR (8) |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | AD_TXJCD | CHAR (15) | |
| STRTYPEAB | Street type abbreviation | STRTYPEAB | STRTYPEAB | * | CHAR (2) |
| POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | TEXT15 | CHAR (15) | |
| MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR25 | CHAR (25) |
Availability
The SAP table ADRDIF_ST is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADRDIF_ST table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
