SAP ABAP Table VIAFKOS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VIAFKOS   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 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
4 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
5 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
6 ANLZU ANLZU ANLZU CHAR 1   0   Syst.Condition T357M
7 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
8 INGPR INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
9 APGRP VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
10 GEWRK LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
11 KUNUM KUNUM KUNNR CHAR 10   0   Customer Number KNA1
12 ANING ANING USNAM CHAR 12   0   Name of Person Reponsible for System  
13 GAUEH MAUEH MEINS UNIT 3   0   Unit for Breakdown Duration T006
14 GAUZT GAUZT FLTP FLTP 16   16   Planned downtime in hours  
15 ANLBD ANLBD DATUM DATS 8   0   Date until which the system is available  
16 ANLVD ANLVD DATUM DATS 8   0   Date from which the system is available  
17 ANLBZ ANLBZ UHRZT TIMS 6   0   Time until which the system is available  
18 ANLVZ ANLVZ UHRZT TIMS 6   0   Time from Which System is Available  
19 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
20 WAPOS WAPOS POSNU CHAR 16   0   Maintenance item  
21 REVNR REVNI REVNI CHAR 8   0   Revision of Plant Maintenance and Customer Service T352R
22 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type T356A
23 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
24 ILOAI ILOAI X CHAR 1   0   ILOA Individual  
25 PM_OBJTY PM_OBJTY CR_OBJTY CHAR 2   0   Object Type of CIM Resources for Work Center  
26 INSPK INSPK USNAM CHAR 12   0   Name of Person Responsible for Technical Inspection  
27 DATAN DATAN DATUM DATS 8   0   Date of Technical Inspection  
28 ABNUM ABNUM ABNUM INT4 10   0   Maintenance Plan Call Number  
29 LAUFN LAUFN AUFNR CHAR 12   0   Order number AUFK
30 OBKNR OBJKNR OBJKN INT4 10   0   Object list number SER00
31 AUART AUFART AUFART CHAR 4   0   Order Type T003O
32 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
33 ERNAM AUFERFNAM USNAM CHAR 12   0   Entered by  
34 ERDAT AUFERFDAT DATUM DATS 8   0   Created on  
35 AENAM AUFAENAM USNAM CHAR 12   0   Last changed by  
36 AEDAT AUFAEDAT DATUM DATS 8   0   Change date for Order Master  
37 KTEXT AUFTEXT TEXT40 CHAR 40   0   Description  
38 LTEXT AUFLTEXT XFELD CHAR 1   0   Long Text Exists  
39 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
40 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
41 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
42 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
43 CCKEY CCKEY CCKEY CHAR 23   0   Cost collector key  
44 KOSTV AUFKOSTV KOSTL CHAR 10   0   Responsible cost center CSKS
45 STORT AUFSTORT AP_STAND CHAR 10   0   Location T499S
46 SOWRK AUFSOWRK WERKS CHAR 4   0   Location plant T001W
47 ASTKZ AUFSTKZ XFELD CHAR 1   0   Identifier for statistical order  
48 WAERS AUFWAERS WAERS CUKY 5   0   Order Currency TCURC
49 ASTNR AUFASTNR AUFSTNR NUMC 2   0   Order status  
50 STDAT AUFSTDAT DATUM DATS 8   0   Date of last status change  
51 ESTNR AUFESTNR AUFSTNR NUMC 2   0   Status reached so far TKO03
52 PDAT1 AUFPDAT1 DATUM DATS 8   0   Planned release date  
53 PDAT2 AUFPDAT2 DATUM DATS 8   0   Planned completion date  
54 PDAT3 AUFPDAT3 DATUM DATS 8   0   Planned closing date  
55 IDAT1 AUFIDAT1 DATUM DATS 8   0   Release date  
56 IDAT2 AUFIDAT2 DATUM DATS 8   0   Technical completion date  
57 IDAT3 AUFIDAT3 DATUM DATS 8   0   Close date  
58 OBJID CCOBJID CHAR1 CHAR 1   0   Object ID  
59 VOGRP AUFSPSET VOGRP CHAR 4   0   Group of disallowed transactions TKAVG
60 LOEKZ AUFLOEKZ XFELD CHAR 1   0   Deletion flag  
61 PLGKZ PLGKZ XFELD CHAR 1   0   Identifier for planning with line items  
62 KVEWE KVEWE KVEWE CHAR 1   0   Usage of the Condition Table T681V
63 KAPPL KAPPL KAPPL CHAR 2   0   Application T681A
64 KALSM AUFKALSM KALSM CHAR 6   0   Costing Sheet T683
65 ZSCHL AUFZSCHL CHAR6 CHAR 6   0   Overhead key  
66 ABKRS AUFABKRS AKREIS NUMC 2   0   Processing group TKO08
67 KSTAR AUFKSTAR KSTAR CHAR 10   0   Settlement cost element CSKB
68 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
69 SAKNR AUFSAKNR SAKNR CHAR 10   0   G/L account for basic settlement SKB1
70 SETNM AUFSETNM SETNR CHAR 12   0   Allocation set  
71 CYCLE ST_KOSTL KOSTL CHAR 10   0   Cost center to which costs are actually posted CSKS
72 SDATE SDATE SDATE DATS 8   0   Start Date  
73 SEQNR AUFSEQNR SQNR NUMC 4   0   Sequence number  
74 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
75 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
76 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
77 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator T8JJ
78 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type T8JG
79 PSPEL PS_PSP_ELE PS_POSNR NUMC 8   0   Work breakdown structure element (WBS element) PRPS
80 AWSLS AWSLS AWSLS CHAR 6   0   Variance Key TKV01
81 ABGSL ABGR_SCHL ABGR_SCHL CHAR 6   0   Results Analysis Key TKKAA
82 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
83 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
84 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
85 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
86 STORT_ILOA PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
87 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
88 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
89 CR_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
90 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center CRID
91 GSBER_ILOA GSBER GSBER CHAR 4   0   Business Area TGSB
92 KOKRS_ILOA KOKRS CACCD CHAR 4   0   Controlling Area TKA01
93 KOSTL_ILOA KOSTL KOSTL CHAR 10   0   Cost Center CSKS
94 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
95 BUKRS_ILOA BUKRS BUKRS CHAR 4   0   Company Code T001
96 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
97 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
98 DAUFN DAUFN AUFNR CHAR 12   0   Standing order number AUFK
99 AUFNR_ILOA ILOM_ORDST AUFNR CHAR 12   0   Settlement order AUFK
100 GLTRP CO_GLTRP DATUM DATS 8   0   Basic finish date  
101 GSTRP PM_ORDGSTRP DATUM DATS 8   0   Basic Start Date  
102 FTRMS CO_FTRMS DATUM DATS 8   0   Scheduled release date  
103 GLTRS CO_GLTRS DATUM DATS 8   0   Scheduled finish  
104 GSTRS CO_GSTRS DATUM DATS 8   0   Scheduled start  
105 GSTRI CO_GSTRI DATUM DATS 8   0   Actual start date  
106 GETRI CO_GETRI DATUM DATS 8   0   Confirmed Order Finish Date  
107 GLTRI CO_GLTRI DATUM DATS 8   0   Actual finish date  
108 FTRMI CO_FTRMI DATUM DATS 8   0   Actual release date  
109 FTRMP CO_FTRMP DATUM DATS 8   0   Planned release date  
110 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements  
111 GASMG GASMG MENG13 QUAN 13   3   Total scrap quantity in the order  
112 GAMNG GAMNG MENG13 QUAN 13   3   Total order quantity  
113 GMEIN MEINS MEINS UNIT 3   0   Base Unit of Measure T006
114 PLNBEZ MATNR MATNR CHAR 18   0   Material Number MARA
115 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type  
116 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
117 PLNAW PLNAW PLNAW CHAR 1   0   Application of the task list TCA09
118 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
119 PVERW PLN_VERWE PLN_VERWE CHAR 3   0   Task list usage T411
120 PLAUF CO_PLAUF DATUM DATS 8   0   Date for routing transfer  
121 PLSVB LOSGRBIS MENG13 QUAN 13   3   To lot size  
122 PLNME PLNME MEINS UNIT 3   0   Task list unit of measure T006
123 PLSVN LOSGRVON MENG13 QUAN 13   3   From Lot Size  
124 PDATV DATUV DATUM DATS 8   0   Valid-From Date  
125 PAENR AENNR AENNR CHAR 12   0   Change Number AENR
126 PLGRP VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
127 LODIV LOSDIV MENG13 QUAN 13   3   Lot size divisor  
128 STLTY STLTY STLTY CHAR 1   0   BOM Category  
129 STLBEZ MATNR MATNR CHAR 18   0   Material Number MARA
130 STLST STLST STLST NUMC 2   0   BOM Statuses T415S
131 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
132 SDATV DATUV DATUM DATS 8   0   Valid-From Date  
133 SBMNG BASMN MENG13 QUAN 13   3   Base quantity  
134 SBMEH MEINS MEINS UNIT 3   0   Base Unit of Measure T006
135 SAENR AENNR AENNR CHAR 12   0   Change Number AENR
136 STLAL STALT ALTNR CHAR 2   0   Alternative BOM  
137 STLAN STLAN STLAN CHAR 1   0   BOM Usage T416
138 SLSVN LOSVN MENG13 QUAN 13   3   From Lot Size  
139 SLSBS LOSBS MENG13 QUAN 13   3   To Lot Size  
140 AUFLD CO_AUFLD DATUM DATS 8   0   Date of BOM Explosion/Routing Transfer  
141 DISPO CO_DISPO DISPO CHAR 3   0   MRP controller for the order T024D
142 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
143 FEVOR FEVOR FEVOR CHAR 3   0   Production Supervisor T024F
144 FHORI FHORI FHORI CHAR 3   0   Scheduling Margin Key for Floats T436A
145 TERKZ TERMKZ TERART CHAR 1   0   Scheduling type T482
146 REDKZ REDKZ REDKZ CHAR 1   0   Reduction indicator for scheduling  
147 APRIO CO_APRIO CHAR1 CHAR 1   0   Order priority  
148 AUFNT CO_TEILNET AUFNR CHAR 12   0   Number of superior network  
149 AUFPT CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
150 APLZT CO_APLZL CO_APLZL NUMC 8   0   General counter for order  
151 PROFID PROFIDNZPL PROFILID CHAR 7   0   Network profile TCN41
152 VORGZ VORGZ NUM3 NUMC 3   0   Float before production (in days)  
153 SICHZ SICHZ NUM3 NUMC 3   0   Float after production (in days)  
154 FREIZ FREIZ NUM3 NUMC 3   0   Release period (in days)  
155 UPTER CO_UPTER CHAR1 CHAR 1   0   Indicator: Change to Scheduled Dates  
156 BEDID BEDID BEDID NUMC 12   0   ID of the capacity requirements record  
157 PRONR PS_PSP_PRO PS_PSPNR NUMC 8   0   Project definition PROJ
158 ZAEHL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
159 MZAEHL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
160 ZKRIZ DZKRIZ ZKRIZ NUMC 7   0   Counter for additional criteria  
161 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number  
162 KLVARP KALKVARPLN KLVAR CHAR 4   0   Costing variant for planned costs  
163 KLVARI KALKVARIST KLVAR CHAR 4   0   Costing variant for actual costs  
164 RGEKZ CO_RGEKZ CO_RGEKZ CHAR 1   0   Indicator: Backflushing for order  
165 PLART PS_PLART PS_PLART CHAR 1   0   Basis for scheduling  
166 ADDAT ADDAT DATUM DATS 8   0   PM Order: Reference Date  
167 ADUHR ADUHR UZEIT TIMS 6   0   Time of Reference Date  
168 IPHAS PM_PHASE PM_PHASE CHAR 1   0   Maintenance Processing Phase  
169 ILART ILA ILART CHAR 3   0   Maintenance activity type T353I
170 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
171 FLG_AOB FLG_AOB FLAG CHAR 1   0   Indicator: relationships  
172 FLG_ARBEI FLG_ARBEI FLAG CHAR 1   0   Indicator: Default value work is relevant  
173 GLTPP CO_GLTPP DATUM DATS 8   0   Finish date (forecast)  
174 GSTPP CO_GSTPP DATUM DATS 8   0   Forecast start date  
175 GLTPS CO_GLTPS DATUM DATS 8   0   Scheduled forecast finish  
176 GSTPS CO_GSTPS DATUM DATS 8   0   Scheduled forecast start  
177 FTRPS CO_FTRPS DATUM DATS 8   0   Scheduled release date (forecast)  
178 RDKZP REDKZP REDKZ CHAR 1   0   Reduction indicator for scheduling (forecast)  
179 TRKZP TERMKZP TERART CHAR 1   0   Scheduling type (forecast)  
180 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
181 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
182 SPART SPART SPART CHAR 2   0   Division TVTA
183 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
184 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
185 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
186 GLUZP CO_GLUZP UHRZT TIMS 6   0   Basic finish (time)  
187 GSUZP CO_GSUZP UHRZT TIMS 6   0   Basic start time  
188 GLUZS CO_GLUZS UHRZT TIMS 6   0   Scheduled finish time  
189 GSUZS CO_GSUZS ATIME TIMS 6   0   Scheduled Start (Time)  
190 MAUFNR MAUFNR AUFNR CHAR 12   0   Number of superior order  
191 LEAD_AUFNR CO_LAUFNR AUFNR CHAR 12   0   Leading order in current processing AUFK
192 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
193 SERMAT MATNR MATNR CHAR 18   0   Material Number MARA
194 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
195 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
196 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
197 /CUM/CMNUM /CUM/CMNUM /CUM/CMNUM CHAR 12   0   CU: Construction Measure Number  
198 /CUM/DESNUM /CUM/DESNUM /CUM/DESNUM CHAR 12   0   CU: Design Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VIAFKOS ABCKZ T370C ABCKZ REF C CN
2 VIAFKOS ABGSL TKKAA ABGSL REF C CN
3 VIAFKOS ABKRS TKO08 ABKRS REF 1 CN
4 VIAFKOS ADRNR ADRC ADDRNUMBER REF 1 CN
5 VIAFKOS ANLNR ANLH ANLN1 REF C CN
6 VIAFKOS ANLUN ANLA ANLN2 REF C CN
7 VIAFKOS ANLZU T357M ANLZU REF C CN
8 VIAFKOS APGRP T024A FEVOR REF C CN
9 VIAFKOS ARTPR T356A ARTPR REF C CN
10 VIAFKOS AUART T003O AUART REF 1 CN
11 VIAFKOS AUFNR AUFK AUFNR KEY 1 1
12 VIAFKOS AUFNR_ILOA AUFK AUFNR REF C CN
13 VIAFKOS AWSLS TKV01 AWSLS REF C CN
14 VIAFKOS BAUTL MARA MATNR REF C CN
15 VIAFKOS BEBER T357 BEBER REF C CN
16 VIAFKOS BUKRS T001 BUKRS REF 1 CN
17 VIAFKOS BUKRS_ILOA T001 BUKRS REF C CN
18 VIAFKOS CYCLE CSKS KOSTL 1 CN
19 VIAFKOS DAUFN AUFK AUFNR REF C CN
20 VIAFKOS DISPO T024D DISPO REF 1 CN
21 VIAFKOS EQUNR EQUI EQUNR REF C CN
22 VIAFKOS ESTNR TKO03 ASTNR REF 1 CN
23 VIAFKOS ETYPE T8JG ETYPE REF C CN
24 VIAFKOS FEVOR T024F FEVOR    
25 VIAFKOS FHORI T436A FHORI REF C CN
26 VIAFKOS GAUEH T006 MSEHI REF C CN
27 VIAFKOS GEWRK CRID OBJID REF C CN
28 VIAFKOS GMEIN T006 MSEHI KEY 1 CN
29 VIAFKOS GSBER TGSB GSBER REF 1 CN
30 VIAFKOS GSBER_ILOA TGSB GSBER REF C CN
31 VIAFKOS ILART T353I ILART REF C CN
32 VIAFKOS ILOAN ILOA ILOAN REF C CN
33 VIAFKOS INGPR T024I INGRP REF C CN
34 VIAFKOS IWERK T399I IWERK REF C CN
35 VIAFKOS KALSM T683 KALSM REF 1 CN
36 VIAFKOS KAPPL T681A KAPPL REF 1 CN
37 VIAFKOS KDAUF VBUK VBELN 1 CN
38 VIAFKOS KOKRS TKA01 KOKRS REF 1 CN
39 VIAFKOS KOKRS_ILOA TKA01 KOKRS REF C CN
40 VIAFKOS KOSTL CSKS KOSTL REF C CN
41 VIAFKOS KOSTL_ILOA CSKS KOSTL REF C CN
42 VIAFKOS KOSTV CSKS KOSTL 1 CN
43 VIAFKOS KSTAR CSKB KSTAR 1 CN
44 VIAFKOS KUNUM KNA1 KUNNR REF C CN
45 VIAFKOS KVEWE T681V KVEWE REF 1 CN
46 VIAFKOS LAUFN AUFK AUFNR REF C CN
47 VIAFKOS LEAD_AUFNR AUFK AUFNR    
48 VIAFKOS MANDT T000 MANDT KEY 1 CN
49 VIAFKOS OBJNR ONR00 OBJNR REF 1 1
50 VIAFKOS OBKNR SER00 OBKNR    
51 VIAFKOS PAENR AENR AENNR REF 1 CN
52 VIAFKOS PLGRP T024A FEVOR REF C CN
53 VIAFKOS PLNAW TCA09 PLNAW REF C CN
54 VIAFKOS PLNBEZ MARA MATNR REF C CN
55 VIAFKOS PLNME T006 MSEHI REF 1 CN
56 VIAFKOS PPSID CRID OBJID REF C CN
57 VIAFKOS PRCTR CEPC PRCTR 1 CN
58 VIAFKOS PRIOK T356 PRIOK REF C CN
59 VIAFKOS PROFID TCN41 PROFIDNETZ REF C CN
60 VIAFKOS PROID PRPS PSPNR C CN
61 VIAFKOS PRONR PROJ PSPNR REF C CN
62 VIAFKOS PSPEL PRPS PSPNR REF C CN
63 VIAFKOS PVERW T411 VERWE REF 1 CN
64 VIAFKOS QMNUM QMEL QMNUM REF C CN
65 VIAFKOS RECID T8JJ RECID REF C CN
66 VIAFKOS REVNR T352R REVNR REF C CN
67 VIAFKOS SAENR AENR AENNR REF C CN
68 VIAFKOS SAKNR SKB1 SAKNR 1 CN
69 VIAFKOS SBMEH T006 MSEHI REF C CN
70 VIAFKOS SERMAT MARA MATNR    
71 VIAFKOS SOWRK T001W WERKS REF 1 CN
72 VIAFKOS SPART TVTA SPART REF 1 CN
73 VIAFKOS STLAN T416 STLAN REF C CN
74 VIAFKOS STLBEZ MARA MATNR REF C CN
75 VIAFKOS STLST T415S STLST REF C CN
76 VIAFKOS STORT T499S STAND REF 1 CN
77 VIAFKOS STORT_ILOA T499S STAND REF C CN
78 VIAFKOS SWERK T001W WERKS REF 1 CN
79 VIAFKOS TERKZ T482 TERMKZ REF 1 CN
80 VIAFKOS TPLNR IFLOT TPLNR REF C CN
81 VIAFKOS VKORG TVKO VKORG REF 1 CN
82 VIAFKOS VNAME T8JV VNAME REF C CN
83 VIAFKOS VOGRP TKAVG GRUPPE 1 CN
84 VIAFKOS VTWEG TVKOV VTWEG REF 1 CN
85 VIAFKOS WAERS TCURC WAERS REF 1 CN
86 VIAFKOS WARPL MPLA WARPL REF C CN
87 VIAFKOS WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130603 
SAP Release Created in