Skip to end of metadata
Go to start of metadata

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

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

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

 

 

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

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

 

 

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

 

 

 

 

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

 

 

 

 

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

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

 

  • No labels