WR01_SIT_ADDR3 SAP (WR01_SIT_ADDR3) Structure details

Dictionary Type: Structure
Description: WR01_SIT_ADDR3




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




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

WR01_SIT_ADDR3 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 "WR01_SIT_ADDR3" 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_WR01_SIT_ADDR3 TYPE WR01_SIT_ADDR3.

The WR01_SIT_ADDR3 table consists of various fields, each holding specific information or linking keys about WR01_SIT_ADDR3 data available in SAP. These include PERSNUMBER (Person number), DATE_FROM (Valid-from date - in current Release only 00010101 possible), DATE_TO (Valid-to date in current Release only 99991231 possible), SO_KEY (SAP-Office key).. 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 (Deep)


SAP WR01_SIT_ADDR3 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
ADDRNUMBERAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
PERSNUMBERPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
SO_KEYSAP-Office key AD_SO_KEYCHAR10ALPHAAD_SO_KEYADDRESS
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDING_CBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_CFloor in building AD_FLOORCHAR10TEXT10
ROOMNUM_CRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
ID_CODEShort name for correspondence AD_ID_CODECHAR10TEXT10
IH_MAILInt. mail postal code AD_IH_MAILCHAR10TEXT10
SORT1_C(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT2_C(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT_PHN_C(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
TITLE_PForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
NAME_FIRSTFirst name AD_NAMEFIRCHAR40TEXT40
NAME_LASTLast name AD_NAMELASCHAR40TEXT40
NAME2_PName of person at birth AD_NAME2_PCHAR40TEXT40
NAMEMIDDLEMiddle name or second forename of a person AD_NAMEMIDCHAR40TEXT40
NAME_LAST2Second surname of a person AD_NAMLAS2CHAR40TEXT40
NAME_TEXTFull Name of Person AD_NAMTEXTCHAR80TEXT80
CONVERTEDStatus of Field 'Full Name' NAME_TEXT AD_NAMCONVCHAR1AD_NAMCONV
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4Assigned to domainAD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4Assigned to domainAD_TITLE1
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4Assigned to domainAD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4Assigned to domainAD_PREFIX
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4Assigned to domainAD_TITLES
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
PROFESSIONProfession AD_PROFESSCHAR40TEXT40
SEXGender key AD_SEXCHAR1AD_SEX
LANGU_PLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
SORT1_PSearch Term 1 AD_SORT1ULCHAR20TEXT20
SORT2_PSearch Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN_P(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
PERSORIGINPersonal data source (key) AD_ORIGINPCHAR4TSAD6AD_ORIGIN
LANGU_CR_PAddress record creation original language AD_LANGUCRLANG1T002ISOLASPRAS
DEFLT_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
ADDR_COMP(not used) AD_ADDRCOMCHAR10ADRCALPHAAD_ADDRNUM
AD_COMP_HDFirst company address: internal ID if DB no. not yet issued AD_COMP_HDCHAR140TEXT140

Key field Non-key field



How do I retrieve data from SAP structure WR01_SIT_ADDR3 using ABAP code?

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

How to access SAP table WR01_SIT_ADDR3

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