SAP ABAP Table AFFH01 (Order PRT Data (for LDB) - 01)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	INTTAB	Structure
Structure	AFFH01	Table Relationship Diagram
Short Description	Order PRT Data (for LDB) - 01

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

History

Last changed by/on	SAP	20130529
SAP Release Created in