SAP PM database structure for work orders, maintenance orders

SAP database tables for Plant maintenance / work orders

AUFK    Order master data
AFKO          Header Data in PP Orders
AFPO                 Order Item
AFFL   Work order sequence
AFIH            Maintenance order header

ILOA    PM Object Location and Account Assignment
   Join condition: AUFK-AUFNR = VIQMEL-AUFNR

VIQMEL    Notification Header (Table join of: QMIH, QMEL, ILOA)
   Join condition: AUFK-AUFNR = VIQMEL-AUFNR

AUFK                    Order master data  -> order number links to Object number

JEST                    Object status
   Join condition: AUFK-OBJNR = JEST-objnr and INACT ne 'X'

TJ02T                   Status Description
   Join condition: JEST-STAT = TJ02T-ISTAT and SPRAS = sy-langu

 

AFVC   Operation within an order
   Joined on: (AFKO-AUFPL = AFVC-AUFPL)

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

 

Function location full structure read

CALL FUNCTION 'FUNC_LOCATION_READ'
         EXPORTING
              tplnr           = header_new-tplnr
         IMPORTING
              iflo_wa         = xiflo
         EXCEPTIONS
              iflot_not_found = 4
              iloa_not_found  = 6
              OTHERS          = 4.