SAP ABAP Table PSHLP_TREX_AFIH_ST (Maintenance Order Header)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS (Application Component) Project System
     ⤷ PS_HLP_CACHE (Package) Handling Large Projects:-Cache

Basic Data

Table Category	INTTAB	Structure
Structure	PSHLP_TREX_AFIH_ST	Table Relationship Diagram
Short Description	Maintenance Order Header

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	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
2	.INCLUDE	☐				0	0	PM Order: Fields AFIH w/o Key
3	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
4	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
5	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
6	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
7	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
8	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
9	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
10	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
11	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
12	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
13	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
14	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
15	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
16	ANING	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
17	GAUZT	☐	GAUZT	FLTP	FLTP	16	16	Planned downtime in hours
18	GAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
19	ANLBD	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
20	ANLVD	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
21	ANLBZ	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
22	ANLVZ	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
23	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
24	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
25	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
26	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
27	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
28	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
29	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
30	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
31	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
32	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
33	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
34	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
35	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
36	HISDA	☐	HISDA	DATUM	DATS	8	0	PM request: History date
37	AKKNZ	☐	AKKNZ	AKKNZ	CHAR	1	0	Order Category Indicator Plant Maintenance
38	PLKNZ	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
39	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
40	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
41	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
42	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
43	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
44	RSUPG	☐	RSUPG	XFIELD	CHAR	1	0	Upgrade Order Indicator
45	.INCLU--AP	☐				0	0	Fields for /ISDFPS/ Enhancements
46	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
47	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
48	.INCLU--AP	☐				0	0	IUID Append
49	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
50	.INCLUDE	☐				0	0	TREX Administration Data
51	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
52	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
53	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_TREX_AFIH_ST	ANLZU	T357M	ANLZU	REF	C	CN
2	PSHLP_TREX_AFIH_ST	APGRP	T024A	FEVOR	REF	C	CN
3	PSHLP_TREX_AFIH_ST	ARTPR	T356A	ARTPR	REF	C	CN
4	PSHLP_TREX_AFIH_ST	BAUTL	MARA	MATNR	REF	C	CN
5	PSHLP_TREX_AFIH_ST	EQUNR	EQUI	EQUNR	REF	C	CN
6	PSHLP_TREX_AFIH_ST	GAUEH	T006	MSEHI	REF	C	CN
7	PSHLP_TREX_AFIH_ST	GEWRK	CRID	OBJID	REF	C	CN
8	PSHLP_TREX_AFIH_ST	ILART	T353I	ILART
9	PSHLP_TREX_AFIH_ST	ILOAN	ILOA	ILOAN	REF	C	CN
10	PSHLP_TREX_AFIH_ST	INGPR	T024I	INGRP	REF	C	CN
11	PSHLP_TREX_AFIH_ST	IWERK	T399I	IWERK	REF	C	CN
12	PSHLP_TREX_AFIH_ST	KUNUM	KNA1	KUNNR	REF	C	CN
13	PSHLP_TREX_AFIH_ST	LAUFN	AUFK	AUFNR	REF	C	CN
14	PSHLP_TREX_AFIH_ST	OBKNR	SER00	OBKNR
15	PSHLP_TREX_AFIH_ST	PRIOK	T356	PRIOK	REF	C	CN
16	PSHLP_TREX_AFIH_ST	QMNUM	QMEL	QMNUM
17	PSHLP_TREX_AFIH_ST	REVNR	T352R	REVNR
18	PSHLP_TREX_AFIH_ST	SCREENTY	TQBT	SCREENTY
19	PSHLP_TREX_AFIH_ST	SERMAT	MARA	MATNR
20	PSHLP_TREX_AFIH_ST	WARPL	MPLA	WARPL	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	606