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
Leave a comment