SAP ABAP Table /MRSS/T_RES_DATA (Resource data)

Hierarchy

☛

MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
⤷

PM-WOC-MO (Application Component) Maintenance Orders
⤷

/MRSS/NW_INTERACTION (Package) Interaction Layer for MRS NW Add on

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_RES_DATA	Table Relationship Diagram
Short Description	Resource data

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RESOURCE_ID	/MRSS/T_RESOURCE_ID	CHAR12	CHAR	12	0	Resource ID
2	RESOURCE_GUID	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
3	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
4	FULL_NAME	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
5	FIRST_NAME	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
6	LAST_NAME	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
7	COMPANY_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	PERS_AREA	PERSA	PERSA	CHAR	4	0	Personnel Area	*
9	PERS_SUB_AREA	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
10	WORK_CENTER	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
11	USERID	SYUNAME	SYCHAR12	CHAR	12	0	User Name
12	ANRLT	ANRLT	TEXT15	CHAR	15	0	Long Text: Form of Address
13	COMMTYPES	/MRSS/T_RES_COMMTYPE_TAB		TTYP	0	0
14	ORG_UNIT	OBJEC		STRU	0	0
15	PLVAR	PLVAR	PLVAR	CHAR	2	0	Plan Version
16	OTYPE	OTYPE	OTYPE	CHAR	2	0	Object Type
17	OBJID	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
18	BEGDA	BEGDATUM	DATUM	DATS	8	0	Start Date
19	ENDDA	ENDDATUM	DATUM	DATS	8	0	End Date
20	ISTAT	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
21	HISTO	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
22	SHORT	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
23	STEXT	STEXT	TEXT40	CHAR	40	0	Object Name
24	REALO	REALO	CHAR45	CHAR	45	0	Extended Object ID
25	ORG_UNITS	OBJEC_T		TTYP	0	0
26	ADDRESS	/MRSS/T_ADDRESS		STRU	0	0
27	ADDRESS_GUID	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
28	ADDRESS_KEY	/MRSS/T_ADDRESS_KEY		CHAR	6	0	Key to display on UI for selection
29	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
30	HOUSE_NUM	AD_HSNM1	TEXT10	CHAR	10	0	House Number
31	CITY	AD_CITY1	TEXT40	CHAR	40	0	City
32	CITY_DISTRICT	AD_CITY2	TEXT40	CHAR	40	0	District
33	POST_CODE	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
35	REGION	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
36	SEC_ADDRESS	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
37	ACTIVE	/MRSS/T_SEC_ACTIVE	/MRSS/_BOOLEAN	CHAR	1	0	Activate secondary address
38	.INCLUDE				0	0	Geographical Position in WGS84 Coordinates
39	LONGITUDE	/MRSS/T_GEO_LONGITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Longitude
40	LATITUDE	/MRSS/T_GEO_LATITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Latitude
41	ALTITUDE	/MRSS/T_GEO_ALTITUDE	/MRSS/_GEO_ALTITUDE	DEC	9	3	Geolocation Height
42	PRECISID	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
43	SOURCE_ID	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
44	SOURCE_TSTMP	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
45	ADDRESS_TYPE	/MRSS/T_ADDRESS_TYPE	/MRSS/ADDRESS_TYPE	CHAR	1	0	Address Type for MRS Addresses
46	VALID_FROM	BEGDATUM	DATUM	DATS	8	0	Start Date
47	VALID_TO	ENDDATUM	DATUM	DATS	8	0	End Date
48	CHANGED_ON	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
49	ADDRESS_SOURCE	/MRSS/T_ADDRESS_SOURCE	/MRSS/ADDRESS_SOURCE	NUMC	1	0	Source of Address
50	.INCLUDE				0	0	Technical (Extended) Address
51	LOCATION	/MRSS/T_ADDRESS_LOCATION	TEXT40	CHAR	40	0	Location for MRS Addresses
52	BUILDING	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
53	FLOOR	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
54	ROOMNUMBER	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
55	ADDRESSES	/MRSS/T_ADDRESS_TAB		TTYP	0	0
56	TIME_ZONE	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
57	TIME_ZONE_INTERVAL	/MRSS/T_RES_TIME_ZONE_TAB		TTYP	0	0
58	COMMUNICATION	/MRSS/T_SGE_HRES_COMM_DATA_TAB		TTYP	0	0
59	MOTPR	/MRSS/T_SGE_R3_RES_MOTPR_TAB		TTYP	0	0
60	USER_ADDRESS	BAPIADDR3		STRU	0	0
61	PERS_NO	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
62	ADDR_NO	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
63	TITLE_P	AD_TITLETX	TEXT30	CHAR	30	0	Title text
64	FIRSTNAME	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
65	LASTNAME	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
66	BIRTH_NAME	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
67	MIDDLENAME	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
68	SECONDNAME	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
69	FULLNAME	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
70	FULLNAME_X	AD_NAMCONV	AD_NAMCONV	CHAR	1	0	Status of Field 'Full Name' NAME_TEXT
71	TITLE_ACA1	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
72	TITLE_ACA2	AD_TITLE2T	TEXT20	CHAR	20	0	2nd academic title: written form
73	PREFIX1	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
74	PREFIX2	AD_PREFX2T	TEXT20	CHAR	20	0	2nd name prefix
75	TITLE_SPPL	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
76	NICKNAME	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
77	INITIALS	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
78	NAMEFORMAT	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format
79	NAMCOUNTRY	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule
80	LANGU_P	SPRAS	SPRAS	LANG	1	0	Language Key
81	LANGUP_ISO	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
82	SORT1_P	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
83	SORT2_P	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
84	DEPARTMENT	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
85	FUNCTION	AD_FNCTN	TEXT40	CHAR	40	0	Function
86	BUILDING_P	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
87	FLOOR_P	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
88	ROOM_NO_P	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
89	INITS_SIG	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
90	INHOUSE_ML	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
91	COMM_TYPE	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
92	TITLE	AD_TITLETX	TEXT30	CHAR	30	0	Title text
93	NAME	AD_NAME1	TEXT40	CHAR	40	0	Name 1
94	NAME_2	AD_NAME2	TEXT40	CHAR	40	0	Name 2
95	NAME_3	AD_NAME3	TEXT40	CHAR	40	0	Name 3
96	NAME_4	AD_NAME4	TEXT40	CHAR	40	0	Name 4
97	C_O_NAME	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
98	CITY	AD_CITY1	TEXT40	CHAR	40	0	City
99	DISTRICT	AD_CITY2	TEXT40	CHAR	40	0	District
100	CITY_NO	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
101	DISTRCT_NO	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
102	CHCKSTATUS	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
103	POSTL_COD1	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
104	POSTL_COD2	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
105	POSTL_COD3	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
106	PO_BOX	AD_POBX	CHAR10	CHAR	10	0	PO Box
107	PO_BOX_CIT	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
108	PBOXCIT_NO	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
109	DELIV_DIS	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
110	TRANSPZONE	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
111	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
112	STREET_NO	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
113	STR_ABBR	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
114	HOUSE_NO	AD_HSNM1	TEXT10	CHAR	10	0	House Number
115	HOUSE_NO2	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
116	STR_SUPPL1	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
117	STR_SUPPL2	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
118	STR_SUPPL3	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
119	LOCATION	AD_LCTN	TEXT40	CHAR	40	0	Street 5
120	BUILDING	AD_BLD_OLD	TEXT10	CHAR	10	0	old: building (no. or abbreviation)
121	FLOOR	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
122	ROOM_NO	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
123	COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
124	COUNTRYISO	INTCA	INTCA	CHAR	2	0	Country ISO code
125	LANGU	SPRAS	SPRAS	LANG	1	0	Language Key
126	LANGU_ISO	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
127	REGION	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
128	SORT1	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
129	SORT2	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
130	TIME_ZONE	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
131	TAXJURCODE	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
132	ADR_NOTES	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
133	TEL1_NUMBR	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
134	TEL1_EXT	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
135	FAX_NUMBER	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
136	FAX_EXTENS	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
137	E_MAIL	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
138	BUILD_LONG	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
139	REGIOGROUP	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
140	HOME_CITY	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
141	HOMECITYNO	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
142	PCODE1_EXT	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
143	PCODE2_EXT	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
144	PCODE3_EXT	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
145	PO_W_O_NO	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
146	PO_BOX_REG	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
147	POBOX_CTRY	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
148	PO_CTRYISO	INTCA	INTCA	CHAR	2	0	Country ISO code
149	DONT_USE_S	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
150	DONT_USE_P	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
151	HOUSE_NO3	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
152	LANGU_CR_P	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
153	LANGUCPISO	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
154	PO_BOX_LOBBY	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
155	DELI_SERV_TYPE	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
156	DELI_SERV_NUMBER	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
157	COUNTY_CODE	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
158	COUNTY	AD_COUNTY	TEXT40	CHAR	40	0	County
159	TOWNSHIP_CODE	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
160	TOWNSHIP	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
161	.INCLUDE				0	0	Notes for resources
162	CREATION_DATE	TDFDATE	DATUM	DATS	8	0	Date created
163	CREATED_BY	TDFUSER	TDUSER	CHAR	12	0	Created by
164	NOTE	/MRSS/T_STRING		STRG	0	0	String