SAP ABAP Table EFHM (PRT fields in equipment master)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CF (Package) R/3 Appl. development: PPS production resources/tools

Basic Data

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

History

Last changed by/on	SAP	20050411
SAP Release Created in	470