SAP ABAP Table EAMS_S_SP_ORD_OPER_PRT_DET (EAMS Structure of Production Resources/Tools for Order)

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_DET	Table Relationship Diagram
Short Description	EAMS Structure of Production Resources/Tools for Order

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	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
2	ITEM_NO_OF_PRODUCTION_RESOURCE	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
3	PRT_PLANT	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	*
4	PRT_CATEGORY	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	*
5	PRT_NUMBER	☐	FHMNR	FHMNR	CHAR	33	0	Production resource/tool number
6	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	MISCELLANEOUS	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
8	DOCUMENT_TYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
9	DOCUMENT_NUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
10	DOCUMENT_PART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
11	DOCUMENT_VERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
12	EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
13	STD_TEXT_KEY	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
14	DESCRIPTION	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
15	CTRL_KEY	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
16	START_REF_DATE	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	*
17	START_OFFSET	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
18	START_OFFSET_UNIT	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	*
19	START_OFFSET_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
20	END_REF_DATE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	*
21	END_OFFSET	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
22	END_OFFSET_UNIT	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	*
23	END_OFFSET_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
24	PRT_MEASURE_UNIT	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	*
25	PRT_MEASURE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
26	STD_VALUE_FOR_PRT_QTY	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
27	FORMULA_TOT_QTY	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
28	STD_USAGE_VALUE_FOR_PRT	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
29	PRT_USAGE_VALUE_UNIT	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
30	PRT_USAGE_VALUE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
31	FORMULA_TOT_USAGE	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
32	PRT_USAGE_QUANTITY_SUM	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
33	PRT_USAGE_QUANTITY_SUM_UNIT	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	*
34	PRT_USAGE_QUANTITY_SUM_UN_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
35	PRT_USAGE_VALUE_SUM	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
36	PRT_USAGE_VALUE_SUM_UNIT	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	*
37	PRT_USAGE_VALUE_SUM_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
38	PRT_MEASUREMENT_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	*
39	PRT_MEASUREMENT_UNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
40	PRT_MEASUREMENT_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
41	PRT_ACTUAL_START_DATE	☐	CF_ISFHD	DATUM	DATS	8	0	Actual start (date) of PRT usage
42	PRT_ACTUAL_START_TIME	☐	CF_ISFHZ	UZEIT	TIMS	6	0	Actual start (time) of PRT usage
43	PRT_ACTUAL_FINISH_DATE	☐	CF_IEFHD	DATUM	DATS	8	0	Actual finish (date) of PRT usage
44	PRT_ACTUAL_FINISH_TIME	☐	CF_IEFHZ	UZEIT	TIMS	6	0	Actual finish (time) of PRT usage
45	PRT_STATUS	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
46	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
47	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
48	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field

Foreign Keys

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

History

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