SAP ABAP View /CUM/VIAUF_AFVC (CU: Maintenance Orders and Operations (for IW37))

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/VIAUF_AFVC
Short Description	CU: Maintenance Orders and Operations (for IW37)
Root table	AFIH	Maintenance order header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFIH	AFIH
2	AUFK
3	AFKO
4	AFVC
5	AFVV
6	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	AFKO	MANDT	JL	EQ				0	0
6	AUFK	MANDT	JR	EQ			AND	0	0
7	AFKO	AUFNR	JL	EQ				0	0
8	AUFK	AUFNR	JR	EQ			AND	0	0
9	AFVC	MANDT	JL	EQ				0	0
10	AFKO	MANDT	JR	EQ			AND	0	0
11	AFVC	AUFPL	JL	EQ				0	0
12	AFKO	AUFPL	JR	EQ			AND	0	0
13	AFVV	MANDT	JL	EQ				0	0
14	AFVC	MANDT	JR	EQ			AND	0	0
15	AFVV	AUFPL	JL	EQ				0	0
16	AFVC	AUFPL	JR	EQ			AND	0	0
17	AFVV	APLZL	JL	EQ				0	0
18	AFVC	APLZL	JR	EQ			AND	0	0
19	ILOA	MANDT	JL	EQ				0	0
20	AFIH	MANDT	JR	EQ			AND	0	0
21	ILOA	ILOAN	JL	EQ				0	0
22	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	ILOAN	ILOA	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
4	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
5	APLZL	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
6	IPHAS	AFIH	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
7	PRIOK	AFIH	PRIOK		☐	PRIOK	☐	Priority
8	ARTPR	AFIH	ARTPR		☐	ARTPR	☐	Priority Type
9	EQUNR	AFIH	EQUNR		☐	EQUNR	☐	Equipment Number
10	BAUTL	AFIH	BAUTL		☐	BAUTL	☐	Assembly
11	INGPR	AFIH	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
12	IWERK	AFIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
13	INSPK	AFIH	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
14	ADDAT	AFIH	ADDAT		☐	ADDAT	☐	PM Order: Reference Date
15	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
16	STORT	AUFK	STORT		☐	AUFSTORT	☐	Location
17	SOWRK	AUFK	SOWRK		☐	AUFSOWRK	☐	Location plant
18	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
19	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
20	KOSTV	AUFK	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
21	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
22	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
23	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
24	STEUS	AFVC	STEUS		☐	STEUS	☐	Control key
25	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
26	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
27	KTSCH	AFVC	KTSCH		☐	KTSCH	☐	Standard text key
28	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
29	LOANZ	AFVC	LOANZ		☐	LOHNANZ	☐	Number of Time Tickets
30	LOART	AFVC	LOART		☐	LOHNART	☐	Wage type
31	RSANZ	AFVC	RSANZ		☐	CR_RS_ANZ	☐	Number of confirmation slips
32	QUALF	AFVC	QUALF		☐	QUALF	☐	Suitability
33	ANZMA	AFVC	ANZMA		☐	ANZMS	☐	Number of employees
34	LOGRP	AFVC	LOGRP		☐	LOHNGRP	☐	Wage group
35	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
36	LIFNR	AFVC	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
37	PREIS	AFVC	PREIS		☐	PREIS	☐	Price
38	PEINH	AFVC	PEINH		☐	PEINH	☐	Price unit
39	SAKTO	AFVC	SAKTO		☐	KSTAR	☐	Cost Element
40	WAERS	AFVC	WAERS		☐	WAERS	☐	Currency Key
41	INFNR	AFVC	INFNR		☐	INFNR	☐	Number of purchasing info record
42	EKORG	AFVC	EKORG		☐	EKORG	☐	Purchasing organization
43	EKGRP	AFVC	EKGRP		☐	VG_EKGRP	☐	Purchasing group for external processing
44	MATKL	AFVC	MATKL		☐	MATKL	☐	Material Group
45	ANZZL	AFVC	ANZZL		☐	ANZKAP	☐	Number of capacities required
46	PRZNT	AFVC	PRZNT		☐	APROZENT	☐	Work percentage
47	BUKRS	AFVC	BUKRS		☐	BUKRS	☐	Company Code
48	INDET	AFVC	INDET		☐	INDET	☐	Calculation key
49	LARNT	AFVC	LARNT		☐	LSTAR	☐	Activity Type
50	RUECK	AFVC	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
51	RMZHL	AFVC	RMZHL		☐	CO_RMZHL	☐	Confirmation counter
52	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
53	BANFN	AFVC	BANFN		☐	CO_BANFN	☐	Purchase requisition number
54	BNFPO	AFVC	BNFPO		☐	CO_BNFPO	☐	Item number of the purchase requisition in the order
55	SELKZ	AFVC	SELKZ		☐	CO_SELKZ	☐	Selection indicator for costing line items
56	ANLZU	AFVC	ANLZU		☐	ANLZU	☐	Syst.Condition
57	ISTRU	AFVC	ISTRU		☐	ISTRU	☐	Assembly
58	EBORT	AFVC	EBORT		☐	EBORT	☐	Installation Point for Subitem
59	MEINH	AFVV	MEINH		☐	VORME	☐	Unit of measure for activity
60	DAUNO	AFVV	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
61	DAUNE	AFVV	DAUNE		☐	DAUNORE	☐	Normal duration/unit
62	DAUMI	AFVV	DAUMI		☐	DAUMIN	☐	Minimum activity duration
63	DAUME	AFVV	DAUME		☐	DAUMINE	☐	Unit for the minimum duration
64	EINSA	AFVV	EINSA		☐	EINSCHRA	☐	Constraint on the basic start date for the activity
65	EINSE	AFVV	EINSE		☐	EINSCHRE	☐	Constraint on the finish date of the activity
66	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
67	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
68	ISMNW	AFVV	ISMNW		☐	CO_ISMNW	☐	Actual work
69	FSAVD	AFVV	FSAVD		☐	FSAVD	☐	Earliest scheduled start: Execution (date)
70	FSAVZ	AFVV	FSAVZ		☐	FSAVZ	☐	Earliest scheduled start: Execution (time)
71	FSEDD	AFVV	FSEDD		☐	FSEDD	☐	Earliest scheduled finish: Execution (date)
72	FSEDZ	AFVV	FSEDZ		☐	FSEDZ	☐	Earliest scheduled finish: Execution (time)
73	SSAVD	AFVV	SSAVD		☐	SSAVD	☐	Latest scheduled start: Execution (date)
74	SSAVZ	AFVV	SSAVZ		☐	SSAVZ	☐	Latest scheduled start: Execution (time)
75	SSEDD	AFVV	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
76	SSEDZ	AFVV	SSEDZ		☐	SSEDZ	☐	Latest scheduled finish: Execution (time)
77	ISDD	AFVV	ISDD		☐	ISDD	☐	Actual start: Execution (date)
78	ISDZ	AFVV	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
79	IEDD	AFVV	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
80	IEDZ	AFVV	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
81	PUFFR	AFVV	PUFFR		☐	PUFFR_FREI	☐	Free float
82	PUFGS	AFVV	PUFGS		☐	PUFFR_GESM	☐	Total float
83	NTANF	AFVV	NTANF		☐	VORGABESTD	☐	Constraint for activity start (Basic)
84	NTANZ	AFVV	NTANZ		☐	VORGABESTZ	☐	Constraint for activity start time (Basic)
85	NTEND	AFVV	NTEND		☐	VORGABEEND2	☐	Constraint for Finish of Activity (Basic)
86	NTENZ	AFVV	NTENZ		☐	VORGABEENZ	☐	Basic finish time of the activity
87	BEMOT	AUFK	BEMOT		☐	BEMOT	☐	Accounting Indicator
88	ADRNRA	AUFK	ADRNRA		☐	AD_ADDRNUM	☐	Address number
89	ABLAD	AFVC	ABLAD		☐	ABLAD	☐	Unloading Point
90	WEMPF	AFVC	WEMPF		☐	WEMPF	☐	Goods recipient
91	SERMAT	AFIH	SERMAT		☐	MATNR	☐	Material Number
92	SERIALNR	AFIH	SERIALNR		☐	GERNR	☐	Serial Number
93	DEVICEID	AFIH	DEVICEID		☐	DEVICEID	☐	Additional Device Data
94	PERNR	AFVC	PERNR		☐	CO_PERNR	☐	Personnel number
95	TXTSP	AFVC	TXTSP		☐	SPRAS	☐	Language Key
96	PHFLG	AFVC	PHFLG		☐	PHFLG	☐	Indicator: Phase
97	OFMNW	AFVV	OFMNW		☐	OFMNW	☐	Forecasted work (actual + remaining)
98	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
99	.APPEND	/CUM/VIAUF_APP			☐		☐
100	/CUM/CMNUM	AUFK	/CUM/CMNUM		☐	/CUM/CMNUM	☐	CU: Construction Measure Number
101	/CUM/CUGUID	AFVC	/CUM/CUGUID		☐	SYSUUID_X	☐	UUID in X form (binary)

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