1. Home
  2. Resources
  3. SAP Tables
  4. VAFILOA - Generated Table for View

SAP Table VAFILOA

Generated Table for View

VAFILOA (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VAFILOA to other SAP tables.

VAFILOA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
ARTPR Priority Type ARTPR T356A CHAR 2 0
PRIOK Priority PRIOK T356 CHAR 1 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
BAUTL Assembly BAUTL MARA CHAR 18 0
ILOAN Location and account assignment for technical object ILOAN ILOA CHAR 12 0
ILOAI ILOA Individual ILOAI CHAR 1 0
X Yes
NULL No
ANLZU Syst.Condition ANLZU T357M CHAR 1 0
IWERK Maintenance Planning Plant IWERK T399I CHAR 4 0
INGPR Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
APGRP Responsible planner group/department VAGRP T024A CHAR 3 0
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
GEWRK Object ID of the Work Center LGWID CRID NUMC 8 0
KUNUM Customer Number KUNUM KNA1 CHAR 10 0
ANING Name of Person Reponsible for System ANING CHAR 12 0
GAUZT Planned downtime in hours GAUZT FLTP 16 16
GAUEH Unit for Breakdown Duration MAUEH T006 UNIT 3 0
ANLBD Date until which the system is available ANLBD DATS 8 0
ANLVD Date from which the system is available ANLVD DATS 8 0
ANLBZ Time until which the system is available ANLBZ TIMS 6 0
ANLVZ Time from Which System is Available ANLVZ TIMS 6 0
INSPK Name of Person Responsible for Technical Inspection INSPK CHAR 12 0
DATAN Date of Technical Inspection DATAN DATS 8 0
WARPL Maintenance Plan WARPL MPLA CHAR 12 0
ABNUM Maintenance Plan Call Number ABNUM INT4 10 0
WAPOS Maintenance item WAPOS CHAR 16 0
LAUFN Order number LAUFN AUFK CHAR 12 0
OBKNR Object list number OBJKNR SER00 INT4 10 0
REVNR Revision for Plant Maintenance and Customer Service REVNI T352R CHAR 8 0
ADDAT PM Order: Reference Date ADDAT DATS 8 0
ADUHR Time of Reference Date ADUHR TIMS 6 0
IPHAS Maintenance Processing Phase PM_PHASE CHAR 1 0
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business (from 4.6)
ILART Maintenance activity type ILA T353I CHAR 3 0
QMNUM Notification No QMNUM QMEL CHAR 12 0
HISDA PM request: History date HISDA DATS 8 0
AKKNZ Order Category Indicator Plant Maintenance AKKNZ CHAR 1 0
NULL Order created online
1 Order created historically
2 Order created subsequently
3 Order from notification
4 Order from maintenance plan
5 Order from reference
6 Follow-up order
7 Generated order from IM_SM_CREATE_ORDER
8 Order for an SD service item
9 Order for an SD repair item (RMA)
PLKNZ Maintenance order planning indicator AUF_PLKNZ CHAR 1 0
NULL Unplanned order
1 Planned order
2 Immediate order
SERIALNR Serial Number GERNR CHAR 18 0
SERMAT Material Number MATNR MARA CHAR 18 0
DEVICEID Additional Device Data DEVICEID CHAR 40 0
SCREENTY Scenario or Subscreen Category SCRTP TQBT CHAR 4 0
ADPSP Reference Element PM/PS ADDCOMPARE_CORE CHAR 40 0
RSUPG Upgrade Order Indicator RSUPG CHAR 1 0
NULL No
X Yes
/ISDFPS/OBJNR Object number J_OBJNR CHAR 22 0
/ISDFPS/MEQUI Master Equipment /ISDFPS/MEQUI CHAR 18 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
ABCKZI Data origin for ABC indicator field INH_ABCKZI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin for sort field INH_EQFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK T001W CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Location of maintenance object PMLOC T499S CHAR 10 0
STORTI Data origin for location field INH_STORTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin for room number field INH_MSGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER T357 CHAR 3 0
BEBERI Data origin for plant section field INH_BEBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID CRID NUMC 8 0
PPSIDI Data origin for PP work center field INH_PPSIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
GSBER Business Area GSBER TGSB CHAR 4 0
GSBERI Data origin for business area field INH_GSBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOKRSI Data origin for controlling area field INH_KOKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOSTLI Data origin for cost center field INH_KOSTLI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PROIDI Data origin for WBS element field INH_PROIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS T001 CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLNRI Data origin for asset main no./sub-no. fields INH_ANLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN AUFK CHAR 12 0
DAUFNI Data origin of standing order number field INH_DAUFNI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IAUFNR Settlement order ILOM_ORDST AUFK CHAR 12 0
IAUFNRI Data origin for settlement order field INH_AUFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VKORG Sales Organization VKORG TVKO CHAR 4 0
VKORGI Data origin for sales organization field INH_VKORGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
VTWEGI Data origin of distribution channel field INH_VTWEGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SPART Division SPART TVTA CHAR 2 0
SPARTI Data origin for division field INH_SPARTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical

VAFILOA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VAFILOA ABCKZ VAFILOA MANDT T370C ABC indicator for technical objects MANDT
VAFILOA ABCKZ VAFILOA ABCKZ T370C ABC indicator for technical objects ABCKZ
VAFILOA ADRNR VAFILOA MANDT ADRC Addresses (Business Address Services) CLIENT
VAFILOA ADRNR VAFILOA ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
VAFILOA ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
VAFILOA ADRNR * ADRC Addresses (Business Address Services) NATION
VAFILOA ANLNR VAFILOA ANLNR ANLH Main asset number ANLN1
VAFILOA ANLNR VAFILOA MANDT ANLH Main asset number MANDT
VAFILOA ANLNR VAFILOA BUKRS ANLH Main asset number BUKRS
VAFILOA ANLUN VAFILOA MANDT ANLA Asset Master Record Segment MANDT
VAFILOA ANLUN VAFILOA BUKRS ANLA Asset Master Record Segment BUKRS
VAFILOA ANLUN VAFILOA ANLNR ANLA Asset Master Record Segment ANLN1
VAFILOA ANLUN VAFILOA ANLUN ANLA Asset Master Record Segment ANLN2
VAFILOA ANLZU SYST MANDT T357M Machine operating condition MANDT
VAFILOA ANLZU VAFILOA ANLZU T357M Machine operating condition ANLZU
VAFILOA APGRP VAFILOA APGRP T024A Planner group FEVOR
VAFILOA APGRP VAFILOA MANDT T024A Planner group MANDT
VAFILOA APGRP VAFILOA IWERK T024A Planner group WERKS
VAFILOA ARTPR VAFILOA MANDT T356A Priority type table MANDT
VAFILOA ARTPR VAFILOA ARTPR T356A Priority type table ARTPR
VAFILOA AUFNR VAFILOA MANDT AUFK Order master data MANDT
VAFILOA AUFNR VAFILOA AUFNR AUFK Order master data AUFNR
VAFILOA BAUTL VAFILOA MANDT MARA General Material Data MANDT
VAFILOA BAUTL VAFILOA BAUTL MARA General Material Data MATNR
VAFILOA BEBER VAFILOA BEBER T357 Plant Section BEBER
VAFILOA BEBER VAFILOA MANDT T357 Plant Section MANDT
VAFILOA BEBER VAFILOA SWERK T357 Plant Section WERKS
VAFILOA BUKRS VAFILOA MANDT T001 Company Codes MANDT
VAFILOA BUKRS VAFILOA BUKRS T001 Company Codes BUKRS
VAFILOA DAUFN VAFILOA MANDT AUFK Order master data MANDT
VAFILOA DAUFN VAFILOA DAUFN AUFK Order master data AUFNR
VAFILOA EQUNR VAFILOA MANDT EQUI Equipment master data MANDT
VAFILOA EQUNR VAFILOA EQUNR EQUI Equipment master data EQUNR
VAFILOA GAUEH VAFILOA MANDT T006 Units of Measurement MANDT
VAFILOA GAUEH VAFILOA GAUEH T006 Units of Measurement MSEHI
VAFILOA GEWRK VAFILOA PM_OBJTY CRID CIM Resource - Entities OBJTY
VAFILOA GEWRK VAFILOA GEWRK CRID CIM Resource - Entities OBJID
VAFILOA GEWRK VAFILOA MANDT CRID CIM Resource - Entities MANDT
VAFILOA GSBER VAFILOA MANDT TGSB Business Areas MANDT
VAFILOA GSBER VAFILOA GSBER TGSB Business Areas GSBER
VAFILOA IAUFNR VAFILOA MANDT AUFK Order master data MANDT
VAFILOA IAUFNR VAFILOA IAUFNR AUFK Order master data AUFNR
VAFILOA ILART VAFILOA MANDT T353I Maintenance activity types MANDT
VAFILOA ILART VAFILOA ILART T353I Maintenance activity types ILART
VAFILOA ILOAN VAFILOA MANDT ILOA PM Object Location and Account Assignment MANDT
VAFILOA ILOAN VAFILOA ILOAN ILOA PM Object Location and Account Assignment ILOAN
VAFILOA INGPR VAFILOA MANDT T024I Maintenance planner groups MANDT
VAFILOA INGPR VAFILOA IWERK T024I Maintenance planner groups IWERK
VAFILOA INGPR VAFILOA INGPR T024I Maintenance planner groups INGRP
VAFILOA IWERK VAFILOA MANDT T399I Planning plant parameters MANDT
VAFILOA IWERK VAFILOA IWERK T399I Planning plant parameters IWERK
VAFILOA KOKRS VAFILOA MANDT TKA01 Controlling Areas MANDT
VAFILOA KOKRS VAFILOA KOKRS TKA01 Controlling Areas KOKRS
VAFILOA KOSTL VAFILOA KOKRS CSKS Cost Center Master Data KOKRS
VAFILOA KOSTL VAFILOA KOSTL CSKS Cost Center Master Data KOSTL
VAFILOA KOSTL SYST DATUM CSKS Cost Center Master Data DATBI
VAFILOA KOSTL VAFILOA MANDT CSKS Cost Center Master Data MANDT
VAFILOA KUNUM VAFILOA KUNUM KNA1 General Data in Customer Master KUNNR
VAFILOA KUNUM VAFILOA MANDT KNA1 General Data in Customer Master MANDT
VAFILOA LAUFN VAFILOA MANDT AUFK Order master data MANDT
VAFILOA LAUFN VAFILOA LAUFN AUFK Order master data AUFNR
VAFILOA MANDT VAFILOA MANDT T000 Clients MANDT
VAFILOA OBKNR SYST MANDT SER00 General Header Table for Serial Number Management MANDT
VAFILOA OBKNR VAFILOA OBKNR SER00 General Header Table for Serial Number Management OBKNR
VAFILOA PPSID VAFILOA MANDT CRID CIM Resource - Entities MANDT
VAFILOA PPSID VAFILOA CR_OBJTY CRID CIM Resource - Entities OBJTY
VAFILOA PPSID VAFILOA PPSID CRID CIM Resource - Entities OBJID
VAFILOA PRIOK VAFILOA ARTPR T356 Priorities ARTPR
VAFILOA PRIOK VAFILOA PRIOK T356 Priorities PRIOK
VAFILOA PRIOK VAFILOA MANDT T356 Priorities MANDT
VAFILOA PROID VAFILOA MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VAFILOA PROID VAFILOA PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VAFILOA QMNUM VAFILOA MANDT QMEL Quality Notification MANDT
VAFILOA QMNUM VAFILOA QMNUM QMEL Quality Notification QMNUM
VAFILOA REVNR VAFILOA IWERK T352R Maintenance revisions IWERK
VAFILOA REVNR VAFILOA REVNR T352R Maintenance revisions REVNR
VAFILOA REVNR VAFILOA MANDT T352R Maintenance revisions MANDT
VAFILOA SCREENTY VAFILOA SCREENTY TQBT Screen type table for subscreen SCREENTY
VAFILOA SERMAT VAFILOA MANDT MARA General Material Data MANDT
VAFILOA SERMAT VAFILOA SERMAT MARA General Material Data MATNR
VAFILOA SPART VAFILOA VKORG TVTA Organizational Unit: Sales Area(s) VKORG
VAFILOA SPART VAFILOA VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
VAFILOA SPART VAFILOA SPART TVTA Organizational Unit: Sales Area(s) SPART
VAFILOA SPART VAFILOA MANDT TVTA Organizational Unit: Sales Area(s) MANDT
VAFILOA STORT VAFILOA MANDT T499S Location MANDT
VAFILOA STORT VAFILOA SWERK T499S Location WERKS
VAFILOA STORT VAFILOA STORT T499S Location STAND
VAFILOA SWERK VAFILOA MANDT T001W Plants/Branches MANDT
VAFILOA SWERK VAFILOA SWERK T001W Plants/Branches WERKS
VAFILOA TPLNR VAFILOA MANDT IFLOT Functional Location (Table) MANDT
VAFILOA TPLNR VAFILOA TPLNR IFLOT Functional Location (Table) TPLNR
VAFILOA VKORG VAFILOA VKORG TVKO Organizational Unit: Sales Organizations VKORG
VAFILOA VKORG VAFILOA MANDT TVKO Organizational Unit: Sales Organizations MANDT
VAFILOA VTWEG VAFILOA MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
VAFILOA VTWEG VAFILOA VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
VAFILOA VTWEG VAFILOA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
VAFILOA WARPL VAFILOA WARPL MPLA Maintenance plan WARPL
VAFILOA WARPL VAFILOA MANDT MPLA Maintenance plan MANDT