SAP ABAP Table /MRSS/T_SQP_WEB_USR_DETAILS_C (Resource details)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/SQP (Package) MRS Qualifications: Profiles

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_SQP_WEB_USR_DETAILS_C	Table Relationship Diagram
Short Description	Resource details

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	Resource Data for the Interface
2	ID	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
3	TEXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
4	TYPE	☐	/MRSS/T_RESOURCE_TYPE	/MRSS/_RESOURCE_TYPE	CHAR	2	0	Type of Resource
5	REL	☐	/MRSS/T_RESOURCE_REL	/MRSS/_RESOURCE_REL	CHAR	1	0	Relevance of a Resource for the Planning Board
6	EDIT_MODE	☐	/MRSS/T_EDIT_MODE	/MRSS/_EDIT_MODE	CHAR	1	0	Processing Mode
7	RESOURCE_ID	☐	/MRSS/T_RESOURCE_ID	CHAR12	CHAR	12	0	Resource ID
8	RESOURCE_NAME	☐	/MRSS/T_SGE_NAME	TEXT40	CHAR	40	0	First and Last Names
9	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
10	USER_ID	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
11	PERS_NO	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
12	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
13	ORG_UNIT	☐	OBJEC		STRU	0	0
14	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
15	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
16	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
17	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
18	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
19	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
20	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
21	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
22	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
23	REALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
24	ANONYMOUS_ID	☐	/MRSS/T_ANONYMOUS_ID	CHAR20	CHAR	20	0	Anonymous resource ID
25	ANONYMOUS_REQUIRED	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
26	WORK_CENTER	☐	/MRSS/T_NODE_ID	NUM08	NUMC	8	0	Node Id
27	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
28	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
29	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
30	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
31	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
32	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
33	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
34	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
35	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
36	.INCLUDE	☐				0	0	Notes for resources
37	CREATION_DATE	☐	TDFDATE	DATUM	DATS	8	0	Date created
38	CREATED_BY	☐	TDFUSER	TDUSER	CHAR	12	0	Created by
39	NOTE	☐	/MRSS/T_STRING		STRG	0	0	String
40	COMMTYPES	☐	/MRSS/T_RES_COMMTYPE_TAB		TTYP	0	0

History

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