SAP ABAP Table AFFHD (Structure of the PRTs in orders)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-BD-PRT (Application Component) Production Resources/Tools
     ⤷ CFO (Package) R/3 Appl. dev.: PPS production resources maintenance order

Basic Data

Table Category	INTTAB	Structure
Structure	AFFHD	Table Relationship Diagram
Short Description	Structure of the PRTs in orders

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in