SAP table VIAUF_AFVC (Generated Table for View)

SAP table VIAUF_AFVC has 5 primary key fields being MANDT,AUFNR,ILOAN,AUFPL,APLZL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
ILOAN Location and account assignment for technical object CHAR 12 0 ILOAN
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL General counter for order NUMC 8 0 CO_APLZL
IPHAS Maintenance Processing Phase CHAR 1 0 PM_PHASE
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business
PRIOK Priority CHAR 1 0 T356 PRIOK
ARTPR Priority Type CHAR 2 0 T356A ARTPR
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
BAUTL Assembly CHAR 40 0 MARA BAUTL
INGPR Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
INSPK Name of Person Responsible for Technical Inspection CHAR 12 0 INSPK
ADDAT PM Order: Reference Date DATS 8 0 ADDAT
AUART Order Type CHAR 4 0 T003O AUFART
STORT Location CHAR 10 0 T499S AUFSTORT
SOWRK Location Plant CHAR 4 0 T001W AUFSOWRK
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
EQFNR Sort Field CHAR 30 0 EQFNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
STEUS Control key CHAR 4 0 T430 STEUS
ARBID Object ID of the resource NUMC 8 0 CRID CR_OBJID
WERKS Plant CHAR 4 0 T001W WERKS_D
KTSCH Standard text key CHAR 7 0 T435 KTSCH_CHG
LTXA1 Operation Short Text CHAR 40 0 LTXA1
LOANZ Number of Time Tickets DEC 3 0 LOHNANZ
LOART Wage type CHAR 4 0 LOHNART
RSANZ Number of Confirmation Slips NUMC 3 0 CR_RS_ANZ
QUALF Suitability CHAR 2 0 T423 QUALF
ANZMA Number of employees DEC 5 2 ANZMS
LOGRP Wage Group CHAR 3 0 T421 LOHNGRP
SUMNR Node Number of the Superior Operation NUMC 8 0 SUMKNTNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
PREIS Price CURR 11 2 PREIS
PEINH Price unit DEC 5 0 PEINH
SAKTO Cost Element CHAR 10 0 CSKA KSTAR
WAERS Currency Key CUKY 5 0 TCURC WAERS
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group for External Processing Activity CHAR 3 0 T024 VG_EKGRP
MATKL Material Group CHAR 9 0 T023 MATKL
ANZZL Number of capacities required INT1 3 0 ANZKAP
PRZNT Work percentage INT1 3 0 APROZENT
BUKRS Company Code CHAR 4 0 T001 BUKRS
INDET Key for calculation CHAR 1 0 INDET
0 Maintain manually
1 Calculate duration
2 Calculate work
3 Calculate number of capacities
LARNT Activity Type CHAR 6 0 LSTAR
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Confirmation counter NUMC 8 0 CO_RMZHL
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
BANFN Purchase Requisition Number CHAR 10 0 CO_BANFN
BNFPO Item Number of Purchase Requisition in Order NUMC 5 0 EBAN CO_BNFPO
SELKZ Selection indicator for costing line items CHAR 1 0 TCK08 CO_SELKZ
ANLZU System Condition CHAR 1 0 T357M ANLZU
ISTRU Assembly CHAR 40 0 MARA ISTRU
EBORT Installation Point for Subitem CHAR 20 0 EBORT
MEINH Unit of measure for activity UNIT 3 0 T006 VORME
DAUNO Normal duration of the activity QUAN 5 1 DAUNOR
DAUNE Normal duration/unit UNIT 3 0 T006 DAUNORE
DAUMI Minimum activity duration QUAN 5 1 DAUMIN
DAUME Unit for the minimum duration UNIT 3 0 T006 DAUMINE
EINSA Constraint on the basic start date for the activity CHAR 1 0 EINSCHRA
EINSE Constraint on the finish date of the activity CHAR 1 0 EINSCHRE
ARBEI Work involved in the activity QUAN 7 1 ARBEIT
ARBEH Unit for work UNIT 3 0 T006 ARBEITE
ISMNW Actual work QUAN 13 3 CO_ISMNW
FSAVD Earliest scheduled start: Execution (date) DATS 8 0 FSAVD
FSAVZ Earliest scheduled start: Execution (time) TIMS 6 0 FSAVZ
FSEDD Earliest scheduled finish: Execution (date) DATS 8 0 FSEDD
FSEDZ Earliest scheduled finish: Execution (time) TIMS 6 0 FSEDZ
SSAVD Latest scheduled start: Execution (date) DATS 8 0 SSAVD
SSAVZ Latest scheduled start: Execution (time) TIMS 6 0 SSAVZ
SSEDD Latest scheduled finish: Execution (date) DATS 8 0 SSEDD
SSEDZ Latest scheduled finish: Execution (time) TIMS 6 0 SSEDZ
ISDD Actual Execution Start Date DATS 8 0 ISDD
ISDZ Actual Execution Start Time TIMS 6 0 ISDZ
IEDD Actual Execution End Date DATS 8 0 IEDD
IEDZ Actual Execution End Time TIMS 6 0 IEDZ
PUFFR Free float DEC 3 0 PUFFR_FREI
PUFGS Total float DEC 3 0 PUFFR_GESM
NTANF Constraint for activity start (Basic) DATS 8 0 VORGABESTD
NTANZ Constraint for activity start time (Basic) TIMS 6 0 VORGABESTZ
NTEND Constraint for Finish of Activity (Basic) DATS 8 0 VORGABEEND2
NTENZ Basic finish time of the activity TIMS 6 0 VORGABEENZ
AUFKT Execution Factor DEC 3 0 AFAKT
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
ADRNRA Address Number CHAR 10 0 AD_ADDRNUM
ABLAD Unloading Point CHAR 25 0 ABLAD
WEMPF Goods Recipient CHAR 12 0 WEMPF
SERMAT Material Number CHAR 40 0 MARA MATNR
SERIALNR Serial Number CHAR 18 0 GERNR
DEVICEID Additional Device Data CHAR 40 0 DEVICEID
PERNR Personnel number NUMC 8 0 CO_PERNR
TXTSP Language Key LANG 1 0 T002 SPRAS
PHFLG Indicator: Phase CHAR 1 0 PHFLG
OFMNW Forecasted work (actual + remaining) QUAN 7 1 OFMNW
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
ADUHR Time of Reference Date TIMS 6 0 ADUHR
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTV Responsible cost center CHAR 10 0 CSKS AUFKOSTV
/CUM/CMNUM CU: Construction Measure Number CHAR 12 0 /CUM/CMNUM
/CUM/CUGUID UUID in X form (binary) RAW 16 0 /CUM/AFCU SYSUUID_X
WTY_IND Warranty indicator CHAR 1 0 WTYSC_WTY_INDICATOR
FALSE
X TRUE

