SAP ABAP Table CRM_MRS_T_DEM_H_EXT (Header Attributes in External Representation)

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_DEM_H_EXT	Table Relationship Diagram
Short Description	Header Attributes in External Representation

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	☐	GUID		RAW	16	0	Globally Unique Identifier
4	HEADER_EXT	☐	CRM_MRS_T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
5	PARENT_EXT	☐	CRM_MRS_T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
6	.INCLUDE	☐				0	0	Attribute des komplexen Bedarfes
7	HEADER	☐	CRM_MRS_T_GUID	SYSUUID	RAW	16	0	GUID
8	PARENT	☐	CRM_MRS_T_GUID	SYSUUID	RAW	16	0	GUID
9	DEM_TYPE	☐	CRM_MRS_T_DEM_TYPE	CRM_MRS_DEM_TYPE	CHAR	4	0	Demand Type
10	ID	☐	CRM_MRS_T_DEM_H_ID	CHAR25	CHAR	25	0	ID of demand
11	DESCRIPTION	☐	CRM_MRS_T_DEM_H_DESC	TEXT40	CHAR	40	0	Description of the Complete Demand
12	BASIC_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	BASIC_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	SCHED_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
15	SCHED_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
16	ACTUAL_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	ACTUAL_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	.INCLUDE	☐				0	0	Object
19	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
20	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
21	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
22	STAT_ERR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
23	STAT_COMPL	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
24	PROBABILITY	☐	CRM_MRSS_T_DEM_PROBABILITY	CRM_MRSS_DEM_PROBABILITY	CHAR	3	0	Probability of a demand
25	ORIG_ORDER_TYPE	☐	CRM_MRS_T_DEM_ORDER_TYPE	AUFART	CHAR	4	0	Type of underlying order or operation	*
26	PLANT	☐	CRM_MRS_T_PM_PLANT	WERKS	CHAR	4	0	Maintenance planning plant	*
27	ACTIVITY_TYPE	☐	CRM_MRS_T_PM_ACTIVITY_TYPE	CRM_MRSS_DEM_PM_ACTIVITY_TYPE	CHAR	3	0	Maintenance activity type (header)
28	CREATED_BY	☐	CRM_MRS_T_DEM_CREATED_BY	USNAM	CHAR	12	0	Created By
29	CREATED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	CHANGED_BY	☐	CRM_MRS_T_DEM_CHANGED_BY	USNAM	CHAR	12	0	Last Changed By
31	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
32	WORKCENTER_ID	☐	CRM_MRS_T_DEM_WORKCENTER_ID	NUM08	NUMC	8	0	Work center ID of operation or item
33	WORKCENTER_TYPE	☐	CRM_MRS_T_DEM_WORKCENTER_TYPE	CRM_MRS_CR_OBJTY	CHAR	2	0	Work center type of operation or item
34	WORKCENTER_PLANT	☐	CRM_MRS_T_DEM_WORKCENTER_PLANT	WERKS	CHAR	4	0	Plant of Work Center	*
35	SCHEDULING_TYPE	☐	CRM_MRS_T_SCHEDULING_TYPE		CHAR	1	0	Scheduling Type for Demand

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_MRS_T_DEM_H_EXT	OTYPE	T778O	OTYPE
2	CRM_MRS_T_DEM_H_EXT	PLVAR	T778P	PLVAR

History

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