ADRCITYT is a standard SAP table in SAP ECC (or) S/4HANA which stores Postal districts (long texts) data. There are total 9 fields in ADRCITYT table.This blog post provides key technical details of SAP table ADRCITYT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRCITYT 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 ADRCITYT Table Fields
The following is the list of fields that are available in SAP ADRCITYT 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) |
| LANGU | Language Key | LANGU | SPRAS | T002 | LANG (1) |
| COUNTRY | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
| CITY_CODE | City Code for City/Street File | CITY_CODE | CITY_CODE | ADRCITY | CHAR (12) |
| CITY_NAME | City | AD_CITY1 | TEXT40 | CHAR (40) | |
| MC_CITY | City name in Uppercase for Search Help | AD_MC_CITY | CHAR25 | CHAR (25) | |
| 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) | |
| CITY_EXT | City name extension | CITY_EXT | TEXT30 | CHAR (30) |
Availability
The SAP table ADRCITYT 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 ADRCITYT table
The following is the list of ADRCITYT CDS views, which can also be used instead of ADRCITYT 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 |
