Comments
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.