SAP ABAP Table AFFH (PRT assignment data for the work order)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CF (Package) R/3 Appl. development: PPS production resources/tools

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AFFH	Table Relationship Diagram
Short Description	PRT assignment data for the work order

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☐				0	0	PRT assignment data for the work order
5	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
6	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
7	DATUI	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
8	USERI	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
9	DATUC	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	USERC	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
12	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
13	PLNTY_KEY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
14	PLNNR_KEY	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
15	PZLFH_KEY	☐	PZLFH	PZLFH	NUMC	8	0	Item counter for production resources/tools
16	ZAEHL_KEY	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
17	OBJCT	☐	OBJCT_D	OBJKT	CHAR	1	0	Object of a task list
18	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
19	PSNFH	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
20	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
21	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
22	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
23	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
24	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
25	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
26	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
27	OFFSTE	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
28	EHOFFE	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	T006
29	FSFHD	☐	CF_FSFHD	DATUM	DATS	8	0	Earliest scheduled start (date) for PRT usage
30	FSFHZ	☐	CF_FSFHZ	UZEIT	TIMS	6	0	Earliest scheduled start (time) for PRT usage
31	FEFHD	☐	CF_FEFHD	DATUM	DATS	8	0	Earliest scheduled finish (date) of PRT usage
32	FEFHZ	☐	CF_FEFHZ	UZEIT	TIMS	6	0	Earliest scheduled end (time) of PRT usage
33	SSFHD	☐	CF_SSFHD	DATUM	DATS	8	0	Latest scheduled start (date) for PRT usage
34	SSFHZ	☐	CF_SSFHZ	UZEIT	TIMS	6	0	Latest scheduled start (time) for PRT usage
35	SEFHD	☐	CF_SEFHD	DATUM	DATS	8	0	Latest scheduled finish (date) of PRT usage
36	SEFHZ	☐	CF_SEFHZ	UZEIT	TIMS	6	0	Latest scheduled end (time) for PRT usage
37	ISFHD	☐	CF_ISFHD	DATUM	DATS	8	0	Actual start (date) of PRT usage
38	ISFHZ	☐	CF_ISFHZ	UZEIT	TIMS	6	0	Actual start (time) of PRT usage
39	IEFHD	☐	CF_IEFHD	DATUM	DATS	8	0	Actual finish (date) of PRT usage
40	IEFHZ	☐	CF_IEFHZ	UZEIT	TIMS	6	0	Actual finish (time) of PRT usage
41	DAUFL	☐	CF_DAUFL	CX_ZEIT	FLTP	16	16	Duration of PRT usage
42	DAUEH	☐	CF_DAUEH	MEINS	UNIT	3	0	Time unit for duration of PRT usage	T006
43	MGEINH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
44	MGVGW	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
45	MGSOLEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
46	MGSOL	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
47	MGISTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
48	MGIST	☐	MGIST	MENG9	QUAN	9	3	Confirmed quantity of production resource/tool
49	MGRSTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
50	MGRST	☐	MGRST	MENG9	QUAN	9	3	Remaining quantity of the production resource/tool
51	MGAUSEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
52	MGAUS	☐	MGAUS	MENG9	QUAN	9	3	Quantity of checked-out production resources/tools
53	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
54	EWEINH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
55	EWVGW	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
56	EWSOLEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
57	EWSOL	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
58	EWISTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
59	EWIST	☐	EWIST	MENG9	QUAN	9	3	Actual usage value for production resource/tool
60	EWRSTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
61	EWRST	☐	EWRST	MENG9	QUAN	9	3	Remaining usage value of the production resource/tool
62	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
63	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
64	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
65	TXTZ1	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
66	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
67	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
68	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFFH	BZOFFB	TCA54	BZOFF	REF	C	CN
2	AFFH	BZOFFE	TCA54	BZOFF	REF	C	CN
3	AFFH	DAUEH	T006	MSEHI	REF	C	CN
4	AFFH	EHOFFB	T006	MSEHI	REF	C	CN
5	AFFH	EHOFFE	T006	MSEHI	REF	C	CN
6	AFFH	EWEINH	T006	MSEHI	REF	C	CN
7	AFFH	EWFORM	TC25	IDENT	REF	C	CN
8	AFFH	EWISTEH	T006	MSEHI	REF	C	CN
9	AFFH	EWRSTEH	T006	MSEHI	REF	C	CN
10	AFFH	EWSOLEH	T006	MSEHI	REF	C	CN
11	AFFH	KTSCH	T435	VLSCH	REF	C	CN
12	AFFH	MANDT	T000	MANDT	KEY	1	CN
13	AFFH	MGAUSEH	T006	MSEHI	REF	C	CN
14	AFFH	MGEINH	T006	MSEHI	REF	1	CN
15	AFFH	MGFORM	TC25	IDENT	REF	C	CN
16	AFFH	MGISTEH	T006	MSEHI	REF	C	CN
17	AFFH	MGRSTEH	T006	MSEHI	REF	C	CN
18	AFFH	MGSOLEH	T006	MSEHI	REF	C	CN
19	AFFH	OBJID	CRID	OBJID	REF	1	CN
20	AFFH	OBJNR	ONR00	OBJNR	REF	1	CN
21	AFFH	PLNTY_KEY	TCA01	PLNTY	REF	C	CN
22	AFFH	STEUF	TCF10	STEUF	REF	1	CN
23	AFFH	TXTSP	T002	SPRAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in