ADRDIF_CT is a standard SAP table in SAP ECC (or) S/4HANA which stores City Difference Table for Quarterly Adjustment data. There are total 23 fields in ADRDIF_CT table.This blog post provides key technical details of SAP table ADRDIF_CT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRDIF_CT 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_CT Table Fields
The following is the list of fields that are available in SAP ADRDIF_CT 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) | |
CTCODE_OLD | Previous City Key | ADDIFCTCOD | CITY_CODE | * | CHAR (12) |
CTNAME_OLD | Previous City Name | ADDIFCTNAM | TEXT40 | CHAR (40) | |
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) | |
CITY_SHORT | Long abbreviation of the city name (24 chars) | CITY_SHORT | TEXT24 | CHAR (24) | |
CITY_SH10 | Short abbreviation of the city name (10 chars) | CITY_SH10 | TEXT10 | CHAR (10) | |
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) | |
REGION | Region (State, Province, County) | REGIO | REGIO | * | CHAR (3) |
TIME_ZONE | Address time zone | AD_TZONE | TZNZONE | * | CHAR (6) |
TRANSPZONE | Transportation Zone | AD_TRNSPZN | ZONE | * | CHAR (10) |
CITY_NM_PS | Name of different postal city for city/street file | CITY_NM_PS | TEXT40 | CHAR (40) | |
CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CITY_CODE | * | CHAR (12) |
MC_CITY | City name in Uppercase for Search Help | AD_MC_CITY | CHAR25 | CHAR (25) | |
COUNTY_CODE | County code for county | AD_CNTYNUM | CNTY_CODE | * | CHAR (8) |
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | TWSHP_CODE | * | CHAR (8) |
Availability
The SAP table ADRDIF_CT 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_CT table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.