SAP ADRDIF_CT City Difference Table for Quarterly Adjustment Table
Overview
ADRDIF_CT is a standard SAP S/4HANA table that stores City Difference Table for Quarterly Adjustment data. There are total 23 fields in the ADRDIF_CT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADRDIF_CT 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_CT to other SAP tables and standard CDS views available based on ADRDIF_CT table in S/4HANA 2020.
Techincal Settings of ADRDIF_CT
Below are technical details of the table ADRDIF_CT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADRDIF_CT Fields
The following table gives you an overview of the fields available in ADRDIF_CT
| 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 | |
| CTCODE_OLD | Previous City Key | ADDIFCTCOD | * | CHAR | 12 |
| CTNAME_OLD | Previous City Name | ADDIFCTNAM | CHAR | 40 | |
| 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 | |
| CITY_SHORT | Long abbreviation of the city name (24 chars) | CITY_SHORT | CHAR | 24 | |
| CITY_SH10 | Short abbreviation of the city name (10 chars) | CITY_SH10 | CHAR | 10 | |
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | * | CHAR | 8 |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | |
| REGION | Region (State, Province, County) | REGIO | * | CHAR | 3 |
| TIME_ZONE | Address time zone | AD_TZONE | * | CHAR | 6 |
| TRANSPZONE | Transportation Zone | AD_TRNSPZN | * | CHAR | 10 |
| CITY_NM_PS | Name of different postal city for city/street file | CITY_NM_PS | CHAR | 40 | |
| CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | * | CHAR | 12 |
| MC_CITY | City name in Uppercase for Search Help | AD_MC_CITY | CHAR | 25 | |
| COUNTY_CODE | County code for county | AD_CNTYNUM | * | CHAR | 8 |
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | * | 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 ADRDIF_CT