SAP ABAP Table EAMS_S_SP_ORD_OPER_PRT (Business Object Order - Operation Production Resources/Tools)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM (Application Component) Plant Maintenance
     ⤷ EAMS_MDP_MISC (Package) Miscellaneous for Master Data Provider

Basic Data

Table Category	INTTAB	Structure
Structure	EAMS_S_SP_ORD_OPER_PRT	Table Relationship Diagram
Short Description	Business Object Order - Operation Production Resources/Tools

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	Business Object Order Operation - Identification
2	EAMS_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
3	EAMS_VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
4	EAMS_UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
5	FHMAR	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	*
6	EAMS_PRTNR	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
7	.INCLUDE	☐				0	0	EAMS Structure of Production Resources/Tools for Order
8	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
9	ITEM_NO_OF_PRODUCTION_RESOURCE	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
10	PRT_PLANT	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	*
11	PRT_CATEGORY	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	*
12	PRT_NUMBER	☐	FHMNR	FHMNR	CHAR	33	0	Production resource/tool number
13	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
14	MISCELLANEOUS	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
15	DOCUMENT_TYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
16	DOCUMENT_NUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
17	DOCUMENT_PART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
18	DOCUMENT_VERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
19	EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
20	STD_TEXT_KEY	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
21	DESCRIPTION	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
22	CTRL_KEY	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
23	START_REF_DATE	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	*
24	START_OFFSET	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
25	START_OFFSET_UNIT	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	*
26	START_OFFSET_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
27	END_REF_DATE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	*
28	END_OFFSET	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
29	END_OFFSET_UNIT	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	*
30	END_OFFSET_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
31	PRT_MEASURE_UNIT	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	*
32	PRT_MEASURE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
33	STD_VALUE_FOR_PRT_QTY	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
34	FORMULA_TOT_QTY	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
35	STD_USAGE_VALUE_FOR_PRT	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
36	PRT_USAGE_VALUE_UNIT	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
37	PRT_USAGE_VALUE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
38	FORMULA_TOT_USAGE	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
39	PRT_USAGE_QUANTITY_SUM	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
40	PRT_USAGE_QUANTITY_SUM_UNIT	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	*
41	PRT_USAGE_QUANTITY_SUM_UN_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
42	PRT_USAGE_VALUE_SUM	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
43	PRT_USAGE_VALUE_SUM_UNIT	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	*
44	PRT_USAGE_VALUE_SUM_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
45	PRT_MEASUREMENT_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	*
46	PRT_MEASUREMENT_UNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
47	PRT_MEASUREMENT_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
48	PRT_ACTUAL_START_DATE	☐	CF_ISFHD	DATUM	DATS	8	0	Actual start (date) of PRT usage
49	PRT_ACTUAL_START_TIME	☐	CF_ISFHZ	UZEIT	TIMS	6	0	Actual start (time) of PRT usage
50	PRT_ACTUAL_FINISH_DATE	☐	CF_IEFHD	DATUM	DATS	8	0	Actual finish (date) of PRT usage
51	PRT_ACTUAL_FINISH_TIME	☐	CF_IEFHZ	UZEIT	TIMS	6	0	Actual finish (time) of PRT usage
52	PRT_STATUS	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
53	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
54	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
55	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
56	MAT_FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
57	MIS_FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
58	EQU_FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
59	DOC_FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
60	FAKTX	☐	FAKTX	TEXT40	CHAR	40	0	Language-dependent description of the PRT category
61	FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
62	EAMS_PRT_USAGE_IND_START	☐	EAMS_PRT_USAGE_IND_START	EAMS_PRT_USAGE_IND	CHAR	1	0	Reference Date for Start of Production Resource/Tool Usage
63	EAMS_PRT_USAGE_IND_FINISH	☐	EAMS_PRT_USAGE_IND_FINISH	EAMS_PRT_USAGE_IND	CHAR	1	0	Reference Date for Finish of Production Resource/Tool Usage
64	PLANT_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
65	USA_VAL_UNIT_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
66	DOCUMENT_TYPE_TXT	☐	DARTXT	TEXT20	CHAR	20	0	Description of Document Type
67	CTRL_KEY_TXT	☐	STFTXT	TEXT40	CHAR	40	0	Text for the production resources/tools control key
68	FORMULA_QTY_TXT	☐	AP_FRMLTXT	TEXT20	CHAR	20	0	Short text for the formula
69	FORMULA_USAGE_TXT	☐	AP_FRMLTXT	TEXT20	CHAR	20	0	Short text for the formula
70	REMAIN_USAGE_QUANTITY_UNIT_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
71	START_OFFSET_UNIT_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
72	END_OFFSET_UNIT_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
73	.INCLU--AP	☐				0	0	work safety data for SP order op. PRT
74	.INCLUDE	☐				0	0	Safety Data for One Object
75	SAFETY_CHAR	☐	EAMWS_SAFETY_CHARACTERISTIC	EAMWS_SAFETY_CHARACTERISTIC	CHAR	1	0	Safety Relevance/Action	EAMWS_SAF_CHAR
76	PRT_IND	☐	EAMWS_PRTKZ	CHAR1	CHAR	1	0	Object Is a Production Resource/Tool

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EAMS_S_SP_ORD_OPER_PRT	CTRL_KEY	TCF10	STEUF
2	EAMS_S_SP_ORD_OPER_PRT	DOCUMENT_NUMBER	DRAW	DOKNR
3	EAMS_S_SP_ORD_OPER_PRT	DOCUMENT_TYPE	TDWA	DOKAR
4	EAMS_S_SP_ORD_OPER_PRT	FORMULA_TOT_QTY	TC25	IDENT	KEY
5	EAMS_S_SP_ORD_OPER_PRT	FORMULA_TOT_USAGE	TC25	IDENT	KEY
6	EAMS_S_SP_ORD_OPER_PRT	PRT_USAGE_VALUE_UNIT	T006	MSEHI
7	EAMS_S_SP_ORD_OPER_PRT	SAFETY_CHAR	EAMWS_SAF_CHAR	SAFETY_CHAR	KEY	1	CN
8	EAMS_S_SP_ORD_OPER_PRT	STD_TEXT_KEY	T435	VLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in	605