PM Tables

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

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:  Keyworks

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 #


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


Functional Location

Tables Description
IFLOT Functional Location Table
IFLOTX Functional Location Short Texts
ILOA PM Object Location and Account Assignment


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

Key Fields Description
TPLNR Functional Location
PLTXT Description of Functional Location


ILOA:  PM Object Location and Account Assignment

Key Fields Description
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


Equipment

Tables Description
EQUI Equipment Master Data
EQUZ Equipment Time Segment
EQKT Equipment Short Texts

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

Key Fields Description
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

Key Fields Description
EQUNR Equipment Number
EQKTX Short Description


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

Key Fields Description
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

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

Key Fields Description
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 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

Key Fields Description
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

Key Fields Description
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


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

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”)


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


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

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)


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

Key Fields Description
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

Key Fields Description
AUFNR Order Number
GLTRP Basic finish date
GSTRP Basic start date
AUFPL Link to Order Operation


AFVC:  Order Operations

Key Fields Description
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

Key Fields Description
ARBEI Work
DAUNO Duration


sources : https://wiki.scn.sap.com/wiki/display/ERPLO/Useful+Tables+-+PM+Module 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s