SAP ABAP View /CUM/VIAUFKS (CU: PM Order Selection)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /CUM/ORDER (Package) Compatible unit order maintenance

Basic Data

View Type	D	Database View
Database View	/CUM/VIAUFKS
Short Description	CU: PM Order Selection
Root table	AFIH	Maintenance order header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFIH	AFIH
2	AUFK
3	AFKO
4	ILOA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AUFK	MANDT	JL	EQ				0	0
2	AFIH	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFIH	AUFNR	JR	EQ			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFKO	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFKO	AUFNR	JR	EQ			AND	0	0
9	ILOA	MANDT	JL	EQ				0	0
10	AFIH	MANDT	JR	EQ			AND	0	0
11	ILOA	ILOAN	JL	EQ				0	0
12	AFIH	ILOAN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFIH	MANDT		☐	MANDT	☐	Client
2	AUFNR	AFIH	AUFNR		☐	AUFNR	☐	Order Number
3	PRIOK	AFIH	PRIOK		☐	PRIOK	☐	Priority
4	EQUNR	AFIH	EQUNR		☐	EQUNR	☐	Equipment Number
5	BAUTL	AFIH	BAUTL		☐	BAUTL	☐	Assembly
6	ANLZU	AFIH	ANLZU		☐	ANLZU	☐	Syst.Condition
7	IWERK	AFIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
8	INGPR	AFIH	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
9	APGRP	AFIH	APGRP		☐	VAGRP	☐	Responsible planner group/department
10	GEWRK	AFIH	GEWRK		☐	LGWID	☐	Object ID of the Work Center
11	KUNUM	AFIH	KUNUM		☐	KUNUM	☐	Customer Number
12	ANING	AFIH	ANING		☐	ANING	☐	Name of Person Reponsible for System
13	GAUEH	AFIH	GAUEH		☐	MAUEH	☐	Unit for Breakdown Duration
14	GAUZT	AFIH	GAUZT		☐	GAUZT	☐	Planned downtime in hours
15	ANLBD	AFIH	ANLBD		☐	ANLBD	☐	Date until which the system is available
16	ANLVD	AFIH	ANLVD		☐	ANLVD	☐	Date from which the system is available
17	ANLBZ	AFIH	ANLBZ		☐	ANLBZ	☐	Time until which the system is available
18	ANLVZ	AFIH	ANLVZ		☐	ANLVZ	☐	Time from Which System is Available
19	WARPL	AFIH	WARPL		☐	WARPL	☐	Maintenance Plan
20	WAPOS	AFIH	WAPOS		☐	WAPOS	☐	Maintenance item
21	REVNR	AFIH	REVNR		☐	REVNI	☐	Revision of Plant Maintenance and Customer Service
22	ARTPR	AFIH	ARTPR		☐	ARTPR	☐	Priority Type
23	ILOAN	AFIH	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
24	ILOAI	AFIH	ILOAI		☐	ILOAI	☐	ILOA Individual
25	PM_OBJTY	AFIH	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
26	INSPK	AFIH	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
27	DATAN	AFIH	DATAN		☐	DATAN	☐	Date of Technical Inspection
28	ABNUM	AFIH	ABNUM		☐	ABNUM	☐	Maintenance Plan Call Number
29	LAUFN	AFIH	LAUFN		☐	LAUFN	☐	Order number
30	OBKNR	AFIH	OBKNR		☐	OBJKNR	☐	Object list number
31	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
32	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
33	ERNAM	AUFK	ERNAM		☐	AUFERFNAM	☐	Entered by
34	ERDAT	AUFK	ERDAT		☐	AUFERFDAT	☐	Created on
35	AENAM	AUFK	AENAM		☐	AUFAENAM	☐	Last changed by
36	AEDAT	AUFK	AEDAT		☐	AUFAEDAT	☐	Change date for Order Master
37	KTEXT	AUFK	KTEXT		☐	AUFTEXT	☐	Description
38	LTEXT	AUFK	LTEXT		☐	AUFLTEXT	☐	Long Text Exists
39	BUKRS	AUFK	BUKRS		☐	BUKRS	☐	Company Code
40	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
41	GSBER	AUFK	GSBER		☐	GSBER	☐	Business Area
42	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
43	CCKEY	AUFK	CCKEY		☐	CCKEY	☐	Cost collector key
44	KOSTV	AUFK	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
45	STORT	AUFK	STORT		☐	AUFSTORT	☐	Location
46	SOWRK	AUFK	SOWRK		☐	AUFSOWRK	☐	Location plant
47	ASTKZ	AUFK	ASTKZ		☐	AUFSTKZ	☐	Identifier for statistical order
48	WAERS	AUFK	WAERS		☐	AUFWAERS	☐	Order Currency
49	ASTNR	AUFK	ASTNR		☐	AUFASTNR	☐	Order status
50	STDAT	AUFK	STDAT		☐	AUFSTDAT	☐	Date of last status change
51	ESTNR	AUFK	ESTNR		☐	AUFESTNR	☐	Status reached so far
52	PDAT1	AUFK	PDAT1		☐	AUFPDAT1	☐	Planned release date
53	PDAT2	AUFK	PDAT2		☐	AUFPDAT2	☐	Planned completion date
54	PDAT3	AUFK	PDAT3		☐	AUFPDAT3	☐	Planned closing date
55	IDAT1	AUFK	IDAT1		☐	AUFIDAT1	☐	Release date
56	IDAT2	AUFK	IDAT2		☐	AUFIDAT2	☐	Technical completion date
57	IDAT3	AUFK	IDAT3		☐	AUFIDAT3	☐	Close date
58	OBJID	AUFK	OBJID		☐	CCOBJID	☐	Object ID
59	VOGRP	AUFK	VOGRP		☐	AUFSPSET	☐	Group of disallowed transactions
60	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
61	PLGKZ	AUFK	PLGKZ		☐	PLGKZ	☐	Identifier for planning with line items
62	KVEWE	AUFK	KVEWE		☐	KVEWE	☐	Usage of the Condition Table
63	KAPPL	AUFK	KAPPL		☐	KAPPL	☐	Application
64	KALSM	AUFK	KALSM		☐	AUFKALSM	☐	Costing Sheet
65	ZSCHL	AUFK	ZSCHL		☐	AUFZSCHL	☐	Overhead key
66	ABKRS	AUFK	ABKRS		☐	AUFABKRS	☐	Processing group
67	KSTAR	AUFK	KSTAR		☐	AUFKSTAR	☐	Settlement cost element
68	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
69	SAKNR	AUFK	SAKNR		☐	AUFSAKNR	☐	G/L account for basic settlement
70	SETNM	AUFK	SETNM		☐	AUFSETNM	☐	Allocation set
71	CYCLE	AUFK	CYCLE		☐	ST_KOSTL	☐	Cost center to which costs are actually posted
72	SDATE	AUFK	SDATE		☐	SDATE	☐	Start Date
73	SEQNR	AUFK	SEQNR		☐	AUFSEQNR	☐	Sequence number
74	OBJNR	AUFK	OBJNR		☐	J_OBJNR	☐	Object number
75	PRCTR	AUFK	PRCTR		☐	PRCTR	☐	Profit Center
76	VNAME	AUFK	VNAME		☐	JV_NAME	☐	Joint venture
77	RECID	AUFK	RECID		☐	JV_RECIND	☐	Recovery Indicator
78	ETYPE	AUFK	ETYPE		☐	JV_ETYPE	☐	Equity type
79	PSPEL	AUFK	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
80	AWSLS	AUFK	AWSLS		☐	AWSLS	☐	Variance Key
81	ABGSL	AUFK	ABGSL		☐	ABGR_SCHL	☐	Results Analysis Key
82	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
83	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
84	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
85	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
86	STORT_ILOA	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
87	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
88	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
89	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
90	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
91	GSBER_ILOA	ILOA	GSBER		☐	GSBER	☐	Business Area
92	KOKRS_ILOA	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
93	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
94	BUKRS_ILOA	ILOA	BUKRS		☐	BUKRS	☐	Company Code
95	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
96	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
97	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
98	AUFNR_ILOA	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
99	GLTRP	AFKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
100	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
101	FTRMS	AFKO	FTRMS		☐	CO_FTRMS	☐	Scheduled release date
102	GLTRS	AFKO	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
103	GSTRS	AFKO	GSTRS		☐	CO_GSTRS	☐	Scheduled start
104	GSTRI	AFKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
105	GETRI	AFKO	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
106	GLTRI	AFKO	GLTRI		☐	CO_GLTRI	☐	Actual finish date
107	FTRMI	AFKO	FTRMI		☐	CO_FTRMI	☐	Actual release date
108	FTRMP	AFKO	FTRMP		☐	CO_FTRMP	☐	Planned release date
109	RSNUM	AFKO	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
110	GASMG	AFKO	GASMG		☐	GASMG	☐	Total scrap quantity in the order
111	GAMNG	AFKO	GAMNG		☐	GAMNG	☐	Total order quantity
112	GMEIN	AFKO	GMEIN		☐	MEINS	☐	Base Unit of Measure
113	PLNBEZ	AFKO	PLNBEZ		☐	MATNR	☐	Material Number
114	PLNTY	AFKO	PLNTY		☐	PLNTY	☐	Task List Type
115	PLNNR	AFKO	PLNNR		☐	PLNNR	☐	Key for Task List Group
116	PLNAW	AFKO	PLNAW		☐	PLNAW	☐	Application of the task list
117	PLNAL	AFKO	PLNAL		☐	PLNAL	☐	Group Counter
118	PVERW	AFKO	PVERW		☐	PLN_VERWE	☐	Task list usage
119	PLAUF	AFKO	PLAUF		☐	CO_PLAUF	☐	Date for routing transfer
120	PLSVB	AFKO	PLSVB		☐	LOSGRBIS	☐	To lot size
121	PLNME	AFKO	PLNME		☐	PLNME	☐	Task list unit of measure
122	PLSVN	AFKO	PLSVN		☐	LOSGRVON	☐	From Lot Size
123	PDATV	AFKO	PDATV		☐	DATUV	☐	Valid-From Date
124	PAENR	AFKO	PAENR		☐	AENNR	☐	Change Number
125	PLGRP	AFKO	PLGRP		☐	VAGRP	☐	Responsible planner group/department
126	LODIV	AFKO	LODIV		☐	LOSDIV	☐	Lot size divisor
127	STLTY	AFKO	STLTY		☐	STLTY	☐	BOM Category
128	STLBEZ	AFKO	STLBEZ		☐	MATNR	☐	Material Number
129	STLST	AFKO	STLST		☐	STLST	☐	BOM Statuses
130	STLNR	AFKO	STLNR		☐	STNUM	☐	Bill of Material
131	SDATV	AFKO	SDATV		☐	DATUV	☐	Valid-From Date
132	SBMNG	AFKO	SBMNG		☐	BASMN	☐	Base quantity
133	SBMEH	AFKO	SBMEH		☐	MEINS	☐	Base Unit of Measure
134	SAENR	AFKO	SAENR		☐	AENNR	☐	Change Number
135	STLAL	AFKO	STLAL		☐	STALT	☐	Alternative BOM
136	STLAN	AFKO	STLAN		☐	STLAN	☐	BOM Usage
137	SLSVN	AFKO	SLSVN		☐	LOSVN	☐	From Lot Size
138	SLSBS	AFKO	SLSBS		☐	LOSBS	☐	To Lot Size
139	AUFLD	AFKO	AUFLD		☐	CO_AUFLD	☐	Date of BOM Explosion/Routing Transfer
140	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
141	AUFPL	AFKO	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
142	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
143	FHORI	AFKO	FHORI		☐	FHORI	☐	Scheduling Margin Key for Floats
144	TERKZ	AFKO	TERKZ		☐	TERMKZ	☐	Scheduling type
145	REDKZ	AFKO	REDKZ		☐	REDKZ	☐	Reduction indicator for scheduling
146	APRIO	AFKO	APRIO		☐	CO_APRIO	☐	Order priority
147	AUFNT	AFKO	AUFNT		☐	CO_TEILNET	☐	Number of superior network
148	AUFPT	AFKO	AUFPT		☐	CO_AUFPL	☐	Routing number of operations in the order
149	APLZT	AFKO	APLZT		☐	CO_APLZL	☐	General counter for order
150	PROFID	AFKO	PROFID		☐	PROFIDNZPL	☐	Network profile
151	VORGZ	AFKO	VORGZ		☐	VORGZ	☐	Float before production (in days)
152	SICHZ	AFKO	SICHZ		☐	SICHZ	☐	Float after production (in days)
153	FREIZ	AFKO	FREIZ		☐	FREIZ	☐	Release period (in days)
154	UPTER	AFKO	UPTER		☐	CO_UPTER	☐	Indicator: Change to Scheduled Dates
155	BEDID	AFKO	BEDID		☐	BEDID	☐	ID of the capacity requirements record
156	PRONR	AFKO	PRONR		☐	PS_PSP_PRO	☐	Project definition
157	ZAEHL	AFKO	ZAEHL		☐	CIM_COUNT	☐	Internal counter
158	MZAEHL	AFKO	MZAEHL		☐	CIM_COUNT	☐	Internal counter
159	ZKRIZ	AFKO	ZKRIZ		☐	DZKRIZ	☐	Counter for additional criteria
160	PRUEFLOS	AFKO	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
161	KLVARP	AFKO	KLVARP		☐	KALKVARPLN	☐	Costing variant for planned costs
162	KLVARI	AFKO	KLVARI		☐	KALKVARIST	☐	Costing variant for actual costs
163	RGEKZ	AFKO	RGEKZ		☐	CO_RGEKZ	☐	Indicator: Backflushing for order
164	PLART	AFKO	PLART		☐	PS_PLART	☐	Basis for scheduling
165	ADDAT	AFIH	ADDAT		☐	ADDAT	☐	PM Order: Reference Date
166	ADUHR	AFIH	ADUHR		☐	ADUHR	☐	Time of Reference Date
167	IPHAS	AFIH	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
168	ILART	AFIH	ILART		☐	ILA	☐	Maintenance activity type
169	QMNUM	AFIH	QMNUM		☐	QMNUM	☐	Message Number
170	FLG_AOB	AFKO	FLG_AOB		☐	FLG_AOB	☐	Indicator: relationships
171	FLG_ARBEI	AFKO	FLG_ARBEI		☐	FLG_ARBEI	☐	Indicator: Default value work is relevant
172	GLTPP	AFKO	GLTPP		☐	CO_GLTPP	☐	Finish date (forecast)
173	GSTPP	AFKO	GSTPP		☐	CO_GSTPP	☐	Forecast start date
174	GLTPS	AFKO	GLTPS		☐	CO_GLTPS	☐	Scheduled forecast finish
175	GSTPS	AFKO	GSTPS		☐	CO_GSTPS	☐	Scheduled forecast start
176	FTRPS	AFKO	FTRPS		☐	CO_FTRPS	☐	Scheduled release date (forecast)
177	RDKZP	AFKO	RDKZP		☐	REDKZP	☐	Reduction indicator for scheduling (forecast)
178	TRKZP	AFKO	TRKZP		☐	TERMKZP	☐	Scheduling type (forecast)
179	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
180	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
181	SPART	ILOA	SPART		☐	SPART	☐	Division
182	ADRNR_ILOA	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
183	KDAUF	AUFK	KDAUF		☐	KDAUF	☐	Sales Order Number
184	KDPOS	AUFK	KDPOS		☐	KDPOS	☐	Item number in Sales Order
185	GLUZP	AFKO	GLUZP		☐	CO_GLUZP	☐	Basic finish (time)
186	GSUZP	AFKO	GSUZP		☐	CO_GSUZP	☐	Basic start time
187	GLUZS	AFKO	GLUZS		☐	CO_GLUZS	☐	Scheduled finish time
188	GSUZS	AFKO	GSUZS		☐	CO_GSUZS	☐	Scheduled Start (Time)
189	MAUFNR	AFKO	MAUFNR		☐	MAUFNR	☐	Number of superior order
190	LEAD_AUFNR	AFKO	LEAD_AUFNR		☐	CO_LAUFNR	☐	Leading order in current processing
191	GEUZI	AFKO	GEUZI		☐	CO_GEUZI	☐	Confirmed order finish (time)
192	GSUZI	AFKO	GSUZI		☐	CO_GSUZI	☐	Actual start time
193	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
194	PLKNZ	AFIH	PLKNZ		☐	AUF_PLKNZ	☐	Maintenance order planning indicator
195	USER4	AUFK	USER4		☐	AUFUSER4	☐	Estimated total costs of order
196	RSORD	AUFK	RSORD		☐	RSORD	☐	Refurbishment order indicator (PM)
197	BEMOT	AUFK	BEMOT		☐	BEMOT	☐	Accounting Indicator
198	SERMAT	AFIH	SERMAT		☐	MATNR	☐	Material Number
199	SERIALNR	AFIH	SERIALNR		☐	GERNR	☐	Serial Number
200	DEVICEID	AFIH	DEVICEID		☐	DEVICEID	☐	Additional Device Data
201	ADRNRA	AUFK	ADRNRA		☐	AD_ADDRNUM	☐	Address number
202	.APPEND	/CUM/VIAUFKS_APP			☐		☐
203	/CUM/CMNUM	AUFK	/CUM/CMNUM		☐	/CUM/CMNUM	☐	CU: Construction Measure Number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130603
SAP Release Created in