100% found this document useful (1 vote)
151 views22 pages

Useful Tables - PM Module

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 22

PM Tables

Configuration
Tables
CSKS
CSSL
T001W
T006
T024I
T352B
T357
T370C
T370F
T370S
T399I
T430
T499S
TC21
TC23
TC24
TC25
TC26
TC27
TC30
TC38A
TGSB
Classification
Tables
INOB
KSSK
AUSP
KLAH
KSML
CAWN
SWOR
CABN
CAWNT

KLAH: Class Header


Key Fields
CLINT
CLASS
KLART

SWOR: Class Description: Keyworkds


Key Fields
CLINT
CLASS

CABN: Characteristics
Key Fields
ATINN
ADZHL
ATNAM
ATFOR
ANZST
ANZDZ
ATKLA

KSML: Characteristics of a Class


Key Fields
CLINT
POSNR
ADZHL
IMERK

KSSK: Object Allocation to a Class


Key Fields
OBJEK
MAFID
KLART
CLINT
ADZHL

CAWNT: Characteristic Value


Key Fields
ATINN
ATZHL
SPRAS
ADZHL
ATWTB

CAWN: Possible Characteristic Values


Key Fields
ATINN
ATZHL
ADZHL

ATWRT

AUSP: Actual Object Characteristic Values


Key Fields
OBJEK
ATINN
ATZHL
MAFID
KLART
ADZHL
ATWRT

INOB: Link Between internal number and object


Key Fields
CUOBJ
KLART
OBTAB
OBJEK
ROBTAB
ROBJEK
CLINT

Work Center
Tables
CRHD
CRCO
CRTX

CRHD: Work Center Header


Key Fields
OBJTY
OBJID
ARBPL
WERKS
VERWE
CRCO: Assignment of Work Center to Cost Center
Key Fields
OBJID
KTEXT
CRTX: Work Center Descriptions
Key Fields
OBJID
KOSTL

KOKRS
LSTAR

Functional Location
Tables
IFLOT
IFLOTX
ILOA

IFLOT: Functional Location Table


Key Fields
TPLNR
FLTYP
TPLMA
INGRP
RBNR
ILOAN

IFLOT: Functional Location Short Texts


TPLNR
PLTXT

ILOA: PM Object Location and Account Assignment


TPLNR
EQFNR
SWERK
STORT
BEBER
GSBER
KOKRS
KOSTL
BUKRS

Equipment
Tables
EQUI
EQUZ
EQKT

EQUI: Equipment Master Data


Key Fields
EQUNR
EQTYP

LVORM
INVRN
HERST
GERNR
OBJNR
WERK

EQUZ: Equipment Time Segment


EQUNR
DATBI
IWERK
HEQUI
HEQNR
INGRP
TIDNR
RBNR

EQKT: Equipment Short Texts


EQUNR
EQKTX

Equipment BOM
Tables
EQST
STKO
STPO

EQST: Equipment to BOM Link


Key Fields
EQUNR
WERKS
STLNR

STPO: BOM Details


STLNR
STLTY
INDRK
POSTP
POSNR
POSTX1
MENGE

Equipment Task List


Tables
EAPL(EquipmentOnly)
PLKO
PLAS
PLPO

EAPL: Allocation of Task List to Equipment


Key Fields
EQUNR
PLNTY
PLNNR
PLNAL
LOEKZ
SWERK
IWERK

PLKO: Task List - Header


PLNTY
PLNNR
PLNAL
VERWE
WERKS
STATU
IWERK
ARBID
KTEXT

PLPO: Task List - Operation / Activity


Key Fields
PLNTY
PLNNR
VORNR
STEUS
WERKS
LTXA1
LAR01

Functional Location BOM


Tables
TPST
STPO


TPST: Functional Location to BOM Link
Key Fields
TPLNR
WERKS
STLNR

STPO: BOM Details


STLNR
STLTY
INDRK
POSTP
POSNR
POSTX1
MENGE
Key Fields
TPST.TPLNR
TPST.WERKS
TPST.STLAN
STPO.INDRK
STPO.POSTP
STPO.POSNR
STPO.MENGE

Material BOM
Tables
MAST
STPO

MAST: BOM Header


Key Fields
MATNR
WERKS
STLAN
STLNR

STPO: BOM Details


STLNR
STLTY
INDRK
POSTP
POSNR

POSTX1
MENGE

Functional Location Task List


Tables
TAPL
PLAS
PLPO

TAPL: Allocation of Task List to Functional Location


Key Fields
TPLNR
PLNTY
PLNNR
PLNAL
IWERK
ARBID

PLAS: Task List - Selection of Operation / Activities


Key Fields
PLNTY
PLNNR
PLNAL
LOEKZ

PLPO: Task List - Operation / Activity


Key Fields
PLNTY
PLNNR
VORNR
STEUS
WERKS
LTXA1
LAR01

