SAP ABAP Table CRM_MRS_T_NW_DEM_ITEM_STR (Structure Representation of Demand Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV (Application Component) Service Resource Planning
     ⤷ CRM_WFD_MRS (Package) CRM MRS Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_MRS_T_NW_DEM_ITEM_STR	Table Relationship Diagram
Short Description	Structure Representation of Demand Item

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	KEY_EXT	☐	CRM_MRS_T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
2	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
3	GUID	☐	CRM_MRS_T_GUID	SYSUUID	RAW	16	0	GUID
4	ADM	☐	CRM_MRS_T_DEM_ADM_EXT		STRU	0	0
5	PARENT_EXT	☐	CHAR60	CHAR60	CHAR	60	0	Char 60
6	HEADER_EXT	☐	CHAR60	CHAR60	CHAR	60	0	Char 60
7	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
8	DEM_TYPE_I	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category
9	ID	☐	CHAR25	CHAR25	CHAR	25	0	User field for cluster PC (national)
10	SUBID	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
11	DESCRIPTION	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
12	DISPO_FLG	☐	CRM_MRS_T_DISPO_FLG	CRM_MRS_DISPO_FLG	CHAR	1	0	MRS:Planning Relevant ?
13	CAPA_FLG	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
14	STAT_COMPL	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
15	STAT_COMPL_FINAL	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
16	IS_COPY_FROM	☐	GUID		RAW	16	0	Globally Unique Identifier
17	IS_SPLIT_FROM	☐	GUID		RAW	16	0	Globally Unique Identifier
18	ORIG_ITEM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category
19	HAS_SUCCESSOR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
20	WORKCENTER_ID	☐	CRM_MRS_T_DEM_WORKCENTER_ID	NUM08	NUMC	8	0	Work center ID of operation or item
21	WORKCENTER_TYPE	☐	CRM_MRS_T_DEM_WORKCENTER_TYPE	CRM_MRS_CR_OBJTY	CHAR	2	0	Work center type of operation or item
22	WORKCENTER_PLANT	☐	CRM_MRS_T_DEM_WORKCENTER_PLANT	WERKS	CHAR	4	0	Plant of Work Center
23	WORKCENTER_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
24	ORGUNIT_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
25	PARENT	☐	GUID		RAW	16	0	Globally Unique Identifier
26	HEADER	☐	GUID		RAW	16	0	Globally Unique Identifier
27	CREATED_BY	☐	CREATED_BY	USNAM	CHAR	12	0	Created by (User)
28	CREATED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
29	CHANGED_BY	☐	CHANGED_BY	USNAM	CHAR	12	0	Changed by (User)
30	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
31	PLR	☐	CRM_MRS_T_DEM_PLR		STRU	0	0
32	.INCLUDE	☐				0	0	Object
33	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
34	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
35	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
36	VAL_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	VAL_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	PLAN_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
39	PLAN_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
40	EARL_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
41	LAT_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
42	EARL_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
43	LAT_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
44	SCHED_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
45	SCHED_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
46	DURATION	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
47	DURATION_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
48	TOTAL_WORK	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
49	TOTAL_WORK_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
50	UTIL	☐	CRM_MRS_T_UITLISATION	CRM_MRS_UITLISATION	DEC	3	0	Resource Utilization
51	MULT_RES	☐	CRM_MRS_T_SGE_MULT_RES	CRM_MRS_SGE_MULT_RES	NUMC	3	0	CRM_MRS_T_SGE_MULT_RES
52	STAT_REL	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
53	STRATEGY	☐	CRM_MRS_T_SCHEDULE_STRAT	CHAR10	CHAR	10	0	Scheduling strategy
54	PRE_ASSMT	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
55	IS_CAPACITIVE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
56	IS_FIXED_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
57	IS_DESIRED_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
58	IS_ARRANGE_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
59	IS_RESOURCE_FIX	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
60	REQ_PROFILE_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
61	REQ_PROFILE_ID	☐	CRM_MRS_T_REQUID	CHAR10	CHAR	10	0	Profile key
62	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant
63	ACTIVITY_TYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
64	TIME_RULE_ID	☐	CRM_MRS_T_TIME_RULE_ID	TEXT25	CHAR	25	0	Time Rule Id
65	RESTR_START_TYPE	☐	CRM_MRS_T_DEM_RESTRICT_START	CRM_MRS_DEM_RESTRICT_START	CHAR	1	0	Demand Start Restriction
66	RESTR_END_TYPE	☐	CRM_MRS_T_DEM_RESTRICT_END	CRM_MRS_DEM_RESTRICT_END	CHAR	1	0	Demand End Restriction
67	RESTRICT_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
68	RESTRICT_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
69	TEAM_PLANNING	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
70	PLRS	☐	CRM_MRS_T_DEM_PLRS		STRU	0	0
71	PRIORITY	☐	CRMTPRIORITY	SC_PRIO	NUMC	1	0	Activity Priority
72	MODEL	☐	CRM_MRS_T_WL_MODEL	TEXT40	CHAR	40	0	Model
73	BEG_SLA	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
74	END_SLA	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
75	INFO	☐	CRM_MRS_T_DEM_INFO		STRU	0	0
76	PARTNER_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
77	PRODUCT	☐	CRM_MRS_T_ORDERED_PROD	CRM_MRS_ORDERED_PROD	CHAR	54	0	Product Name Entered
78	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
79	PROBABILITY	☐	CRM_MRS_T_DEM_PROBABILITY	CRM_MRS_DEM_PROBABILITY	CHAR	3	0	Order probability
80	SUPERVISOR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
81	SUPERVISOR_NO	☐	CRM_MRS_T_DEM_SUPERVISOR_NO		NUMC	3	0	Number of Site Supervisors for Demand
82	FOUND_RESOURCES	☐	CRM_MRS_T_DEM_FOUND_RESOURCES		CHAR	200	0	Resources Found for Demand
83	AUTOMATIC_ASGN	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
84	SCHED_INDICATOR	☐	CRM_MRS_T_SCHED_INDICATOR	CRM_MRS_SCHED_INDICATOR	CHAR	1	0	Scheduling Indicator (Automatic Scheduling & Self Planning)
85	SALES_ORG	☐	CCMVKORG	CHAR4	CHAR	4	0	sales organization
86	REQUESTER_EMAIL	☐	CRM_MRS_T_REQ_EMAIL	TEXT120	CHAR	120	0	E-Mail Address of Requester
87	REQUESTER_UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
88	REQUESTER_FNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
89	REQUESTER_TLNUM	☐	CRM_MRS_T_REQ_TLNUM	CHAR40	CHAR	40	0	Telephone Number of Requester
90	DURATN_SRC	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
91	DURATN_SRC_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
92	TIME_CALC_CAPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
93	STATUS_GRP_ID	☐	CRM_MRS_T_STATUS_GROUP_ID	CHAR10	CHAR	10	0	ID of status group
94	REF_GUID_H	☐	GUID		RAW	16	0	Globally Unique Identifier
95	REF_GUID_I	☐	GUID		RAW	16	0	Globally Unique Identifier
96	REF_EXT_ID	☐	CRM_MRS_T_SGD_CGPL_EXTID	CRM_MRS_SGD_CGPL_EXTID	CHAR	24	0	Project Planning: External Identifier of an Element
97	BCR_TARGET	☐	CRM_MRS_T_RM_BROADCAST_TARGET	CHAR5	CHAR	5	0	Broadcast Targets
98	SOURCE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
99	BCRIDTY	☐	CRM_MRS_T_RM_BCRIDTY	CRM_MRS_RM_BCRIDTY	CHAR	1	0	Region Type
100	SEARCH_PARTY_ID	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
101	VERSION_NO	☐	CRM_MRS_T_RM_MDCI_VERSION	CHAR10	CHAR	10	0	Version Number
102	TOOL	☐	CRM_MRS_T_DEM_TOOL		STRU	0	0
103	PRODUCT	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
104	PRODUCT_KIND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
105	CTRL_KEY	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
106	MATE	☐	CRM_MRS_T_DEM_MATE		STRU	0	0
107	AVAIL_DATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
108	STATUS_TAB	☐	CRM_MRS_T_STATUS_TAB		TTYP	0	0
109	PARTNER_TAB	☐	CRM_MRS_T_PARTNER_TAB		TTYP	0	0
110	ADDITIONAL_ATTR	☐	CRM_MRS_T_DEM_ADD_ATTR		STRU	0	0
111	REMAIN_DUR	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
112	REMAIN_DUR_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
113	PLAN_STATUS	☐	CRM_MRS_T_SGE_PLAN_STATUS	CRM_MRS_SGE_PLAN_STATUS	CHAR	2	0	Plan Status for Demand
114	NUM_ASS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
115	ADDRESS	☐	CRM_MRS_T_ADDRESS		STRU	0	0
116	ADDRESS_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
117	ADDRESS_KEY	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
118	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
119	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
120	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
121	CITY_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
122	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
123	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
124	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
125	SEC_ADDRESS	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
126	ACTIVE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
127	.INCLUDE	☐				0	0	Geographical Position in WGS84 Coordinates
128	LONGITUDE	☐	CRM_MRS_T_GEO_LONGITUDE	CRM_MRS_GEO_LONGITUDE	DEC	15	12	Geo location longitude and latitude data format
129	LATITUDE	☐	CRM_MRS_T_GEO_LATITUDE	CRM_MRS_GEO_LONGITUDE	DEC	15	12	Geolocation Latitude
130	ALTITUDE	☐	CRM_MRS_T_GEO_ALTITUDE	CRM_MRS_GEO_ALTITUDE	DEC	9	3	Geolocation Height
131	PRECISID	☐	CRM_MRS_T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
132	SOURCE_ID	☐	CRM_MRS_T_GEO_SOURCE_ID	CHAR4	CHAR	4	0	Geolocation Data Source ID/Geocoder ID
133	SOURCE_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
134	QUALIFICATIONS	☐	CRM_MRS_T_QUALIF_REQ_WFM_TAB		TTYP	0	0
135	SERVICE_PRODUCTS	☐	CRM_MRS_T_SERVICE_PRODUCT		TTYP	0	0
136	TECHNICAL_OBJECTS_TAB	☐	CRM_MRS_T_TECH_OBJECT_TAB		TTYP	0	0

History

Last changed by/on	SAP	20140802
SAP Release Created in	702