ADRCITY is a standard SAP table in SAP ECC (or) S/4HANA which stores Postal cities data. There are total 14 fields in ADRCITY table.This blog post provides key technical details of SAP table ADRCITY, including its availability across SAP S/4HANA versions and the list of CDS views for ADRCITY table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Single entries of table were buffered |
| Package | SAP Technology – Business Services: Regional Structure (SZRS) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRCITY Table Fields
The following is the list of fields that are available in SAP ADRCITY table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
| COUNTRY | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
| CITY_CODE | City Code for City/Street File | CITY_CODE | CITY_CODE | CHAR (12) | |
| COUNTY_CODE | County code for county | AD_CNTYNUM | CNTY_CODE | CHAR (8) | |
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | TWSHP_CODE | CHAR (8) | |
| COMMU_CODE | Municipality key | COMMU_CODE | COMMU_CODE | CHAR (15) | |
| FLAG_STRTS | Flag: Street directory exists | FLAG_STRTS | RS_XFIELD | CHAR (1) | |
| REGION | Region (State, Province, County) | REGIO | REGIO | T005S | CHAR (3) |
| TIME_ZONE | Address time zone | AD_TZONE | TZNZONE | * | CHAR (6) |
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | AD_TXJCD | CHAR (15) | |
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | ZONE | * | CHAR (10) |
| DEF_LANGU | Default language for city | DEF_LANGU | SPRAS | * | LANG (1) |
| REGIOGROUP | Regional structure grouping | REGIOGROUP | REGIOGROUP | * | CHAR (8) |
| CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CITY_CODE | CHAR (12) |
Availability
The SAP table ADRCITY 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 ADRCITY table
The following is the list of ADRCITY CDS views, which can also be used instead of ADRCITY table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| P_CO_DIANCITYCODE | BASIC | City Code for Colombia DIAN |
| C_CO_DIANCITYCODE | CONSUMPTION | City Code for Colombia DIAN |
| C_CO_DIANSTRPBPTAXITEMCUBE | CONSUMPTION | Format 1005 & 1006 – Tax Item Cube |
| C_CO_DIANSTRPCREDITOROPENITEMC | CONSUMPTION | Creditor Balances Cube for Colombia DIAN |
| C_CO_DIANSTRPCREDITOROPENITEMQ | CONSUMPTION | Crdtr Balances Query for Colombia DIAN |
| C_CO_DIANSTRPCUSTOMEROPENITEMC | CONSUMPTION | Cust. Balances Cube for Colombia DIAN |
| C_CO_DIANSTRPCUSTOMEROPENITEMQ | CONSUMPTION | Cust. Balances Query for Colombia DIAN |
| C_CO_DIANSTRPCUSTOPENITEMLG | CONSUMPTION | All Customer Open Item for Colombia DIAN |
| C_CO_DIANSTRPDEBTOROPENITEMC | CONSUMPTION | Debtor Balances Cube for Colombia DIAN |
| C_CO_DIANSTRPDEBTOROPENITEMQ | CONSUMPTION | Debtor Balances Query for Colombia DIAN |
| C_CO_DIANSTRPFORMAT1001CUBE | CONSUMPTION | Format 1001 – Journal Entry Item Cube |
| C_CO_DIANSTRPFORMAT1001QUERY | CONSUMPTION | Format 1001 – Journal Entry Item Query |
| C_CO_DIANSTRPFRMT1001VERS10Q | CONSUMPTION | Format 1001 – Journal Entry Item Query |
| C_CO_DIANSTRPREVENUECUBE | CONSUMPTION | Format 1007 – Revenue Cube |
| C_CO_DIANSTRPREVENUEQUERY | CONSUMPTION | Format 1007 – Revenue Query V8 |
| C_CO_DIANSTRPREVENUEVERSION9Q | CONSUMPTION | Format 1007 – Revenue Query V9 |
| C_CO_DIANSTRPSUPLRCUSTOPNITEMC | CONSUMPTION | Supplier & Customer Open Item for DIAN |
| C_CO_DIANSTRPSUPLRCUSTOPNITMLG | CONSUMPTION | All Suplr. & Cust.Bal. for Colombia DIAN |
| C_CO_DIANSTRPSUPLROPENITEMLG | CONSUMPTION | All Supp. Balances for Colombia DIAN |
| C_CO_DIANSTRPSUPPLIEROPENITEMC | CONSUMPTION | Supplier Balances Cube for Colombia DIAN |
| C_CO_DIANSTRPTAXITEMQUERY | CONSUMPTION | Format 1005 & 1006 – Tax Item Query |
| C_CO_DIANSTRPWHLDGTAXITEMCUBE | CONSUMPTION | Withholding Tax Item for Colombia DIAN |
| C_CO_DIANSTRPWHLDGTAXITEMLG | CONSUMPTION | All Whldg. Tax Items For Colombia DIAN |
| C_CO_DIANSTRPWHLDGTAXITEMQUERY | CONSUMPTION | Whldg Tax Items Query for Colombia DIAN |
| P_CO_DIANFRMT1001JRNLENTRITEM4 | CONSUMPTION | Format 1001 – JE Item with BP Details |
| P_CO_DIANSTRP1001TOTAMTBYITMTP | CONSUMPTION | Format 1001 – Total Amount by Item Type |
| P_CO_DIANSTRPAGGRGCREDITOR | CONSUMPTION | Union Creditors for Colombia DIAN |
| P_CO_DIANSTRPAGGRGFORMAT1001 | CONSUMPTION | Format 1001 – Acctg and Payroll Items |
| P_CO_DIANSTRPCREDITOROPENITM | CONSUMPTION | Creditor Open Item for Colombia DIAN |
| P_CO_DIANSTRPCUSTOMEROPENITM | CONSUMPTION | Priv. Cust. Balances for Colombia DIAN |
| P_CO_DIANSTRPDEBTOROPENITEM | CONSUMPTION | Priv. Debtor Balances for Colombia DIAN |
| P_CO_DIANSTRPFINALCRDTROPENITM | CONSUMPTION | Fnl Creditor Open Item for Colombia DIAN |
| P_CO_DIANSTRPFINALCREDITORBAL | CONSUMPTION | Final Creditor Balance for Colombia DIAN |
| P_CO_DIANSTRPFINALDBTROPENITM | CONSUMPTION | Fnl Debtor Open Item for Colombia DIAN |
| P_CO_DIANSTRPFINALDEBTORBAL | CONSUMPTION | Final Debtor Balance for Colombia DIAN |
| P_CO_DIANSTRPFORMAT1001 | CONSUMPTION | Format 1001 – Payment in Account |
| P_CO_DIANSTRPFRMT1001MINAMOUNT | CONSUMPTION | Format 1001 – Minimum Amount |
| P_CO_DIANSTRPFRMT1008MINAMOUNT | CONSUMPTION | Minimum Amount For Format 1008 |
| P_CO_DIANSTRPFRMT1009MINAMOUNT | CONSUMPTION | Minimum Amount for Format 1009 |
| P_CO_DIANSTRPREVENUE | CONSUMPTION | Format 1007 – Revenue Item |
| P_CO_DIANSTRPTOTAMTBYCREDITOR | CONSUMPTION | Total Amount By Creditor for Colombia |
| P_CO_DIANSTRPTOTAMTBYCREDITOR2 | CONSUMPTION | Total Creditor Balance for Colombia |
| P_CO_DIANSTRPTOTAMTBYDEBTOR | CONSUMPTION | Total Amount by Debtor for Colombia |
| P_CO_DIANSTRPTOTAMTBYDEBTOR2 | CONSUMPTION | Total Amount by Debtor for Colombia |
| P_CO_DIANSTRPWHLDGTAXITEM2 | CONSUMPTION | Withholding Tax Items 2 |
| P_CO_DIANSTRPWHLDGTAXITEM3 | CONSUMPTION | Withholding Tax Items 2 |
