ADR_LSMREF SAP (Transfer Structure RSADRLSM02 (Only Reference Fields)) Structure details
Description: Transfer Structure RSADRLSM02 (Only Reference Fields)
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_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_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_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 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