SAP ABAP Table MFHM (Production Resource Tool (PRT) Fields in the Material Master)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	MFHM	Table Relationship Diagram
Short Description	Production Resource Tool (PRT) Fields in the Material Master

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	.INCLUDE	☐				0	0	Structure MFHM w/o Client or Matl No.
5	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
6	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
7	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
8	OBJTY_V	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
9	OBJID_V	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
10	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
11	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
12	STEUF_REF	☐	CF_STKZR	XFELD	CHAR	1	0	Control key cannot be changed
13	FGRU1	☐	FGRUA	FGRUA	CHAR	4	0	Grouping key 1 for production resources/tools	TCF12
14	FGRU2	☐	FGRUB	FGRUA	CHAR	4	0	Grouping key 2 for production resources/tools	TCF12
15	PLANV	☐	FH_PLANV	AP_PLANV	CHAR	3	0	Production resource/tool usage	TC23
16	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
17	KTSCH_REF	☐	CF_KTKZR	XFELD	CHAR	1	0	Reference Key Cannot be Changed
18	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
19	BZOFFB_REF	☐	CF_BBKZR	XFELD	CHAR	1	0	Start reference date cannot be changed
20	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
21	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
22	OFFSTB_REF	☐	CF_OBKZR	XFELD	CHAR	1	0	Offset to start cannot be changed
23	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
24	BZOFFE_REF	☐	CF_BEKZR	XFELD	CHAR	1	0	End reference date cannot be changed
25	OFFSTE	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
26	EHOFFE	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	T006
27	OFFSTE_REF	☐	CF_OEKZR	XFELD	CHAR	1	0	Offset to end cannot be changed
28	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
29	MGFORM_REF	☐	CF_MFKZR	XFELD	CHAR	1	0	Formula for calculating the total quantity cannot be changed
30	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
31	EWFORM_REF	☐	CF_EFKZR	XFELD	CHAR	1	0	Formula to calculate entire usage value cannot be changed
32	PAR01	☐	CF_PAR01	PARAMID	CHAR	6	0	First parameter (for formulas)	TC20
33	PAR02	☐	CF_PAR02	PARAMID	CHAR	6	0	Second parameter (for formulas)	TC20
34	PAR03	☐	CF_PAR03	PARAMID	CHAR	6	0	Third parameter (for formulas)	TC20
35	PAR04	☐	CF_PAR04	PARAMID	CHAR	6	0	Fourth parameter (for formulas)	TC20
36	PAR05	☐	CF_PAR05	PARAMID	CHAR	6	0	Fifth parameter (for formulas)	TC20
37	PAR06	☐	CF_PAR06	PARAMID	CHAR	6	0	Sixth parameter (for formulas)	TC20
38	PARU1	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
39	PARU2	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
40	PARU3	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
41	PARU4	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
42	PARU5	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
43	PARU6	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
44	PARV1	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
45	PARV2	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
46	PARV3	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
47	PARV4	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
48	PARV5	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
49	PARV6	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MFHM	BZOFFB	TCA54	BZOFF
2	MFHM	BZOFFE	TCA54	BZOFF
3	MFHM	EHOFFB	T006	MSEHI
4	MFHM	EHOFFE	T006	MSEHI
5	MFHM	EWFORM	TC25	IDENT
6	MFHM	FGRU1	TCF12	FGRUA
7	MFHM	FGRU2	TCF12	FGRUA
8	MFHM	KTSCH	T435	VLSCH
9	MFHM	MATNR	MARA	MATNR
10	MFHM	MGFORM	TC25	IDENT
11	MFHM	PAR01	TC20	PARID
12	MFHM	PAR02	TC20	PARID
13	MFHM	PAR03	TC20	PARID
14	MFHM	PAR04	TC20	PARID
15	MFHM	PAR05	TC20	PARID
16	MFHM	PAR06	TC20	PARID
17	MFHM	PARU1	T006	MSEHI
18	MFHM	PARU2	T006	MSEHI
19	MFHM	PARU3	T006	MSEHI
20	MFHM	PARU4	T006	MSEHI
21	MFHM	PARU5	T006	MSEHI
22	MFHM	PARU6	T006	MSEHI
23	MFHM	PLANV	TC23	PLANV
24	MFHM	STEUF	TCF10	STEUF
25	MFHM	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20041209
SAP Release Created in