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.


Related Articles

Change name of tab within SAP PM transactions IW32 and IW33
Functional location classification
Add new and set default tab entry for SAP PM transactions IW32 and IW33
SAP PM - Example code and information for developing ABAP in the Plant maintenance area of SAP