ADR_LSM0 SAP (Transfer Structure RSADRLSM02: Cities) Structure details
Description: Transfer Structure RSADRLSM02: Cities
Structure field list including key, data, relationships and ABAP select examples
ADR_LSM0 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transfer Structure RSADRLSM02: Cities" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ADR_LSM0 TYPE ADR_LSM0.
The ADR_LSM0 table consists of various fields, each holding specific information or linking keys about Transfer Structure RSADRLSM02: Cities data available in SAP. These include LANGU (Language Key), DATA_ID (RSADRLSM02 Data Transfer ID), STATUS (Processing Type of a Data Record in RSADRLSM02), CITY_CODE (City Code for City/Street File).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP ADR_LSM0 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
LANGU | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
DATA_ID | RSADRLSM02 Data Transfer ID | RS_DATA_ID | CHAR | 2 | RS_DATA_ID | ||||
STATUS | Processing Type of a Data Record in RSADRLSM02 | ADR_STATUS | CHAR | 1 | ADR_STATUS | ||||
CITY_CODE | City Code for City/Street File | CITY_CODE | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ORT | CITYA |
COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | COMMU_CODE | ||||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
TRANSPZONE | Transportation zone | AD_TRNSPZN | CHAR | 10 | Assigned to domain | ZONE | |||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | Assigned to domain | REGIOGROUP | |||
CITY_NAME | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY_SHORT | Long abbreviation of the city name (24 chars) | CITY_SHORT | CHAR | 24 | TEXT24 | ||||
CITY_SH10 | Short abbreviation of the city name (10 chars) | CITY_SH10 | CHAR | 10 | TEXT10 | ||||
CITY_EXT | City name extension | CITY_EXT | CHAR | 30 | TEXT30 | ||||
CITYP_CODE | District code for city and street file | CITYP_CODE | CHAR | 8 | Assigned to domain | ALPHA | CITYP_CODE | CPRTA | |
CITY_PART | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
PO_BOX_HGH | P.O. box - upper limit of an interval | PO_BOX_HGH | CHAR | 10 | ALPHA | PO_BOX | |||
PO_BOX_LOW | P.O. box - lower limit of an interval | PO_BOX_LOW | CHAR | 10 | ALPHA | PO_BOX | |||
PO_BOX_IND | Post box no. ID (even/uneven/all) | PO_BOX_IND | NUMC | 1 | PO_BOX_IND | ||||
PO_BOX_TXT | P.O. box text | PO_BOX_TXT | CHAR | 50 | TEXT50 | ||||
POST_CODE | Postal Code | POST_CODE | CHAR | 10 | Assigned to domain | POST_CODE | PSC | PSTC | |
FLAG_DELIV | Flag: Delivery postal code | FLAG_DELIV | CHAR | 1 | RS_XFIELD | ||||
FLAG_POBOX | Flag: PO Box postal code | FLAG_POBOX | CHAR | 1 | RS_XFIELD | ||||
FLAG_CUST | Flag: Major customer postal code | FLAG_CUST | CHAR | 1 | RS_XFIELD | ||||
FLAG_CSTGR | Flag: Group major customer postal code | FLAG_CSTGR | CHAR | 1 | RS_XFIELD | ||||
STRT_CODE | Street Number for City/Street File | STRT_CODE | CHAR | 12 | Assigned to domain | ALPHA | STRT_CODE | STN | STRTA |
STRTYPEAB | Street type abbreviation | STRTYPEAB | CHAR | 2 | Assigned to domain | STRTYPEAB | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
STREET_SHR | Long abbreviation of street name (22 chars) | STREET_SHR | CHAR | 22 | TEXT22 | ||||
STREET_S15 | Short abbreviation of street name (15 chars) | STREET_S15 | CHAR | 15 | TEXT15 | ||||
HOUSENUM_H | House number - upper limit (LSM Workbench interface only) | AD_LSM_HNH | CHAR | 10 | TEXT10 | ||||
HSN_SUPP_H | House number supplement - upper limit of an interval | HSN_SUPP_H | CHAR | 4 | TEXT4 | ||||
HOUSENUM_L | House number - lower limit (LSM Workbench interface only) | AD_LSM_HNL | CHAR | 10 | TEXT10 | ||||
HSN_SUPP_L | House number supplement - lower limit of an interval | HSN_SUPP_L | CHAR | 4 | TEXT4 | ||||
HSN_IND | House number ID (even/odd/all) | HSN_IND | NUMC | 1 | HSN_IND | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
CITY_NM_PS | Name of different postal city for city/street file | CITY_NM_PS | CHAR | 40 | TEXT40 | ||||
CITY_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
MC_CITY | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | CHAR25 | ||||
MC_STREET | Street name in upper case for search help | AD_MC_STRT | CHAR | 25 | CHAR25 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | Assigned to domain | ALPHA | CNTY_CODE | ||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | Assigned to domain | ALPHA | TWSHP_CODE | ||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR | 25 | CHAR25 | ||||
MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR | 25 | CHAR25 | ||||
R_CITYCODE | City Code for City/Street File | CITY_CODE | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ORT | CITYA |
R_COMMUCOD | Municipality key | COMMU_CODE | CHAR | 15 | COMMU_CODE | ||||
R_REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
R_TIMEZONE | Address time zone | AD_TZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
R_TAXJURCD | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
R_TRANSPZN | Transportation zone | AD_TRNSPZN | CHAR | 10 | Assigned to domain | ZONE | |||
R_REGIOGRP | Regional structure grouping | REGIOGROUP | CHAR | 8 | Assigned to domain | REGIOGROUP | |||
R_CITYNAME | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
R_CITYSHRT | Long abbreviation of the city name (24 chars) | CITY_SHORT | CHAR | 24 | TEXT24 | ||||
R_CITYSH10 | Short abbreviation of the city name (10 chars) | CITY_SH10 | CHAR | 10 | TEXT10 | ||||
R_CITY_EXT | City name extension | CITY_EXT | CHAR | 30 | TEXT30 | ||||
R_CITYP_CD | District code for city and street file | CITYP_CODE | CHAR | 8 | Assigned to domain | ALPHA | CITYP_CODE | CPRTA | |
R_CITY_PRT | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
R_POBOXHGH | P.O. box - upper limit of an interval | PO_BOX_HGH | CHAR | 10 | ALPHA | PO_BOX | |||
R_POBOXLOW | P.O. box - lower limit of an interval | PO_BOX_LOW | CHAR | 10 | ALPHA | PO_BOX | |||
R_POBOXIND | Post box no. ID (even/uneven/all) | PO_BOX_IND | NUMC | 1 | PO_BOX_IND | ||||
R_POBOXTXT | P.O. box text | PO_BOX_TXT | CHAR | 50 | TEXT50 | ||||
R_POST_COD | Postal Code | POST_CODE | CHAR | 10 | Assigned to domain | POST_CODE | PSC | PSTC | |
R_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
R_FLGDELIV | Flag: Delivery postal code | FLAG_DELIV | CHAR | 1 | RS_XFIELD | ||||
R_FLGPOBOX | Flag: PO Box postal code | FLAG_POBOX | CHAR | 1 | RS_XFIELD | ||||
R_FLAGCUST | Flag: Major customer postal code | FLAG_CUST | CHAR | 1 | RS_XFIELD | ||||
R_FLGCSTGR | Flag: Group major customer postal code | FLAG_CSTGR | CHAR | 1 | RS_XFIELD | ||||
R_STRTCODE | Street Number for City/Street File | STRT_CODE | CHAR | 12 | Assigned to domain | ALPHA | STRT_CODE | STN | STRTA |
R_STRTYPAB | Street type abbreviation | STRTYPEAB | CHAR | 2 | Assigned to domain | STRTYPEAB | |||
R_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
R_STRT_SHR | Long abbreviation of street name (22 chars) | STREET_SHR | CHAR | 22 | TEXT22 | ||||
R_STRT_S15 | Short abbreviation of street name (15 chars) | STREET_S15 | CHAR | 15 | TEXT15 | ||||
R_HSNUM_H | House number - upper limit (LSM Workbench interface only) | AD_LSM_HNH | CHAR | 10 | TEXT10 | ||||
R_HSNSUPPH | House number supplement - upper limit of an interval | HSN_SUPP_H | CHAR | 4 | TEXT4 | ||||
R_HSNUM_L | House number - lower limit (LSM Workbench interface only) | AD_LSM_HNL | CHAR | 10 | TEXT10 | ||||
R_HSNSUPPL | House number supplement - lower limit of an interval | HSN_SUPP_L | CHAR | 4 | TEXT4 | ||||
R_HSN_IND | House number ID (even/odd/all) | HSN_IND | NUMC | 1 | HSN_IND | ||||
R_POSTALAR | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
R_CT_NM_PS | Name of different postal city for city/street file | CITY_NM_PS | CHAR | 40 | TEXT40 | ||||
R_CT_CD_PS | Coding of different postal city for City/Street file | CITY_CD_PS | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
R_MC_CITY | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | CHAR25 | ||||
R_MC_STREET | Street name in upper case for search help | AD_MC_STRT | CHAR | 25 | CHAR25 | ||||
R_COUNTYCODE | County code for county | AD_CNTYNUM | CHAR | 8 | Assigned to domain | ALPHA | CNTY_CODE | ||
R_COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
R_TOWNSHIPCODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | Assigned to domain | ALPHA | TWSHP_CODE | ||
R_TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
R_MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR | 25 | CHAR25 | ||||
R_MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR | 25 | CHAR25 |
Key field | Non-key field |
How do I retrieve data from SAP structure ADR_LSM0 using ABAP code?
As ADR_LSM0 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ADR_LSM0 as there is no data to select.How to access SAP table ADR_LSM0
Within an ECC or HANA version of SAP you can also view further information about ADR_LSM0 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects