SAP ABAP View VIORA (Selection PM orders via status table JEST - Archiving)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing
Basic Data
View Type D Database View 
Database View VIORA  
Short Description Selection PM orders via status table JEST - Archiving    
Root table AFIH   Maintenance order header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AFIH AFIH
2 AUFK  
3 AFKO  
4 JEST  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 AUFK MANDT JL EQ 0 0
2 AFIH MANDT JR EQ AND 0 0
3 AUFK AUFNR JL EQ 0 0
4 AFIH AUFNR JR EQ AND 0 0
5 AUFK MANDT JL EQ 0 0
6 AFKO MANDT JR EQ AND 0 0
7 AUFK AUFNR JL EQ 0 0
8 AFKO AUFNR JR EQ AND 0 0
9 JEST MANDT JL EQ 0 0
10 AUFK MANDT JR EQ AND 0 0
11 JEST OBJNR JL EQ 0 0
12 AUFK OBJNR JR EQ AND 0 0
13 JEST STAT EQ 'I0013' OR 0 0
14 JEST STAT EQ 'I0046' OR 0 0
15 JEST STAT EQ 'I0076' AND 0 0
16 JEST INACT EQ ' ' AND 0 0
17 AFIH ILOAI EQ 'X' AND 0 0
18 AFIH IPHAS EQ '3' OR 0 0
19 AFIH IPHAS EQ '4' OR 0 0
20 AFIH IPHAS EQ '6' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT AFIH MANDT   MANDT Client
2 AUFNR AFIH AUFNR   AUFNR Order Number
3 STAT JEST STAT   J_STATUS Object status
4 INACT JEST INACT   J_INACT Indicator: Status Is Inactive
5 IWERK AFIH IWERK   IWERK Maintenance Planning Plant
6 ILOAN AFIH ILOAN   ILOAN Location and account assignment for technical object
7 ILOAI AFIH ILOAI   ILOAI ILOA Individual
8 OBKNR AFIH OBKNR   OBJKNR Object list number
9 IPHAS AFIH IPHAS   PM_PHASE Maintenance Processing Phase
10 * AUFK *    
11 - AUFK MANDT   MANDT Client
12 - AUFK AUFNR   AUFNR Order Number
13 AUART AUFK AUART   AUFART Order Type
14 AUTYP AUFK AUTYP   AUFTYP Order category
15 REFNR AUFK REFNR   AUFREFNR Reference order number
16 ERNAM AUFK ERNAM   AUFERFNAM Entered by
17 ERDAT AUFK ERDAT   AUFERFDAT Created on
18 AENAM AUFK AENAM   AUFAENAM Last changed by
19 AEDAT AUFK AEDAT   AUFAEDAT Change date for Order Master
20 KTEXT AUFK KTEXT   AUFTEXT Description
21 LTEXT AUFK LTEXT   AUFLTEXT Long Text Exists
22 BUKRS AUFK BUKRS   BUKRS Company Code
23 WERKS AUFK WERKS   WERKS_D Plant
24 GSBER AUFK GSBER   GSBER Business Area
25 KOKRS AUFK KOKRS   KOKRS Controlling Area
26 CCKEY AUFK CCKEY   CCKEY Cost collector key
27 KOSTV AUFK KOSTV   AUFKOSTV Responsible cost center
28 STORT AUFK STORT   AUFSTORT Location
29 SOWRK AUFK SOWRK   AUFSOWRK Location plant
30 ASTKZ AUFK ASTKZ   AUFSTKZ Identifier for statistical order
31 WAERS AUFK WAERS   AUFWAERS Order Currency
32 - AUFK ASTNR   AUFASTNR Order status
33 STDAT AUFK STDAT   AUFSTDAT Date of last status change
34 - AUFK ESTNR   AUFESTNR Status reached so far
35 - AUFK PHAS0   AUFPHAS0 Phase "Order created"
36 - AUFK PHAS1   AUFPHAS1 Phase "Order released"
37 - AUFK PHAS2   AUFPHAS2 Phase "order completed"
38 - AUFK PHAS3   AUFPHAS3 Phase "order closed"
39 - AUFK PDAT1   AUFPDAT1 Planned release date
40 - AUFK PDAT2   AUFPDAT2 Planned completion date
41 - AUFK PDAT3   AUFPDAT3 Planned closing date
42 IDAT1 AUFK IDAT1   AUFIDAT1 Release date
43 IDAT2 AUFK IDAT2   AUFIDAT2 Technical completion date
44 IDAT3 AUFK IDAT3   AUFIDAT3 Close date
45 OBJID AUFK OBJID   CCOBJID Object ID
46 - AUFK VOGRP   AUFSPSET Group of disallowed transactions
47 LOEKZ AUFK LOEKZ   AUFLOEKZ Deletion flag
48 PLGKZ AUFK PLGKZ   PLGKZ Identifier for planning with line items
49 KVEWE AUFK KVEWE   KVEWE Usage of the Condition Table
50 KAPPL AUFK KAPPL   KAPPL Application
51 KALSM AUFK KALSM   AUFKALSM Costing Sheet
52 ZSCHL AUFK ZSCHL   AUFZSCHL Overhead key
53 ABKRS AUFK ABKRS   AUFABKRS Processing group
54 KSTAR AUFK KSTAR   AUFKSTAR Settlement cost element
55 KOSTL AUFK KOSTL   AUFKOSTL Cost center for basic settlement
56 - AUFK SAKNR   AUFSAKNR G/L account for basic settlement
57 SETNM AUFK SETNM   AUFSETNM Allocation set
58 CYCLE AUFK CYCLE   ST_KOSTL Cost center to which costs are actually posted
59 SDATE AUFK SDATE   SDATE Start Date
60 SEQNR AUFK SEQNR   AUFSEQNR Sequence number
61 - AUFK USER0   AUFUSER0 Applicant
62 - AUFK USER1   AUFUSER1 Applicant's telephone number
63 - AUFK USER2   AUFUSER2 Person Responsible
64 - AUFK USER3   AUFUSER3 Telephone number of person in charge
65 USER4 AUFK USER4   AUFUSER4 Estimated total costs of order
66 - AUFK USER5   AUFUSER5 Application date
67 - AUFK USER6   AUFUSER6 Department
68 - AUFK USER7   AUFUSER7 Work Start
69 - AUFK USER8   AUFUSER8 End of Work
70 - AUFK USER9   AUFUSER9 Identifier for work permit issued
71 OBJNR AUFK OBJNR   J_OBJNR Object number
72 PRCTR AUFK PRCTR   PRCTR Profit Center
73 PSPEL AUFK PSPEL   PS_PSP_ELE Work breakdown structure element (WBS element)
74 AWSLS AUFK AWSLS   AWSLS Variance Key
75 ABGSL AUFK ABGSL   ABGR_SCHL Results Analysis Key
76 TXJCD AUFK TXJCD   TXJCD Tax Jurisdiction
77 FUNC_AREA AUFK FUNC_AREA   FKBER Functional Area
78 SCOPE AUFK SCOPE   SCOPE_CV Object Class
79 PLINT AUFK PLINT   PLINT Indicator for Integrated Planning
80 KDAUF AUFK KDAUF   KDAUF Sales Order Number
81 KDPOS AUFK KDPOS   KDPOS Item number in Sales Order
82 AUFEX AUFK AUFEX   AUFEX External order number
83 IVPRO AUFK IVPRO   IM_PROFIL Investment measure profile
84 LOGSYSTEM AUFK LOGSYSTEM   LOGSYSTEM Logical System
85 FLG_MLTPS AUFK FLG_MLTPS   CO_MLTPS Order with multiple items
86 ABUKR AUFK ABUKR   IM_ABUKRS Requesting company code
87 - AUFK AKSTL   PS_AKSTL Requesting cost center
88 SIZECL AUFK SIZECL   IM_SIZECL Scale of investment objects
89 IZWEK AUFK IZWEK   IZWEK Reason for investment
90 UMWKZ AUFK UMWKZ   AM_UMWKZ Reason for environmental investment
91 KSTEMPF AUFK KSTEMPF   CO_KSTEMPF Indicator: Direct cost collector
92 ZSCHM AUFK ZSCHM   PS_ZSCHM Interest Profile for Project/Order Interest Calculation
93 PKOSA AUFK PKOSA   PKOSA_D Cost collector for production process PROCNR
94 ANFAUFNR AUFK ANFAUFNR   AUFANFNR Requesting order
95 PROCNR AUFK PROCNR   CKML_F_PROCNR Production Process
96 PROTY AUFK PROTY   CKML_PROZESS_TYP Process Category (Procurement/Consumption)
97 RSORD AUFK RSORD   RSORD Refurbishment order indicator (PM)
98 BEMOT AUFK BEMOT   BEMOT Accounting Indicator
99 ADRNRA AUFK ADRNRA   AD_ADDRNUM Address number
100 ERFZEIT AUFK ERFZEIT   CO_INS_TIME Time created
101 AEZEIT AUFK AEZEIT   CO_CHG_TIME Changed at
102 CSTG_VRNT AUFK CSTG_VRNT   CK_KLVAR Costing Variant
103 COSTESTNR AUFK COSTESTNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
104 VERAA_USER AUFK VERAA_USER   VERAA_USER Person Responsible for CO Internal Order
105 VNAME AUFK VNAME   JV_NAME Joint venture
106 RECID AUFK RECID   JV_RECIND Recovery Indicator
107 ETYPE AUFK ETYPE   JV_ETYPE Equity type
108 OTYPE AUFK OTYPE   JV_OTYPE Joint Venture Object Type
109 JV_JIBCL AUFK JV_JIBCL   JV_JIBCL JIB/JIBE Class
110 JV_JIBSA AUFK JV_JIBSA   JV_JIBSA JIB/JIBE Subclass A
111 JV_OCO AUFK JV_OCO   JV_OR_CO JV original cost object
112 /CUM/INDCU AUFK /CUM/INDCU   /CUM/INDCU CU: Order is Used for Compatible Units
113 /CUM/CMNUM AUFK /CUM/CMNUM   /CUM/CMNUM CU: Construction Measure Number
114 /CUM/AUEST AUFK /CUM/AUEST   /CUM/AUEST CU: Automatic Copy of Estimated Costs
115 /CUM/DESNUM AUFK /CUM/DESNUM   /CUM/DESNUM CU: Design Number
116 VAPLZ AUFK VAPLZ   GEWRK Main work center for maintenance tasks
117 WAWRK AUFK WAWRK   WERGW Plant associated with main work center
118 FERC_IND AUFK FERC_IND   FE_IND Regulatory indicator
119 GLTRP AFKO GLTRP   CO_GLTRP Basic finish date
120 GSTRP AFKO GSTRP   PM_ORDGSTRP Basic Start Date
121 FTRMS AFKO FTRMS   CO_FTRMS Scheduled release date
122 GLTRS AFKO GLTRS   CO_GLTRS Scheduled finish
123 GSTRS AFKO GSTRS   CO_GSTRS Scheduled start
124 GSTRI AFKO GSTRI   CO_GSTRI Actual start date
125 GETRI AFKO GETRI   CO_GETRI Confirmed Order Finish Date
126 GLTRI AFKO GLTRI   CO_GLTRI Actual finish date
127 FTRMI AFKO FTRMI   CO_FTRMI Actual release date
128 FTRMP AFKO FTRMP   CO_FTRMP Planned release date
129 RSNUM AFKO RSNUM   RSNUM Number of reservation/dependent requirements
130 GASMG AFKO GASMG   GASMG Total scrap quantity in the order
131 GAMNG AFKO GAMNG   GAMNG Total order quantity
132 GMEIN AFKO GMEIN   MEINS Base Unit of Measure
133 PLNBEZ AFKO PLNBEZ   MATNR Material Number
134 PLNTY AFKO PLNTY   PLNTY Task List Type
135 PLNNR AFKO PLNNR   PLNNR Key for Task List Group
136 PLNAW AFKO PLNAW   PLNAW Application of the task list
137 PLNAL AFKO PLNAL   PLNAL Group Counter
138 PVERW AFKO PVERW   PLN_VERWE Task list usage
139 PLAUF AFKO PLAUF   CO_PLAUF Date for routing transfer
140 PLSVB AFKO PLSVB   LOSGRBIS To lot size
141 PLNME AFKO PLNME   PLNME Task list unit of measure
142 PLSVN AFKO PLSVN   LOSGRVON From Lot Size
143 PDATV AFKO PDATV   DATUV Valid-From Date
144 PAENR AFKO PAENR   AENNR Change Number
145 PLGRP AFKO PLGRP   VAGRP Responsible planner group/department
146 LODIV AFKO LODIV   LOSDIV Lot size divisor
147 STLTY AFKO STLTY   STLTY BOM Category
148 STLBEZ AFKO STLBEZ   MATNR Material Number
149 STLST AFKO STLST   STLST BOM Statuses
150 STLNR AFKO STLNR   STNUM Bill of Material
151 SDATV AFKO SDATV   DATUV Valid-From Date
152 SBMNG AFKO SBMNG   BASMN Base quantity
153 SBMEH AFKO SBMEH   MEINS Base Unit of Measure
154 SAENR AFKO SAENR   AENNR Change Number
155 STLAL AFKO STLAL   STALT Alternative BOM
156 STLAN AFKO STLAN   STLAN BOM Usage
157 SLSVN AFKO SLSVN   LOSVN From Lot Size
158 SLSBS AFKO SLSBS   LOSBS To Lot Size
159 AUFLD AFKO AUFLD   CO_AUFLD Date of BOM Explosion/Routing Transfer
160 DISPO AFKO DISPO   CO_DISPO MRP controller for the order
161 AUFPL AFKO AUFPL   CO_AUFPL Routing number of operations in the order
162 FEVOR AFKO FEVOR   FEVOR Production Supervisor
163 FHORI AFKO FHORI   FHORI Scheduling Margin Key for Floats
164 TERKZ AFKO TERKZ   TERMKZ Scheduling type
165 REDKZ AFKO REDKZ   REDKZ Reduction indicator for scheduling
166 APRIO AFKO APRIO   CO_APRIO Order priority
167 NTZUE AFKO NTZUE   NETZ_UEBER Superior network number
168 VORUE AFKO VORUE   VORG_UEBER Superior activity
169 PROFID AFKO PROFID   PROFIDNZPL Network profile
170 VORGZ AFKO VORGZ   VORGZ Float before production (in days)
171 SICHZ AFKO SICHZ   SICHZ Float after production (in days)
172 FREIZ AFKO FREIZ   FREIZ Release period (in days)
173 UPTER AFKO UPTER   CO_UPTER Indicator: Change to Scheduled Dates
174 BEDID AFKO BEDID   BEDID ID of the capacity requirements record
175 PRONR AFKO PRONR   PS_PSP_PRO Project definition
176 ZAEHL AFKO ZAEHL   CIM_COUNT Internal counter
177 MZAEHL AFKO MZAEHL   CIM_COUNT Internal counter
178 ZKRIZ AFKO ZKRIZ   DZKRIZ Counter for additional criteria
179 PRUEFLOS AFKO PRUEFLOS   QPLOS Inspection Lot Number
180 KLVARP AFKO KLVARP   KALKVARPLN Costing variant for planned costs
181 KLVARI AFKO KLVARI   KALKVARIST Costing variant for actual costs
182 RGEKZ AFKO RGEKZ   CO_RGEKZ Indicator: Backflushing for order
183 PLART AFKO PLART   PS_PLART Basis for scheduling
184 FLG_AOB AFKO FLG_AOB   FLG_AOB Indicator: relationships
185 FLG_ARBEI AFKO FLG_ARBEI   FLG_ARBEI Indicator: Default value work is relevant
186 GLTPP AFKO GLTPP   CO_GLTPP Finish date (forecast)
187 GSTPP AFKO GSTPP   CO_GSTPP Forecast start date
188 GLTPS AFKO GLTPS   CO_GLTPS Scheduled forecast finish
189 GSTPS AFKO GSTPS   CO_GSTPS Scheduled forecast start
190 FTRPS AFKO FTRPS   CO_FTRPS Scheduled release date (forecast)
191 RDKZP AFKO RDKZP   REDKZP Reduction indicator for scheduling (forecast)
192 TRKZP AFKO TRKZP   TERMKZP Scheduling type (forecast)
193 RUECK AFKO RUECK   CO_RUECK Completion confirmation number for the operation
194 RMZHL AFKO RMZHL   CIM_COUNT Internal counter
195 IGMNG AFKO IGMNG   CO_IGMNG Yield confirmed from order confirmation
196 RATID AFKO RATID   BEDID ID of the capacity requirements record
197 GROID AFKO GROID   BEDID ID of the capacity requirements record
198 CUOBJ AFKO CUOBJ   CUOBJ Configuration (internal object number)
199 GLUZS AFKO GLUZS   CO_GLUZS Scheduled finish time
200 GSUZS AFKO GSUZS   CO_GSUZS Scheduled Start (Time)
201 REVLV AFKO REVLV   REVLV Revision level
202 RSHTY AFKO RSHTY   CR_OBJTY Object types of the CIM resource
203 RSHID AFKO RSHID   CR_OBJID Object ID of the resource
204 RSNTY AFKO RSNTY   CR_OBJTY Object types of the CIM resource
205 RSNID AFKO RSNID   CR_OBJID Object ID of the resource
206 NAUTERM AFKO NAUTERM   CO_NAUTERM Indicator: Do not schedule automatically
207 NAUCOST AFKO NAUCOST   CO_NAUCOST Indicator: Do not cost automatically
208 STUFE AFKO STUFE   HISTU Level (in Multi-Level BOM Explosions)
209 WEGXX AFKO WEGXX   WEGXX Path (for Multi-Level BOM Explosions)
210 VWEGX AFKO VWEGX   WEGXX Path (for Multi-Level BOM Explosions)
211 ARSNR AFKO ARSNR   RSNUM Number of reservation/dependent requirements
212 ARSPS AFKO ARSPS   CO_POSNR Order item number
213 MAUFNR AFKO MAUFNR   MAUFNR Number of superior order
214 LKNOT AFKO LKNOT   CO_LKNOT Left node in collective order
215 RKNOT AFKO RKNOT   CO_RKNOT Right node of a collective order
216 PRODNET AFKO PRODNET   CO_PRODNET Indicator: Order is part of collective order
217 IASMG AFKO IASMG   CO_IASMG Scrap confirmed for order
218 ABARB AFKO ABARB   CO_ABARB Confirmation: Degree of processing
219 AUFNT AFKO AUFNT   CO_TEILNET Number of superior network
220 AUFPT AFKO AUFPT   CO_AUFPL Routing number of operations in the order
221 APLZT AFKO APLZT   CO_APLZL General counter for order
222 NO_DISP AFKO NO_DISP   NO_DISP_PLUS Effective for Materials Planning
223 CSPLIT AFKO CSPLIT   CSPLIT Apportionment structure
224 AENNR AFKO AENNR   AENNR Change Number
225 CY_SEQNR AFKO CY_SEQNR   CY_SEQNR Seq. number order
226 BREAKS AFKO BREAKS   BREAKS Indicator: Scheduling allowing for breaks
227 VORGZ_TRM AFKO VORGZ_TRM   VORGZ_TRM Scheduled float before production in days
228 SICHZ_TRM AFKO SICHZ_TRM   SICHZ_TRM Scheduled float after production in days
229 TRMDT AFKO TRMDT   TRMDT Date of the last scheduling
230 GLUZP AFKO GLUZP   CO_GLUZP Basic finish (time)
231 GSUZP AFKO GSUZP   CO_GSUZP Basic start time
232 GSUZI AFKO GSUZI   CO_GSUZI Actual start time
233 GEUZI AFKO GEUZI   CO_GEUZI Confirmed order finish (time)
234 GLUPP AFKO GLUPP   CO_GLUPP Forecast finish (time)
235 GSUPP AFKO GSUPP   CO_GSUPP Forecast start (time)
236 GLUPS AFKO GLUPS   CO_GLUPS Scheduled forecast finish time
237 GSUPS AFKO GSUPS   CO_GSUPS Scheduled start time (Forecast)
238 CHSCH AFKO CHSCH   KALSMA_CH Search procedure for batch determination
239 KAPT_VORGZ AFKO KAPT_VORGZ   KAPT_VORGZ Float (bef. production) remaining after finite scheduling
240 KAPT_SICHZ AFKO KAPT_SICHZ   KAPT_SICHZ Remaining float after finite scheduling
241 LEAD_AUFNR AFKO LEAD_AUFNR   CO_LAUFNR Leading order in current processing
242 PNETSTARTD AFKO PNETSTARTD   CO_PSTARTD Outline start of collective network (date)
243 PNETSTARTT AFKO PNETSTARTT   CO_PSTARTT Start time of a collective order
244 PNETENDD AFKO PNETENDD   CO_PENDD Outline finish of collective order (date)
245 PNETENDT AFKO PNETENDT   CO_PENDT Outline finish time
246 KBED AFKO KBED   KBED_D Ind: do not create capacity requirements
247 KKALKR AFKO KKALKR   COMP_CALC Indicator: Components will not be costed
248 SFCPF AFKO SFCPF   CO_PRODPRF Production Scheduling Profile
249 RMNGA AFKO RMNGA   RMNGA Total confirmed rework quantity
250 GSBTR AFKO GSBTR   CO_GSBTR Overall commitment date
251 VFMNG AFKO VFMNG   CO_VFMNG Committed quantity for order acc. to ATP check components
252 NOPCOST AFKO NOPCOST   CO_NOPCOST Do not calculate planned costs for order
253 NETZKONT AFKO NETZKONT   NETZKONT Indicator for the account assignment of a network(hdr/act.)
254 ATRKZ AFKO ATRKZ   ATRKZ Request ID
255 OBJTYPE AFKO OBJTYPE   OCM_OBJ_TYPE Change indicator
256 CH_PROC AFKO CH_PROC   OCM_CH_PROC Process that has lead to the change of an object
257 KAPVERSA AFKO KAPVERSA   KAPVERSA Version of Available Capacity
258 COLORDPROC AFKO COLORDPROC   CO_COLORDPRC Collective order with/without automatic goods movement
259 KZERB AFKO KZERB   PS_KZERB Indicator: Project summarization
260 CONF_KEY AFKO CONF_KEY   CC_CONF_KEY Identical object
261 ST_ARBID AFKO ST_ARBID   OBJEKTID Object ID
262 VSNMR_V AFKO VSNMR_V   VSNMR_V Sales document version number
263 TERHW AFKO TERHW   TERHW Scheduling note from order scheduling
264 SPLSTAT AFKO SPLSTAT   SPLIT_STAT Status of an order in a split hierarchy
265 COSTUPD AFKO COSTUPD   CN_COSTUPD Costs are updated
266 RMANR AFKO RMANR   VBELN Sales and Distribution Document Number
267 POSNR_RMA AFKO POSNR_RMA   POSNR Item number of the SD document
268 POSNV_RMA AFKO POSNV_RMA   POSNR Item number of the SD document
269 REVNR AFIH REVNR   REVNI Revision of Plant Maintenance and Customer Service
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in