SAP ABAP View VIAFKOS (PM Order Selection)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing

Basic Data

View Type	D	Database View
Database View	VIAFKOS
Short Description	PM Order Selection
Root table	AFKO	Order Header Data PP Orders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFKO	AFKO
2	AUFK
3	AFIH
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	AFKO	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFKO	AUFNR	JR	EQ			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFIH	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFIH	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	AFKO	MANDT		☐	MANDT	☐	Client
2	AUFNR	AFKO	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	KOSTL_ILOA	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
94	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
95	BUKRS_ILOA	ILOA	BUKRS		☐	BUKRS	☐	Company Code
96	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
97	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
98	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
99	AUFNR_ILOA	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
100	GLTRP	AFKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
101	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
102	FTRMS	AFKO	FTRMS		☐	CO_FTRMS	☐	Scheduled release date
103	GLTRS	AFKO	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
104	GSTRS	AFKO	GSTRS		☐	CO_GSTRS	☐	Scheduled start
105	GSTRI	AFKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
106	GETRI	AFKO	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
107	GLTRI	AFKO	GLTRI		☐	CO_GLTRI	☐	Actual finish date
108	FTRMI	AFKO	FTRMI		☐	CO_FTRMI	☐	Actual release date
109	FTRMP	AFKO	FTRMP		☐	CO_FTRMP	☐	Planned release date
110	RSNUM	AFKO	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
111	GASMG	AFKO	GASMG		☐	GASMG	☐	Total scrap quantity in the order
112	GAMNG	AFKO	GAMNG		☐	GAMNG	☐	Total order quantity
113	GMEIN	AFKO	GMEIN		☐	MEINS	☐	Base Unit of Measure
114	PLNBEZ	AFKO	PLNBEZ		☐	MATNR	☐	Material Number
115	PLNTY	AFKO	PLNTY		☐	PLNTY	☐	Task List Type
116	PLNNR	AFKO	PLNNR		☐	PLNNR	☐	Key for Task List Group
117	PLNAW	AFKO	PLNAW		☐	PLNAW	☐	Application of the task list
118	PLNAL	AFKO	PLNAL		☐	PLNAL	☐	Group Counter
119	PVERW	AFKO	PVERW		☐	PLN_VERWE	☐	Task list usage
120	PLAUF	AFKO	PLAUF		☐	CO_PLAUF	☐	Date for routing transfer
121	PLSVB	AFKO	PLSVB		☐	LOSGRBIS	☐	To lot size
122	PLNME	AFKO	PLNME		☐	PLNME	☐	Task list unit of measure
123	PLSVN	AFKO	PLSVN		☐	LOSGRVON	☐	From Lot Size
124	PDATV	AFKO	PDATV		☐	DATUV	☐	Valid-From Date
125	PAENR	AFKO	PAENR		☐	AENNR	☐	Change Number
126	PLGRP	AFKO	PLGRP		☐	VAGRP	☐	Responsible planner group/department
127	LODIV	AFKO	LODIV		☐	LOSDIV	☐	Lot size divisor
128	STLTY	AFKO	STLTY		☐	STLTY	☐	BOM Category
129	STLBEZ	AFKO	STLBEZ		☐	MATNR	☐	Material Number
130	STLST	AFKO	STLST		☐	STLST	☐	BOM Statuses
131	STLNR	AFKO	STLNR		☐	STNUM	☐	Bill of Material
132	SDATV	AFKO	SDATV		☐	DATUV	☐	Valid-From Date
133	SBMNG	AFKO	SBMNG		☐	BASMN	☐	Base quantity
134	SBMEH	AFKO	SBMEH		☐	MEINS	☐	Base Unit of Measure
135	SAENR	AFKO	SAENR		☐	AENNR	☐	Change Number
136	STLAL	AFKO	STLAL		☐	STALT	☐	Alternative BOM
137	STLAN	AFKO	STLAN		☐	STLAN	☐	BOM Usage
138	SLSVN	AFKO	SLSVN		☐	LOSVN	☐	From Lot Size
139	SLSBS	AFKO	SLSBS		☐	LOSBS	☐	To Lot Size
140	AUFLD	AFKO	AUFLD		☐	CO_AUFLD	☐	Date of BOM Explosion/Routing Transfer
141	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
142	AUFPL	AFKO	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
143	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
144	FHORI	AFKO	FHORI		☐	FHORI	☐	Scheduling Margin Key for Floats
145	TERKZ	AFKO	TERKZ		☐	TERMKZ	☐	Scheduling type
146	REDKZ	AFKO	REDKZ		☐	REDKZ	☐	Reduction indicator for scheduling
147	APRIO	AFKO	APRIO		☐	CO_APRIO	☐	Order priority
148	AUFNT	AFKO	AUFNT		☐	CO_TEILNET	☐	Number of superior network
149	AUFPT	AFKO	AUFPT		☐	CO_AUFPL	☐	Routing number of operations in the order
150	APLZT	AFKO	APLZT		☐	CO_APLZL	☐	General counter for order
151	PROFID	AFKO	PROFID		☐	PROFIDNZPL	☐	Network profile
152	VORGZ	AFKO	VORGZ		☐	VORGZ	☐	Float before production (in days)
153	SICHZ	AFKO	SICHZ		☐	SICHZ	☐	Float after production (in days)
154	FREIZ	AFKO	FREIZ		☐	FREIZ	☐	Release period (in days)
155	UPTER	AFKO	UPTER		☐	CO_UPTER	☐	Indicator: Change to Scheduled Dates
156	BEDID	AFKO	BEDID		☐	BEDID	☐	ID of the capacity requirements record
157	PRONR	AFKO	PRONR		☐	PS_PSP_PRO	☐	Project definition
158	ZAEHL	AFKO	ZAEHL		☐	CIM_COUNT	☐	Internal counter
159	MZAEHL	AFKO	MZAEHL		☐	CIM_COUNT	☐	Internal counter
160	ZKRIZ	AFKO	ZKRIZ		☐	DZKRIZ	☐	Counter for additional criteria
161	PRUEFLOS	AFKO	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
162	KLVARP	AFKO	KLVARP		☐	KALKVARPLN	☐	Costing variant for planned costs
163	KLVARI	AFKO	KLVARI		☐	KALKVARIST	☐	Costing variant for actual costs
164	RGEKZ	AFKO	RGEKZ		☐	CO_RGEKZ	☐	Indicator: Backflushing for order
165	PLART	AFKO	PLART		☐	PS_PLART	☐	Basis for scheduling
166	ADDAT	AFIH	ADDAT		☐	ADDAT	☐	PM Order: Reference Date
167	ADUHR	AFIH	ADUHR		☐	ADUHR	☐	Time of Reference Date
168	IPHAS	AFIH	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
169	ILART	AFIH	ILART		☐	ILA	☐	Maintenance activity type
170	QMNUM	AFIH	QMNUM		☐	QMNUM	☐	Message Number
171	FLG_AOB	AFKO	FLG_AOB		☐	FLG_AOB	☐	Indicator: relationships
172	FLG_ARBEI	AFKO	FLG_ARBEI		☐	FLG_ARBEI	☐	Indicator: Default value work is relevant
173	GLTPP	AFKO	GLTPP		☐	CO_GLTPP	☐	Finish date (forecast)
174	GSTPP	AFKO	GSTPP		☐	CO_GSTPP	☐	Forecast start date
175	GLTPS	AFKO	GLTPS		☐	CO_GLTPS	☐	Scheduled forecast finish
176	GSTPS	AFKO	GSTPS		☐	CO_GSTPS	☐	Scheduled forecast start
177	FTRPS	AFKO	FTRPS		☐	CO_FTRPS	☐	Scheduled release date (forecast)
178	RDKZP	AFKO	RDKZP		☐	REDKZP	☐	Reduction indicator for scheduling (forecast)
179	TRKZP	AFKO	TRKZP		☐	TERMKZP	☐	Scheduling type (forecast)
180	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
181	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
182	SPART	ILOA	SPART		☐	SPART	☐	Division
183	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
184	KDAUF	AUFK	KDAUF		☐	KDAUF	☐	Sales Order Number
185	KDPOS	AUFK	KDPOS		☐	KDPOS	☐	Item number in Sales Order
186	GLUZP	AFKO	GLUZP		☐	CO_GLUZP	☐	Basic finish (time)
187	GSUZP	AFKO	GSUZP		☐	CO_GSUZP	☐	Basic start time
188	GLUZS	AFKO	GLUZS		☐	CO_GLUZS	☐	Scheduled finish time
189	GSUZS	AFKO	GSUZS		☐	CO_GSUZS	☐	Scheduled Start (Time)
190	MAUFNR	AFKO	MAUFNR		☐	MAUFNR	☐	Number of superior order
191	LEAD_AUFNR	AFKO	LEAD_AUFNR		☐	CO_LAUFNR	☐	Leading order in current processing
192	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
193	SERMAT	AFIH	SERMAT		☐	MATNR	☐	Material Number
194	SERIALNR	AFIH	SERIALNR		☐	GERNR	☐	Serial Number
195	DEVICEID	AFIH	DEVICEID		☐	DEVICEID	☐	Additional Device Data
196	UII	AFIH	UII		☐	UII_CHAR72	☐	Unique Item Identifier
197	.APPEND	/CUM/APP_VIAFKOS			☐		☐
198	/CUM/CMNUM	AUFK	/CUM/CMNUM		☐	/CUM/CMNUM	☐	CU: Construction Measure Number
199	/CUM/DESNUM	AUFK	/CUM/DESNUM		☐	/CUM/DESNUM	☐	CU: Design 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