SAP ABAP View VIORD (Order header view IH AFIH/AUFK)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MSE (Application Component) Mobile Service
⤷
IWOC (Package) Application Development R/3 Work Order Cycle

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | VIORD | |
Short Description | Order header view IH AFIH/AUFK | |
Root table | AFIH | Maintenance order header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
AFIH | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
AUFNR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
AUFNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
* | |||||
2 | ![]() |
![]() |
MANDT | MANDT | Client | |||
3 | ![]() |
![]() |
AUFNR | AUFNR | Order Number | |||
4 | ![]() |
![]() |
ARTPR | ARTPR | Priority Type | |||
5 | ![]() |
![]() |
PRIOK | PRIOK | Priority | |||
6 | ![]() |
![]() |
EQUNR | EQUNR | Equipment Number | |||
7 | ![]() |
![]() |
BAUTL | BAUTL | Assembly | |||
8 | ![]() |
![]() |
ILOAN | ILOAN | Location and account assignment for technical object | |||
9 | ![]() |
![]() |
ILOAI | ILOAI | ILOA Individual | |||
10 | ![]() |
![]() |
ANLZU | ANLZU | Syst.Condition | |||
11 | ![]() |
![]() |
IWERK | IWERK | Maintenance Planning Plant | |||
12 | ![]() |
![]() |
INGPR | INGRP | Planner Group for Customer Service and Plant Maintenance | |||
13 | ![]() |
![]() |
APGRP | VAGRP | Responsible planner group/department | |||
14 | ![]() |
![]() |
PM_OBJTY | PM_OBJTY | Object Type of CIM Resources for Work Center | |||
15 | ![]() |
![]() |
GEWRK | LGWID | Object ID of the Work Center | |||
16 | ![]() |
![]() |
KUNUM | KUNUM | Customer Number | |||
17 | ![]() |
![]() |
ANING | ANING | Name of Person Reponsible for System | |||
18 | ![]() |
![]() |
GAUZT | GAUZT | Planned downtime in hours | |||
19 | ![]() |
![]() |
GAUEH | MAUEH | Unit for Breakdown Duration | |||
20 | ![]() |
![]() |
ANLBD | ANLBD | Date until which the system is available | |||
21 | ![]() |
![]() |
ANLVD | ANLVD | Date from which the system is available | |||
22 | ![]() |
![]() |
ANLBZ | ANLBZ | Time until which the system is available | |||
23 | ![]() |
![]() |
ANLVZ | ANLVZ | Time from Which System is Available | |||
24 | ![]() |
![]() |
INSPK | INSPK | Name of Person Responsible for Technical Inspection | |||
25 | ![]() |
![]() |
DATAN | DATAN | Date of Technical Inspection | |||
26 | ![]() |
![]() |
WARPL | WARPL | Maintenance Plan | |||
27 | ![]() |
![]() |
ABNUM | ABNUM | Maintenance Plan Call Number | |||
28 | ![]() |
![]() |
WAPOS | WAPOS | Maintenance item | |||
29 | ![]() |
![]() |
LAUFN | LAUFN | Order number | |||
30 | ![]() |
![]() |
OBKNR | OBJKNR | Object list number | |||
31 | ![]() |
![]() |
REVNR | REVNI | Revision of Plant Maintenance and Customer Service | |||
32 | ![]() |
![]() |
ADDAT | ADDAT | PM Order: Reference Date | |||
33 | ![]() |
![]() |
ADUHR | ADUHR | Time of Reference Date | |||
34 | ![]() |
![]() |
IPHAS | PM_PHASE | Maintenance Processing Phase | |||
35 | ![]() |
![]() |
ILART | ILA | Maintenance activity type | |||
36 | ![]() |
![]() |
QMNUM | QMNUM | Message Number | |||
37 | ![]() |
![]() |
HISDA | HISDA | PM request: History date | |||
38 | ![]() |
![]() |
AKKNZ | AKKNZ | Order Category Indicator Plant Maintenance | |||
39 | ![]() |
![]() |
PLKNZ | AUF_PLKNZ | Maintenance order planning indicator | |||
40 | ![]() |
![]() |
SERIALNR | GERNR | Serial Number | |||
41 | ![]() |
![]() |
SERMAT | MATNR | Material Number | |||
42 | ![]() |
![]() |
DEVICEID | DEVICEID | Additional Device Data | |||
43 | ![]() |
![]() |
SCREENTY | SCRTP | Scenario or Subscreen Category | |||
44 | ![]() |
![]() |
ADPSP | ADDCOMPARE_CORE | Reference Element PM/PS | |||
45 | ![]() |
![]() |
RSUPG | RSUPG | Upgrade Order Indicator | |||
46 | ![]() |
![]() |
/ISDFPS/OBJNR | J_OBJNR | Object number | |||
47 | ![]() |
![]() |
/ISDFPS/MEQUI | /ISDFPS/MEQUI | Master Equipment | |||
48 | ![]() |
![]() |
UII | UII_CHAR72 | Unique Item Identifier | |||
49 | ![]() |
![]() |
* | |||||
50 | ![]() |
![]() |
MANDT | MANDT | Client | |||
51 | ![]() |
![]() |
AUFNR | AUFNR | Order Number | |||
52 | ![]() |
![]() |
AUART | AUFART | Order Type | |||
53 | ![]() |
![]() |
AUTYP | AUFTYP | Order category | |||
54 | ![]() |
![]() |
REFNR | AUFREFNR | Reference order number | |||
55 | ![]() |
![]() |
ERNAM | AUFERFNAM | Entered by | |||
56 | ![]() |
![]() |
ERDAT | AUFERFDAT | Created on | |||
57 | ![]() |
![]() |
AENAM | AUFAENAM | Last changed by | |||
58 | ![]() |
![]() |
AEDAT | AUFAEDAT | Change date for Order Master | |||
59 | ![]() |
![]() |
KTEXT | AUFTEXT | Description | |||
60 | ![]() |
![]() |
LTEXT | AUFLTEXT | Long Text Exists | |||
61 | ![]() |
![]() |
BUKRS | BUKRS | Company Code | |||
62 | ![]() |
![]() |
WERKS | WERKS_D | Plant | |||
63 | ![]() |
![]() |
GSBER | GSBER | Business Area | |||
64 | ![]() |
![]() |
KOKRS | KOKRS | Controlling Area | |||
65 | ![]() |
![]() |
CCKEY | CCKEY | Cost collector key | |||
66 | ![]() |
![]() |
KOSTV | AUFKOSTV | Responsible cost center | |||
67 | ![]() |
![]() |
STORT | AUFSTORT | Location | |||
68 | ![]() |
![]() |
SOWRK | AUFSOWRK | Location plant | |||
69 | ![]() |
![]() |
ASTKZ | AUFSTKZ | Identifier for statistical order | |||
70 | ![]() |
![]() |
WAERS | AUFWAERS | Order Currency | |||
71 | ![]() |
![]() |
ASTNR | AUFASTNR | Order status | |||
72 | ![]() |
![]() |
STDAT | AUFSTDAT | Date of last status change | |||
73 | ![]() |
![]() |
ESTNR | AUFESTNR | Status reached so far | |||
74 | ![]() |
![]() |
PHAS0 | AUFPHAS0 | Phase "Order created" | |||
75 | ![]() |
![]() |
PHAS1 | AUFPHAS1 | Phase "Order released" | |||
76 | ![]() |
![]() |
PHAS2 | AUFPHAS2 | Phase "order completed" | |||
77 | ![]() |
![]() |
PHAS3 | AUFPHAS3 | Phase "order closed" | |||
78 | ![]() |
![]() |
PDAT1 | AUFPDAT1 | Planned release date | |||
79 | ![]() |
![]() |
PDAT2 | AUFPDAT2 | Planned completion date | |||
80 | ![]() |
![]() |
PDAT3 | AUFPDAT3 | Planned closing date | |||
81 | ![]() |
![]() |
IDAT1 | AUFIDAT1 | Release date | |||
82 | ![]() |
![]() |
IDAT2 | AUFIDAT2 | Technical completion date | |||
83 | ![]() |
![]() |
IDAT3 | AUFIDAT3 | Close date | |||
84 | ![]() |
![]() |
OBJID | CCOBJID | Object ID | |||
85 | ![]() |
![]() |
VOGRP | AUFSPSET | Group of disallowed transactions | |||
86 | ![]() |
![]() |
LOEKZ | AUFLOEKZ | Deletion flag | |||
87 | ![]() |
![]() |
PLGKZ | PLGKZ | Identifier for planning with line items | |||
88 | ![]() |
![]() |
KVEWE | KVEWE | Usage of the Condition Table | |||
89 | ![]() |
![]() |
KAPPL | KAPPL | Application | |||
90 | ![]() |
![]() |
KALSM | AUFKALSM | Costing Sheet | |||
91 | ![]() |
![]() |
ZSCHL | AUFZSCHL | Overhead key | |||
92 | ![]() |
![]() |
ABKRS | AUFABKRS | Processing group | |||
93 | ![]() |
![]() |
KSTAR | AUFKSTAR | Settlement cost element | |||
94 | ![]() |
![]() |
KOSTL | AUFKOSTL | Cost center for basic settlement | |||
95 | ![]() |
![]() |
SAKNR | AUFSAKNR | G/L account for basic settlement | |||
96 | ![]() |
![]() |
SETNM | AUFSETNM | Allocation set | |||
97 | ![]() |
![]() |
CYCLE | ST_KOSTL | Cost center to which costs are actually posted | |||
98 | ![]() |
![]() |
SDATE | SDATE | Start Date | |||
99 | ![]() |
![]() |
SEQNR | AUFSEQNR | Sequence number | |||
100 | ![]() |
![]() |
USER0 | AUFUSER0 | Applicant | |||
101 | ![]() |
![]() |
USER1 | AUFUSER1 | Applicant's telephone number | |||
102 | ![]() |
![]() |
USER2 | AUFUSER2 | Person Responsible | |||
103 | ![]() |
![]() |
USER3 | AUFUSER3 | Telephone number of person in charge | |||
104 | ![]() |
![]() |
USER4 | AUFUSER4 | Estimated total costs of order | |||
105 | ![]() |
![]() |
USER5 | AUFUSER5 | Application date | |||
106 | ![]() |
![]() |
USER6 | AUFUSER6 | Department | |||
107 | ![]() |
![]() |
USER7 | AUFUSER7 | Work Start | |||
108 | ![]() |
![]() |
USER8 | AUFUSER8 | End of Work | |||
109 | ![]() |
![]() |
USER9 | AUFUSER9 | Identifier for work permit issued | |||
110 | ![]() |
![]() |
OBJNR | J_OBJNR | Object number | |||
111 | ![]() |
![]() |
PRCTR | PRCTR | Profit Center | |||
112 | ![]() |
![]() |
PSPEL | PS_PSP_ELE | Work breakdown structure element (WBS element) | |||
113 | ![]() |
![]() |
AWSLS | AWSLS | Variance Key | |||
114 | ![]() |
![]() |
ABGSL | ABGR_SCHL | Results Analysis Key | |||
115 | ![]() |
![]() |
TXJCD | TXJCD | Tax Jurisdiction | |||
116 | ![]() |
![]() |
FUNC_AREA | FKBER | Functional Area | |||
117 | ![]() |
![]() |
SCOPE | SCOPE_CV | Object Class | |||
118 | ![]() |
![]() |
PLINT | PLINT | Indicator for Integrated Planning | |||
119 | ![]() |
![]() |
KDAUF | KDAUF | Sales Order Number | |||
120 | ![]() |
![]() |
KDPOS | KDPOS | Item number in Sales Order | |||
121 | ![]() |
![]() |
AUFEX | AUFEX | External order number | |||
122 | ![]() |
![]() |
IVPRO | IM_PROFIL | Investment measure profile | |||
123 | ![]() |
![]() |
LOGSYSTEM | LOGSYSTEM | Logical System | |||
124 | ![]() |
![]() |
FLG_MLTPS | CO_MLTPS | Order with multiple items | |||
125 | ![]() |
![]() |
ABUKR | IM_ABUKRS | Requesting company code | |||
126 | ![]() |
![]() |
AKSTL | PS_AKSTL | Requesting cost center | |||
127 | ![]() |
![]() |
SIZECL | IM_SIZECL | Scale of investment objects | |||
128 | ![]() |
![]() |
IZWEK | IZWEK | Reason for investment | |||
129 | ![]() |
![]() |
UMWKZ | AM_UMWKZ | Reason for environmental investment | |||
130 | ![]() |
![]() |
KSTEMPF | CO_KSTEMPF | Indicator: Direct cost collector | |||
131 | ![]() |
![]() |
ZSCHM | PS_ZSCHM | Interest Profile for Project/Order Interest Calculation | |||
132 | ![]() |
![]() |
PKOSA | PKOSA_D | Cost collector for production process PROCNR | |||
133 | ![]() |
![]() |
ANFAUFNR | AUFANFNR | Requesting order | |||
134 | ![]() |
![]() |
PROCNR | CKML_F_PROCNR | Production Process | |||
135 | ![]() |
![]() |
PROTY | CKML_PROZESS_TYP | Process Category (Procurement/Consumption) | |||
136 | ![]() |
![]() |
RSORD | RSORD | Refurbishment order indicator (PM) | |||
137 | ![]() |
![]() |
BEMOT | BEMOT | Accounting Indicator | |||
138 | ![]() |
![]() |
ADRNRA | AD_ADDRNUM | Address number | |||
139 | ![]() |
![]() |
ERFZEIT | CO_INS_TIME | Time created | |||
140 | ![]() |
![]() |
AEZEIT | CO_CHG_TIME | Changed at | |||
141 | ![]() |
![]() |
CSTG_VRNT | CK_KLVAR | Costing Variant | |||
142 | ![]() |
![]() |
COSTESTNR | CK_KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | |||
143 | ![]() |
![]() |
VERAA_USER | VERAA_USER | Person Responsible for CO Internal Order | |||
144 | ![]() |
![]() |
VNAME | JV_NAME | Joint venture | |||
145 | ![]() |
![]() |
RECID | JV_RECIND | Recovery Indicator | |||
146 | ![]() |
![]() |
ETYPE | JV_ETYPE | Equity type | |||
147 | ![]() |
![]() |
OTYPE | JV_OTYPE | Joint Venture Object Type | |||
148 | ![]() |
![]() |
JV_JIBCL | JV_JIBCL | JIB/JIBE Class | |||
149 | ![]() |
![]() |
JV_JIBSA | JV_JIBSA | JIB/JIBE Subclass A | |||
150 | ![]() |
![]() |
JV_OCO | JV_OR_CO | JV original cost object | |||
151 | ![]() |
![]() |
/CUM/INDCU | /CUM/INDCU | CU: Order is Used for Compatible Units | |||
152 | ![]() |
![]() |
/CUM/CMNUM | /CUM/CMNUM | CU: Construction Measure Number | |||
153 | ![]() |
![]() |
/CUM/AUEST | /CUM/AUEST | CU: Automatic Copy of Estimated Costs | |||
154 | ![]() |
![]() |
/CUM/DESNUM | /CUM/DESNUM | CU: Design Number | |||
155 | ![]() |
![]() |
VAPLZ | GEWRK | Main work center for maintenance tasks | |||
156 | ![]() |
![]() |
WAWRK | WERGW | Plant associated with main work center | |||
157 | ![]() |
![]() |
FERC_IND | FE_IND | Regulatory indicator | |||
Maintenance Status
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 |