VIAUF_AFVC foreign key relationships

Table Field Check Table Check Field
0 VIAUF_AFVC ANLZU T357M Machine operating condition MANDT
1 VIAUF_AFVC ARBEH T006 Units of Measurement MANDT
0 VIAUF_AFVC ARBID CRID CIM Resource - Entities MANDT
0 VIAUF_AFVC ARBID CRID CIM Resource - Entities OBJID
1 VIAUF_AFVC ARTPR T356A Priority type table MANDT
1 VIAUF_AFVC ARTPR T356A Priority type table ARTPR
0 VIAUF_AFVC AUART T003O Order Types AUART
1 VIAUF_AFVC AUFNR AUFK Order master data AUFNR
0 VIAUF_AFVC BAUTL MARA General Material Data MANDT
0 VIAUF_AFVC BAUTL MARA General Material Data MATNR
1 VIAUF_AFVC BEMOT TBMOT Accounting indicators MANDT
1 VIAUF_AFVC BEMOT TBMOT Accounting indicators BEMOT
0 VIAUF_AFVC BNFPO EBAN Purchase Requisition BANFN
0 VIAUF_AFVC BNFPO EBAN Purchase Requisition BNFPO
1 VIAUF_AFVC BUKRS T001 Company Codes BUKRS
0 VIAUF_AFVC DAUME T006 Units of Measurement MANDT
0 VIAUF_AFVC DAUME T006 Units of Measurement MSEHI
1 VIAUF_AFVC DAUNE T006 Units of Measurement MANDT
0 VIAUF_AFVC EKGRP T024 Purchasing Groups EKGRP
1 VIAUF_AFVC EKORG T024E Purchasing Organizations EKORG
0 VIAUF_AFVC EQUNR EQUI Equipment master data MANDT
1 VIAUF_AFVC INFNR EINA Purchasing Info Record: General Data INFNR
0 VIAUF_AFVC INGPR T024I Maintenance planner groups INGRP
1 VIAUF_AFVC ISTRU MARA General Material Data MANDT
1 VIAUF_AFVC ISTRU MARA General Material Data MATNR
0 VIAUF_AFVC IWERK T399I Planning plant parameters MANDT
1 VIAUF_AFVC KOKRS TKA01 Controlling Areas MANDT
0 VIAUF_AFVC KOSTV CSKS Cost Center Master Record MANDT
0 VIAUF_AFVC KOSTV CSKS Cost Center Master Record KOKRS
0 VIAUF_AFVC KOSTV CSKS Cost Center Master Record DATBI
1 VIAUF_AFVC KTSCH T435 Standard texts for routing/ref. op set items MANDT
0 VIAUF_AFVC LIFNR LFA1 Supplier Master (General Section) MANDT
0 VIAUF_AFVC LIFNR LFA1 Supplier Master (General Section) LIFNR
1 VIAUF_AFVC LOGRP T421 Wage groups MANDT
0 VIAUF_AFVC MANDT T000 Clients MANDT
1 VIAUF_AFVC MATKL T023 Material Groups MATKL
0 VIAUF_AFVC MEINH T006 Units of Measurement MANDT
0 VIAUF_AFVC MEINH T006 Units of Measurement MSEHI
1 VIAUF_AFVC OBJNR ONR00 General Object Number MANDT
0 VIAUF_AFVC PRIOK T356 Priorities MANDT
0 VIAUF_AFVC PRIOK T356 Priorities ARTPR
1 VIAUF_AFVC QUALF T423 Wage group qualification MANDT
1 VIAUF_AFVC QUALF T423 Wage group qualification QUALF
0 VIAUF_AFVC SAKTO CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
0 VIAUF_AFVC SAKTO CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
1 VIAUF_AFVC SELKZ TCK08 Indicator for Relevancy to Costing MANDT
1 VIAUF_AFVC SELKZ TCK08 Indicator for Relevancy to Costing SELKZ
0 VIAUF_AFVC SERMAT MARA General Material Data MATNR
1 VIAUF_AFVC SOWRK T001W Plants/Branches MANDT
1 VIAUF_AFVC SOWRK T001W Plants/Branches WERKS
0 VIAUF_AFVC STEUS T430 Operation/Activity control key MANDT
0 VIAUF_AFVC STEUS T430 Operation/Activity control key PLNAW
0 VIAUF_AFVC STEUS T430 Operation/Activity control key STEUS
1 VIAUF_AFVC STORT T499S Location MANDT
1 VIAUF_AFVC STORT T499S Location WERKS
0 VIAUF_AFVC SWERK T001W Plants/Branches MANDT
0 VIAUF_AFVC SWERK T001W Plants/Branches WERKS
1 VIAUF_AFVC TXTSP T002 Language Keys (Component BC-I18) SPRAS
0 VIAUF_AFVC WAERS TCURC Currency Codes MANDT
0 VIAUF_AFVC WAERS TCURC Currency Codes WAERS
1 VIAUF_AFVC WERKS T001W Plants/Branches WERKS