SAP ABAP View VIAFVC_SML (Order operations selection exclusive status 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	VIAFVC_SML
Short Description	Order operations selection exclusive status for IW37
Root table	AFVC	Operation within an order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFVC	AFVC
2	AFVV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFVC	MANDT	JL	EQ				0	0
2	AFVV	MANDT	JR	EQ			AND	0	0
3	AFVC	AUFPL	JL	EQ				0	0
4	AFVV	AUFPL	JR	EQ			AND	0	0
5	AFVC	APLZL	JL	EQ				0	0
6	AFVV	APLZL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFVC	MANDT		☐	MANDT	☐	Client
2	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
3	APLZL	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
4	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
5	STEUS	AFVC	STEUS		☐	STEUS	☐	Control key
6	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
7	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
8	KTSCH	AFVC	KTSCH		☐	KTSCH	☐	Standard text key
9	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
10	LOANZ	AFVC	LOANZ		☐	LOHNANZ	☐	Number of Time Tickets
11	LOART	AFVC	LOART		☐	LOHNART	☐	Wage type
12	RSANZ	AFVC	RSANZ		☐	CR_RS_ANZ	☐	Number of confirmation slips
13	QUALF	AFVC	QUALF		☐	QUALF	☐	Suitability
14	ANZMA	AFVC	ANZMA		☐	ANZMS	☐	Number of employees
15	LOGRP	AFVC	LOGRP		☐	LOHNGRP	☐	Wage group
16	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
17	LIFNR	AFVC	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
18	PREIS	AFVC	PREIS		☐	PREIS	☐	Price
19	PEINH	AFVC	PEINH		☐	PEINH	☐	Price unit
20	SAKTO	AFVC	SAKTO		☐	KSTAR	☐	Cost Element
21	WAERS	AFVC	WAERS		☐	WAERS	☐	Currency Key
22	INFNR	AFVC	INFNR		☐	INFNR	☐	Number of purchasing info record
23	EKORG	AFVC	EKORG		☐	EKORG	☐	Purchasing organization
24	EKGRP	AFVC	EKGRP		☐	VG_EKGRP	☐	Purchasing group for external processing
25	MATKL	AFVC	MATKL		☐	MATKL	☐	Material Group
26	ANZZL	AFVC	ANZZL		☐	ANZKAP	☐	Number of capacities required
27	PRZNT	AFVC	PRZNT		☐	APROZENT	☐	Work percentage
28	BUKRS	AFVC	BUKRS		☐	BUKRS	☐	Company Code
29	INDET	AFVC	INDET		☐	INDET	☐	Calculation key
30	LARNT	AFVC	LARNT		☐	LSTAR	☐	Activity Type
31	RUECK	AFVC	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
32	RMZHL	AFVC	RMZHL		☐	CO_RMZHL	☐	Confirmation counter
33	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
34	BANFN	AFVC	BANFN		☐	CO_BANFN	☐	Purchase requisition number
35	BNFPO	AFVC	BNFPO		☐	CO_BNFPO	☐	Item number of the purchase requisition in the order
36	SELKZ	AFVC	SELKZ		☐	CO_SELKZ	☐	Selection indicator for costing line items
37	ANLZU	AFVC	ANLZU		☐	ANLZU	☐	Syst.Condition
38	ISTRU	AFVC	ISTRU		☐	ISTRU	☐	Assembly
39	EBORT	AFVC	EBORT		☐	EBORT	☐	Installation Point for Subitem
40	MEINH	AFVV	MEINH		☐	VORME	☐	Unit of measure for activity
41	DAUNO	AFVV	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
42	DAUNE	AFVV	DAUNE		☐	DAUNORE	☐	Normal duration/unit
43	DAUMI	AFVV	DAUMI		☐	DAUMIN	☐	Minimum activity duration
44	DAUME	AFVV	DAUME		☐	DAUMINE	☐	Unit for the minimum duration
45	EINSA	AFVV	EINSA		☐	EINSCHRA	☐	Constraint on the basic start date for the activity
46	EINSE	AFVV	EINSE		☐	EINSCHRE	☐	Constraint on the finish date of the activity
47	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
48	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
49	FSAVD	AFVV	FSAVD		☐	FSAVD	☐	Earliest scheduled start: Execution (date)
50	FSAVZ	AFVV	FSAVZ		☐	FSAVZ	☐	Earliest scheduled start: Execution (time)
51	FSEDD	AFVV	FSEDD		☐	FSEDD	☐	Earliest scheduled finish: Execution (date)
52	FSEDZ	AFVV	FSEDZ		☐	FSEDZ	☐	Earliest scheduled finish: Execution (time)
53	SSAVD	AFVV	SSAVD		☐	SSAVD	☐	Latest scheduled start: Execution (date)
54	SSAVZ	AFVV	SSAVZ		☐	SSAVZ	☐	Latest scheduled start: Execution (time)
55	SSEDD	AFVV	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
56	SSEDZ	AFVV	SSEDZ		☐	SSEDZ	☐	Latest scheduled finish: Execution (time)
57	ISDD	AFVV	ISDD		☐	ISDD	☐	Actual start: Execution (date)
58	ISDZ	AFVV	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
59	IEDD	AFVV	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
60	IEDZ	AFVV	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
61	PUFFR	AFVV	PUFFR		☐	PUFFR_FREI	☐	Free float
62	PUFGS	AFVV	PUFGS		☐	PUFFR_GESM	☐	Total float
63	NTANF	AFVV	NTANF		☐	VORGABESTD	☐	Constraint for activity start (Basic)
64	NTANZ	AFVV	NTANZ		☐	VORGABESTZ	☐	Constraint for activity start time (Basic)
65	NTEND	AFVV	NTEND		☐	VORGABEEND2	☐	Constraint for Finish of Activity (Basic)
66	NTENZ	AFVV	NTENZ		☐	VORGABEENZ	☐	Basic finish time of the activity
67	ISMNW	AFVV	ISMNW		☐	CO_ISMNW	☐	Actual work
68	AUFKT	AFVV	AUFKT		☐	AFAKT	☐	Execution Factor
69	PERNR	AFVC	PERNR		☐	CO_PERNR	☐	Personnel number
70	TXTSP	AFVC	TXTSP		☐	SPRAS	☐	Language Key

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	20130529
SAP Release Created in