0PM_ORDER_ATTR

Plant Maintenance Order Attribute | #ATTR | Extraction method: V | Delta: AIE | Component: Plant Maintenance Master Data

Tables used: ILOA, AFIH, AUFK, AFKO, CRHD → show details

🔑 Keys (34)
💰 Amounts (1)
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (2)
🔗 Relations (25)

Column Name	Description
AUFNR FK	Maintenance Order
AUART FK	Order Type
EQUNR FK	Equipment Number
BAUTL FK	Assembly
IWERK FK	Maintenance Planning Plant
INGRP FK	Planner Group for Customer Service and Plant Maintenance
ARBPL	Work Center
WERKS FK	Plant
REVNR FK	Revision for Plant Maintenance and Customer Service
ILART FK	Maintenance activity type
TPLNR FK	Functional Location
ABCKZ FK	ABC Indicator for Technical Object
SWERK FK	Maintenance Plant
STORT FK	Location of maintenance object
MSGRP	Room
BEBER FK	Plant Section
GSBER FK	Business Area
KOKRS FK	Controlling Area
KOSTL FK	Cost Center
BUKRS FK	Company Code
ANLNR FK	Main Asset Number
ANLUN FK	Asset Subnumber
OBJNR FK	Object number
ERDAT	Created On
AEDAT	Change Date for Order Master
QMNUM FK	Notification Number
PROID FK	Work Breakdown Structure Element (WBS Element)
PLKNZ	Maintenance order planning indicator	Show values
PLNTY	Task List Type
PLNNR	Key for Task List Group
PLNAL	Group Counter
WAPOS	Maintenance item
USER4	Estimated total costs of order
WAERS FK	Order Currency

Column Name	Description
💲 Order Currency (WAERS):
USER4	Estimated total costs of order

Column Name	Description

Column Name	Description
ERDAT	Created On
AEDAT	Change Date for Order Master

Column Name	Description
PLKNZ	Maintenance order planning indicator	Show values

Column Name	Description	Domain name
BWSTSYS0	System Status	J_STONR
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object Client ABC Indicator for Technical Object	`0PM_ORDER_ATTR.MANDT == T370C.MANDT` `0PM_ORDER_ATTR.ABCKZ == T370C.ABCKZ`
Asset Subnumber Main Asset Number Company Code Asset Subnumber Client	`0PM_ORDER_ATTR.ANLNR == ANLA.ANLN1` `0PM_ORDER_ATTR.BUKRS == ANLA.BUKRS` `0PM_ORDER_ATTR.ANLUN == ANLA.ANLN2` `0PM_ORDER_ATTR.MANDT == ANLA.MANDT`
Order Type Order Type Client	`0PM_ORDER_ATTR.AUART == T003O.AUART` `0PM_ORDER_ATTR.MANDT == T003O.CLIENT`
Maintenance Order Client Maintenance Order Settlement order	`0PM_ORDER_ATTR.MANDT == AUFK.MANDT` `0PM_ORDER_ATTR.AUFNR == AUFK.AUFNR` `0PM_ORDER_ATTR.COORD == AUFK.AUFNR`
Assembly Client Assembly	`0PM_ORDER_ATTR.MANDT == MARA.MANDT` `0PM_ORDER_ATTR.BAUTL == MARA.MATNR`
Plant Section Maintenance Plant Client Plant Section	`0PM_ORDER_ATTR.SWERK == T357.WERKS` `0PM_ORDER_ATTR.MANDT == T357.MANDT` `0PM_ORDER_ATTR.BEBER == T357.BEBER`
Company Code Company Code Client	`0PM_ORDER_ATTR.BUKRS == T001.BUKRS` `0PM_ORDER_ATTR.MANDT == T001.MANDT`
Settlement order Client Maintenance Order Settlement order	`0PM_ORDER_ATTR.MANDT == AUFK.MANDT` `0PM_ORDER_ATTR.AUFNR == AUFK.AUFNR` `0PM_ORDER_ATTR.COORD == AUFK.AUFNR`
Equipment Number Client Equipment Number	`0PM_ORDER_ATTR.MANDT == EQUI.MANDT` `0PM_ORDER_ATTR.EQUNR == EQUI.EQUNR`
Business Area Business Area Client	`0PM_ORDER_ATTR.GSBER == TGSB.GSBER` `0PM_ORDER_ATTR.MANDT == TGSB.MANDT`
Maintenance activity type Maintenance activity type Client	`0PM_ORDER_ATTR.ILART == T353I.ILART` `0PM_ORDER_ATTR.MANDT == T353I.MANDT`
Controlling Area Controlling Area Client	`0PM_ORDER_ATTR.KOKRS == TKA01.KOKRS` `0PM_ORDER_ATTR.MANDT == TKA01.MANDT`
Cost Center Controlling Area Cost Center Client	`0PM_ORDER_ATTR.KOKRS == CSKS.KOKRS` `0PM_ORDER_ATTR.KOSTL == CSKS.KOSTL` `0PM_ORDER_ATTR.MANDT == CSKS.MANDT`
Revision for Plant Maintenance and Customer Service Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Client	`0PM_ORDER_ATTR.REVNR == T352R.REVNR` `0PM_ORDER_ATTR.IWERK == T352R.IWERK` `0PM_ORDER_ATTR.MANDT == T352R.MANDT`
Location of maintenance object Maintenance Plant Client Location of maintenance object	`0PM_ORDER_ATTR.SWERK == T499S.WERKS` `0PM_ORDER_ATTR.MANDT == T499S.MANDT` `0PM_ORDER_ATTR.STORT == T499S.STAND`
Maintenance Plant Maintenance Plant Client	`0PM_ORDER_ATTR.SWERK == T001W.WERKS` `0PM_ORDER_ATTR.MANDT == T001W.MANDT`
Functional Location Functional Location Client	`0PM_ORDER_ATTR.TPLNR == IFLOT.TPLNR` `0PM_ORDER_ATTR.MANDT == IFLOT.MANDT`
Order Currency Order Currency Client	`0PM_ORDER_ATTR.WAERS == TCURC.WAERS` `0PM_ORDER_ATTR.MANDT == TCURC.MANDT`
Plant Plant Client	`0PM_ORDER_ATTR.WERKS == T001W.WERKS` `0PM_ORDER_ATTR.MANDT == T001W.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client	`0PM_ORDER_ATTR.INGRP == T024I.INGRP` `0PM_ORDER_ATTR.IWERK == T024I.IWERK` `0PM_ORDER_ATTR.MANDT == T024I.MANDT`
Maintenance Planning Plant Client Maintenance Planning Plant	`0PM_ORDER_ATTR.MANDT == T399I.MANDT` `0PM_ORDER_ATTR.IWERK == T399I.IWERK`