ADR_LSM0 SAP (Transfer Structure RSADRLSM02: Cities) Structure details

Dictionary Type: Structure
Description: Transfer Structure RSADRLSM02: Cities




ABAP Code to SELECT data from ADR_LSM0
Related tables to ADR_LSM0
Access table ADR_LSM0




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
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
DATA_IDRSADRLSM02 Data Transfer ID RS_DATA_IDCHAR2RS_DATA_ID
STATUSProcessing Type of a Data Record in RSADRLSM02 ADR_STATUSCHAR1ADR_STATUS
CITY_CODECity Code for City/Street File CITY_CODECHAR12Assigned to domainALPHACITY_CODEORTCITYA
COMMU_CODEMunicipality key COMMU_CODECHAR15COMMU_CODE
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
TRANSPZONETransportation zone AD_TRNSPZNCHAR10Assigned to domainZONE
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
CITY_NAMECity AD_CITY1CHAR40TEXT40CLCITYNAME
CITY_SHORTLong abbreviation of the city name (24 chars) CITY_SHORTCHAR24TEXT24
CITY_SH10Short abbreviation of the city name (10 chars) CITY_SH10CHAR10TEXT10
CITY_EXTCity name extension CITY_EXTCHAR30TEXT30
CITYP_CODEDistrict code for city and street file CITYP_CODECHAR8Assigned to domainALPHACITYP_CODECPRTA
CITY_PARTDistrict AD_CITY2CHAR40TEXT40CITY_PART
PO_BOX_HGHP.O. box - upper limit of an interval PO_BOX_HGHCHAR10ALPHAPO_BOX
PO_BOX_LOWP.O. box - lower limit of an interval PO_BOX_LOWCHAR10ALPHAPO_BOX
PO_BOX_INDPost box no. ID (even/uneven/all) PO_BOX_INDNUMC1PO_BOX_IND
PO_BOX_TXTP.O. box text PO_BOX_TXTCHAR50TEXT50
POST_CODEPostal Code POST_CODECHAR10Assigned to domainPOST_CODEPSCPSTC
FLAG_DELIVFlag: Delivery postal code FLAG_DELIVCHAR1RS_XFIELD
FLAG_POBOXFlag: PO Box postal code FLAG_POBOXCHAR1RS_XFIELD
FLAG_CUSTFlag: Major customer postal code FLAG_CUSTCHAR1RS_XFIELD
FLAG_CSTGRFlag: Group major customer postal code FLAG_CSTGRCHAR1RS_XFIELD
STRT_CODEStreet Number for City/Street File STRT_CODECHAR12Assigned to domainALPHASTRT_CODESTNSTRTA
STRTYPEABStreet type abbreviation STRTYPEABCHAR2Assigned to domainSTRTYPEAB
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STREET_SHRLong abbreviation of street name (22 chars) STREET_SHRCHAR22TEXT22
STREET_S15Short abbreviation of street name (15 chars) STREET_S15CHAR15TEXT15
HOUSENUM_HHouse number - upper limit (LSM Workbench interface only) AD_LSM_HNHCHAR10TEXT10
HSN_SUPP_HHouse number supplement - upper limit of an interval HSN_SUPP_HCHAR4TEXT4
HOUSENUM_LHouse number - lower limit (LSM Workbench interface only) AD_LSM_HNLCHAR10TEXT10
HSN_SUPP_LHouse number supplement - lower limit of an interval HSN_SUPP_LCHAR4TEXT4
HSN_INDHouse number ID (even/odd/all) HSN_INDNUMC1HSN_IND
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
CITY_NM_PSName of different postal city for city/street file CITY_NM_PSCHAR40TEXT40
CITY_CD_PSCoding of different postal city for City/Street file CITY_CD_PSCHAR12Assigned to domainALPHACITY_CODE
MC_CITYCity name in upper case for search help AD_MC_CITYCHAR25CHAR25
MC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
MC_COUNTYCounty name in upper case for search help AD_MC_COUNTYCHAR25CHAR25
MC_TOWNSHIPTownship name in upper case for search help AD_MC_TWSHPCHAR25CHAR25
R_CITYCODECity Code for City/Street File CITY_CODECHAR12Assigned to domainALPHACITY_CODEORTCITYA
R_COMMUCODMunicipality key COMMU_CODECHAR15COMMU_CODE
R_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
R_TIMEZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
R_TAXJURCDTax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
R_TRANSPZNTransportation zone AD_TRNSPZNCHAR10Assigned to domainZONE
R_REGIOGRPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
R_CITYNAMECity AD_CITY1CHAR40TEXT40CLCITYNAME
R_CITYSHRTLong abbreviation of the city name (24 chars) CITY_SHORTCHAR24TEXT24
R_CITYSH10Short abbreviation of the city name (10 chars) CITY_SH10CHAR10TEXT10
R_CITY_EXTCity name extension CITY_EXTCHAR30TEXT30
R_CITYP_CDDistrict code for city and street file CITYP_CODECHAR8Assigned to domainALPHACITYP_CODECPRTA
R_CITY_PRTDistrict AD_CITY2CHAR40TEXT40CITY_PART
R_POBOXHGHP.O. box - upper limit of an interval PO_BOX_HGHCHAR10ALPHAPO_BOX
R_POBOXLOWP.O. box - lower limit of an interval PO_BOX_LOWCHAR10ALPHAPO_BOX
R_POBOXINDPost box no. ID (even/uneven/all) PO_BOX_INDNUMC1PO_BOX_IND
R_POBOXTXTP.O. box text PO_BOX_TXTCHAR50TEXT50
R_POST_CODPostal Code POST_CODECHAR10Assigned to domainPOST_CODEPSCPSTC
R_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
R_FLGDELIVFlag: Delivery postal code FLAG_DELIVCHAR1RS_XFIELD
R_FLGPOBOXFlag: PO Box postal code FLAG_POBOXCHAR1RS_XFIELD
R_FLAGCUSTFlag: Major customer postal code FLAG_CUSTCHAR1RS_XFIELD
R_FLGCSTGRFlag: Group major customer postal code FLAG_CSTGRCHAR1RS_XFIELD
R_STRTCODEStreet Number for City/Street File STRT_CODECHAR12Assigned to domainALPHASTRT_CODESTNSTRTA
R_STRTYPABStreet type abbreviation STRTYPEABCHAR2Assigned to domainSTRTYPEAB
R_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
R_STRT_SHRLong abbreviation of street name (22 chars) STREET_SHRCHAR22TEXT22
R_STRT_S15Short abbreviation of street name (15 chars) STREET_S15CHAR15TEXT15
R_HSNUM_HHouse number - upper limit (LSM Workbench interface only) AD_LSM_HNHCHAR10TEXT10
R_HSNSUPPHHouse number supplement - upper limit of an interval HSN_SUPP_HCHAR4TEXT4
R_HSNUM_LHouse number - lower limit (LSM Workbench interface only) AD_LSM_HNLCHAR10TEXT10
R_HSNSUPPLHouse number supplement - lower limit of an interval HSN_SUPP_LCHAR4TEXT4
R_HSN_INDHouse number ID (even/odd/all) HSN_INDNUMC1HSN_IND
R_POSTALAR(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
R_CT_NM_PSName of different postal city for city/street file CITY_NM_PSCHAR40TEXT40
R_CT_CD_PSCoding of different postal city for City/Street file CITY_CD_PSCHAR12Assigned to domainALPHACITY_CODE
R_MC_CITYCity name in upper case for search help AD_MC_CITYCHAR25CHAR25
R_MC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
R_COUNTYCODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
R_COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
R_TOWNSHIPCODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
R_TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
R_MC_COUNTYCounty name in upper case for search help AD_MC_COUNTYCHAR25CHAR25
R_MC_TOWNSHIPTownship name in upper case for search help AD_MC_TWSHPCHAR25CHAR25

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!