ERP Operations /ERP Logistics Operations----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 |
