引:http://wiki.sdn.sap.com/wiki/display/ERPLO/Frequently+Used+Tables
Group | Table Name | Description |
Classification Tables & Others | AUSP | Characteristic Values |
Classification Tables & Others | CABN | Characteristics |
Classification Tables & Others | CABNT | Characteristic Descriptions |
Classification Tables & Others | JCDS | Change Documents for System/User Statuses (Table JEST) |
Classification Tables & Others | JEST | Object status |
Classification Tables & Others | JSTO | Status object information |
Classification Tables & Others | KLAH | Class Header Data |
Classification Tables & Others | KSML | Characteristics of a Class |
Classification Tables & Others | KSSK | Allocation Table: Object to Class |
Classification Tables & Others | ONR00 | General Object Number |
Classification Tables & Others | ONROR | Object Number Index, Order |
Classification Tables & Others | SWOR | Classification System: Catchwords |
Classification Tables & Others | TCLA | Class Types |
Classification Tables & Others | TCLAT | Class Type Texts |
Classification Tables & Others | TCO09 | CIM order: Text IDs of objects in orders |
Classification Tables & Others | TJ02T | System status texts |
Classification Tables & 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 |