General Task List


Tables
PLKO
PLAS
PLPO

PLKO: Task List Header

Key Fields
PLNTY
PLNNR
PLNAL
VERWE
WERKS
KTEXT
VAGRP

PLAS: Task List - Selection of Operation / Activities


Key Fields
PLNTY
PLNNR
PLNAL
LOEKZ

Maintenance Plans
Tables
MPLA
MPOS
PLWP
T351P
MHIS
MMPT

MPLA: Maintenance Plan


Key Fields
WARPL
WPTXT
STRAT
EQUNR
TPLNR
HORIZ
ABRHO

MPOS: Maintenance Item


Key Fields
WAPOS
WARPL
STRAT
PSTXT
EQUNR

PLNTY
PLNNR
PLNAL
WPGRP
GEWRK
IWERK
ILOAN
AUART
PRIOK
WARPL
ABNUM
NPLDA
STADT
LRMDT
HORDA

PLWP: Allocation of Maintenance Packages to Task List Operations


Key Fields
PLNTY
PLNNR
PLNAL
STRAT
LOEKZ
PAKET

Work Orders
Tables
AUFK
AFIH
AFKO
AFVC
AFVV
AFVU
JEST
TJ02T
CRHD
ILOA
COBRA
COBRB
AUFM
AUFK: Order master data
Key Fields
AUFNR

AUART
AUTYP
KTEXT
LTEXT
WERKS
LOEKZ
KOSTL
KOSTV

AFIH: Maintenance Order Header


AUFNR
PRIOK
EQUNR
ILOAN
ANLZU
IWERK
INGPR
GEWRK
ILART
QMNUM

AFKO: Order Header Data


AUFNR
GLTRP
GSTRP
AUFPL

AFVC: Order Operations


AUFPL
VORNR
STEUS
ARBID
WERKS
LTXA1
LTXA2
LARNT
INDET
ANZZL

AFVV: Operation Duration Quantity/Dates/Values


ARBEI
DAUNO

Description
CostCenterMasterData
CostCenter/ActivityTypeAssignment
Plant
UnitofMeasure
MaintenancePlannerGroups
CatalogProfile
PlantSection
ABCIndicator
FunctionalLocationCategory
FunctionalLocationStructureIndicator
PlanningPlant
Operation/ActivityControlKey
LocationCodes
StandardValueKey
WorkCenterUsage
WorkCenterPersonResponsible
WorkCenterCapacityOtherFormula
WorkCenterCapacityCategory
WorkCenterCapacityPlannerGorup
WorkCenterCategory
WorkCenterShiftSequence
BusinessArea

Description
Linkbetweeninternalnumberandobject
AllocationTable:ObjecttoClass
ActualCharacteristicValues
ClassHeaderData
CharacteristicsofaClass
PossibleCharacteristicValues
ClassDescription(keywords)
Characteristic
CharacteristicDescription

Description
IntClass#
ClassName
ClassType

Description
IntClass#
ClassName

Description
IntChar#
IntCountforArchive
CharDescription
DataTypeofCharacteristic
NumberofCharacters
NumberofDecimalPlaces
CharacteristicGroup

Description
IntClass#
Itemnumber
IntCountforArchive
IntChar#

Description
Object
Indicator:object/class
Classtype
IntClass#
IntCountforArchive

Description
IntChar#
IntCounter
Languagekey
IntCountforArchive
CharValueDescription

Description
IntChar#
IntCounter
IntCountforArchive

CharValue

Description
Object
IntChar#
CharValCounter
Indicator:object/class
Classtype
IntCountforArchive
CharValue

Description
Object
Classtype
Dbasetablename
Keyofclassifiedobject
Dbasetablename
Keyofconfigobject
IntClass#

Description
WorkCenterHeader
AssignmentofWorkCentertoCostCenter
WorkCenterDescriptions

Description
Objecttype
ObjectID(Key)
WorkCenter
Plant
WorkCenterCategory

Description
ObjectID(Key)
ShortDescription

Description
ObjectID(Key)
CostCenter

ControllingArea
ActivityType

Description
FunctionalLocationTable
FunctionalLocationShortTexts
PMObjectLocationandAccountAssignment

Description
FunctionalLocation
FunctionalLocationCategory
SuperiorFunctionalLocation
PlannerGroup
CatalogProfile
LocationandAccountAssignmentKey

FunctionalLocation
DescriptionofFunctionalLocation

FunctionalLocation
SortField
MaintenancePlant
Location
PlantSection
BusinessArea
ControllingArea
CostCenter
CompanyCode

Description
EquipmentMasterData
EquipmentTimeSegment
EquipmentShortTexts

Description
EquipmentNumber
EquipmentCategory

DeletionFlag
InventoryNumber
Manufacture
Serial
ObjectNumber
Plant

