ADR_LSMREF SAP (Transfer Structure RSADRLSM02 (Only Reference Fields)) Structure details

Dictionary Type: Structure
Description: Transfer Structure RSADRLSM02 (Only Reference Fields)




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




Structure field list including key, data, relationships and ABAP select examples

ADR_LSMREF 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 (Only Reference Fields)" 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_LSMREF TYPE ADR_LSMREF.

The ADR_LSMREF table consists of various fields, each holding specific information or linking keys about Transfer Structure RSADRLSM02 (Only Reference Fields) data available in SAP. These include R_COMMUCOD (Municipality key), R_REGION (STATE (State, Province, County)), R_TIMEZONE (Address time zone), R_TAXJURCD (Tax Jurisdiction).. 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: Cannot Be Enhanced


SAP ADR_LSMREF 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
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_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_LSMREF using ABAP code?

As ADR_LSMREF 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_LSMREF as there is no data to select.

How to access SAP table ADR_LSMREF

Within an ECC or HANA version of SAP you can also view further information about ADR_LSMREF 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!