CITY_CODE in ADRCITY
City Number (DE: Ortsnummer)
CITY_CODE is a field in SAP table ADRCITY (Postalische Orte). It represents "City Number". Data element: CITY_CODE. Available in 4 CDS view(s) as CityNumber, BusinessPartnerCityCode.
Business Meaning
| Description (EN) | City Number |
|---|---|
| Beschreibung (DE) | Ortsnummer |
| Data Element | CITY_CODE |
| Key Field | Yes |
CDS Views & Technical Names (4)
ADRCITY.CITY_CODE is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
CityNumber
(3 views)
City Code for City/Street File
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_PostalCity | direct | BASIC | Postal City | |
| C_PostalCityTempVH | via 2 level | CONSUMPTION | Postal City | |
| I_PostalCityVH | via 2 level | BASIC | Postal City |
BusinessPartnerCityCode
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BPCityValueHelpTmp | direct | BASIC | City Code |
Other Tables with Field CITY_CODE (8)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ADRC | AD_CITYNUM | Adressen (Business Address Services) | |
| ADRCITYT | CITY_CODE | KEY | Postalische Orte (Langtexte) |
| ADRSTREETT | CITY_CODE | Straßen (Langtexte) | |
| BUT_ADRC_IMOUT | AD_CITYNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_CITYNUM | Master Data Consolidation: Process Table for ADRC | |
| GLOFAAC_JPCITY | GLO_JP_CITY_CODE | KEY | Japan Property Tax Report: City Code |
| GLOFAAC_JPCITY_T | GLO_JP_CITY_CODE | KEY | Japan Property Tax Report: City Code Description |
| J_1BNFE_ACTIVE | NFE_CITY_CODE | Electronic Nota Fiscal: Actual Status |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA