SAP ABAP Table VIAUF_AFVC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIAUF_AFVC	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	ILOAN	☑	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object
4	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
5	APLZL	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
6	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
7	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
8	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
9	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
10	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
11	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
12	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
13	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
14	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
15	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
16	STORT	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
17	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
18	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
19	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
20	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
21	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
22	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
23	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
24	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
25	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
26	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
27	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
28	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
29	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
30	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
31	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
32	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
33	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
34	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
35	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
36	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
37	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
38	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
39	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
40	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
41	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
42	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
43	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
44	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
45	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
46	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
47	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
48	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
49	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
50	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
51	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
52	SELKZ	☐	CO_SELKZ	CK_SELKZ	CHAR	1	0	Selection indicator for costing line items	TCK08
53	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
54	ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly	MARA
55	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
56	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
57	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
58	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
59	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
60	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
61	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
62	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
63	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
64	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
65	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
66	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
67	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
68	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
69	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
70	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
71	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
72	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
73	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
74	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
75	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
76	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
77	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
78	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
79	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
80	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
81	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
82	NTEND	☐	VORGABEEND2	VORGABEEND	DATS	8	0	Constraint for Finish of Activity (Basic)
83	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
84	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
85	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
86	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
87	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
88	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
89	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
90	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
91	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
92	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
93	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
94	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
95	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
96	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
97	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
98	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
99	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
100	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
101	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
102	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
103	/CUM/CUGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)	/CUM/AFCU

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAUF_AFVC	/CUM/CUGUID	/CUM/AFCU	CUGUID	KEY	1	CN
2	VIAUF_AFVC	ANLZU	T357M	ANLZU
3	VIAUF_AFVC	ARBEH	T006	MSEHI
4	VIAUF_AFVC	ARBID	CRID	OBJID
5	VIAUF_AFVC	ARTPR	T356A	ARTPR	REF	C	CN
6	VIAUF_AFVC	AUART	T003O	AUART	REF	1	CN
7	VIAUF_AFVC	AUFNR	AUFK	AUFNR	KEY	1	CN
8	VIAUF_AFVC	BAUTL	MARA	MATNR	REF	C	CN
9	VIAUF_AFVC	BEMOT	TBMOT	BEMOT
10	VIAUF_AFVC	BNFPO	EBAN	BNFPO
11	VIAUF_AFVC	BUKRS	T001	BUKRS
12	VIAUF_AFVC	DAUME	T006	MSEHI
13	VIAUF_AFVC	DAUNE	T006	MSEHI
14	VIAUF_AFVC	EKGRP	T024	EKGRP
15	VIAUF_AFVC	EKORG	T024E	EKORG
16	VIAUF_AFVC	EQUNR	EQUI	EQUNR	REF	C	CN
17	VIAUF_AFVC	INFNR	EINA	INFNR
18	VIAUF_AFVC	INGPR	T024I	INGRP	REF	C	CN
19	VIAUF_AFVC	ISTRU	MARA	MATNR
20	VIAUF_AFVC	IWERK	T399I	IWERK	REF	C	CN
21	VIAUF_AFVC	KOKRS	TKA01	KOKRS	REF	1	CN
22	VIAUF_AFVC	KOSTV	CSKS	KOSTL		1	CN
23	VIAUF_AFVC	KTSCH	T435	VLSCH
24	VIAUF_AFVC	LIFNR	LFA1	LIFNR
25	VIAUF_AFVC	LOGRP	T421	LOGRP
26	VIAUF_AFVC	MANDT	T000	MANDT	KEY	1	CN
27	VIAUF_AFVC	MATKL	T023	MATKL
28	VIAUF_AFVC	MEINH	T006	MSEHI
29	VIAUF_AFVC	OBJNR	ONR00	OBJNR
30	VIAUF_AFVC	PRIOK	T356	PRIOK	REF	C	CN
31	VIAUF_AFVC	QUALF	T423	QUALF
32	VIAUF_AFVC	SAKTO	CSKA	KSTAR
33	VIAUF_AFVC	SELKZ	TCK08	SELKZ
34	VIAUF_AFVC	SERMAT	MARA	MATNR
35	VIAUF_AFVC	SOWRK	T001W	WERKS	REF	1	CN
36	VIAUF_AFVC	STEUS	T430	STEUS
37	VIAUF_AFVC	STORT	T499S	STAND	REF	1	CN
38	VIAUF_AFVC	SWERK	T001W	WERKS	REF	1	CN
39	VIAUF_AFVC	TPLNR	IFLOT	TPLNR	REF	C	CN
40	VIAUF_AFVC	TXTSP	T002	SPRAS
41	VIAUF_AFVC	WAERS	TCURC	WAERS
42	VIAUF_AFVC	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130603
SAP Release Created in