Sunday, March 3, 2024

SAP Table ADRCITY – Postal cities

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