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