SAP ABAP View VIAUF_AFVC (Maintenance orders and operations (for IW37))

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	VIAUF_AFVC
Short Description	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	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
19	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
20	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
21	STEUS	AFVC	STEUS		☐	STEUS	☐	Control key
22	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
23	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
24	KTSCH	AFVC	KTSCH		☐	KTSCH	☐	Standard text key
25	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
26	LOANZ	AFVC	LOANZ		☐	LOHNANZ	☐	Number of Time Tickets
27	LOART	AFVC	LOART		☐	LOHNART	☐	Wage type
28	RSANZ	AFVC	RSANZ		☐	CR_RS_ANZ	☐	Number of confirmation slips
29	QUALF	AFVC	QUALF		☐	QUALF	☐	Suitability
30	ANZMA	AFVC	ANZMA		☐	ANZMS	☐	Number of employees
31	LOGRP	AFVC	LOGRP		☐	LOHNGRP	☐	Wage group
32	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
33	LIFNR	AFVC	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
34	PREIS	AFVC	PREIS		☐	PREIS	☐	Price
35	PEINH	AFVC	PEINH		☐	PEINH	☐	Price unit
36	SAKTO	AFVC	SAKTO		☐	KSTAR	☐	Cost Element
37	WAERS	AFVC	WAERS		☐	WAERS	☐	Currency Key
38	INFNR	AFVC	INFNR		☐	INFNR	☐	Number of purchasing info record
39	EKORG	AFVC	EKORG		☐	EKORG	☐	Purchasing organization
40	EKGRP	AFVC	EKGRP		☐	VG_EKGRP	☐	Purchasing group for external processing
41	MATKL	AFVC	MATKL		☐	MATKL	☐	Material Group
42	ANZZL	AFVC	ANZZL		☐	ANZKAP	☐	Number of capacities required
43	PRZNT	AFVC	PRZNT		☐	APROZENT	☐	Work percentage
44	BUKRS	AFVC	BUKRS		☐	BUKRS	☐	Company Code
45	INDET	AFVC	INDET		☐	INDET	☐	Calculation key
46	LARNT	AFVC	LARNT		☐	LSTAR	☐	Activity Type
47	RUECK	AFVC	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
48	RMZHL	AFVC	RMZHL		☐	CO_RMZHL	☐	Confirmation counter
49	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
50	BANFN	AFVC	BANFN		☐	CO_BANFN	☐	Purchase requisition number
51	BNFPO	AFVC	BNFPO		☐	CO_BNFPO	☐	Item number of the purchase requisition in the order
52	SELKZ	AFVC	SELKZ		☐	CO_SELKZ	☐	Selection indicator for costing line items
53	ANLZU	AFVC	ANLZU		☐	ANLZU	☐	Syst.Condition
54	ISTRU	AFVC	ISTRU		☐	ISTRU	☐	Assembly
55	EBORT	AFVC	EBORT		☐	EBORT	☐	Installation Point for Subitem
56	MEINH	AFVV	MEINH		☐	VORME	☐	Unit of measure for activity
57	DAUNO	AFVV	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
58	DAUNE	AFVV	DAUNE		☐	DAUNORE	☐	Normal duration/unit
59	DAUMI	AFVV	DAUMI		☐	DAUMIN	☐	Minimum activity duration
60	DAUME	AFVV	DAUME		☐	DAUMINE	☐	Unit for the minimum duration
61	EINSA	AFVV	EINSA		☐	EINSCHRA	☐	Constraint on the basic start date for the activity
62	EINSE	AFVV	EINSE		☐	EINSCHRE	☐	Constraint on the finish date of the activity
63	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
64	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
65	ISMNW	AFVV	ISMNW		☐	CO_ISMNW	☐	Actual work
66	FSAVD	AFVV	FSAVD		☐	FSAVD	☐	Earliest scheduled start: Execution (date)
67	FSAVZ	AFVV	FSAVZ		☐	FSAVZ	☐	Earliest scheduled start: Execution (time)
68	FSEDD	AFVV	FSEDD		☐	FSEDD	☐	Earliest scheduled finish: Execution (date)
69	FSEDZ	AFVV	FSEDZ		☐	FSEDZ	☐	Earliest scheduled finish: Execution (time)
70	SSAVD	AFVV	SSAVD		☐	SSAVD	☐	Latest scheduled start: Execution (date)
71	SSAVZ	AFVV	SSAVZ		☐	SSAVZ	☐	Latest scheduled start: Execution (time)
72	SSEDD	AFVV	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
73	SSEDZ	AFVV	SSEDZ		☐	SSEDZ	☐	Latest scheduled finish: Execution (time)
74	ISDD	AFVV	ISDD		☐	ISDD	☐	Actual start: Execution (date)
75	ISDZ	AFVV	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
76	IEDD	AFVV	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
77	IEDZ	AFVV	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
78	PUFFR	AFVV	PUFFR		☐	PUFFR_FREI	☐	Free float
79	PUFGS	AFVV	PUFGS		☐	PUFFR_GESM	☐	Total float
80	NTANF	AFVV	NTANF		☐	VORGABESTD	☐	Constraint for activity start (Basic)
81	NTANZ	AFVV	NTANZ		☐	VORGABESTZ	☐	Constraint for activity start time (Basic)
82	NTEND	AFVV	NTEND		☐	VORGABEEND2	☐	Constraint for Finish of Activity (Basic)
83	NTENZ	AFVV	NTENZ		☐	VORGABEENZ	☐	Basic finish time of the activity
84	AUFKT	AFVV	AUFKT		☐	AFAKT	☐	Execution Factor
85	BEMOT	AUFK	BEMOT		☐	BEMOT	☐	Accounting Indicator
86	ADRNRA	AUFK	ADRNRA		☐	AD_ADDRNUM	☐	Address number
87	ABLAD	AFVC	ABLAD		☐	ABLAD	☐	Unloading Point
88	WEMPF	AFVC	WEMPF		☐	WEMPF	☐	Goods recipient
89	SERMAT	AFIH	SERMAT		☐	MATNR	☐	Material Number
90	SERIALNR	AFIH	SERIALNR		☐	GERNR	☐	Serial Number
91	DEVICEID	AFIH	DEVICEID		☐	DEVICEID	☐	Additional Device Data
92	PERNR	AFVC	PERNR		☐	CO_PERNR	☐	Personnel number
93	TXTSP	AFVC	TXTSP		☐	SPRAS	☐	Language Key
94	PHFLG	AFVC	PHFLG		☐	PHFLG	☐	Indicator: Phase
95	OFMNW	AFVV	OFMNW		☐	OFMNW	☐	Forecasted work (actual + remaining)
96	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
97	UII	AFIH	UII		☐	UII_CHAR72	☐	Unique Item Identifier
98	ADUHR	AFIH	ADUHR		☐	ADUHR	☐	Time of Reference Date
99	.APPEND	/CUM/ORDER_APP			☐		☐
100	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
101	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
102	KOSTV	AUFK	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
103	/CUM/CMNUM	AUFK	/CUM/CMNUM		☐	/CUM/CMNUM	☐	CU: Construction Measure Number
104	/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