SAP ABAP Table DIPLFH (Production resources/tools for operations)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IMRM (Package) Application Development R/3 Maintenance Task List Management

Basic Data

Table Category	INTTAB	Structure
Structure	DIPLFH	Table Relationship Diagram
Short Description	Production resources/tools for operations

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	Dialogue structure PRTs in task lists
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
4	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
5	PZLFH	☐	PZLFH	PZLFH	NUMC	8	0	Item counter for production resources/tools
6	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
7	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
8	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
9	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
10	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
11	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
12	DATUI	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
13	USERI	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
14	DATUC	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	USERC	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
17	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
18	OBJCT	☐	OBJCT_D	OBJKT	CHAR	1	0	Object of a task list
19	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
20	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
21	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
22	PSNFH	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
23	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
24	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
25	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
26	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
27	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
28	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
29	OFFSTE	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
30	EHOFFE	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	T006
31	MGEINH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
32	MGVGW	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
33	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
34	EWEINH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
35	EWVGW	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
36	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
37	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
38	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
39	TXTZ1	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
40	KNOBJ	☐	KNOBJ	KNOBJ	NUMC	18	0	Number of Object with Assigned Dependencies
41	GP_KRIT1	☐	PLOBJ	CHAR18	CHAR	18	0	Planning object
42	MGSOL	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
43	MGIST	☐	MGIST	MENG9	QUAN	9	3	Confirmed quantity of production resource/tool
44	MGRST	☐	MGRST	MENG9	QUAN	9	3	Remaining quantity of the production resource/tool
45	MGAUS	☐	MGAUS	MENG9	QUAN	9	3	Quantity of checked-out production resources/tools
46	EWSOL	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
47	EWIST	☐	EWIST	MENG9	QUAN	9	3	Actual usage value for production resource/tool
48	EWRST	☐	EWRST	MENG9	QUAN	9	3	Remaining usage value of the production resource/tool
49	FHMAR	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	TCF02
50	FHMNR	☐	FHMNR	FHMNR	CHAR	33	0	Production resource/tool number
51	FHWRK	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	T001W
52	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
53	SFHNR	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
54	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
55	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
56	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
57	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
58	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
59	EQWPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
60	EQWTX	☐	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
61	EQPNT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
62	EQPTX	☐	IMRC_PTTXT	TEXT40	CHAR	40	0	Description of Measuring Point
63	ATNAM	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
64	ATVOR	☐	IMRC_INEGV	X	CHAR	1	0	Indicator: Negative Values Allowed
65	MSEHI	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
66	ATDIM	☐	ATDIM	EXP10	INT2	5	0	Exponent display
67	ANZDZ	☐	ANZDZ	ANZDZ	INT2	5	0	Number of Decimal Places
68	FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
69	BASEH	☐	CF_BASEH	MEINS	UNIT	3	0	Base unit of measure for production resources/tools	T006
70	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
71	FGRU1	☐	FGRUA	FGRUA	CHAR	4	0	Grouping key 1 for production resources/tools	TCF12
72	FGRU2	☐	FGRUB	FGRUA	CHAR	4	0	Grouping key 2 for production resources/tools	TCF12
73	STOWK	☐	CF_STOWK	WERKS	CHAR	4	0	Plant location of the production resource/tool	T001W
74	STORT	☐	CF_STORT	AP_STAND	CHAR	10	0	Location of a production resource or tool	T499S
75	STEUF_REF	☐	CF_STKZR	XFELD	CHAR	1	0	Control key cannot be changed
76	KTSCH_REF	☐	CF_KTKZR	XFELD	CHAR	1	0	Reference Key Cannot be Changed
77	BZOFFB_REF	☐	CF_BBKZR	XFELD	CHAR	1	0	Start reference date cannot be changed
78	OFFSTB_REF	☐	CF_OBKZR	XFELD	CHAR	1	0	Offset to start cannot be changed
79	BZOFFE_REF	☐	CF_BEKZR	XFELD	CHAR	1	0	End reference date cannot be changed
80	OFFSTE_REF	☐	CF_OEKZR	XFELD	CHAR	1	0	Offset to end cannot be changed
81	MGFORM_REF	☐	CF_MFKZR	XFELD	CHAR	1	0	Formula for calculating the total quantity cannot be changed
82	EWFORM_REF	☐	CF_EFKZR	XFELD	CHAR	1	0	Formula to calculate entire usage value cannot be changed
83	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
84	TXTKZ	☐	CF_TXTKZ	FLAG	CHAR	1	0	Indicator: Long text exists
85	CF_KZSVS	☐	CF_KZSVS	XFELD	CHAR	1	0	Indicator for start of PRT usage: Offset to Operation start
86	CF_KZSVE	☐	CF_KZSVE	XFELD	CHAR	1	0	Indicator for start of PRT usage: Offset to op. finish
87	CF_KZEVS	☐	CF_KZEVS	XFELD	CHAR	1	0	Indicator for end of PRT usage: Offset to operation start
88	CF_KZEVE	☐	CF_KZEVE	XFELD	CHAR	1	0	Indicator for end of PRT usage: Offset to operation finish

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIPLFH	BASEH	T006	MSEHI
2	DIPLFH	BZOFFB	TCA54	BZOFF
3	DIPLFH	BZOFFE	TCA54	BZOFF
4	DIPLFH	DOKAR	TDWA	DOKAR
5	DIPLFH	DOKNR	DRAW	DOKNR
6	DIPLFH	EHOFFB	T006	MSEHI
7	DIPLFH	EHOFFE	T006	MSEHI
8	DIPLFH	EQPNT	IMPTT	POINT
9	DIPLFH	EQUNR	EQUI	EQUNR
10	DIPLFH	EQWPL	MPLA	WARPL
11	DIPLFH	EWEINH	T006	MSEHI
12	DIPLFH	EWFORM	TC25	IDENT
13	DIPLFH	FGRU1	TCF12	FGRUA
14	DIPLFH	FGRU2	TCF12	FGRUA
15	DIPLFH	FHMAR	TCF02	FHMAR
16	DIPLFH	FHWRK	T001W	WERKS
17	DIPLFH	KTSCH	T435	VLSCH
18	DIPLFH	MATNR	MARA	MATNR
19	DIPLFH	MEINS	T006	MSEHI
20	DIPLFH	MGEINH	T006	MSEHI
21	DIPLFH	MGFORM	TC25	IDENT
22	DIPLFH	MSEHI	T006	MSEHI
23	DIPLFH	OBJID	CRID	OBJID
24	DIPLFH	STEUF	TCF10	STEUF
25	DIPLFH	STORT	T499S	STAND
26	DIPLFH	STOWK	T001W	WERKS
27	DIPLFH	TXTSP	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in