SAP ABAP Table AFFHI (PSIS - Individual Overviews: Production Resources/Tools)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS-REP-LOG (Application Component) Logistics
     ⤷ PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'

Basic Data

Table Category	INTTAB	Structure
Structure	AFFHI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: Production Resources/Tools

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 Structure for Project Reporting
2	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
3	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
4	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
6	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
7	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
8	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
9	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
10	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
11	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
12	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
13	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
14	PSNFH	☐	PSNFH	PSNFH	NUMC	4	0	Item Number for Production Resource/Tool
15	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
16	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
17	STEUTXT	☐	STEUTXT	TEXT40	CHAR	40	0	Control key description
18	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
19	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
20	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
21	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
22	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
23	OFFSTE	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
24	EHOFFE	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	T006
25	FSFHD	☐	CF_FSFHD	DATUM	DATS	8	0	Earliest scheduled start (date) for PRT usage
26	FSFHZ	☐	CF_FSFHZ	UZEIT	TIMS	6	0	Earliest scheduled start (time) for PRT usage
27	FEFHD	☐	CF_FEFHD	DATUM	DATS	8	0	Earliest scheduled finish (date) of PRT usage
28	FEFHZ	☐	CF_FEFHZ	UZEIT	TIMS	6	0	Earliest scheduled end (time) of PRT usage
29	SSFHD	☐	CF_SSFHD	DATUM	DATS	8	0	Latest scheduled start (date) for PRT usage
30	SSFHZ	☐	CF_SSFHZ	UZEIT	TIMS	6	0	Latest scheduled start (time) for PRT usage
31	SEFHD	☐	CF_SEFHD	DATUM	DATS	8	0	Latest scheduled finish (date) of PRT usage
32	SEFHZ	☐	CF_SEFHZ	UZEIT	TIMS	6	0	Latest scheduled end (time) for PRT usage
33	ISFHD	☐	CF_ISFHD	DATUM	DATS	8	0	Actual start (date) of PRT usage
34	ISFHZ	☐	CF_ISFHZ	UZEIT	TIMS	6	0	Actual start (time) of PRT usage
35	IEFHD	☐	CF_IEFHD	DATUM	DATS	8	0	Actual finish (date) of PRT usage
36	IEFHZ	☐	CF_IEFHZ	UZEIT	TIMS	6	0	Actual finish (time) of PRT usage
37	DAUSE	☐	CF_DAUSE	DAUER_4_1	QUAN	5	1	Duration of the PRT usage
38	DAUEH	☐	CF_DAUEH	MEINS	UNIT	3	0	Time unit for duration of PRT usage	T006
39	MGEINH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
40	MGVGW	☐	MGVGW	MENG9	QUAN	9	3	Standard value for the PRT quantity
41	MGSOLEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
42	MGSOL	☐	MGSOL	MENG9	QUAN	9	3	Total planned quantity of production resource/tool
43	MGISTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
44	MGIST	☐	MGIST	MENG9	QUAN	9	3	Confirmed quantity of production resource/tool
45	MGRSTEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
46	MGRST	☐	MGRST	MENG9	QUAN	9	3	Remaining quantity of the production resource/tool
47	MGAUSEH	☐	MGEINH	MEINS	UNIT	3	0	Quantity unit of production resource/tool	T006
48	MGAUS	☐	MGAUS	MENG9	QUAN	9	3	Quantity of checked-out production resources/tools
49	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
50	EWEINH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
51	EWVGW	☐	EWVGW	MENG9	QUAN	9	3	Standard usage value for production resources/tools
52	EWSOLEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
53	EWSOL	☐	EWSOL	MENG9	QUAN	9	3	Total planned usage value of production resource/tool
54	EWISTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
55	EWIST	☐	EWIST	MENG9	QUAN	9	3	Actual usage value for production resource/tool
56	EWRSTEH	☐	EWEINH	MEINS	UNIT	3	0	Usage value unit of the production resource/tool	T006
57	EWRST	☐	EWRST	MENG9	QUAN	9	3	Remaining usage value of the production resource/tool
58	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
59	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
60	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
61	TXTZ1	☐	TXTZ1	TEXT40	CHAR	40	0	First line of text for production resources/tools
62	FHMAR	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	TCF02
63	FHMNR	☐	FHMNR	FHMNR	CHAR	33	0	Production resource/tool number
64	FHWRK	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	T001W
65	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
66	MTEXT	☐	PS_MATTEXT	TEXT40	CHAR	40	0	Material description
67	SFHNR	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
68	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
69	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
70	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
71	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
72	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
73	EQPNT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
74	EQPTX	☐	IMRC_PTTXT	TEXT40	CHAR	40	0	Description of Measuring Point
75	MSEHI	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
76	FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
77	FGRU1	☐	FGRUA	FGRUA	CHAR	4	0	Grouping key 1 for production resources/tools	TCF12
78	FGRU2	☐	FGRUB	FGRUA	CHAR	4	0	Grouping key 2 for production resources/tools	TCF12
79	TXTKZ	☐	CF_TXTKZ	FLAG	CHAR	1	0	Indicator: Long text exists
80	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text
81	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
82	VGTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
83	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
84	INT_ID	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
85	LIGHT	☐	LVC_EXLED	CHAR1	CHAR	1	0	ALV control: Exception as LED
86	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
87	PZLFH	☐	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	AFFHI	AUFNR	AUFK	AUFNR	REF	C	CN
2	AFFHI	BZOFFB	TCA54	BZOFF	REF	C	CN
3	AFFHI	BZOFFE	TCA54	BZOFF	REF	C	CN
4	AFFHI	DAUEH	T006	MSEHI	REF	C	CN
5	AFFHI	DOKAR	TDWA	DOKAR	REF	C	CN
6	AFFHI	DOKNR	DRAW	DOKNR	REF	C	CN
7	AFFHI	EHOFFB	T006	MSEHI	REF	C	CN
8	AFFHI	EHOFFE	T006	MSEHI	REF	C	CN
9	AFFHI	EQPNT	IMPTT	POINT
10	AFFHI	EQUNR	EQUI	EQUNR	REF	C	CN
11	AFFHI	EWEINH	T006	MSEHI	REF	C	CN
12	AFFHI	EWFORM	TC25	IDENT	REF	C	CN
13	AFFHI	EWISTEH	T006	MSEHI	REF	C	CN
14	AFFHI	EWRSTEH	T006	MSEHI	REF	C	CN
15	AFFHI	EWSOLEH	T006	MSEHI	REF	C	CN
16	AFFHI	FGRU1	TCF12	FGRUA	REF	C	CN
17	AFFHI	FGRU2	TCF12	FGRUA	REF	C	CN
18	AFFHI	FHMAR	TCF02	FHMAR	REF	C	CN
19	AFFHI	FHWRK	T001W	WERKS	REF	C	CN
20	AFFHI	KDAUF	VBUK	VBELN	REF	C	CN
21	AFFHI	KDPOS	VBUP	POSNR	REF	C	CN
22	AFFHI	KTSCH	T435	VLSCH	REF	C	CN
23	AFFHI	MATNR	MARA	MATNR	REF	C	CN
24	AFFHI	MGAUSEH	T006	MSEHI	REF	C	CN
25	AFFHI	MGEINH	T006	MSEHI	REF	C	CN
26	AFFHI	MGFORM	TC25	IDENT	REF	C	CN
27	AFFHI	MGISTEH	T006	MSEHI	REF	C	CN
28	AFFHI	MGRSTEH	T006	MSEHI	REF	C	CN
29	AFFHI	MGSOLEH	T006	MSEHI	REF	C	CN
30	AFFHI	MSEHI	T006	MSEHI
31	AFFHI	PRCTR	CEPC	PRCTR	REF	C	CN
32	AFFHI	PRNAM	IMTP	PRNAM			CN
33	AFFHI	STEUF	TCF10	STEUF	REF	1	CN
34	AFFHI	TXTSP	T002	SPRAS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C