SAP ABAP Table VIAUFK_AFVC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIAUFK_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	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
4	APLZL	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
5	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
6	STRNO	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
7	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
8	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
9	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
10	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
11	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
12	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
13	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
14	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
15	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
16	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
17	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
18	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
19	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
20	ANING	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
21	GAUZT	☐	GAUZT	FLTP	FLTP	16	16	Planned downtime in hours
22	GAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
23	ANLBD	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
24	ANLVD	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
25	ANLBZ	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
26	ANLVZ	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
27	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
28	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
29	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
30	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
31	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
32	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
33	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
34	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
35	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
36	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
37	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
38	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
39	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
40	HISDA	☐	HISDA	DATUM	DATS	8	0	PM request: History date
41	AKKNZ	☐	AKKNZ	AKKNZ	CHAR	1	0	Order Category Indicator Plant Maintenance
42	PLKNZ	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
43	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
44	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
45	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
46	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
47	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS
48	RSUPG	☐	RSUPG	XFIELD	CHAR	1	0	Upgrade Order Indicator
49	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
50	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment
51	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
52	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
53	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
54	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
55	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
56	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
57	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
58	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
59	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
60	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
61	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
62	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
63	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
64	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
65	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
66	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
67	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
68	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
69	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
70	ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status
71	STDAT	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
72	ESTNR	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
73	PDAT1	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
74	PDAT2	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
75	PDAT3	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
76	IDAT1	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
77	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
78	IDAT3	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
79	OBJID	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
80	VOGRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
81	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
82	PLGKZ	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
83	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
84	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
85	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
86	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
87	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
88	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	CSKB
89	SAKNR	☐	AUFSAKNR	SAKNR	CHAR	10	0	G/L account for basic settlement	SKB1
90	SETNM	☐	AUFSETNM	SETNR	CHAR	12	0	Allocation set
91	CYCLE	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
92	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date
93	SEQNR	☐	AUFSEQNR	SQNR	NUMC	4	0	Sequence number
94	USER2	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
95	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
96	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
97	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
98	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
99	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
100	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
101	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
102	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
103	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
104	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
105	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
106	IVPRO	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
107	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
108	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
109	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
110	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
111	RSORD	☐	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
112	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
113	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
114	ERFZEIT	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
115	AEZEIT	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
116	CSTG_VRNT	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant
117	COSTESTNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
118	VERAA_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	USR02
119	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
120	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
121	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
122	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
123	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
124	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
125	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
126	/CUM/INDCU	☐	/CUM/INDCU	FLAG	CHAR	1	0	CU: Order is Used for Compatible Units
127	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
128	/CUM/AUEST	☐	/CUM/AUEST	FLAG	CHAR	1	0	CU: Automatic Copy of Estimated Costs
129	/CUM/DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number
130	VAPLZ	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
131	WAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center
132	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
133	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
134	GSTRP	☐	PM_ORDGSTRP	DATUM	DATS	8	0	Basic Start Date
135	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
136	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
137	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
138	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
139	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
140	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
141	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
142	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
143	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
144	GASMG	☐	GASMG	MENG13	QUAN	13	3	Total scrap quantity in the order
145	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
146	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
147	PLNBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
148	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type
149	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
150	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	TCA09
151	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
152	PVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
153	PLAUF	☐	CO_PLAUF	DATUM	DATS	8	0	Date for routing transfer
154	PLSVB	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
155	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
156	PLSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
157	PDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
158	PAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
159	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
160	LODIV	☐	LOSDIV	MENG13	QUAN	13	3	Lot size divisor
161	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
162	STLBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
163	STLST	☐	STLST	STLST	NUMC	2	0	BOM Statuses	T415S
164	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
165	SDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
166	SBMNG	☐	BASMN	MENG13	QUAN	13	3	Base quantity
167	SBMEH	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
168	SAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
169	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
170	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
171	SLSVN	☐	LOSVN	MENG13	QUAN	13	3	From Lot Size
172	SLSBS	☐	LOSBS	MENG13	QUAN	13	3	To Lot Size
173	AUFLD	☐	CO_AUFLD	DATUM	DATS	8	0	Date of BOM Explosion/Routing Transfer
174	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
175	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
176	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	T436A
177	TERKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	T482
178	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
179	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
180	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network
181	AUFPT	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
182	APLZT	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
183	PROFID	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	TCN41
184	VORGZ	☐	VORGZ	NUM3	NUMC	3	0	Float before production (in days)
185	SICHZ	☐	SICHZ	NUM3	NUMC	3	0	Float after production (in days)
186	FREIZ	☐	FREIZ	NUM3	NUMC	3	0	Release period (in days)
187	UPTER	☐	CO_UPTER	CHAR1	CHAR	1	0	Indicator: Change to Scheduled Dates
188	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record
189	PRONR	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	PROJ
190	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
191	MZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
192	ZKRIZ	☐	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
193	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
194	KLVARP	☐	KALKVARPLN	KLVAR	CHAR	4	0	Costing variant for planned costs
195	KLVARI	☐	KALKVARIST	KLVAR	CHAR	4	0	Costing variant for actual costs
196	RGEKZ	☐	CO_RGEKZ	CO_RGEKZ	CHAR	1	0	Indicator: Backflushing for order
197	PLART	☐	PS_PLART	PS_PLART	CHAR	1	0	Basis for scheduling
198	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order
199	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
200	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
201	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
202	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
203	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
204	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
205	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
206	NO_DISP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
207	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
208	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
209	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
210	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
211	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
212	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
213	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
214	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
215	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
216	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
217	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number
218	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber
219	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
220	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
221	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
222	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
223	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
224	ADRNR_ILOA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
225	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
226	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
227	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
228	V_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
229	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
230	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
231	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
232	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
233	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
234	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
235	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
236	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
237	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
238	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
239	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
240	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
241	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
242	V_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
243	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
244	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
245	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
246	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
247	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
248	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
249	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
250	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
251	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
252	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
253	V_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
254	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
255	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
256	SELKZ	☐	CO_SELKZ	CK_SELKZ	CHAR	1	0	Selection indicator for costing line items	TCK08
257	V_ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
258	V_ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly	MARA
259	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
260	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
261	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
262	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
263	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
264	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
265	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
266	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
267	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
268	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
269	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
270	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
271	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
272	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
273	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
274	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
275	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
276	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
277	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
278	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
279	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
280	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
281	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
282	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
283	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
284	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
285	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
286	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
287	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
288	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
289	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
290	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
291	NTEND	☐	VORGABEEND2	VORGABEEND	DATS	8	0	Constraint for Finish of Activity (Basic)
292	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
293	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
294	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
295	V_TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location
296	V_EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number
297	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
298	V_TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
299	V_GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
300	V_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
301	V_ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
302	V_KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet
303	V_FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
304	ILART_OP	☐	ILA	ILART	CHAR	3	0	Maintenance activity type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAUFK_AFVC	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIAUFK_AFVC	ABGSL	TKKAA	ABGSL	REF	C	CN
3	VIAUFK_AFVC	ABKRS	TKO08	ABKRS	REF	1	CN
4	VIAUFK_AFVC	ABUKR	T001	BUKRS		1	CN
5	VIAUFK_AFVC	ADRNR_ILOA	ADRC	ADDRNUMBER	REF	1	CN
6	VIAUFK_AFVC	ANLZU	T357M	ANLZU	REF	C	CN
7	VIAUFK_AFVC	APGRP	T024A	FEVOR	REF	C	CN
8	VIAUFK_AFVC	ARBEH	T006	MSEHI
9	VIAUFK_AFVC	ARBID	CRID	OBJID
10	VIAUFK_AFVC	ARTPR	T356A	ARTPR	REF	C	CN
11	VIAUFK_AFVC	AUART	T003O	AUART	REF	1	CN
12	VIAUFK_AFVC	AUFNR	AUFK	AUFNR	KEY	1	CN
13	VIAUFK_AFVC	AWSLS	TKV01	AWSLS	REF	C	CN
14	VIAUFK_AFVC	BAUTL	MARA	MATNR	REF	C	CN
15	VIAUFK_AFVC	BEBER	T357	BEBER	REF	C	CN
16	VIAUFK_AFVC	BEMOT	TBMOT	BEMOT
17	VIAUFK_AFVC	BNFPO	EBAN	BNFPO
18	VIAUFK_AFVC	BUKRS	T001	BUKRS	REF	1	CN
19	VIAUFK_AFVC	CYCLE	CSKS	KOSTL		1	CN
20	VIAUFK_AFVC	DAUFN	AUFK	AUFNR	REF	C	CN
21	VIAUFK_AFVC	DAUME	T006	MSEHI
22	VIAUFK_AFVC	DAUNE	T006	MSEHI
23	VIAUFK_AFVC	DISPO	T024D	DISPO	REF	1	CN
24	VIAUFK_AFVC	EKGRP	T024	EKGRP
25	VIAUFK_AFVC	EKORG	T024E	EKORG
26	VIAUFK_AFVC	EQUNR	EQUI	EQUNR	REF	C	CN
27	VIAUFK_AFVC	ESTNR	TKO03	ASTNR	REF	1	CN
28	VIAUFK_AFVC	ETYPE	T8JG	ETYPE	REF	C	CN
29	VIAUFK_AFVC	FERC_IND	FERC_C7	IND	REF
30	VIAUFK_AFVC	FEVOR	T024F	FEVOR
31	VIAUFK_AFVC	FHORI	T436A	FHORI	REF	C	CN
32	VIAUFK_AFVC	FUNC_AREA	TFKB	FKBER
33	VIAUFK_AFVC	GAUEH	T006	MSEHI	REF	C	CN
34	VIAUFK_AFVC	GEWRK	CRID	OBJID	REF	C	CN
35	VIAUFK_AFVC	GMEIN	T006	MSEHI	KEY	1	CN
36	VIAUFK_AFVC	GSBER	TGSB	GSBER	REF	1	CN
37	VIAUFK_AFVC	ILART	T353I	ILART	REF	C	CN
38	VIAUFK_AFVC	ILOAN	ILOA	ILOAN	REF	C	CN
39	VIAUFK_AFVC	INFNR	EINA	INFNR
40	VIAUFK_AFVC	INGPR	T024I	INGRP	REF	C	CN
41	VIAUFK_AFVC	IVPRO	TAPRF	IVPRO	REF	C	CN
42	VIAUFK_AFVC	IWERK	T399I	IWERK	REF	C	CN
43	VIAUFK_AFVC	IZWEK	T087I	IZWEK		1	CN
44	VIAUFK_AFVC	JV_JIBCL	T8J6A	CLASS	REF	C	CN
45	VIAUFK_AFVC	JV_JIBSA	T8J6C	SUBCLASS	REF	C	CN
46	VIAUFK_AFVC	KALSM	T683	KALSM	REF	1	CN
47	VIAUFK_AFVC	KAPPL	T681A	KAPPL	REF	1	CN
48	VIAUFK_AFVC	KDAUF	VBUK	VBELN		1	CN
49	VIAUFK_AFVC	KOKRS	TKA01	KOKRS	REF	1	CN
50	VIAUFK_AFVC	KOSTV	CSKS	KOSTL		1	CN
51	VIAUFK_AFVC	KSTAR	CSKB	KSTAR		1	CN
52	VIAUFK_AFVC	KTSCH	T435	VLSCH
53	VIAUFK_AFVC	KUNUM	KNA1	KUNNR	REF	C	CN
54	VIAUFK_AFVC	KVEWE	T681V	KVEWE	REF	1	CN
55	VIAUFK_AFVC	LAUFN	AUFK	AUFNR	REF	C	CN
56	VIAUFK_AFVC	LEAD_AUFNR	AUFK	AUFNR
57	VIAUFK_AFVC	LIFNR	LFA1	LIFNR
58	VIAUFK_AFVC	LOGRP	T421	LOGRP
59	VIAUFK_AFVC	MANDT	T000	MANDT	KEY	1	CN
60	VIAUFK_AFVC	MATKL	T023	MATKL
61	VIAUFK_AFVC	MEINH	T006	MSEHI
62	VIAUFK_AFVC	OBJNR	ONR00	OBJNR	REF	1	1
63	VIAUFK_AFVC	OBKNR	SER00	OBKNR
64	VIAUFK_AFVC	PAENR	AENR	AENNR	REF	1	CN
65	VIAUFK_AFVC	PLGRP	T024A	FEVOR	REF	C	CN
66	VIAUFK_AFVC	PLNAW	TCA09	PLNAW	REF	C	CN
67	VIAUFK_AFVC	PLNBEZ	MARA	MATNR	REF	C	CN
68	VIAUFK_AFVC	PLNME	T006	MSEHI	REF	1	CN
69	VIAUFK_AFVC	PPSID	CRID	OBJID	REF	C	CN
70	VIAUFK_AFVC	PRCTR	CEPC	PRCTR		1	CN
71	VIAUFK_AFVC	PRIOK	T356	PRIOK	REF	C	CN
72	VIAUFK_AFVC	PROFID	TCN41	PROFIDNETZ	REF	C	CN
73	VIAUFK_AFVC	PROID	PRPS	PSPNR		C	CN
74	VIAUFK_AFVC	PROJN	PRPS	PSPNR
75	VIAUFK_AFVC	PRONR	PROJ	PSPNR	REF	C	CN
76	VIAUFK_AFVC	PSPEL	PRPS	PSPNR	REF	C	CN
77	VIAUFK_AFVC	PVERW	T411	VERWE	REF	1	CN
78	VIAUFK_AFVC	QMNUM	QMEL	QMNUM	REF	C	CN
79	VIAUFK_AFVC	QUALF	T423	QUALF
80	VIAUFK_AFVC	RECID	T8JJ	RECID	REF	C	CN
81	VIAUFK_AFVC	REFNR	AUFK	AUFNR	REF	1	CN
82	VIAUFK_AFVC	REVNR	T352R	REVNR	REF	C	CN
83	VIAUFK_AFVC	SAENR	AENR	AENNR	REF	C	CN
84	VIAUFK_AFVC	SAKNR	SKB1	SAKNR		1	CN
85	VIAUFK_AFVC	SAKTO	CSKA	KSTAR
86	VIAUFK_AFVC	SBMEH	T006	MSEHI	REF	C	CN
87	VIAUFK_AFVC	SCREENTY	TQBT	SCREENTY
88	VIAUFK_AFVC	SELKZ	TCK08	SELKZ
89	VIAUFK_AFVC	SERMAT	MARA	MATNR
90	VIAUFK_AFVC	SIZECL	TAIF5	SIZECL		1	CN
91	VIAUFK_AFVC	SOWRK	T001W	WERKS	REF	1	CN
92	VIAUFK_AFVC	SPART	TVTA	SPART	REF	1	CN
93	VIAUFK_AFVC	STEUS	T430	STEUS
94	VIAUFK_AFVC	STLAN	T416	STLAN	REF	C	CN
95	VIAUFK_AFVC	STLBEZ	MARA	MATNR	REF	C	CN
96	VIAUFK_AFVC	STLST	T415S	STLST	REF	C	CN
97	VIAUFK_AFVC	STORT	T499S	STAND	REF	C	CN
98	VIAUFK_AFVC	STRNO	IFLOT	TPLNR	REF	C	CN
99	VIAUFK_AFVC	SWERK	T001W	WERKS	REF	1	CN
100	VIAUFK_AFVC	TERKZ	T482	TERMKZ	REF	1	CN
101	VIAUFK_AFVC	TPLNR	IFLOT	TPLNR	REF	C	CN
102	VIAUFK_AFVC	TXJCD	TTXJ	TXJCD
103	VIAUFK_AFVC	TXTSP	T002	SPRAS
104	VIAUFK_AFVC	UMWKZ	T087K	UMWKZ		1	CN
105	VIAUFK_AFVC	VERAA_USER	USR02	BNAME
106	VIAUFK_AFVC	VKORG	TVKO	VKORG	REF	1	CN
107	VIAUFK_AFVC	VNAME	T8JV	VNAME	REF	C	CN
108	VIAUFK_AFVC	VOGRP	TKAVG	GRUPPE		1	CN
109	VIAUFK_AFVC	VTWEG	TVKOV	VTWEG	REF	1	CN
110	VIAUFK_AFVC	V_ANLZU	T357M	ANLZU
111	VIAUFK_AFVC	V_FUNC_AREA	TFKB	FKBER		C	CN
112	VIAUFK_AFVC	V_GSBER	TGSB	GSBER
113	VIAUFK_AFVC	V_ISTRU	MARA	MATNR
114	VIAUFK_AFVC	V_OBJNR	ONR00	OBJNR
115	VIAUFK_AFVC	V_PRCTR	CEPC	PRCTR
116	VIAUFK_AFVC	V_TXJCD	TTXJ	TXJCD
117	VIAUFK_AFVC	V_WAERS	TCURC	WAERS
118	VIAUFK_AFVC	V_WERKS	T001W	WERKS
119	VIAUFK_AFVC	WAERS	TCURC	WAERS	REF	1	CN
120	VIAUFK_AFVC	WARPL	MPLA	WARPL	REF	C	CN
121	VIAUFK_AFVC	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in