SAP PM TABLES LIST

 SAP PM TABLES LIST:

SUMMARY OF PM TABLE TOPIC-WISE:

A. MASTER DATA

B. TRANSCATION DATA

C. CONFIRGUATIONS

A. MASTER DATA

1.FUNCTIONAL LOCATIONS

Functional Location
Tables	Description
IFLOT	Functional Location Table
IFLOTX	Functional Location Short Texts
ILOA	PM Object Location and Account Assignment
IFLOS	Functional location labeling
ILOA	Location and account assignment data for the maintenance object
IHPA	Partner
IHSG	Table of permits for Plant Maintenance with long texts.
IFLOT:  Functional Location Table
Key Fields	Description
TPLNR	Functional Location
FLTYP	Functional Location Category
TPLMA	Superior Functional Location
INGRP	Planner Group
RBNR	Catalog Profile
ILOAN	Location and Account Assignment Key
IFLOT:  Functional Location Short Texts
TPLNR	Functional Location
PLTXT	Description of Functional Location
ILOA:  PM Object Location and Account Assignment
TPLNR	Functional Location
EQFNR	Sort Field
SWERK	Maintenance Plant
STORT	Location
BEBER	Plant Section
GSBER	Business Area
KOKRS	Controlling Area
KOSTL	Cost Center
BUKRS	Company Code

 

2.EQUIPMENTS

Equipment
Tables	Description
EQUI	Equipment Master Data
EQUZ	Equipment Time Segment
EQKT	Equipment Short Texts
ILOA	Location and account assignment data for the maintenance object
IHSG	Table of permits for Plant Maintenance with long texts
IHPA	Partners
FLEET	Fleet object-specific data for technical objects
EQUI:  Equipment Master Data
Key Fields	Description
EQUNR	Equipment Number
EQTYP	Equipment Category
LVORM	Deletion Flag
INVRN	Inventory Number
HERST	Manufacture
GERNR	Serial
OBJNR	Object Number
WERK	Plant
EQUZ:  Equipment Time Segment
EQUNR	Equipment Number
DATBI	Vaid to date (99991231 for latest)
IWERK	Planning Plant
HEQUI	Superior Equipment
HEQNR	Equipment Position at Install Location
INGRP	Planner Group
TIDNR	Technical ID
RBNR	Catalog Profile
EQKT:  Equipment Short Texts
EQUNR	Equipment Number
EQKTX	Short Description

 

3.WORK CENTRES

 

Work Center
Tables	Description
CRHD	Work Center Header
CRCO	Assignment of Work Center to Cost Center
CRTX	Work Center Descriptions
CRHD:  Work Center Header
Key Fields	Description
OBJTY	Object type
OBJID	Object ID (Key)
ARBPL	Work Center
WERKS	Plant
VERWE	Work Center Category
CRCO:  Assignment of Work Center to Cost Center
Key Fields	Description
OBJID	Object ID (Key)
KTEXT	Short Description
CRTX:  Work Center Descriptions
Key Fields	Description
OBJID	Object ID (Key)
KOSTL	Cost Center
KOKRS	Controlling Area
LSTAR	Activity Type

 

4.CLASS &

5.CHARCTERSITICS

Classification
Tables	Description
INOB	Link between internal number and object
KSSK	Allocation Table: Object to Class
AUSP	Actual Characteristic Values
KLAH	Class Header Data
KSML	Characteristics of a Class
CAWN	Possible Characteristic Values
SWOR	Class Description (keywords)
CABN	Characteristic
CAWNT	Characteristic Description
KLAH:  Class Header
Key Fields	Description
CLINT	Int Class #
CLASS	Class Name
KLART	Class Type
SWOR:   Class Description:  Keywords
Key Fields	Description
CLINT	Int Class #
CLASS	Class Name
CABN:  Characteristics
Key Fields	Description
ATINN	Int Char #
ADZHL	Int Count for Archive
ATNAM	Char Description
ATFOR	Data Type of Characteristic
ANZST	Number of Characters
ANZDZ	Number of Decimal Places
ATKLA	Characteristic Group
KSML:  Characteristics of a Class
Key Fields	Description
CLINT	Int Class #
POSNR	Item number
ADZHL	Int Count for Archive
IMERK	Int Char #
KSSK:  Object Allocation to a Class
Key Fields	Description
OBJEK	Object
MAFID	Indicator: object/class
KLART	Class type
CLINT	Int Class #
ADZHL	Int Count for Archive
CAWNT:  Characteristic Value
Key Fields	Description
ATINN	Int Char #
ATZHL	Int Counter
SPRAS	Language key
ADZHL	Int Count for Archive
ATWTB	Char Value Description
CAWN:  Possible Characteristic Values
Key Fields	Description
ATINN	Int Char #
ATZHL	Int Counter
ADZHL	Int Count for Archive
ATWRT	Char Value
AUSP:  Actual Object Characteristic Values
Key Fields	Description
OBJEK	Object
ATINN	Int Char #
ATZHL	Char Val Counter
MAFID	Indicator: object/class
KLART	Class type
ADZHL	Int Count for Archive
ATWRT	Char Value
INOB:  Link Between internal number and object
Key Fields	Description
CUOBJ	Object
KLART	Class type
OBTAB	Dbase table name
OBJEK	Key of classified object
ROBTAB	Dbase table name
ROBJEK	Key of config object
CLINT	Int Class #

 

 

 

