cancel
Showing results for 
Search instead for 
Did you mean: 

IW33 (Maintenance order)

Former Member
0 Kudos

Hi all,

in the maintenance order (IW31), I want to know in which table the operations and components data is saved?

I have the purchase requisition number and line item number and i want to find out the PM order number (I have this PM order value) and the operation / Component number for the same.

Thanks in advance,

Vithalprasad

Accepted Solutions (1)

Accepted Solutions (1)

ferry_lianto
Active Contributor
0 Kudos

Hi Vithalprasad,

Please find list of PM - SD tables that is used by SAP.

AFAB - Network - Relationships

AFFH - PRT assignment data for the work order

AFFL - Work order sequence

AFFT - Order - Process Instructions

AFFV - Order - Process Instruction Values

AFFW - Goods movements with errors from confirmations

AFIH - Maintenance order header

AFKO - Order header data PP orders

AFPO - Order item

AFRC - Incorrect cost calculations from confirmations

AFRD - Default values for collective confirmation

AFRH - Header information for confirmation pool

AFRU - Order completion confirmations

AFRV - Confirmations pool

AFVC - Operation within an order

AFVU - DB structure of the user fields of the operation

AFVV - DB structure of the quantities/dates/values in the operation

AFWI - Subsequently posted goods movements for confirmations

AUFK - Order master data

AUFM - Goods movements for order

BGMK - Master Warranty Header

BGMP - Master Warranty Item

BGMS - Master Warranty Text Item

BGMT - Master Warranty Text

BGMZ - Warranty Counter

CRHD - Work Center Header

CRTX - Text for the Work Center or Production Resource/Tool

EQKT - Equipment Short Texts

EQST - Equipment to BOM Link

EQUI - Equipment master data

EQUZ - Equipment time segment

HIKO - Order master data history

IFLO - Table generated for View IFLO

IFLOT - Functional Location (Table)

IFLOTX - Functional Location- Short Texts

IHGNS - Permit Segment for Plant Maintenance

IHPA - Plant Maintenance- Partners

IHSG - Object-Related Permits in Plant Maintenance

ILOA - PM Object Location and Account Assignment

IMPTT - Measuring Point (Table)

IMRG - Measurement Document

KAKO - Capacity Header Segment

KONP - Conditions (Item)

KONV - Conditions (Transaction Data)

OBJK - Plant Maintenance Object List

QMEL - Quality Notification

QMFE - Quality notification - items

QMIH - Quality message - maintenance data excerpt

QMMA - Quality notification - activities

QMSM - Quality notification - tasks

QMUR - Quality notification - causes

T001 - Company Codes

T001L - Storage Locations

T001W - Plants/Branches

T077D - Customer account groups

T003O - Order Types

T352R - Maintenance revisions

T353I_T - Maintenance activity type description

T356 - Priorities

T357G - Permits

T357G_T - Text for Table 357GT

T370A - Activity Category for PM Lists

TINCT - Customers- Incoterms- Texts

TVKO - Organizational Unit- Sales Organizations

TVKOS - Organizational Unit- Divisions per Sales Organization

TVKOV - Org. Unit- Distribution Channels per Sales Organization

TVTA - Organizational Unit- Sales Area(s)

VIAUFKST - Generated Table for View VIAUFKST

Hope this will help.

Regards,

Ferry Lianto

Answers (2)

Answers (2)

former_member181962
Active Contributor
0 Kudos

Hi Vithal prasad,

The best way is to open an sql trace (st05 transactoon and run iw31 transaction). You can get all the relevant tables that are updated in the iw31 transaction.

Former Member
0 Kudos

For goods – to find out the Component Number

Query RESB table using EBAN-ARSNR and EBAN-ARSPS.

For services– to find out the operation Number

Query AFKO to find out AUFPL using PM order number and

Query AFVC using AUFPL and purchase requisition no and item no.

thnx for all u r help

Former Member
0 Kudos

i have worked long back on PM. i think the data gets stores in one of the SD tables. U need to map the maintenance order to PM order using sales order.

this might be correct or not...just check