Useful Tables - PM Module
Useful Tables - PM Module
Useful Tables - PM Module
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
CABN: Characteristics
Key Fields
ATINN
ADZHL
ATNAM
ATFOR
ANZST
ANZDZ
ATKLA
ATWRT
Work Center
Tables
CRHD
CRCO
CRTX
KOKRS
LSTAR
Functional Location
Tables
IFLOT
IFLOTX
ILOA
Equipment
Tables
EQUI
EQUZ
EQKT
LVORM
INVRN
HERST
GERNR
OBJNR
WERK
Equipment BOM
Tables
EQST
STKO
STPO
TPST: Functional Location to BOM Link
Key Fields
TPLNR
WERKS
STLNR
Material BOM
Tables
MAST
STPO
POSTX1
MENGE
Key Fields
PLNTY
PLNNR
PLNAL
VERWE
WERKS
KTEXT
VAGRP
Maintenance Plans
Tables
MPLA
MPOS
PLWP
T351P
MHIS
MMPT
PLNTY
PLNNR
PLNAL
WPGRP
GEWRK
IWERK
ILOAN
AUART
PRIOK
WARPL
ABNUM
NPLDA
STADT
LRMDT
HORDA
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
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