6.TASK LIST

Equipment Task List
Tables	Description
EAPL (Equipment Only)	Allocation of Task List to Equipment
PLKO	Task List - Header
PLAS	Task List - Selection of Operations / Activities
PLPO	Task List - Operation / Activity
EAPL:  Allocation of Task List to Equipment
Key Fields	Description
EQUNR	Equipment number
PLNTY	Task list type
PLNNR	Group key
PLNAL	Group Counter
LOEKZ	Deletion Indicator
SWERK	Maintenance Plant
IWERK	Planning Plant
PLKO:  Task List - Header
PLNTY	Task list type
PLNNR	Group key
PLNAL	Group Counter
VERWE	Task List Usage
WERKS	Plant
STATU	Status
IWERK	Planning Plant
ARBID	Work Center ID
KTEXT	Short Description
PLPO:  Task List - Operation / Activity
Key Fields	Description
PLNTY	Task List Type
PLNNR	Key for Task List Group
VORNR	Operation Number
STEUS	Control Key
WERKS	Plant
LTXA1	Short Text
LAR01	Activity Type

 

Functional Location Task List
Tables	Description
TAPL	Allocation of Task List to Functional Location
PLAS	Task List - Selection of Operations / Activities
PLPO	Task List - Operation / Activity
TAPL:  Allocation of Task List to Functional Location
Key Fields	Description
TPLNR	Functional Location
PLNTY	Task List Type
PLNNR	Key for Task List Group
PLNAL	Group Counter
IWERK	Maintenance Planning Plant
ARBID	Work Center ID
PLAS:  Task List - Selection of Operation / Activities
Key Fields	Description
PLNTY	Task List Type
PLNNR	Key for Task List Group
PLNAL	Group Counter
LOEKZ	Marked for Deletion ("X")
PLPO:  Task List - Operation / Activity
Key Fields	Description
PLNTY	Task List Type
PLNNR	Key for Task List Group
VORNR	Operation Number
STEUS	Control Key
WERKS	Plant
LTXA1	Short Text
LAR01	Activity Type
General Task List
Tables	Description
PLKO	Task List Header
PLAS	Task List - Selection of Operations / Activities
PLPO	Task List - Operation / Activity
PLKZ	Time-independent header data (administrative data..)
MAPL	Material-task list assignments
KALC	Formulas for material quantity calculation
KALT	Texts for the formulas
PLKO:  Task List Header
Key Fields	Description
PLNTY	Task List Type
PLNNR	Key for Task List Group
PLNAL	Group Counter
VERWE	Task List Usage
WERKS	Plant
KTEXT	Task List Short Text
VAGRP	Responsible Planner Group
PLAS:  Task List - Selection of Operation / Activities
Key Fields	Description
PLNTY	Task List Type
PLNNR	Key for Task List Group
PLNAL	Group Counter
LOEKZ	Marked for Deletion ("X")

 

7.MAINTENANCE STRATEGY

