SAP Table ADRC_REGIO

Structure with data from address not in ADRC

ADRC_REGIO (Structure with data from address not in ADRC) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADRC_REGIO to other SAP tables.

ADRC_REGIO table fields

Field Data element Checktable Datatype Length Decimals
DEF_LANGU Default language for city DEF_LANGU T002 LANG 1 0
FLAG_STRTS Flag: Street directory exists FLAG_STRTS CHAR 1 0
X Indicator is set
NULL Indicator is not set
COMMU_CODE Municipality key COMMU_CODE CHAR 15 0
CITY_SHORT Long abbreviation of the city name (24 chars) CITY_SHORT CHAR 24 0
CITY_SH10 Short abbreviation of the city name (10 chars) CITY_SH10 CHAR 10 0
CITY_EXT City name extension CITY_EXT CHAR 30 0
MC_CITY City name in upper case for search help AD_MC_CITY CHAR 25 0
STREET_SHR Long abbreviation of street name (22 chars) STREET_SHR CHAR 22 0
STREET_S15 Short abbreviation of street name (15 chars) STREET_S15 CHAR 15 0
MC_STREET Street name in upper case for search help AD_MC_STRT CHAR 25 0

ADRC_REGIO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADRC_REGIO DEF_LANGU ADRC_REGIO DEF_LANGU T002 Language Keys (Component BC-I18) SPRAS