SAP ABAP Table /MRSS/D_POT_LINK (links Service order <-> Capacity Pot)

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ CA-MRS (Application Component) SAP Multiresource Scheduling
     ⤷ /MRSS/POT_ENGINE (Package) Capacity Pots Engine

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/MRSS/D_POT_LINK	Table Relationship Diagram
Short Description	links Service order <-> Capacity Pot

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☑	/MRSS/T_POT_GUID	SYSUUID	RAW	16	0	GUID of Capacity Pot Instance
3	.INCLUDE	☑				0	0	Structure for External Key
4	LOGSYS	☑	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
5	KEY_EXT	☑	/MRSS/T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
6	GUID_MD_ATTR	☐	/MRSS/T_POT_GUID_MD_ATTR	SYSUUID	RAW	16	0	GUID of Capacity Pot Master Data Attributes	/MRSS/D_POT_MD
7	DATE_FROM_TS	☐	/MRSS/T_POT_DATE_FROM_TS	BCOS_TSTMP	DEC	15	0	Data From Timestamp
8	DATE_TO_TS	☐	/MRSS/T_POT_DATE_TO_TS	BCOS_TSTMP	DEC	15	0	Data To Timestamp
9	SLA_PRIORITY	☐	/MRSS/T_POT_PRIORITY	/MRSS/_POT_PRIORITY	CHAR	2	0	SLA Threshold Priority	*
10	DEMAND_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
11	ASSIGN_GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
12	.INCLUDE	☐				0	0	Link Table: Job Capacity Information
13	JOB_CAPA_PLAN	☐	/MRSS/T_POT_JOB_CAPA_PLAN	/MRSS/_POT_CAPACITY	QUAN	12	2	Planned Job Capacity
14	JOB_CAPA_P_UNIT	☐	/MRSS/T_POT_JOB_CAPA_UNIT_PLA	MEINS	UNIT	3	0	Unit of Job Capacity Planned	*
15	JOB_CAPA_CALC	☐	/MRSS/T_POT_JOB_CAPA_CALC	/MRSS/POT_CAPACITY	QUAN	12	2	Job Capacity Calculated
16	JOB_CAPA_C_UNIT	☐	/MRSS/T_POT_JOB_CAPA_UNIT_CAL	MEINS	UNIT	3	0	Unit of Job Capacity Calculated	*
17	JOB_CAPA_ACT	☐	/MRSS/T_POT_JOB_CAPA_ACT	/MRSS/POT_CAPACITY	QUAN	12	2	Job Capacity Actual
18	JOB_CAPA_A_UNIT	☐	/MRSS/T_POT_JOB_CAPA_UNIT_ACT	MEINS	UNIT	3	0	Unit of Job Capacity Actual	*
19	.INCLUDE	☐				0	0	Link Table: Travel Time Information
20	TRAVEL_TIME_PLAN	☐	/MRSS/T_POT_TRAVEL_TIME_PLAN	/MRSS/POT_TRAVEL_TIME	QUAN	7	2	Travel Time Planned
21	TRAVEL_TIME_P_UN	☐	/MRSS/POT_TRAVEL_TIME_UNIT_PLA	MEINS	UNIT	3	0	Unit of Travel Time Planned	*
22	TRAVEL_TIME_CALC	☐	/MRSS/T_POT_TRAVEL_TIME_CALC	/MRSS/POT_TRAVEL_TIME	QUAN	7	2	Travel Time Calculated
23	TRAVEL_TIME_C_UN	☐	/MRSS/POT_TRAVEL_TIME_UNIT_CAL	MEINS	UNIT	3	0	Unit of Travel Time Calculated	*
24	TRAVEL_TIME_ACT	☐	/MRSS/T_POT_TRAVEL_TIME_ACT	/MRSS/POT_TRAVEL_TIME	QUAN	7	2	Travel Time Actual
25	TRAVEL_TIME_A_UN	☐	/MRSS/POT_TRAVEL_TIME_UNIT_ACT	MEINS	UNIT	3	0	Unit of Travel Time Actual	*
26	TRV_TO_BEG_CALC	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27	TRV_TO_END_CALC	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
28	TRV_FRM_BEG_CALC	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
29	TRV_FRM_END_CALC	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	TRV_TO_BEG_ACT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
31	TRV_TO_END_ACT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
32	TRV_FRM_BEG_ACT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
33	TRV_FRM_END_ACT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
34	.INCLUDE	☐				0	0	Capacity Pot: Administrative Data
35	CREATED_BY	☐	/MRSS/T_POT_CREATE_BY	USNAM	CHAR	12	0	User who created Capacity Pot
36	CREATED_ON	☐	/MRSS/T_POT_CREATED_ON	BCOS_TSTMP	DEC	15	0	Creation Timestamp
37	CHANGED_BY	☐	/MRSS/T_POT_CHANGED_BY	USNAM	CHAR	12	0	User who changed Capacity Pot
38	CHANGED_ON	☐	/MRSS/T_POT_CHANGED_ON	BCOS_TSTMP	DEC	15	0	Change Timestamp

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/MRSS/D_POT_LINK	GUID_MD_ATTR	/MRSS/D_POT_MD	GUID_MD_ATTR	KEY	1	CN

History

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