Table	Description	Module
T351	Maintenance strategy	PM-PRM
T351T	Maintenance strategy texts	PM-PRM
T351X	Maintenance strategy package texts	PM-PRM
T351_OLD	Old Status of Maintenance Strategy	PM-PRM
IHSG	Object-Related Permits in Plant Maintenance	PM-EQM
T350	Maintenance Control Parameters: Client/Order Type	PM-WOC
OBJK	Plant Maintenance Object List	LO-MD
T627	Allocation Strategy: Allocation Table	LO-MDS
IHPA	Plant Maintenance: Partners	PM-EQM
PMCO	Cost structure of maintenance order	PM-WOC
MPLA	Maintenance plan	PM-PRM
MMPX	Maintenance cycle short texts	PM-PRM
B060	PM Message - Plant Maintenance	SD-MD
MPOS	Maintenance item	PM-PRM
T351	Maintenance strategy	PM-PRM
TC86	Short Text for Signature Strategy	CA-DSG
TC85	Signature Strategy	CA-DSG
H000	Condition Table for Batch Search Strategy $	SD-MD
PLWP	Allocation of maintenance packages to task list operations	PM-PRM
MHIS	Maintenance plan history	PM-PRM
AFIH	Maintenance order header	PM-WOC
R000	Condition table for derivation strategy R	LO-BM
QMIH	Quality message - maintenance data excerpt	PM-WOC
CUKB	Administrative Information for Dependency Maintenance	CA-GTF

 

8.MEASURING POINT

 

 

9.MEASUREMENT DOCUMENT

MEASUREMENT TABLES	DESCRIPTION
CDHDR	Change document header
CDPOS	Change document item
IMRG	Measurement document
THEAD	Long text

 

10. BOM (BILL OF MATERIAL)

Equipment BOM
Tables	Description
EQST	Equipment to BOM Link
STKO	BOM Header
STPO	BOM Details
EQST:  Equipment to BOM Link
Key Fields	Description
EQUNR	Equipment Number
WERKS	Plant
STLNR	Equip to Detail Link
STPO:  BOM Details
STLNR	Equip to Detail Link
STLTY	Detail Type "E" for Equip BOMs
INDRK	Component
POSTP	Item Category
POSNR	Item Number
POSTX1	ItemText
MENGE	Component Quantity

 

Functional Location BOM
Tables	Description
TPST	Functional Location - BOM Link
STPO	BOM Details
TPST:  Functional Location to BOM Link
Key Fields	Description
TPLNR	Functional Location
WERKS	Plant
STLNR	Functional Location to Detail Link
STPO:  BOM Details
STLNR	Equip to Detail Link
STLTY	Detail Type "E" for Equip BOMs
INDRK	Component
POSTP	Item Category
POSNR	Item Number
POSTX1	ItemText
MENGE	Component Quantity
Key Fields	Description
TPST.TPLNR	Equipment Number
TPST.WERKS	Plant
TPST.STLAN	BOM Usage
STPO.INDRK	Component
STPO.POSTP	Item Category
STPO.POSNR	Item Number
STPO.MENGE	Component Quantity
Material BOM
Tables	Description
MAST	Material to BOM Link
STPO	BOM Details
MAST:  BOM Header
Key Fields	Description
MATNR	Material Number
WERKS	Plant
STLAN	BOM Usage ("4" for PM)
STLNR	Bill of material
STPO:  BOM Details
STLNR	BOM Header - BOM Detail Link
STLTY	Detail Type "?" for Material BOMs
INDRK	Component
POSTP	Item Category
POSNR	Item Number
POSTX1	ItemText
MENGE	Component Quantity

 

11.MAINTENANCE PLAN

Maintenance Plans
Tables	Description
MPLA	Maintenance Plan
MPOS	Maintenance Item
PLWP	Alloc of Maint. Packages to TaskList Operatoins
T351P	Maintenance Packages
MHIS	Maintenance Plan History/calls
MMPT	Cycle definitions and measuring points for the maintenance plan
MHIO	Call objects & call object history
ONR00	Object number
ILOA	Location and account assignment for maintenance object (PM object)
OBJK	Object list for Plant Maintenance
MPLA:  Maintenance Plan
Key Fields	Description
WARPL	Maintenance Plan
WPTXT	Maintenance Plan Text
STRAT	Maintenance Plan Strategy
EQUNR	Equipment Number
TPLNR	Functional Location
HORIZ	Call Horizon
ABRHO	Scheduling Period
MPOS:  Maintenance Item
Key Fields	Description
WAPOS	Maintenance Item
WARPL	Maintenance Plan
STRAT	Maintenance Strategy
PSTXT	Item Short Text
EQUNR	Equipment Number
PLNTY	Task List Type
PLNNR	Task List Group
PLNAL	Group Counter
WPGRP	Planner Group
GEWRK	Object ID for Work Center
IWERK	Maintenance Planning Plant
ILOAN	Location
AUART	Order Type
PRIOK	Priority
WARPL	Maintenance Plan
ABNUM	Maintenance Plan Call Number
NPLDA	Next Planned Date
STADT	Start Date
LRMDT	Date of last Comp. Confirmation
HORDA	Call Date
PLWP:  Allocation of Maintenance Packages to Task List Operations
Key Fields	Description
PLNTY	Task List Type
PLNNR	Group Key
PLNAL	Group Counter
STRAT	Maintenance Strategy
LOEKZ	Deletion Indicator
PAKET	Maintenance package number

 

