CITY_CODE in ADRC

Table Field AD_CITYNUM

City Code (DE: Ortsnummer)

CITY_CODE is a field in SAP table ADRC (Addresses (Business Address Services)). It represents "City Code". Data element: AD_CITYNUM. Available in 37 CDS view(s) as CityNumber, CityCode, city_code.

Business Meaning

Description (EN)City Code
Beschreibung (DE)Ortsnummer
Data ElementAD_CITYNUM
Key FieldNo

CDS Views & Technical Names (37)

ADRC.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 (24 views)

City code for city/street file

ViewAccessVDMReleaseDescription
I_AddrOrgNamePostalAddress direct BASIC Postal Address and Organization Name
I_InvgCsMAddress direct BASIC ICM Address
I_AddressPostalAddress via 2 level BASIC Postal Address
I_BankOrganizationAddress via 2 level COMPOSITE Address of an Organization used for Bank
I_EWA_SalesContractCube via 2 level COMPOSITE Sales Contract - Cube
I_InvgCsMLocation via 2 level BASIC ICM Location
I_OrganizationAddress via 2 level BASIC Address of an Organization
I_OrgNamePostlAddrDfltRprstn via 2 level COMPOSITE Dflt Addr Rprstn for Org and Postal
I_PersonAddress via 2 level COMPOSITE Address of a Person
I_PostalWorkplaceAddress via 2 level BASIC Person Address type from ADRC & ADCP
R_AddrAddlRepresentationTP via 2 level Additional Representation - TP
R_OrganizationAddressTP via 2 level Organization Address - TP
C_EWA_SalesContractQuery via 3 levels CONSUMPTION Sales contracts - Query
I_InvgCsMVisibleLocation via 3 levels COMPOSITE Nonhidden Location
I_OrgAddressDefaultRprstn via 3 levels COMPOSITE Default Representation of an Org Address
I_PersonAddressDefaultRprstn via 3 levels COMPOSITE Dflt Represention of a Person Address
R_AddlRepresentationTP via 3 levels TRANSACTIONAL Address for Person BO
C_AddlRepresentationTP via 4 levels CONSUMPTION Pview for R_AddlRepresentationTP
I_InvgCsMLocationTP via 4 levels TRANSACTIONAL TP View for ICM Location
I_InvgCsMLocRelatedLocTP via 4 levels TRANSACTIONAL TP view for ICM Relationship Location to Location
I_InvgCsMObjRelatedLocTP via 4 levels TRANSACTIONAL TP view for ICM Relationship Object to Location
C_InvgCsMLocationTP via 5 levels CONSUMPTION ICM Location
C_InvgCsMLocRelatedLocTP via 5 levels CONSUMPTION ICM Relationship Location to Location
C_InvgCsMObjRelatedLocTP via 5 levels CONSUMPTION ICM Relationship Object to Location

CityCode (10 views)

City code for city/street file

ViewAccessVDMReleaseDescription
CIC_PlantAddress direct Proj. view on Plant address
I_InvgCsMAddress direct BASIC ICM Address
I_ScriptedOrganizationAddress direct COMPOSITE Interational Address Version
I_InvgCsMLocation via 2 level BASIC ICM Location
C_PurReqnItemDeliveryAddress via 3 levels CONSUMPTION Consumption View for Purchase Reqn Delivery address
I_InvgCsMVisibleLocation via 3 levels COMPOSITE Nonhidden Location
I_PurchaseReqnAddress via 3 levels COMPOSITE Purchase Requisition Address Basic View
I_PurchaseReqnDeliveryAddress via 4 levels COMPOSITE Pur Reqn Delivery Address Basic View
T_PurchaseReqnDeliveryAdd via 5 levels TRANSACTIONAL Pur Reqn Delivery Address Basic View
C_PurchaseReqnDelivAdd via 6 levels CONSUMPTION Purchase Reqn Delivery Address C View

city_code (4 views)

ViewAccessVDMReleaseDescription
/UCOM/I_MCM_ADRC direct BASIC Address (Basic)
P_CN_CADEOrganizationName direct BASIC
P_OrganizationAddress direct COMPOSITE
P_OrganizationAddressConsum direct CONSUMPTION

city (2 views)

ViewAccessVDMReleaseDescription
/SCMTMS/CV_LocQuByPhysAdd direct Obsolete: Use CDS View /SCMTMS/VE_LocQuByPhysAdd
/SCMTMS/VE_LocQuByPhysAdd direct BOPF: Location Query By Physical Address

Other Tables with Field CITY_CODE (13)

TableData ElementKeyDescription
ADRCITY CITY_CODE KEY Postal cities
ADRCITYT CITY_CODE KEY Postal districts (long texts)
ADRSTREET CITY_CODE Streets
ADRSTREETT CITY_CODE Streets (long texts)
BUT_ADRC_IMOUT AD_CITYNUM Master Data Consolidation: Process Table for ADRC
BUT_ADRC_PRC AD_CITYNUM Master Data Consolidation: Process Table for ADRC
EGTUR CITY_CODE Periodic Replacement List
FICODIAND_HCM AD_CITYNUM HCM information for DIAN
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_1BNFCPD AD_CITYNUM Nota Fiscal one-time accounts
PTRV_TRIP_CHAIN PTRV_CITY_CODE Table of all Trip Destinations f. Processing Recurring Dest.
T706_CITY_CD_D PTRV_CITY_CODE Definition: City Codes / Community Code No., Date-Dependent

Learn More