SAP ABAP View BIW_0PM_ORDOPER (BW Extraction View for Orders and Operations)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM (Application Component) Plant Maintenance
     ⤷ PMEX (Package) PM: Extraction of Release-independent Objects

Basic Data

View Type	D	Database View
Database View	BIW_0PM_ORDOPER
Short Description	BW Extraction View for Orders and Operations
Root table	AFIH	Maintenance order header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFIH	AFIH
2	AUFK
3	AFKO
4	AFVC
5	AFVV
6	ILOA

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	AFKO	MANDT	JL	EQ				0	0
6	AUFK	MANDT	JR	EQ			AND	0	0
7	AFKO	AUFNR	JL	EQ				0	0
8	AUFK	AUFNR	JR	EQ			AND	0	0
9	AFVC	MANDT	JL	EQ				0	0
10	AFKO	MANDT	JR	EQ			AND	0	0
11	AFVC	AUFPL	JL	EQ				0	0
12	AFKO	AUFPL	JR	EQ			AND	0	0
13	AFVV	MANDT	JL	EQ				0	0
14	AFVC	MANDT	JR	EQ			AND	0	0
15	AFVV	AUFPL	JL	EQ				0	0
16	AFVC	AUFPL	JR	EQ			AND	0	0
17	AFVV	APLZL	JL	EQ				0	0
18	AFVC	APLZL	JR	EQ			AND	0	0
19	ILOA	MANDT	JL	EQ				0	0
20	AFIH	MANDT	JR	EQ			AND	0	0
21	ILOA	ILOAN	JL	EQ				0	0
22	AFIH	ILOAN	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	PRIOK	AFIH	PRIOK		☐	PRIOK	☐	Priority
4	EQUNR	AFIH	EQUNR		☐	EQUNR	☐	Equipment Number
5	IWERK	AFIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
6	INGPR	AFIH	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
7	KUNUM	AFIH	KUNUM		☐	KUNUM	☐	Customer Number
8	WARPL	AFIH	WARPL		☐	WARPL	☐	Maintenance Plan
9	ABNUM	AFIH	ABNUM		☐	ABNUM	☐	Maintenance Plan Call Number
10	WAPOS	AFIH	WAPOS		☐	WAPOS	☐	Maintenance item
11	IPHAS	AFIH	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
12	ILART	AFIH	ILART		☐	ILA	☐	Maintenance activity type
13	SERIALNR	AFIH	SERIALNR		☐	GERNR	☐	Serial Number
14	SERMAT	AFIH	SERMAT		☐	MATNR	☐	Material Number
15	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
16	WERKS_ORD	AUFK	WERKS		☐	WERKS_D	☐	Plant
17	KOSTV	AUFK	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
18	ASTNR	AUFK	ASTNR		☐	AUFASTNR	☐	Order status
19	OBJNR	AUFK	OBJNR		☐	J_OBJNR	☐	Object number
20	VAPLZ	AUFK	VAPLZ		☐	GEWRK	☐	Main work center for maintenance tasks
21	WAWRK	AUFK	WAWRK		☐	WERGW	☐	Plant associated with main work center
22	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
23	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
24	APLZL	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
25	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
26	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
27	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
28	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
29	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
30	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
31	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
32	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
33	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
34	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
35	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
36	SPART	ILOA	SPART		☐	SPART	☐	Division
37	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
38	WERKS_OPR	AFVC	WERKS		☐	WERKS_D	☐	Plant
39	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
40	GEWRK	AFIH	GEWRK		☐	LGWID	☐	Object ID of the Work Center
41	PLNTY	AFKO	PLNTY		☐	PLNTY	☐	Task List Type
42	PLNNR	AFKO	PLNNR		☐	PLNNR	☐	Key for Task List Group
43	PLNAL	AFKO	PLNAL		☐	PLNAL	☐	Group Counter

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	604