Friday, October 26, 2012

List of SAP Tables you may need to SAP developments, Enhancements, Reports and Script and Smart forms

Group
Table Name
Description
Classification Tables and Others
AUSP
Characteristic Values
Classification Tables and Others
CABN
Characteristics
Classification Tables and Others
CABNT
Characteristic Descriptions
Classification Tables and Others
JCDS
Change Documents for System/User Statuses (Table JEST)
Classification Tables and Others
JEST
Object status
Classification Tables and Others
JSTO
Status object information
Classification Tables and Others
KLAH
Class Header Data
Classification Tables and Others
KSML
Characteristics of a Class
Classification Tables and Others
KSSK
Allocation Table: Object to Class
Classification Tables and Others
ONR00
General Object Number
Classification Tables and Others
ONROR
Object Number Index, Order
Classification Tables and Others
SWOR
Classification System: Catchwords
Classification Tables and Others
TCLA
Class Types
Classification Tables and Others
TCLAT
Class Type Texts
Classification Tables and Others
TCO09
CIM order: Text IDs of objects in orders
Classification Tables and Others
TJ02T
System status texts
Classification Tables and Others
TJ30T
User status texts
FI / CO Tables
BPBK
Budget revision text
FI / CO Tables
BPEG
Budget revision header
FI / CO Tables
BPEJ
Budget revision header
FI / CO Tables
BPEP
Line Item Period Values
FI / CO Tables
BPGE
Overall/annual budget
FI / CO Tables
BPJA
Overall/annual budget
FI / CO Tables
BNKA
Bank master record
FI / CO Tables
BP000
Business Partner Master (General Data)
FI / CO Tables
BSAD
Accounting: Secondary index for customers (cleared items)
FI / CO Tables
BSAK
Accounting: Secondary index for vendors (cleared items)
FI / CO Tables
T001
Company Codes
FI / CO Tables
ANAR
Asset Types
FI / CO Tables
ANAT
Asset Types
FI / CO Tables
BKDF
Asset type text
FI / CO Tables
BSAS
Document header supplement for recurring entry
FI / CO Tables
BSEC
One-Time Account Data Document Segment
FI / CO Tables
BSEG
One-time account data document segment
FI / CO Tables
BSID
Accounting document segment
FI / CO Tables
BSIK
Accounting: Secondary index for customers
FI / CO Tables
BSIM
Accounting: Secondary index for vendors
FI / CO Tables
BSIS
Secondary Index, Documents for Material
FI / CO Tables
CEPC
Accounting: Secondary index for G/L accounts
FI / CO Tables
CEPCT
Profit center master data table
FI / CO Tables
COBRA
Texts for Profit Center Master Data
FI / CO Tables
COBRB
Settlement rule for orders
FI / CO Tables
COKA
Distribution settlement rules
FI / CO Tables
COSP
CO Object: Cost Element Control Data
FI / CO Tables
COSS
External actual costs
FI / CO Tables
CRCO
Internal actual costs
FI / CO Tables
CSKA
Assignment of Work Center to Cost Center
FI / CO Tables
CSKB
Cost elements (data dependent on chart of accounts)
FI / CO Tables
CSLA
Cost elements (data dependent on controlling area)
FI / CO Tables
FEBEP
Activity master
FI / CO Tables
FPLA
Electronic Bank Statement Line Items
FI / CO Tables
FPLT
Billing Plan
FI / CO Tables
GLPCT
Billing Plan: Dates
FI / CO Tables
KNA1
EC-PCA: Totals Table
FI / CO Tables
KOMK
General Data in Customer Master
FI / CO Tables
MAHNV
Pricing communications
FI / CO Tables
REGUT
Management records for the dunning program
FI / CO Tables
SKA1
TemSe - administration data
FI / CO Tables
SKAT
G/L accounts master (chart of accounts)
FI / CO Tables
SKB1
G/L account master record (chart of accounts: description)
FI / CO Tables
T003T
G/L account master (company code)
FI / CO Tables
T007S
Document type texts
FI / CO Tables
T087J
Tax Code Names
FI / CO Tables
TAPRFT
Text (Investments)
FI / CO Tables
TKA01
Text tab. for investment profile
FI / CO Tables
TKA09
Controlling areas
FI / CO Tables
TKVS
Basic settings for versions
FI / CO Tables
TZB0T
CO versions
FI / CO Tables
TZPAT
Flow types text table
FI / CO Tables
VBSEGS
Financial Assets Management product type texts
FI / CO Tables
VTBFHA
Preliminary posting doc.segment for G/L accts
FI / CO Tables
VTBFHAPO
Transaction
FI / CO Tables
VTBFHAZU
Transaction Flow
FI / CO Tables
VTBFINKO
Transaction Activity
FI / CO Tables
VTIDERI
Transaction Condition
FI / CO Tables
VTIFHA
Master Data Listed Options and Futures
FI / CO Tables
VTIFHAPO
Underlying transaction
FI / CO Tables
VTIFHAZU
Underlying transaction flows
FI / CO Tables
VTIOF
Underlying transaction status table
FI / CO Tables
VWPANLA
Futures and Options
FI / CO Tables
CSKS
Cost center master
FI / CO Tables
CSKT
Cost Center Texts
Gen Tables
T001W
Plants
HR Tables / Infotypes
CATSCO
Cross-Application Time Sheet (CATS): Transfer to CO
HR Tables / Infotypes
CATSDB
CATS: Database for Time Recording Sheet
HR Tables / Infotypes
CATSHR
Cross-Application Time Sheet (CATS): Transfer to HR
HR Tables / Infotypes
CATSMM
Cross-Application Time Sheet (CATS): Transfer to MM
HR Tables / Infotypes
CATSPM
Cross-Application Time Sheet (CATS): Transfer to PM/SM
HR Tables / Infotypes
CATSPS
Cross-Application Time Sheet (CATS): Transfer to PS
HR Tables / Infotypes
HRP1000
Infotype 1000 DB Table
HR Tables / Infotypes
HRP1001
Infotype 1001 DB Table
HR Tables / Infotypes
HRP1028
Infotype 1028 DB Table
HR Tables / Infotypes
Paxxxx
transparent tables for infotypes
HR Tables / Infotypes
PCL1
HR Cluster 1
HR Tables / Infotypes
PCL2
HR Cluster 2
HR Tables / Infotypes
PERNR
Standard Selections for HR Master Data Reporting
HR Tables / Infotypes
T001P
Personnel Area/Subarea
HR Tables / Infotypes
T001T
Company code-dependent texts
HR Tables / Infotypes
T500L
Personnel Country Grouping
HR Tables / Infotypes
T500P
Personnel Areas
HR Tables / Infotypes
T502T
Marital Status Designators
HR Tables / Infotypes
T503
Employee Groups / Subgroups
HR Tables / Infotypes
T503T
Employee Subgroup Names
HR Tables / Infotypes
T508A
Work Schedule Rules
HR Tables / Infotypes
T510
Pay Scale Groups
HR Tables / Infotypes
T510A
Pay Scale Types
HR Tables / Infotypes
T510F
Assign pay scale --> Currency
HR Tables / Infotypes
T510W
Pay Scale > Period Parameter Assignment
HR Tables / Infotypes
T511
Wage Types
HR Tables / Infotypes
T512T
Wage type texts
HR Tables / Infotypes
T512W
Wage Type Valuation
HR Tables / Infotypes
T512Z
Permissibility of Wage Types per Infotype
HR Tables / Infotypes
T527X
Organizational Units
HR Tables / Infotypes
T528T
Position Texts
HR Tables / Infotypes
T529T
Personnel Action Texts
HR Tables / Infotypes
T529U
Status Values
HR Tables / Infotypes
T530 
Reason for action
HR Tables / Infotypes
T530T
Reason for Action Texts
HR Tables / Infotypes
T549A
Payroll Accounting Areas
HR Tables / Infotypes
T549Q
Payroll Periods
HR Tables / Infotypes
T550A
Daily Work Schedules
HR Tables / Infotypes
T550S
Daily Work Schedule Texts
HR Tables / Infotypes
T551S
Period Work Schedule Texts
HR Tables / Infotypes
T552A
Monthly work schedule
HR Tables / Infotypes
T554C
Absence Valuation
HR Tables / Infotypes
T554S
Absence and Attendance Types
HR Tables / Infotypes
T554T
Absence and Attendance Texts
HR Tables / Infotypes
T558B
Payroll Account Transfer: Payroll Periods
HR Tables / Infotypes
T569V
Payroll Control Records
HR Tables / Infotypes
T5K8C
Transfer ext. payroll results into Canadian specific tables
HR Tables / Infotypes
T74FA
Benefits insurance plan
HR Tables / Infotypes
T74FC
Benefits Calculation Rule for Insurance Coverage Formula
HR Tables / Infotypes
0
Actions
HR Tables / Infotypes
1
Org. Assignment
HR Tables / Infotypes
2
Personal Data
HR Tables / Infotypes
3
Payroll status
HR Tables / Infotypes
6
Addresses
HR Tables / Infotypes
7
Planned Working Time
HR Tables / Infotypes
8
Basic pay
HR Tables / Infotypes
9
Bank details
HR Tables / Infotypes
11
Ext.Bank Transfers
HR Tables / Infotypes
14
Recurring Benefits/Deductions
HR Tables / Infotypes
15
Additional Payments
HR Tables / Infotypes
19
Monitoring of Dates
HR Tables / Infotypes
21
Family
HR Tables / Infotypes
22
Education
HR Tables / Infotypes
23
Previous employment
HR Tables / Infotypes
24
Qualifications
HR Tables / Infotypes
41
Date Specifications
HR Tables / Infotypes
57
Membership Fees
HR Tables / Infotypes
167
Health Care Plans
HR Tables / Infotypes
168
Insurance Plans
HR Tables / Infotypes
169
Savings Plans
HR Tables / Infotypes
376
Medical Benefits Data
HR Tables / Infotypes
377
Misc. Plans
HR Tables / Infotypes
416
Time Quota Compensation
HR Tables / Infotypes
2001
Absences
HR Tables / Infotypes
2002
Attendances
HR Tables / Infotypes
2003
Substitutions
HR Tables / Infotypes
2006
Absence Quotas
MM Tables
BSIK
Accounting: Secondary index for vendors
MM Tables
EINA
Purchasing Info Record: General Data
MM Tables
EINE
Purchasing Info Record: Purchasing Organization Data
MM Tables
MAKT
Material Descriptions
MM Tables
MARA
Material Master
MM Tables
MARC
Material Master Plant segment
MM Tables
MARD
Material Master: Storage location
MM Tables
MAST
Material to BOM Link
MM Tables
MBEW
Material valuation
MM Tables
MKPF
Material document header
MM Tables
MSEG
Material document segment
MM Tables
MVER
Material Consumption
MM Tables
RKPF
Document Header: Reservation
MM Tables
T023
Material types
MM Tables
T024
Purchasing Groups
MM Tables
T156
Movement Type
MM Tables
T157H
Help Texts for Movement Types
MM Tables
T001L
Storage Locations
MM/SD Tables
TINCT
Customers: Incoterms: Texts
PM/CS Tables
OBJK
Plant Maintenance Object List
PM/CS Tables
T352R
Maintenance revisions
PM/CS Tables
T353I_T
Maintenance activity type description
PM/CS Tables
T356
Priorities
PM/CS Tables
T357G
Permits
PM/CS Tables
T357G_T
Table 357G texts
PM/CS Tables
T370A
Activity category for PM lists
PM/CS Tables
VIAUFKST
Order selection view
PM/CS/AM Tables
ANEK
Asset Document header
PM/CS/AM Tables
ANEP
Asset document Items
PM/CS/AM Tables
ANEV
Asset downpymt settlement
PM/CS/AM Tables
ANKT
Asset text
PM/CS/AM Tables
ANLA
Asset master
PM/CS/AM Tables
ANLB
Asset - Depreciation terms
PM/CS/AM Tables
ANLC
Asset values
PM/CS/AM Tables
ANLH
Main asset number
PM/CS/AM Tables
AT02T
Transaction Activity Category: Description
PM/CS/AM Tables
AT02A
Transaction Code for Menu TIMN
PM/CS/AM Tables
AT10
Transaction type
PM/CS/AM Tables
AT10T
Name of Transaction Type
PM/CS/AM Tables
BKORM
Accounting correspondence requests
PM/CS/AM Tables
BKPF
Accounting document header
PM/CS/AM Tables
BLPK
Document log header
PM/CS/AM Tables
BLPP
Document log item
PM/CS/QM Tables
QMEL
Quality notification
PM/CS/QM Tables
QMFE
Quality notification - items
PM/CS/QM Tables
QMIH
Quality message - maintenance data excerpt
PM/CS/QM Tables
QMMA
Quality notification - activities
PM/CS/QM Tables
QMSM
Notification - Tasks
PM/CS/QM Tables
QMUR
Quality notification - causes
PM/SM/SD Tables
AFAB
Network - Relationships
PM/SM/SD Tables
AFFH
PRT assignment data for the work order
PM/SM/SD Tables
AFFL
Work order sequence
PM/SM/SD Tables
AFFT
Order process instructions
PM/SM/SD Tables
AFFV
Order process instruction values
PM/SM/SD Tables
AFFW
Goods movements with errors from confirmations
PM/SM/SD Tables
AFIH
Maintenance order header
PM/SM/SD Tables
AFKO
Order header data PP orders
PM/SM/SD Tables
AFPO
Order item
PM/SM/SD Tables
AFRC
Table of planned changes to conf.: Automatic goods receipt
PM/SM/SD Tables
AFRD
Default values for collective confirmation
PM/SM/SD Tables
AFRH
Header information for confirmation pool
PM/SM/SD Tables
AFRU
Order completion confirmations
PM/SM/SD Tables
AFRV
Pool of confirmations
PM/SM/SD Tables
AFVC
Operation within an order
PM/SM/SD Tables
AFVU
DB structure of the user fields of the operation
PM/SM/SD Tables
AFVV
DB structure of the quantities/dates/values in the operation
PM/SM/SD Tables
AFWI
Subsequently posted goods movements for confirmations
PM/SM/SD Tables
AUFK
Order master data
PM/SM/SD Tables
AUFM
Goods movement for order
PM/SM/SD Tables
BGMK
Master warranty header
PM/SM/SD Tables
BGMP
Master warranty item
PM/SM/SD Tables
BGMS
Text item master warranty
PM/SM/SD Tables
BGMT
Master warranty text
PM/SM/SD Tables
BGMZ
Warranty counter information
PM/SM/SD Tables
CRHD
Work Center Header
PM/SM/SD Tables
CRTX
Text for the Work Center or Production Resource/Tool
PM/SM/SD Tables
EQKT
Equipment short texts
PM/SM/SD Tables
EQST
Equipment link to BOM
PM/SM/SD Tables
EQUI
Equipment master data
PM/SM/SD Tables
EQUZ
Equipment time segment
PM/SM/SD Tables
HIKO
Order master data history
PM/SM/SD Tables
IFLO
Functional Location (View)
PM/SM/SD Tables
IFLOT
Functional location (TABLE)
PM/SM/SD Tables
IFLOTX
Functional location: Short texts
PM/SM/SD Tables
IHGNS
Plant maintenance permit segment
PM/SM/SD Tables
IHPA
Plant Maintenance: Partners
PM/SM/SD Tables
IHSG
Object-related permits in Plant Maintenance
PM/SM/SD Tables
ILOA
PM object location and account assignment
PM/SM/SD Tables
IMPTT
Measuring point (table)
PM/SM/SD Tables
IMRG
Measurement document
PM/SM/SD Tables
KAKO
Capacity Header Segment
PM/SM/SD Tables
AGKO
Cleared accounts
PP Tables
BLPR
Document log index and planned order (backflush)
PP/PM/CS Tables
STPOA
BOM items
PP/PM/CS/PS/CO Tables 
T003O
Order Types
PS Tables
AFAB
Network - Relationships
PS Tables
IMAK
Appropriation requests
PS Tables
IMAV
Appropriation request variants
PS Tables
IMPR
Capital Investment Program Positions
PS Tables
IMPU
Texts for cap. inv. program positions
PS Tables
IMTP
Capital Investment Programs
PS Tables
IMZO
CO object assignment
PS Tables
PMCO
Cost structure of maintenance order
PS Tables
PRHI
WBS Hierarchy
PS Tables
PROJ
Projects
PS Tables
PRPS
Work Breakdown structures
Purchasing Tables
A501
Winter Rate- Purch. Org/Material
Purchasing Tables
EBAN
Purchase Requisition
Purchasing Tables
EBKN
Purchase Requisition Account Assignment
Purchasing Tables
EKAB
Release Documentation
Purchasing Tables
EKBE
History of Purchasing Document
Purchasing Tables
EKET
Scheduling Agreement Delivery Schedules
Purchasing Tables
EKKN
Account Assignment in Purchasing Document
Purchasing Tables
EKKO
Purchasing document header (PO)
Purchasing Tables
EKPO
Purchasing document item
Purchasing Tables
IKPF
Header: Physical Inventory Document
Purchasing Tables
ISEG
Physical Inventory Document Items
Purchasing Tables
LFA1
Vendor master
Purchasing Tables
LFB1
Vendor master (company code)
Purchasing Tables
NRIV
Number range intervals
Purchasing Tables
RESB
Reservation/dependent requirements
Purchasing Tables
T161T
Texts for Purchasing Document Types
QM/PM/CS Tables
QPCT
Code texts
QM/PM/CS Tables
QPGR
Inspection catalog code groups
QM/PM/CS Tables
QPGT
Code group texts
QM/PM/CS Tables
TQ15
Inspection catalog type index
SD Tables
KONP
Conditions (Item)
SD Tables
KONV
Conditions (Procedure Data)
SD Tables
T077D
Customer account groups
SD Tables
TVKO
Organizational Unit: Sales Organizations
SD Tables
TVKOS
Organizational Unit: Divisions per Sales Organization
SD Tables
TVKOV
Org. Unit: Distribution Channels per Sales Organization
SD Tables
TVTA
Organizational Unit: Sales Area(s)
System Tables
ADCP
Person/Address assignment (central address administration)
System Tables
ADIRACCESS
Table to store keys for TADIR objects
System Tables
ADR2
Telephone numbers (central address admin.)
System Tables
ADRP
Persons (central address administration)
System Tables
APQD
DATA DEFINITION Queue
System Tables
APQI
Queue info definition
System Tables
D010SINF
ABAP/4: Information about ABAP/4 program source code
System Tables
E071
WBO + transport: Object entries of requests/tasks
System Tables
E07T
WBO + transport: Short texts for requests/tasks
System Tables
ENLFDIR
Additional Attributes for Function Modules
System Tables
INDX
System table INDX
System Tables
NAST
Message status
System Tables
STXH
STXD SAPscript text file header
System Tables
T005
Countries
System Tables
T005S
Taxes: Region (Province) Key
System Tables
T005U
Taxes: Region Key: Texts
System Tables
T006
Units of Measurement
System Tables
T015M
Names of the months
System Tables
T247
Month name and short text
System Tables
T777A
Building Addresses
System Tables
TADIR
Catalog of R/3 Repository objects
System Tables
TBTCO
Job status overview table
System Tables
TBTCP
Batch job step overview
System Tables
TFDIR
Function Modules
System Tables
TFTIT
Function module short text
System Tables
TSP03L
Spool: Long device names
System Tables
TSTC
Transaction codes
System Tables
TSTCT
Transaction Code Texts
System Tables
TUTYP
User types in the R/3 System
System Tables
TUZUS
Special versions
System Tables
TVARV
Table of variables in selection criteria
System Tables
TVDIR
View Directory
System Tables
US930
Data relevant to measurement for user master record
System Tables
USR01
User master record (runtime data)
System Tables
USR02
Logon data
System Tables
USR04
User master authorizations
System Tables
USR06
Additional data per user
System Tables
USR14
Surchargeable language versions per user
System Tables
USR21
Assign user name address key