PM order --> functional location

[Former Member]

Hi all!

a "simple" question:

I have a number of pm order and I need to find its functional location, which tables I can use?

Thank you.

Ciao.

[Former Member · Accepted solution]

Hi,

Plant Maintenance (PM) --Tcodes.

IW31 Create Plant Maintenance Order

IW32 Change Plant Maintenance Order

IW33 Display Plant Maintenance Order

IW34 Create Notification Order

IW51 Create Service Notification

IW52 Change Service Notification

IW53 Display Service Notification

IW54 Create Service Notification :Problem notification

IW55 Create Service Notification :Activity Request

IW56 Create Service Notification :Service Request

IW57 Assign deletion Flag to Completed Service Notifications

IW58 Change Service Notifications: Selection of Notification

IW59 Display Service Notifications: Selection of Notification

bold Plant maintenance (PM) ---> Table

IHPA Plant Maintenance: Partners

OBJK Plant Maintenance Object List

ILOA PM Object Location and Account Assignment

AFIH Maintenance order header

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 it helps.

Thanks

Arbind

[Former Member · Accepted solution]

Dear Arbind,

thank you for your help, but I need the relationship between field AUFNR and TPLNR via SAP tables... I don't yet find it!!!

Thank you.

[Former Member · Accepted solution]

Hi,

Try View 'VIAUFKS'.

Regards,

Daz.

[Former Member · Accepted solution]

Thank you very much!!!

[Former Member · Accepted solution]

   1. Fetch ILOAN field from AFIH table based on work order no

   2. Use ILOAN field value to fetch TPLNR (FLOC) from ILOA table...

VIAUFKS have many tables as joins so it will be a performance issue I guess...