12.CATALOGS

13.EQUIPMENT LINKAGE

 

 

 

 

 

 

 

 

B. TRANSCATION DATA

a. MAINTENANCE

1. NOTIFICATION

Notification
PM NOTIFICATION TABLES	DESCRIPTION
QMEL	Notification header data
QMFE	Items
QMMA	Activities
QMSM	Tasks
QMUR	Causes
QMIH	Maintenance data
ILOA	Location data
IHPA	Partners
PMLP	Print log
KSSK	Classification
JEST	Status
JESTO	Status
SWW_CONTOB	Workflow/work item
THEAD	Long text
SERVICE NOTIFICATION TABLES	DESCRIPTION
QMEL	Notification header data
QMFE	Items
QMMA	Activities
QMSM	Tasks
QMUR	Causes
QMIH	Maintenance data
ILOA	Location data
IHPA	Partner
PMLP	Print log

 

1. WORK ORDER

Work Orders
Tables	Description
AUFK	Order master data
AFIH	Maintenance Order Header
AFKO	Order Header data
AFVC	Operation within an order
AFVV	Operation Duration Quantity/Dates/Values
AFVU	User fields for Operation
JEST	Object Status
TJ02T	System Status Texts
CRHD	Work Center Header
ILOA	PM Object Location and Account Assignment
COBRA	Settlement Rule for Order Settlement
COBRB	Distribution Rules for Settlement Rule (order)
AFAB	Network Relationships
AFFH	PRT assignment data for the work order
AFFL	Work order sequence
AFFT	Order Process Instructions
AFFV	Order Process Instruction Values
IHPA	Partners
PMCO	Cost structure and overview of the order
MCIPMIS	Order data for PMIS
PMCOQT	Quantity structure for the maintenance order
PMPL	Print data for the order
PMSDO	PM organizational data for SD documents
AUFK:  Order master data
Key Fields	Description
AUFNR	Order Number
AUART	Order Type ("30" for PM)
AUTYP	Order Category
KTEXT	Short Text
LTEXT	Indicator:  "Long Text Exists"
WERKS	Maintenance Plant
LOEKZ	Deletion Flag
KOSTL	Settlement Cost Center
KOSTV	Responsible Cost Center
AFIH:  Maintenance Order Header
AUFNR	Order Number
PRIOK	Priority
EQUNR	Equipment Number
ILOAN	Functional Location ID
ANLZU	System Condition
IWERK	Planning Plant
INGPR	Responsible Planner Group
GEWRK	Work Center ID
ILART	Maintenance Activity Type
QMNUM	Notification
AFKO:  Order Header Data
AUFNR	Order Number
GLTRP	Basic finish date
GSTRP	Basic start date
AUFPL	Link to Order Operation
AFVC:  Order Operations
AUFPL	Link to Order Header
VORNR	Operation Number
STEUS	Control Key
ARBID	Work Center ID
WERKS	Plant
LTXA1	Short Text
LTXA2	2nd Line of Description
LARNT	Activity Type
INDET	Calculation Key
ANZZL	Number of Resources
AFVV:  Operation Duration Quantity/Dates/Values
ARBEI	Work
DAUNO	Duration

 

C. CONFIRGUATIONS

