ERP Operations /ERP Logistics Operations----Frequently Used Tables

Frequently Used Tables  

 

 

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