SAP ABAP Table /MRSS/T_SGX_WD_DEMAND_DETAIL (Demand Detail)

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_WD_DEMAND_DETAIL	Table Relationship Diagram
Short Description	Demand Detail

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	Demand Details for output
2	.INCLUDE	☐				0	0	Demand details
3	ID_H	☐	/MRSS/T_DEM_H_ID	CHAR25	CHAR	25	0	Demand ID
4	HEADER	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
5	GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
6	ID	☐	/MRSS/T_DEM_I_ID	CHAR25	CHAR	25	0	Demand Item ID
7	DESCRIPTION	☐	/MRSS/T_DEM_I_DESCRIPTION	TEXT40	CHAR	40	0	Description of Demand Item
8	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
9	PLAN_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	PLAN_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	DURATION	☐	/MRSS/T_SGE_DURATION	MENG13	QUAN	13	3	Duration
12	DURATION_UNIT	☐	/MRSS/T_SGE_DURATION_UNIT	MEINS	UNIT	3	0	Unit for the Transaction Duration	*
13	TOTAL_WORK	☐	/MRSS/T_SGE_TOTAL_WORK	MENG13	QUAN	13	3	Total Work
14	TOTAL_WORK_UNIT	☐	/MRSS/T_SGE_TOTAL_WORK_UNIT	MEINS	UNIT	3	0	Unit of Total Work of Operation	*
15	UTIL	☐	/MRSS/T_UTILISATION	/MRSS/_UITLISATION	DEC	3	0	Resource Utilization
16	MULT_RES	☐	/MRSS/T_SGE_MULT_RES	/MRSS/_SGE_MULT_RES	NUMC	3	0	Number of Persons
17	REQ_PROFILE_ID	☐	/MRSS/T_REQUID	/MRSS/REQUID	CHAR	10	0	Profile key
18	PROBABILITY	☐	/MRSS/T_DEM_PROBABILITY	/MRSS/_DEM_PROBABILITY	CHAR	3	0	Demand Probability
19	REQUESTER_EMAIL	☐	/MRSS/T_REQ_EMAIL	TEXT120	CHAR	120	0	E-Mail Address of Requester
20	REQUESTER_UNAME	☐	/MRSS/T_REQ_UNAME	UNAME	CHAR	12	0	User Name of Requester
21	REQUESTER_FNAME	☐	/MRSS/T_REQ_NAME	/MRSS/_SGD_FULL_NAME	CHAR	132	0	Name of Requester
22	REQUESTER_TLNUM	☐	/MRSS/T_REQ_TLNUM	CHAR40	CHAR	40	0	Telephone Number of Requester
23	REMAIN_DUR	☐	/MRSS/T_SGE_REMAIN_DUR	MENG13	QUAN	13	3	Remaining Work of Operation
24	REMAIN_DUR_UNIT	☐	/MRSS/T_SGE_REMAIN_DUR_UNIT	MEINS	UNIT	3	0	Unit of Remaining Work of Operation	*
25	PLAN_STATUS	☐	/MRSS/T_SGE_PLAN_STATUS	/MRSS/_SGE_PLAN_STATUS	CHAR	2	0	Plan Status Information
26	NUM_ASS	☐	/MRSS/T_SGE_NUM_ASS		INT2	5	0	Number of Assignments for a Demand
27	NUM_RES	☐	/MRSS/T_SGE_NUM_RES		NUMC	3	0	Number of resource
28	LOCATION	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
29	DEM_TYPE	☐	/MRSS/T_DEM_TYPE_I		CHAR	4	0	Demand Item Category
30	FOUND_RESOURCES	☐	/MRSS/T_DEM_FOUND_RESOURCES		CHAR	200	0	Resources Found for Demand
31	PF_DATE	☐	/MRSS/T_SGU_BEGDA	DATUM	DATS	8	0	Start date
32	PF_TIME	☐	/MRSS/T_SGU_BEG_UZEIT	UZEIT	TIMS	6	0	Start Time
33	PT_DATE	☐	/MRSS/T_SGU_ENDDA	DATUM	DATS	8	0	End date
34	PT_TIME	☐	/MRSS/T_SGU_END_UZEIT	UZEIT	TIMS	6	0	End Time
35	ORG_UNIT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
36	PLAN_STATUS_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
37	PLAN_STATUS_ICON_DESC	☐	ICONQUICK	ICONTEXT	CHAR	30	0	Quickinfo for an icon
38	TOTAL_SOFTBOOK	☐	/MRSS/T_SGE_DURATION	MENG13	QUAN	13	3	Duration
39	TOTAL_REQUEST	☐	/MRSS/T_SGE_DURATION	MENG13	QUAN	13	3	Duration
40	STATUS_TAB	☐	/MRSS/T_STATUS_TAB		TTYP	0	0
41	CONFIDENTIAL	☐	/MRSS/T_DEM_IS_CONFIDENTIAL	/MRSS/_BOOLEAN	CHAR	1	0	Demand Confidentiality
42	CONF_DEM_AUTH	☐	/MRSS/T_CONF_DEM_AUTH	/MRSS/_BOOLEAN	CHAR	1	0	Confidential Demand Authorization
43	PRIORITY	☐	/MRSS/T_SGE_PRIORITY	/MRSS/_SGE_DEMAND_PRIORITY	CHAR	1	0	Priority of an Operation
44	RELEVANCE	☐	/MRSS/T_WL_ITEM_REL	/MRSS/_WL_ITEM_REL	CHAR	1	0	Relevance of an Item for the Planning Board
45	DISPO_FLG	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
46	HEADER_DESCRIPTION	☐	/MRSS/T_DEM_H_DESC	TEXT40	CHAR	40	0	Description of Complex Demand
47	.INCLUDE	☐				0	0
48	ADDRESS	☐	/MRSS/T_ADDRESS		STRU	0	0
49	ADDRESS_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
50	ADDRESS_KEY	☐	/MRSS/T_ADDRESS_KEY		CHAR	6	0	Key to display on UI for selection
51	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
52	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
53	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
54	CITY_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
55	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
56	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
57	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
58	SEC_ADDRESS	☐	/MRSS/T_BOOLEAN	/MRSS/_BOOLEAN	CHAR	1	0	Boolean Variable
59	ACTIVE	☐	/MRSS/T_SEC_ACTIVE	/MRSS/_BOOLEAN	CHAR	1	0	Activate secondary address
60	.INCLUDE	☐				0	0	Geographical Position in WGS84 Coordinates
61	LONGITUDE	☐	/MRSS/T_GEO_LONGITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Longitude
62	LATITUDE	☐	/MRSS/T_GEO_LATITUDE	/MRSS/_GEO_LONGITUDE	DEC	15	12	Geolocation Latitude
63	ALTITUDE	☐	/MRSS/T_GEO_ALTITUDE	/MRSS/_GEO_ALTITUDE	DEC	9	3	Geolocation Height
64	PRECISID	☐	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
65	SOURCE_ID	☐	/MRSS/T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
66	SOURCE_TSTMP	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
67	ADDRESS_TYPE	☐	/MRSS/T_ADDRESS_TYPE	/MRSS/ADDRESS_TYPE	CHAR	1	0	Address Type for MRS Addresses
68	VALID_FROM	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
69	VALID_TO	☐	ENDDATUM	DATUM	DATS	8	0	End Date
70	CHANGED_ON	☐	/MRSS/T_TIMESTAMP	TZNTSTMPS	DEC	15	0	Time Stamp (Date and Time)
71	ADDRESS_SOURCE	☐	/MRSS/T_ADDRESS_SOURCE	/MRSS/ADDRESS_SOURCE	NUMC	1	0	Source of Address
72	.INCLUDE	☐				0	0	Technical (Extended) Address
73	LOCATION	☐	/MRSS/T_ADDRESS_LOCATION	TEXT40	CHAR	40	0	Location for MRS Addresses
74	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
75	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
76	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
77	DEM_H_I_DESC	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
78	DEM_H_DESC	☐	/MRSS/T_DEM_H_DESC	TEXT40	CHAR	40	0	Description of Complex Demand
79	ATTRIBUTES	☐	/MRSS/T_FIELDNAME_VALUE_TAB		TTYP	0	0
80	DEMAND_TYPE	☐	/MRSS/T_DEMAND_TYPE	/MRSS/_DEMAND_TYPE	CHAR	2	0	Demand Type
81	CELLVARIANT	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
82	.INCLUDE	☐				0	0	Bundle Details for Demand ALV
83	BUNDLE_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
84	BUNDLE_ID	☐	/MRSS/T_BUNDLE_ID	/MRSS/_BUNDLE_ID	CHAR	10	0	Bundle ID
85	BUNDLE_DESCRIPTION	☐	/MRSS/T_SGE_BUNDLE_DESCRIPTION	CHAR40K	CHAR	40	0	Bundle Description
86	STATUS_TEXT	☐	/MRSS/T_SGU_DATA_LIST_STATUS	/MRSS/_SGU_DATA_LIST_STATUS	CHAR	80	0	Entry Status

History

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