SAP ABAP Table AFFHB (Structure of the doc. table for PRT allocations in work ord.)

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	AFFHB	Table Relationship Diagram
Short Description	Structure of the doc. table for PRT allocations in work ord.

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	FLG_SEL	☐	FLGSEL	FLAG	CHAR	1	0	Version is valid on key date entered
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	MODKZ	☐	CF_MODKZ	CF_MODKZ	CHAR	1	0	Modification indicator (new, changed, to be deleted ...)
74	COMP_RES	☐	OCM_COMP_RES	OCM_COMP_RES	CHAR	1	0	OCM: Result of comparison of two order objects
75	.INCLUDE	☐				0	0	Version information about production resources/tools
76	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
77	.INCLUDE	☐				0	0	Original key for production resources/tools (versions)
78	ORGAUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
79	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	AFFHB	AUFNR	AUFK	AUFNR
2	AFFHB	BZOFFB	TCA54	BZOFF	REF	C	CN
3	AFFHB	BZOFFE	TCA54	BZOFF	REF	C	CN
4	AFFHB	DAUEH	T006	MSEHI	REF	C	CN
5	AFFHB	EHOFFB	T006	MSEHI	REF	C	CN
6	AFFHB	EHOFFE	T006	MSEHI	REF	C	CN
7	AFFHB	EWEINH	T006	MSEHI	REF	C	CN
8	AFFHB	EWFORM	TC25	IDENT	REF	C	CN
9	AFFHB	EWISTEH	T006	MSEHI	REF	C	CN
10	AFFHB	EWRSTEH	T006	MSEHI	REF	C	CN
11	AFFHB	EWSOLEH	T006	MSEHI	REF	C	CN
12	AFFHB	KTSCH	T435	VLSCH	REF	C	CN
13	AFFHB	MANDT	T000	MANDT	KEY	1	CN
14	AFFHB	MGAUSEH	T006	MSEHI	REF	C	CN
15	AFFHB	MGEINH	T006	MSEHI	REF	1	CN
16	AFFHB	MGFORM	TC25	IDENT	REF	C	CN
17	AFFHB	MGISTEH	T006	MSEHI	REF	C	CN
18	AFFHB	MGRSTEH	T006	MSEHI	REF	C	CN
19	AFFHB	MGSOLEH	T006	MSEHI	REF	C	CN
20	AFFHB	OBJID	CRID	OBJID	REF	1	CN
21	AFFHB	OBJNR	ONR00	OBJNR	REF	1	CN
22	AFFHB	PLNTY_KEY	TCA01	PLNTY	REF	C	CN
23	AFFHB	STEUF	TCF10	STEUF	REF	1	CN
24	AFFHB	TXTSP	T002	SPRAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in