Configuration
Tables	Description
CSKS	Cost Center Master Data
CSSL	Cost Center / Activity Type Assignment
T001W	Plant
T006	Unit of Measure
T024I	Maintenance Planner Groups
T352B	Catalog Profile
T357	Plant Section
T370C	ABC Indicator
T370F	Functional Location Category
T370S	Functional Location Structure Indicator
T399I	Planning Plant
T430	Operation/Activity Control Key
T499S	Location Codes
TC21	Standard Value Key
TC23	Work Center Usage
TC24	Work Center Person Responsible
TC25	Work Center Capacity Other Formula
TC26	Work Center Capacity Category
TC27	Work Center Capacity Planner Gorup
TC30	Work Center Category
TC38A	Work Center Shift Sequence
TGSB	Business Area
PM SERIAL NUMBERS TABLES	DESCRIPTION
OBJK	Object list for Plant Maintenance
SER01	Document header for serial numbers for delivery
SER02	Document header for serial numbers for maintenance contract (SD order)
SER03	header Document for serial numbers for delivery
SER04	Document header for serial numbers for inspection lot
SER05	Document header for serial numbers for PP order
SER06	number Document for serial numbers for handling unit contents
SER07	Document header for serial numbers in physical inventory

 

 

 

 

 

SAP PM Tables for Assignments, Inspection Plan and Phases

PLFL	TASK LIST SEQUENCES
PLPO	Operations
PLAS	Assignments of operations to sequences
PLMZ	Material component assignments
PLWP	Maintenance package assignments
PLFH	Production resources/tool assignments
PLMK	Inspection plan characteristics
PLMW	Inspection plan characteristic values
PLAB	Task list relationships
PLTX	PMS texts
PLPH	Phases and partial operations for CAP
PLFT	Process instructions
PLFV	Process instruction characteristics and partial operation parameters
MLST	Milestones
EINA	Purchasing info record (general data)
EINE	Purchasing info record (data for purchasing organization)
ESLL	Lines for service package
ESLH	Service package header data

 

 

How to find Table name for a Field which is shown structure name on press F1.

We can get this from F1 – Technical Information for table and field.

The fields names are always shown correct. But for table name, sometime it shows the structure name instead of table name.

For an example,

When we press F1 on field Short Text on screen ME51N. We can see as well the Short Text field name, but in table portion we can see a structure name not a table name.

As we know the field Short Text (TXZ01) is stored in EBAN table, but we can’t find this from F1 screen.

It shown a structure name as MEREQ3211GRID.

In that situation, we have to find the original table name for this field.

Here I am giving the 3 way to find the original table for any field.

Way 1:

When the above pop-up comes, double click on the “Data Element”.

Now you can see a screen of Display Data Element.

Now you can see the data element screen for the field Short Text.

Now Press Where-Used List. This is on application menu bar

You can see another pop-up screen will come, which is like below screen.

As we need the table name, so remove the all tick without Table Fields.

Now press enter or continue. After pressing enter, you will find a list.

This list shows you on which table the field is used.

It means in the listed tables, you can find the field Short Text (TXZ01)

We can see 15 Hits comes on the screen.

It means the field TXZ01 is used in 15 tables.

Now we can find the table as per our requirement. We need the table for ME51N (Purchase Requisition).

We can see Purchase requisition is also listed in the list.

And we can also see the table name for Purchase Requisition.

If you have found a many number of hits, then you can search for your table with given description.

Like as if you want to know the table for PR, then you can search as purchase requisition

In that way we can find the original table name for this particular field.

(Note: I know I have given an easy field and table name, But I am just sharing the procedure to see the original table name for a particular field)

Way 2:

This is a similar way as way one. Just first step is little different.

If you know the field name, then we can enter it directly in SE11 screen and we can get the Table name.

In SE11 screen, on the field Database Table, give the field name (Where usually we give the table name)

Now press display.

You can see the Display Data Element screen.

You can do the further process which we have already discussed in the Way 1 section.

Way 3:

This is little different way.

Use t-code SE84 or SE15.

You can see an initial screen is appearing for Object Navigator.

Now from here select the option

ABAP Dictionary-Fields-Table Fields.

–

Now Double click on Table Fields.

You can see a screen is will come on right side of the screen.

Here give the field name as TXZ01.

Then Press execute.

Now you will get the all table list for the field TXZ01.

Here you also use the search option which I have discussed in way 1.

In these above 3 ways, you can find the original table name for a particular field.

So don’t worry when you see a structure name in table field, just use one option from above and you will get the table original table name.