SAP ABAP Table CRM_MRS_T_NW_DEM_ITEM_STR_WRK (Structure representation of a 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_WRK	Table Relationship Diagram
Short Description	Structure representation of a demand item

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