SAP 各模块常用表整理

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值