SAP ABAP Table DIAFFH (PM resources)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing

Basic Data

Table Category	INTTAB	Structure
Structure	DIAFFH	Table Relationship Diagram
Short Description	PM resources

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	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	PZLFH	☐	PZLFH	PZLFH	NUMC	8	0	Item counter for production resources/tools
4	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
5	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
6	DATUI	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
7	USERI	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
8	DATUC	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
9	USERC	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
11	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
12	PLNTY_KEY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
13	PLNNR_KEY	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
14	PZLFH_KEY	☐	PZLFH	PZLFH	NUMC	8	0	Item counter for production resources/tools
15	ZAEHL_KEY	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
16	OBJCT	☐	OBJCT_D	OBJKT	CHAR	1	0	Object of a task list
17	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
18	PSNFH	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
19	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
20	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
21	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
22	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
23	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
24	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
25	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
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	FSFHD	☐	CF_FSFHD	DATUM	DATS	8	0	Earliest scheduled start (date) for PRT usage
29	FSFHZ	☐	CF_FSFHZ	UZEIT	TIMS	6	0	Earliest scheduled start (time) for PRT usage
30	FEFHD	☐	CF_FEFHD	DATUM	DATS	8	0	Earliest scheduled finish (date) of PRT usage
31	FEFHZ	☐	CF_FEFHZ	UZEIT	TIMS	6	0	Earliest scheduled end (time) of PRT usage
32	SSFHD	☐	CF_SSFHD	DATUM	DATS	8	0	Latest scheduled start (date) for PRT usage
33	SSFHZ	☐	CF_SSFHZ	UZEIT	TIMS	6	0	Latest scheduled start (time) for PRT usage
34	SEFHD	☐	CF_SEFHD	DATUM	DATS	8	0	Latest scheduled finish (date) of PRT usage
35	SEFHZ	☐	CF_SEFHZ	UZEIT	TIMS	6	0	Latest scheduled end (time) for PRT usage
36	ISFHD	☐	CF_ISFHD	DATUM	DATS	8	0	Actual start (date) of PRT usage
37	ISFHZ	☐	CF_ISFHZ	UZEIT	TIMS	6	0	Actual start (time) of PRT usage
38	IEFHD	☐	CF_IEFHD	DATUM	DATS	8	0	Actual finish (date) of PRT usage
39	IEFHZ	☐	CF_IEFHZ	UZEIT	TIMS	6	0	Actual finish (time) of PRT usage
40	DAUFL	☐	CF_DAUFL	CX_ZEIT	FLTP	16	16	Duration of PRT usage
41	DAUEH	☐	CF_DAUEH	MEINS	UNIT	3	0	Time unit for duration of PRT usage	T006
42	MGEINH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
43	MGVGW	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
44	MGSOLEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
45	MGSOL	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
46	MGISTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
47	MGIST	☐	MGIST	MENG9	QUAN	9	3	Confirmed quantity of production resource/tool
48	MGRSTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
49	MGRST	☐	MGRST	MENG9	QUAN	9	3	Remaining quantity of the production resource/tool
50	MGAUSEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
51	MGAUS	☐	MGAUS	MENG9	QUAN	9	3	Quantity of checked-out production resources/tools
52	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
53	EWEINH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
54	EWVGW	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
55	EWSOLEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
56	EWSOL	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
57	EWISTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
58	EWIST	☐	EWIST	MENG9	QUAN	9	3	Actual usage value for production resource/tool
59	EWRSTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
60	EWRST	☐	EWRST	MENG9	QUAN	9	3	Remaining usage value of the production resource/tool
61	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
62	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
63	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
64	TXTZ1	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
65	DAUSE	☐	CF_DAUSE	DAUER_4_1	QUAN	5	1	Duration of the PRT usage
66	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
67	FHMAR	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	TCF02
68	FHMNR	☐	FHMNR	FHMNR	CHAR	33	0	Production resource/tool number
69	FHWRK	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	T001W
70	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
71	SFHNR	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
72	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
73	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
74	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
75	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
76	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
77	EQWPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
78	EQWTX	☐	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
79	EQPNT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
80	EQPTX	☐	IMRC_PTTXT	TEXT40	CHAR	40	0	Description of Measuring Point
81	ATNAM	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
82	ATVOR	☐	IMRC_INEGV	X	CHAR	1	0	Indicator: Negative Values Allowed
83	MSEHI	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
84	ATDIM	☐	ATDIM	EXP10	INT2	5	0	Exponent display
85	ANZDZ	☐	ANZDZ	ANZDZ	INT2	5	0	Number of Decimal Places
86	FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
87	BASEH	☐	CF_BASEH	MEINS	UNIT	3	0	Base unit of measure for production resources/tools	T006
88	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
89	FGRU1	☐	FGRUA	FGRUA	CHAR	4	0	Grouping key 1 for production resources/tools	TCF12
90	FGRU2	☐	FGRUB	FGRUA	CHAR	4	0	Grouping key 2 for production resources/tools	TCF12
91	STOWK	☐	CF_STOWK	WERKS	CHAR	4	0	Plant location of the production resource/tool	T001W
92	STORT	☐	CF_STORT	AP_STAND	CHAR	10	0	Location of a production resource or tool	T499S
93	FSTTXT	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
94	CF_KZSVS	☐	CF_KZSVS	XFELD	CHAR	1	0	Indicator for start of PRT usage: Offset to Operation start
95	CF_KZSVE	☐	CF_KZSVE	XFELD	CHAR	1	0	Indicator for start of PRT usage: Offset to op. finish
96	CF_KZEVS	☐	CF_KZEVS	XFELD	CHAR	1	0	Indicator for end of PRT usage: Offset to operation start
97	CF_KZEVE	☐	CF_KZEVE	XFELD	CHAR	1	0	Indicator for end of PRT usage: Offset to operation finish
98	STEUF_REF	☐	CF_STKZR	XFELD	CHAR	1	0	Control key cannot be changed
99	KTSCH_REF	☐	CF_KTKZR	XFELD	CHAR	1	0	Reference Key Cannot be Changed
100	BZOFFB_REF	☐	CF_BBKZR	XFELD	CHAR	1	0	Start reference date cannot be changed
101	OFFSTB_REF	☐	CF_OBKZR	XFELD	CHAR	1	0	Offset to start cannot be changed
102	BZOFFE_REF	☐	CF_BEKZR	XFELD	CHAR	1	0	End reference date cannot be changed
103	OFFSTE_REF	☐	CF_OEKZR	XFELD	CHAR	1	0	Offset to end cannot be changed
104	MGFORM_REF	☐	CF_MFKZR	XFELD	CHAR	1	0	Formula for calculating the total quantity cannot be changed
105	EWFORM_REF	☐	CF_EFKZR	XFELD	CHAR	1	0	Formula to calculate entire usage value cannot be changed
106	TXTKZ	☐	CF_TXTKZ	FLAG	CHAR	1	0	Indicator: Long text exists
107	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIAFFH	AUFNR	AUFK	AUFNR
2	DIAFFH	BASEH	T006	MSEHI
3	DIAFFH	BZOFFB	TCA54	BZOFF
4	DIAFFH	BZOFFE	TCA54	BZOFF
5	DIAFFH	DAUEH	T006	MSEHI
6	DIAFFH	DOKAR	TDWA	DOKAR
7	DIAFFH	DOKNR	DRAW	DOKNR
8	DIAFFH	EHOFFB	T006	MSEHI
9	DIAFFH	EHOFFE	T006	MSEHI
10	DIAFFH	EQPNT	IMPTT	POINT
11	DIAFFH	EQUNR	EQUI	EQUNR
12	DIAFFH	EQWPL	MPLA	WARPL
13	DIAFFH	EWEINH	T006	MSEHI
14	DIAFFH	EWFORM	TC25	IDENT
15	DIAFFH	EWISTEH	T006	MSEHI
16	DIAFFH	EWRSTEH	T006	MSEHI
17	DIAFFH	EWSOLEH	T006	MSEHI
18	DIAFFH	FGRU1	TCF12	FGRUA
19	DIAFFH	FGRU2	TCF12	FGRUA
20	DIAFFH	FHMAR	TCF02	FHMAR
21	DIAFFH	FHWRK	T001W	WERKS
22	DIAFFH	KTSCH	T435	VLSCH
23	DIAFFH	MANDT	T000	MANDT
24	DIAFFH	MATNR	MARA	MATNR
25	DIAFFH	MEINS	T006	MSEHI
26	DIAFFH	MGAUSEH	T006	MSEHI
27	DIAFFH	MGEINH	T006	MSEHI
28	DIAFFH	MGFORM	TC25	IDENT
29	DIAFFH	MGISTEH	T006	MSEHI
30	DIAFFH	MGRSTEH	T006	MSEHI
31	DIAFFH	MGSOLEH	T006	MSEHI
32	DIAFFH	MSEHI	T006	MSEHI
33	DIAFFH	OBJID	CRID	OBJID
34	DIAFFH	OBJNR	ONR00	OBJNR
35	DIAFFH	PLNTY_KEY	TCA01	PLNTY
36	DIAFFH	STEUF	TCF10	STEUF
37	DIAFFH	STORT	T499S	STAND
38	DIAFFH	STOWK	T001W	WERKS
39	DIAFFH	TXTSP	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in