SAP ABAP View VIAUFKST_IFLOS (Selection of PM orders by status (altern. indic. adjusted))
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 VIAUFKST_IFLOS  
Short Description Selection of PM orders by status (altern. indic. adjusted)    
Root table AFIH   Maintenance order header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AFIH AFIH
2 AUFK  
3 ILOA  
4 AFKO  
5 IFLOS  
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 ILOA MANDT JL EQ 0 0
6 AFIH MANDT JR EQ AND 0 0
7 ILOA ILOAN JL EQ 0 0
8 AFIH ILOAN JR EQ AND 0 0
9 AUFK MANDT JL EQ 0 0
10 AFKO MANDT JR EQ AND 0 0
11 AUFK AUFNR JL EQ 0 0
12 AFKO AUFNR JR EQ AND 0 0
13 IFLOS MANDT JL EQ 0 0
14 ILOA MANDT JR EQ AND 0 0
15 IFLOS TPLNR JL EQ 0 0
16 ILOA TPLNR JR EQ AND 0 0
17 IFLOS ACTVS EQ 'X' 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 * AFIH *    
4 - AFIH MANDT   MANDT Client
5 - AFIH AUFNR   AUFNR Order Number
6 ARTPR AFIH ARTPR   ARTPR Priority Type
7 PRIOK AFIH PRIOK   PRIOK Priority
8 EQUNR AFIH EQUNR   EQUNR Equipment Number
9 BAUTL AFIH BAUTL   BAUTL Assembly
10 ILOAN AFIH ILOAN   ILOAN Location and account assignment for technical object
11 ILOAI AFIH ILOAI   ILOAI ILOA Individual
12 ANLZU AFIH ANLZU   ANLZU Syst.Condition
13 IWERK AFIH IWERK   IWERK Maintenance Planning Plant
14 INGPR AFIH INGPR   INGRP Planner Group for Customer Service and Plant Maintenance
15 APGRP AFIH APGRP   VAGRP Responsible planner group/department
16 PM_OBJTY AFIH PM_OBJTY   PM_OBJTY Object Type of CIM Resources for Work Center
17 GEWRK AFIH GEWRK   LGWID Object ID of the Work Center
18 KUNUM AFIH KUNUM   KUNUM Customer Number
19 ANING AFIH ANING   ANING Name of Person Reponsible for System
20 GAUZT AFIH GAUZT   GAUZT Planned downtime in hours
21 GAUEH AFIH GAUEH   MAUEH Unit for Breakdown Duration
22 ANLBD AFIH ANLBD   ANLBD Date until which the system is available
23 ANLVD AFIH ANLVD   ANLVD Date from which the system is available
24 ANLBZ AFIH ANLBZ   ANLBZ Time until which the system is available
25 ANLVZ AFIH ANLVZ   ANLVZ Time from Which System is Available
26 INSPK AFIH INSPK   INSPK Name of Person Responsible for Technical Inspection
27 DATAN AFIH DATAN   DATAN Date of Technical Inspection
28 WARPL AFIH WARPL   WARPL Maintenance Plan
29 ABNUM AFIH ABNUM   ABNUM Maintenance Plan Call Number
30 WAPOS AFIH WAPOS   WAPOS Maintenance item
31 LAUFN AFIH LAUFN   LAUFN Order number
32 OBKNR AFIH OBKNR   OBJKNR Object list number
33 REVNR AFIH REVNR   REVNI Revision of Plant Maintenance and Customer Service
34 ADDAT AFIH ADDAT   ADDAT PM Order: Reference Date
35 ADUHR AFIH ADUHR   ADUHR Time of Reference Date
36 IPHAS AFIH IPHAS   PM_PHASE Maintenance Processing Phase
37 ILART AFIH ILART   ILA Maintenance activity type
38 QMNUM AFIH QMNUM   QMNUM Message Number
39 HISDA AFIH HISDA   HISDA PM request: History date
40 AKKNZ AFIH AKKNZ   AKKNZ Order Category Indicator Plant Maintenance
41 PLKNZ AFIH PLKNZ   AUF_PLKNZ Maintenance order planning indicator
42 SERIALNR AFIH SERIALNR   GERNR Serial Number
43 SERMAT AFIH SERMAT   MATNR Material Number
44 DEVICEID AFIH DEVICEID   DEVICEID Additional Device Data
45 SCREENTY AFIH SCREENTY   SCRTP Scenario or Subscreen Category
46 ADPSP AFIH ADPSP   ADDCOMPARE_CORE Reference Element PM/PS
47 RSUPG AFIH RSUPG   RSUPG Upgrade Order Indicator
48 /ISDFPS/OBJNR AFIH /ISDFPS/OBJNR   J_OBJNR Object number
49 /ISDFPS/MEQUI AFIH /ISDFPS/MEQUI   /ISDFPS/MEQUI Master Equipment
50 UII AFIH UII   UII_CHAR72 Unique Item Identifier
51 * AUFK *    
52 - AUFK MANDT   MANDT Client
53 - AUFK AUFNR   AUFNR Order Number
54 AUART AUFK AUART   AUFART Order Type
55 AUTYP AUFK AUTYP   AUFTYP Order category
56 REFNR AUFK REFNR   AUFREFNR Reference order number
57 ERNAM AUFK ERNAM   AUFERFNAM Entered by
58 ERDAT AUFK ERDAT   AUFERFDAT Created on
59 AENAM AUFK AENAM   AUFAENAM Last changed by
60 AEDAT AUFK AEDAT   AUFAEDAT Change date for Order Master
61 KTEXT AUFK KTEXT   AUFTEXT Description
62 LTEXT AUFK LTEXT   AUFLTEXT Long Text Exists
63 BUKRS AUFK BUKRS   BUKRS Company Code
64 WERKS AUFK WERKS   WERKS_D Plant
65 GSBER AUFK GSBER   GSBER Business Area
66 KOKRS AUFK KOKRS   KOKRS Controlling Area
67 CCKEY AUFK CCKEY   CCKEY Cost collector key
68 KOSTV AUFK KOSTV   AUFKOSTV Responsible cost center
69 - AUFK STORT   AUFSTORT Location
70 SOWRK AUFK SOWRK   AUFSOWRK Location plant
71 ASTKZ AUFK ASTKZ   AUFSTKZ Identifier for statistical order
72 WAERS AUFK WAERS   AUFWAERS Order Currency
73 ASTNR AUFK ASTNR   AUFASTNR Order status
74 STDAT AUFK STDAT   AUFSTDAT Date of last status change
75 ESTNR AUFK ESTNR   AUFESTNR Status reached so far
76 - AUFK PHAS0   AUFPHAS0 Phase "Order created"
77 - AUFK PHAS1   AUFPHAS1 Phase "Order released"
78 - AUFK PHAS2   AUFPHAS2 Phase "order completed"
79 - AUFK PHAS3   AUFPHAS3 Phase "order closed"
80 PDAT1 AUFK PDAT1   AUFPDAT1 Planned release date
81 PDAT2 AUFK PDAT2   AUFPDAT2 Planned completion date
82 PDAT3 AUFK PDAT3   AUFPDAT3 Planned closing date
83 IDAT1 AUFK IDAT1   AUFIDAT1 Release date
84 IDAT2 AUFK IDAT2   AUFIDAT2 Technical completion date
85 IDAT3 AUFK IDAT3   AUFIDAT3 Close date
86 OBJID AUFK OBJID   CCOBJID Object ID
87 VOGRP AUFK VOGRP   AUFSPSET Group of disallowed transactions
88 LOEKZ AUFK LOEKZ   AUFLOEKZ Deletion flag
89 PLGKZ AUFK PLGKZ   PLGKZ Identifier for planning with line items
90 KVEWE AUFK KVEWE   KVEWE Usage of the Condition Table
91 KAPPL AUFK KAPPL   KAPPL Application
92 KALSM AUFK KALSM   AUFKALSM Costing Sheet
93 ZSCHL AUFK ZSCHL   AUFZSCHL Overhead key
94 ABKRS AUFK ABKRS   AUFABKRS Processing group
95 KSTAR AUFK KSTAR   AUFKSTAR Settlement cost element
96 - AUFK KOSTL   AUFKOSTL Cost center for basic settlement
97 SAKNR AUFK SAKNR   AUFSAKNR G/L account for basic settlement
98 SETNM AUFK SETNM   AUFSETNM Allocation set
99 CYCLE AUFK CYCLE   ST_KOSTL Cost center to which costs are actually posted
100 SDATE AUFK SDATE   SDATE Start Date
101 SEQNR AUFK SEQNR   AUFSEQNR Sequence number
102 - AUFK USER0   AUFUSER0 Applicant
103 - AUFK USER1   AUFUSER1 Applicant's telephone number
104 USER2 AUFK USER2   AUFUSER2 Person Responsible
105 - AUFK USER3   AUFUSER3 Telephone number of person in charge
106 USER4 AUFK USER4   AUFUSER4 Estimated total costs of order
107 - AUFK USER5   AUFUSER5 Application date
108 - AUFK USER6   AUFUSER6 Department
109 - AUFK USER7   AUFUSER7 Work Start
110 - AUFK USER8   AUFUSER8 End of Work
111 - AUFK USER9   AUFUSER9 Identifier for work permit issued
112 OBJNR AUFK OBJNR   J_OBJNR Object number
113 PRCTR AUFK PRCTR   PRCTR Profit Center
114 PSPEL AUFK PSPEL   PS_PSP_ELE Work breakdown structure element (WBS element)
115 AWSLS AUFK AWSLS   AWSLS Variance Key
116 ABGSL AUFK ABGSL   ABGR_SCHL Results Analysis Key
117 - AUFK TXJCD   TXJCD Tax Jurisdiction
118 - AUFK FUNC_AREA   FKBER Functional Area
119 - AUFK SCOPE   SCOPE_CV Object Class
120 - AUFK PLINT   PLINT Indicator for Integrated Planning
121 KDAUF AUFK KDAUF   KDAUF Sales Order Number
122 KDPOS AUFK KDPOS   KDPOS Item number in Sales Order
123 - AUFK AUFEX   AUFEX External order number
124 - AUFK IVPRO   IM_PROFIL Investment measure profile
125 - AUFK LOGSYSTEM   LOGSYSTEM Logical System
126 - AUFK FLG_MLTPS   CO_MLTPS Order with multiple items
127 - AUFK ABUKR   IM_ABUKRS Requesting company code
128 - AUFK AKSTL   PS_AKSTL Requesting cost center
129 - AUFK SIZECL   IM_SIZECL Scale of investment objects
130 - AUFK IZWEK   IZWEK Reason for investment
131 - AUFK UMWKZ   AM_UMWKZ Reason for environmental investment
132 - AUFK KSTEMPF   CO_KSTEMPF Indicator: Direct cost collector
133 - AUFK ZSCHM   PS_ZSCHM Interest Profile for Project/Order Interest Calculation
134 - AUFK PKOSA   PKOSA_D Cost collector for production process PROCNR
135 - AUFK ANFAUFNR   AUFANFNR Requesting order
136 - AUFK PROCNR   CKML_F_PROCNR Production Process
137 - AUFK PROTY   CKML_PROZESS_TYP Process Category (Procurement/Consumption)
138 RSORD AUFK RSORD   RSORD Refurbishment order indicator (PM)
139 BEMOT AUFK BEMOT   BEMOT Accounting Indicator
140 ADRNRA AUFK ADRNRA   AD_ADDRNUM Address number
141 ERFZEIT AUFK ERFZEIT   CO_INS_TIME Time created
142 AEZEIT AUFK AEZEIT   CO_CHG_TIME Changed at
143 CSTG_VRNT AUFK CSTG_VRNT   CK_KLVAR Costing Variant
144 COSTESTNR AUFK COSTESTNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
145 VERAA_USER AUFK VERAA_USER   VERAA_USER Person Responsible for CO Internal Order
146 VNAME AUFK VNAME   JV_NAME Joint venture
147 RECID AUFK RECID   JV_RECIND Recovery Indicator
148 ETYPE AUFK ETYPE   JV_ETYPE Equity type
149 OTYPE AUFK OTYPE   JV_OTYPE Joint Venture Object Type
150 JV_JIBCL AUFK JV_JIBCL   JV_JIBCL JIB/JIBE Class
151 JV_JIBSA AUFK JV_JIBSA   JV_JIBSA JIB/JIBE Subclass A
152 JV_OCO AUFK JV_OCO   JV_OR_CO JV original cost object
153 /CUM/INDCU AUFK /CUM/INDCU   /CUM/INDCU CU: Order is Used for Compatible Units
154 /CUM/CMNUM AUFK /CUM/CMNUM   /CUM/CMNUM CU: Construction Measure Number
155 /CUM/AUEST AUFK /CUM/AUEST   /CUM/AUEST CU: Automatic Copy of Estimated Costs
156 /CUM/DESNUM AUFK /CUM/DESNUM   /CUM/DESNUM CU: Design Number
157 VAPLZ AUFK VAPLZ   GEWRK Main work center for maintenance tasks
158 WAWRK AUFK WAWRK   WERGW Plant associated with main work center
159 FERC_IND AUFK FERC_IND   FE_IND Regulatory indicator
160 STORT ILOA STORT   PMLOC Location of maintenance object
161 KOSTL ILOA KOSTL   KOSTL Cost Center
162 TPLNR IFLOS STRNO   ILOM_STRNO Functional location label
163 ABCKZ ILOA ABCKZ   ABCKZ ABC Indicator for Technical Object
164 EQFNR ILOA EQFNR   EQFNR Sort Field
165 SWERK ILOA SWERK   SWERK Maintenance Plant
166 MSGRP ILOA MSGRP   RAUMNR Room
167 BEBER ILOA BEBER   BEBER Organizational Area
168 CR_OBJTY ILOA CR_OBJTY   CR_OBJTY Object types of the CIM resource
169 PPSID ILOA PPSID   PPSID Object ID of PP work center
170 PROID ILOA PROID   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
171 ANLNR ILOA ANLNR   ANLN1 Main Asset Number
172 ANLUN ILOA ANLUN   ANLN2 Asset Subnumber
173 DAUFN ILOA DAUFN   DAUFN Standing order number
174 GLTRP AFKO GLTRP   CO_GLTRP Basic finish date
175 GSTRP AFKO GSTRP   PM_ORDGSTRP Basic Start Date
176 FTRMS AFKO FTRMS   CO_FTRMS Scheduled release date
177 GLTRS AFKO GLTRS   CO_GLTRS Scheduled finish
178 GSTRS AFKO GSTRS   CO_GSTRS Scheduled start
179 GSTRI AFKO GSTRI   CO_GSTRI Actual start date
180 GETRI AFKO GETRI   CO_GETRI Confirmed Order Finish Date
181 GLTRI AFKO GLTRI   CO_GLTRI Actual finish date
182 FTRMI AFKO FTRMI   CO_FTRMI Actual release date
183 FTRMP AFKO FTRMP   CO_FTRMP Planned release date
184 RSNUM AFKO RSNUM   RSNUM Number of reservation/dependent requirements
185 GASMG AFKO GASMG   GASMG Total scrap quantity in the order
186 GAMNG AFKO GAMNG   GAMNG Total order quantity
187 GMEIN AFKO GMEIN   MEINS Base Unit of Measure
188 PLNBEZ AFKO PLNBEZ   MATNR Material Number
189 PLNTY AFKO PLNTY   PLNTY Task List Type
190 PLNNR AFKO PLNNR   PLNNR Key for Task List Group
191 PLNAW AFKO PLNAW   PLNAW Application of the task list
192 PLNAL AFKO PLNAL   PLNAL Group Counter
193 PVERW AFKO PVERW   PLN_VERWE Task list usage
194 PLAUF AFKO PLAUF   CO_PLAUF Date for routing transfer
195 PLSVB AFKO PLSVB   LOSGRBIS To lot size
196 PLNME AFKO PLNME   PLNME Task list unit of measure
197 PLSVN AFKO PLSVN   LOSGRVON From Lot Size
198 PDATV AFKO PDATV   DATUV Valid-From Date
199 PAENR AFKO PAENR   AENNR Change Number
200 PLGRP AFKO PLGRP   VAGRP Responsible planner group/department
201 LODIV AFKO LODIV   LOSDIV Lot size divisor
202 STLTY AFKO STLTY   STLTY BOM Category
203 STLBEZ AFKO STLBEZ   MATNR Material Number
204 STLST AFKO STLST   STLST BOM Statuses
205 STLNR AFKO STLNR   STNUM Bill of Material
206 SDATV AFKO SDATV   DATUV Valid-From Date
207 SBMNG AFKO SBMNG   BASMN Base quantity
208 SBMEH AFKO SBMEH   MEINS Base Unit of Measure
209 SAENR AFKO SAENR   AENNR Change Number
210 STLAL AFKO STLAL   STALT Alternative BOM
211 STLAN AFKO STLAN   STLAN BOM Usage
212 SLSVN AFKO SLSVN   LOSVN From Lot Size
213 SLSBS AFKO SLSBS   LOSBS To Lot Size
214 AUFLD AFKO AUFLD   CO_AUFLD Date of BOM Explosion/Routing Transfer
215 DISPO AFKO DISPO   CO_DISPO MRP controller for the order
216 AUFPL AFKO AUFPL   CO_AUFPL Routing number of operations in the order
217 FEVOR AFKO FEVOR   FEVOR Production Supervisor
218 FHORI AFKO FHORI   FHORI Scheduling Margin Key for Floats
219 TERKZ AFKO TERKZ   TERMKZ Scheduling type
220 REDKZ AFKO REDKZ   REDKZ Reduction indicator for scheduling
221 APRIO AFKO APRIO   CO_APRIO Order priority
222 AUFNT AFKO AUFNT   CO_TEILNET Number of superior network
223 AUFPT AFKO AUFPT   CO_AUFPL Routing number of operations in the order
224 APLZT AFKO APLZT   CO_APLZL General counter for order
225 PROFID AFKO PROFID   PROFIDNZPL Network profile
226 VORGZ AFKO VORGZ   VORGZ Float before production (in days)
227 SICHZ AFKO SICHZ   SICHZ Float after production (in days)
228 FREIZ AFKO FREIZ   FREIZ Release period (in days)
229 UPTER AFKO UPTER   CO_UPTER Indicator: Change to Scheduled Dates
230 BEDID AFKO BEDID   BEDID ID of the capacity requirements record
231 PRONR AFKO PRONR   PS_PSP_PRO Project definition
232 ZAEHL AFKO ZAEHL   CIM_COUNT Internal counter
233 MZAEHL AFKO MZAEHL   CIM_COUNT Internal counter
234 ZKRIZ AFKO ZKRIZ   DZKRIZ Counter for additional criteria
235 PRUEFLOS AFKO PRUEFLOS   QPLOS Inspection Lot Number
236 KLVARP AFKO KLVARP   KALKVARPLN Costing variant for planned costs
237 KLVARI AFKO KLVARI   KALKVARIST Costing variant for actual costs
238 RGEKZ AFKO RGEKZ   CO_RGEKZ Indicator: Backflushing for order
239 PLART AFKO PLART   PS_PLART Basis for scheduling
240 MAUFNR AFKO MAUFNR   MAUFNR Number of superior order
241 LEAD_AUFNR AFKO LEAD_AUFNR   CO_LAUFNR Leading order in current processing
242 OWNER ILOA OWNER   ILOM_OWNER Object reference indicator
243 VKORG ILOA VKORG   VKORG Sales Organization
244 VTWEG ILOA VTWEG   VTWEG Distribution Channel
245 SPART ILOA SPART   SPART Division
246 GLUZP AFKO GLUZP   CO_GLUZP Basic finish (time)
247 GSUZP AFKO GSUZP   CO_GSUZP Basic start time
248 GLUZS AFKO GLUZS   CO_GLUZS Scheduled finish time
249 GSUZS AFKO GSUZS   CO_GSUZS Scheduled Start (Time)
250 GEUZI AFKO GEUZI   CO_GEUZI Confirmed order finish (time)
251 GSUZI AFKO GSUZI   CO_GSUZI Actual start time
252 ADRNR_ILOA ILOA ADRNR   AD_ADDRNUM Address number
253 NO_DISP AFKO NO_DISP   NO_DISP_PLUS Effective for Materials Planning
254 ALKEY IFLOS ALKEY   ILOM_ALKEY Labeling system for functional locations
255 VERSN IFLOS VERSN   ILOM_VERSN Version of functional location label
256 TPLNR_INT IFLOS TPLNR   TPLNR Functional Location
                 
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 46C