SAP ABAP Table VAFILOA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VAFILOA	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	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
4	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
5	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
6	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
7	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
8	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
9	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
10	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
11	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
12	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
13	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
14	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
15	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
16	ANING	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
17	GAUZT	☐	GAUZT	FLTP	FLTP	16	16	Planned downtime in hours
18	GAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
19	ANLBD	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
20	ANLVD	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
21	ANLBZ	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
22	ANLVZ	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
23	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
24	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
25	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
26	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
27	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
28	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
29	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
30	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
31	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
32	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
33	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
34	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
35	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
36	HISDA	☐	HISDA	DATUM	DATS	8	0	PM request: History date
37	AKKNZ	☐	AKKNZ	AKKNZ	CHAR	1	0	Order Category Indicator Plant Maintenance
38	PLKNZ	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
39	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
40	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
41	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
42	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
43	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
44	RSUPG	☐	RSUPG	XFIELD	CHAR	1	0	Upgrade Order Indicator
45	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
46	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
47	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
48	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
49	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
50	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
51	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
52	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
53	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
54	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
55	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
56	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
57	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
58	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
59	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
60	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
61	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
62	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
63	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
64	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
65	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
66	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
67	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
68	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
69	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
70	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
71	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
72	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
73	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
74	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
75	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
76	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
77	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
78	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
79	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
80	IAUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
81	IAUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
82	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
83	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
84	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
85	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
86	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
87	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
88	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
89	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
90	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VAFILOA	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VAFILOA	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	VAFILOA	ANLNR	ANLH	ANLN1	REF	C	CN
4	VAFILOA	ANLUN	ANLA	ANLN2	REF	C	CN
5	VAFILOA	ANLZU	T357M	ANLZU	REF	C	CN
6	VAFILOA	APGRP	T024A	FEVOR	REF	C	CN
7	VAFILOA	ARTPR	T356A	ARTPR	REF	C	CN
8	VAFILOA	AUFNR	AUFK	AUFNR	KEY	1	CN
9	VAFILOA	BAUTL	MARA	MATNR	REF	C	CN
10	VAFILOA	BEBER	T357	BEBER	REF	C	CN
11	VAFILOA	BUKRS	T001	BUKRS	REF	C	CN
12	VAFILOA	DAUFN	AUFK	AUFNR	REF	C	CN
13	VAFILOA	EQUNR	EQUI	EQUNR	REF	C	CN
14	VAFILOA	GAUEH	T006	MSEHI	REF	C	CN
15	VAFILOA	GEWRK	CRID	OBJID	REF	C	CN
16	VAFILOA	GSBER	TGSB	GSBER	REF	C	CN
17	VAFILOA	IAUFNR	AUFK	AUFNR	REF	C	CN
18	VAFILOA	ILART	T353I	ILART	REF	C	CN
19	VAFILOA	ILOAN	ILOA	ILOAN	REF	C	CN
20	VAFILOA	INGPR	T024I	INGRP	REF	C	CN
21	VAFILOA	IWERK	T399I	IWERK	REF	C	CN
22	VAFILOA	KOKRS	TKA01	KOKRS	REF	C	CN
23	VAFILOA	KOSTL	CSKS	KOSTL	REF	C	CN
24	VAFILOA	KUNUM	KNA1	KUNNR	REF	C	CN
25	VAFILOA	LAUFN	AUFK	AUFNR	REF	C	CN
26	VAFILOA	MANDT	T000	MANDT	KEY	1	CN
27	VAFILOA	OBKNR	SER00	OBKNR
28	VAFILOA	PPSID	CRID	OBJID	REF	C	CN
29	VAFILOA	PRIOK	T356	PRIOK	REF	C	CN
30	VAFILOA	PROID	PRPS	PSPNR		C	CN
31	VAFILOA	QMNUM	QMEL	QMNUM	REF	C	CN
32	VAFILOA	REVNR	T352R	REVNR	REF	C	CN
33	VAFILOA	SCREENTY	TQBT	SCREENTY
34	VAFILOA	SERMAT	MARA	MATNR
35	VAFILOA	SPART	TVTA	SPART	REF	1	CN
36	VAFILOA	STORT	T499S	STAND	REF	C	CN
37	VAFILOA	SWERK	T001W	WERKS	REF	1	CN
38	VAFILOA	TPLNR	IFLOT	TPLNR	REF	C	CN
39	VAFILOA	VKORG	TVKO	VKORG	REF	1	CN
40	VAFILOA	VTWEG	TVKOV	VTWEG	REF	1	CN
41	VAFILOA	WARPL	MPLA	WARPL	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in