SAP ABAP Table VIAUFK_AFVCIFLOS (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in