SAP ABAP Table /MRSS/T_SGX_RES_ADDRESS (Structure to store the resource adresses)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ CA-MRS (Application Component) SAP Multiresource Scheduling
     ⤷ /MRSS/SGX (Package) MRS Planning Board Extended Web Interface

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_SGX_RES_ADDRESS	Table Relationship Diagram
Short Description	Structure to store the resource adresses

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Structure to store the adresses to GEO code
2	ADDRESS_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
3	ADDRESS_KEY	☐	/MRSS/T_ADDRESS_KEY		CHAR	6	0	Key to display on UI for selection
4	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
5	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
6	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
7	CITY_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
8	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
10	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
11	SEC_ADDRESS	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
12	ACTIVE	☐	/MRSS/T_SEC_ACTIVE	/MRSS/_BOOLEAN	CHAR	1	0	Activate secondary address
13	.INCLUDE	☐				0	0	Geographical Position in WGS84 Coordinates
14	LONGITUDE	☐	/MRSS/T_GEO_LONGITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Longitude
15	LATITUDE	☐	/MRSS/T_GEO_LATITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Latitude
16	ALTITUDE	☐	/MRSS/T_GEO_ALTITUDE	/MRSS/_GEO_ALTITUDE	DEC	9	3	Geolocation Height
17	PRECISID	☐	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
18	SOURCE_ID	☐	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
19	SOURCE_TSTMP	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
20	ADDRESS_TYPE	☐	/MRSS/T_ADDRESS_TYPE	/MRSS/ADDRESS_TYPE	CHAR	1	0	Address Type for MRS Addresses
21	VALID_FROM	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
22	VALID_TO	☐	ENDDATUM	DATUM	DATS	8	0	End Date
23	CHANGED_ON	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
24	ADDRESS_SOURCE	☐	/MRSS/T_ADDRESS_SOURCE	/MRSS/ADDRESS_SOURCE	NUMC	1	0	Source of Address
25	.INCLUDE	☐				0	0	Technical (Extended) Address
26	LOCATION	☐	/MRSS/T_ADDRESS_LOCATION	TEXT40	CHAR	40	0	Location for MRS Addresses
27	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
28	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
29	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
30	ADDRESS_CATEGORY	☐	/MRSS/T_ADDRESS_CATEGORY	/MRSS/_ADDRESS_CATEGORY	CHAR	1	0	Address Category for MRS Addresses

History

Last changed by/on	SAP	20141109
SAP Release Created in	800