EquipmentNumber
Vaidtodate(99991231forlatest)
PlanningPlant
SuperiorEquipment
EquipmentPositionatInstallLocation
PlannerGroup
TechnicalID
CatalogProfile

EquipmentNumber
ShortDescription

Description
EquipmenttoBOMLink
BOMHeader
BOMDetails

Description
EquipmentNumber
Plant
EquiptoDetailLink

EquiptoDetailLink
DetailType"E"forEquipBOMs
Component
ItemCategory
ItemNumber
ItemText
ComponentQuantity

Description
AllocationofTaskListtoEquipment
TaskList-Header
TaskList-SelectionofOperations/Activities
TaskList-Operation/Activity

Description
Equipmentnumber
Tasklisttype
Groupkey
GroupCounter
DeletionIndicator
MaintenancePlant
PlanningPlant

Tasklisttype
Groupkey
GroupCounter
TaskListUsage
Plant
Status
PlanningPlant
WorkCenterID
ShortDescription

Description
TaskListType
KeyforTaskListGroup
OperationNumber
ControlKey
Plant
ShortText
ActivityType

Description
FunctionalLocation-BOMLink
BOMDetails

Description
FunctionalLocation
Plant
FunctionalLocationtoDetailLink

EquiptoDetailLink
DetailType"E"forEquipBOMs
Component
ItemCategory
ItemNumber
ItemText
ComponentQuantity
Description
EquipmentNumber
Plant
BOMUsage
Component
ItemCategory
ItemNumber
ComponentQuantity

Description
MaterialtoBOMLink
BOMDetails

Description
MaterialNumber
Plant
BOMUsage("4"forPM)
Billofmaterial

BOMHeader-BOMDetailLink
DetailType"?"forMaterialBOMs
Component
ItemCategory
ItemNumber

ItemText
ComponentQuantity

Description
AllocationofTaskListtoFunctionalLocation
TaskList-SelectionofOperations/Activities
TaskList-Operation/Activity

Description
FunctionalLocation
TaskListType
KeyforTaskListGroup
GroupCounter
MaintenancePlanningPlant
WorkCenterID

Description
TaskListType
KeyforTaskListGroup
GroupCounter
MarkedforDeletion("X")

Description
TaskListType
KeyforTaskListGroup
OperationNumber
ControlKey
Plant
ShortText
ActivityType

Description
TaskListHeader
TaskList-SelectionofOperations/Activities
TaskList-Operation/Activity

Description
TaskListType
KeyforTaskListGroup
GroupCounter
TaskListUsage
Plant
TaskListShortText
ResponsiblePlannerGroup

Description
TaskListType
KeyforTaskListGroup
GroupCounter
MarkedforDeletion("X")

Description
MaintenancePlan
MaintenanceItem
AllocofMaint.PackagestoTaskListOperatoins
MaintenancePackages
MaintenancePlanHistory
CycledefinitionsandMeasPointsforMaintPlan

Description
MaintenancePlan
MaintenancePlanText
MaintenancePlanStrategy
EquipmentNumber
FunctionalLocation
CallHorizon
SchedulingPeriod

Description
MaintenanceItem
MaintenancePlan
MaintenanceStrategy
ItemShortText
EquipmentNumber

TaskListType
TaskListGroup
GroupCounter
PlannerGroup
ObjectIDforWorkCenter
MaintenancePlanningPlant
Location
OrderType
Priority
MaintenancePlan
MaintenancePlanCallNumber
NextPlannedDate
StartDate
DateoflastComp.Confirmation
CallDate

Description
TaskListType
GroupKey
GroupCounter
MaintenanceStrategy
DeletionIndicator
Maintenancepackagenumber

Description
Ordermasterdata
MaintenanceOrderHeader
OrderHeaderdata
Operationwithinanorder
OperationDurationQuantity/Dates/Values
UserfieldsforOperation
ObjectStatus
SystemStatusTexts
WorkCenterHeader
PMObjectLocationandAccountAssignment
SettlementRuleforOrderSettlement
DistributionRulesforSettlementRule(order)
Goodsmovementsfororder

Description
OrderNumber

OrderType("30"forPM)
OrderCategory
ShortText
Indicator:"LongTextExists"
MaintenancePlant
DeletionFlag
SettlementCostCenter
ResponsibleCostCenter

OrderNumber
Priority
EquipmentNumber
FunctionalLocationID
SystemCondition
PlanningPlant
ResponsiblePlannerGroup
WorkCenterID
MaintenanceActivityType
Notification

OrderNumber
Basicfinishdate
Basicstartdate
LinktoOrderOperation

LinktoOrderHeader
OperationNumber
ControlKey
WorkCenterID
Plant
ShortText
2ndLineofDescription
ActivityType
CalculationKey
NumberofResources

Work
Duration

You might also like