How to find tables in SAP:
Select the required field
Press F1 for help
Press F9 for technical information
Double-click on the data element field
Double-click on the domain field (provided it isn't something like CHAR1, otherwise go to step 6)
Select the where-used button (button with little yellow square with 3 arrows radiating)
Select indirect application from the pop-up box
Double-click on the database tables line in the next pop-up box
You should now have a list of all DB tables where that field is used (this should work in about 90% of cases)
Get More Questions and Answers with Explanation at SAP PM (Plant Maintenance) Forums.
Alternatively:
Run TCode ST05 (performance analysis)
Press button
Enter the transaction you want to use (e.g. /NIW32) in the command code box
Enter an order number in the Order sub-screen
Execute, or F8
Enter /NST05 in the command code box
Press the button
Press the button
Review tables
PM & CS Tables:
Follow the link below to the most comprehensive list of PM/CS Tables on the web.
Download PM/CS Tables file here
The following two files have been provided by Kelly Kernan:
- Download PM Tables Keys here
- Download CS Tables For Programmers here
Code:
AD01C_ATTR DIP profile: Characteristics RRB
AD01C_CHK DIP profile: Check function RRB
AD01C_CHKT DIP profile: Check function texts RRB
AD01C_CT Apportionment reason RRB
AD01C_CTT Apportionment reason text RRB
AD01C_MAT DIP profile: Material determination RRB
AD01C_MATA DIP profile: Material determination criteria RRB
AD01C_PROF DIP profile: Usage RRB
AD01C_PRTX DIP profile: Texts RRB
AD01C_SEL DIP profile: Sources RRB
AD01C_SELA DIP profile: Selection criteria RRB
AD01DLI Dynamic items (DI) RRB
AD01DLIEF DI flow: Individual flow RRB
AD01DLISF DI Flow: Totals Flow RRB
AD01FILTVAR Filter Variants RRB
AD01SETTCH DIP: Saved settings for user 1 RRB
AD01SETTMO DIP: Saved settings for user 2 RRB
AD01SRC DIP: Sources RRB
AD01SRCARC Residence Time for DIP Sources RRB
AD01SRCTAB DIP: Source <-> Table RRB
AD01SRCTXT DIP: Source Texts RRB
AFAB Network - Relationships Orders
AFFH PRT assignment data for the work order Orders
AFFL Work order sequence Orders
AFFW Goods Movements with Errors from Confirmation Confirmations
AFFWPRO Log of deleted AFFW entries Confirmations
AFIH Maintenance order header Orders
AFKO Order header data PP orders Orders
AFPO Order item Orders
AFRC Incorrect cost calculations from confirmation Confirmations
AFRD Default values for collective confirmation Confirmations
AFRH Header information for confirmation pool Confirmations
AFRH_DEL Backup Copy of Header Information for Confirm Confirmations
AFRP0 Table of planned changes for confirmation (PD Confirmations
AFRP1 Table of planned changes to conf.: Automatic Confirmations
AFRP2 Table of planned changes for confirmation: Ba Confirmations
AFRP3 Table of planned changes for confirmation: Ca Confirmations
AFRP4 Table of planned changes to confirmatn: Data Confirmations
AFRU Order Confirmations Confirmations
AFRUHR Order Confirmations for HR Confirmations
AFRV Confirmation pool Confirmations
AFRV_DEL Backup Copy for Confirmation Pool Confirmations
AFSPOPR Split Operations in an Order Split Orders
AFSPREL Relation Between Orders in an Order Split Orders
AFVC Operation within an order Orders
AFVU DB structure of the user fields of the operat Orders
AFVV DB structure of the quantities/dates/values i Orders
AFWI Subsequently posted goods movements for confi Confirmations
ARC_PM_OBJLIST Customizing for Archiving of Serial Number Ob TechObjects, SerNo
ARC_PM_OBJLIST_T Customizing Texts for Archiving of Serial Num TechObjects, SerNo
ASMDT Service Short Texts Service
AUFK Order master data Orders
AUFM Goods movements for order Orders
BGMK Master Warranty Header Warranty
BGMKOBJ Master Warranty - Object Assignment Warranty
BGMP Master Warranty Item Warranty
BGMS Master Warranty Text Item Warranty
BGMT Master Warranty Text Warranty
BGMZ Warranty Counter Warranty
CCRHD Work Center Header Work Centres
COBRA Settlement Rule for Order Settlement Settlement, Orders
COBRB Distribution Rules Settlement Rule Order Sett Settlement, Orders
COMPPRT OCM: Comparison result, individual record for PRT
CORUUSR User Settings for Confirmation Confirmations
CRCA Work Center Capacity Allocation Work Centres
CRCO Assignment of Work Center to Cost Center Work Centres
CRFH CIM production resource/tool master data Work Centres
CRHD Work Center Header Work Centres
CRHH Hierarchy Header Data Work Centres
CRHS Hierarchy Structure Work Centres
CRID CIM Resource - Entities Work Centres
CRTX Text for the Work Center or Production Resour Work Centres
CRVD_A Link of PRT to Document PRT
CRVD_B Link of Document to PRT PRT
CRVE_A Assignment PRT data - equipment TechObjects, Equip, PRT
CRVE_B Assignment equipment - PRT data TechObjects, Equip, PRT
CRVM_A Link of PRT data to a material PRT
CRVM_B Link of material to a production resource/too PRT
CRVS_A Relationship of PRT internal number to PRT ex PRT
CRVS_B Relationship of PRT external number to PRT in PRT
DOST Document to BOM Link Technical Object, BOM
DPBP_PROF DIP Profile: Profile Header Enhancement RRB
DPPROFH DIP profile: Header RRB
EAPL Allocation of task lists to pieces of equipme Task List, TechObjects
EBII CO/SD document flow: billed portions of expen RRB
EQBS Serial Number Stock Segment TechObjects, SerNo
EQKT Equipment Short Texts TechObjects, Equip
EQSE Serial Number Records TechObjects, SerNo
EQST Equipment to BOM Link TechObjects, Equip, BOM
EQUI Equipment master data TechObjects, Equip
EQUZ Equipment time segment TechObjects, Equip
ESKL Account Assignment Specification: Service Lin Services
ESKN Account Assignment in Service Package Services
ESLA Service Type Editions Services
ESLB Service Type Header of Standard Service Catal Services
ESLH Service Package Header Data Services
ESLL Lines of Service Package Services
ESLP Service Item Services
ESLT Service Item Short Texts Services
ESLZ Service Type Lines Services
ESSR Service Entry Sheet Header Data Services
ESST Service Item Short Texts Services
ESUC Ext. Services Management: Unplanned Limits on Services
ESUH Ext. Services Management: Unpl. Service Limit Services
ESUP Ext. Services Management: Unpl. Limits on Ser Services
ESUS Services Management: Unplanned Limits on Serv Services
HIKO Order master data history Orders
HIMA PM order history - materials Orders
HIVG PM order history - operations Orders
HUINV_SERNR Handling Unit Phys. Inv. Doc. - Serial Number TechObjects, SerNo
HUMSEG_SER Serial Numbers for the HUMSEG Table TechObjects, SerNo
IBBINDING IB: Relationship Table Between IBase Event an IBase, Class
IBDU Postprocessing of PM/SM Objects IBase, Class, Notif'n
IBEXTINST IB: Instance Number for External Display IBase, Class
IBIB IB: Installed Base/IBase IBase, Class
IBIBOBS IB: IBase observer IBase, Class
IBIBT IB: Installed base short texts IBase, Class
IBIN IB: Component/instance IBase, Class
IBINCM IB: Config.Mang.: Component/Instance IBase, Class
IBINDOMAINS IB: Redundant design object
Read Here for more SAP PM (Plant Maintenance) Interview Questions and Answers.