【IT168 信息化】

    All personnel administration tables start with PA and the infotype number behind it.

    所有职员的管理table是以PA打头并有相应的infotype加在其后的.

    All personnel development/OM tables start with HRP and infotype (e.g. 1000) behind it.

    所有职员的development/OM table是以HRP打头并有相应的infotype加在其后的.

    All recruitment tables start with PB and infotype number behind it.

    所有招聘的人员的表是以PB打头,并以相应的infotype号结尾的.

    There also are HR tables that start with HRA, HPD, HRT, etc. The easy way to get a list is to use SAP's 'Application Hierarchy', transaction SE81 (select all HR modes in the tree that you are want a list of tables for, click on the 'Information System' button, under Abap Dictionary --> Basic Objs, double click on 'database tables', increase your 'maximun no. of hits' and execute).

    同样,有HRA,HPD,HRT等等打头的表也是HR里的, 有一种获取的方便方法, 事务'SE81'中,(在右边的树结构里,选择所有HR有关的modes, 点击工具栏上的'Information System'按纽, 在Abap Dictionary中选Basic Objs,双击'database tables', 输入'maximun no of hits'后执行.

    Use transaction se11...type in PA* do dropdown and enter, do the same for HRP* and you will have most of the HR transaparent Tables. To access them look for RP_read_* and RP_provide* in Table TRMAC to read a infotype or use the 'select' statement to access the Transparent table.

    Transaction SE16 (data browser) is also useful. As mentioned above, the PA infotype tables all begin with PA and are followed by the infotype number e.g. PA0001 for the Org Man infotype.

    用事务se11,输入PA*后按F4, 同样输入HRP*,你会看见大多HR用的transaparent Tables, 在表TRMAC中访问RP_read_*和RP_provide*打头的去读取一个infotype.或是用select语句访问这些表.

    PA* - PA infotype tables 
    PCL* - HR clusters 
    PB* - recruitment tables 
    PCERT - payroll posting runs

    Another useful table is CATSDB for CATS, and PTEX2000 for the CATS transfer table for infotype 2001/2002.

    The rest of the HR Tables are as follows: 
    DD01L Domains 
    DD02L SAP tables 
    DD03L Table Fields 
    DD03T DD: Texts for fields (language dependent) 
    DD04L Data elements 
    DD04T R/3 DD: Data element texts 
    DD05S Foreign key fields 
    DD06L Pool/cluster structures 
    DD20L Matchcode Ids 
    DD24S Fields of a matchcode ID 
    T000 Clients 
    T001 Company Codes 
    T001E Company code-dependent address data 
    T001P Personnel Areas/Subareas 
    T012 House banks 
    T012K House bank accounts 
    T012T House bank account names 
    T500L Personnel Country Grouping 
    T500P Personnel Areas 
    T500T Personnel Country Groupings 
    T501 Employee Group 
    T501T Employee Group Names 
    T502T Marital Status Designators 
    T503 Employee Groups / Subgroups 
    T503K Employee subgroup 
    T503T Employee Subgroup Names 
    T504A Benefits - Default Values (NA) 
    T504B Benefit Option Texts (North America) 
    T504C Benefit Type (NA) 
    T504D Benefit Credit Group Amount 
    T504E Benefit Amount 
    T504F Benefit Costs 
    T508A Work Schedule Rules 
    T508T Texts for Employee Subgroup Groupings for Work Schedules 
    T510 Pay Scale Groups 
    T510A Pay Scale Types 
    T510F Assign Pay Scale > Time Unit, Currency 
    T510G Pay Scale Areas 
    T510H Payroll Constants with Regard to Time Unit 
    T510I Standard Working Hours 
    T510J Constant Valuations 
    T510L Levels 
    T510M Valuation of pay scale groups acc. to hiring date 
    T510N Pay Scales for Annual Salaries (NA) 
    T510S Time Wage Type Selection Rule 
    T510U Pay Scale Groups 
    T510Y Special Rules for Wage Type Generation 
    T511 Wage Types 
    T512R Cumulation Wage Types in Forms 
    T512S Texts for Cumulation Wage Types in Forms 
    T512T Wage Type Texts 
    T512W Wage Type Valuation 
    T512Z Permissibility of Wage Types per Infotype 
    T513 Jobs 
    T514S Table Name Texts 
    T514T Field Name Texts 
    T51D2 Wage Type Classes 
    T51D3 Reduction Rules 
    T51D4 Cumulation Rules 
    T527X Organizational Units 
    T528B Positions - Work Centers 
    T528C Wage Type Catalog 
    T528T Position Texts 
    T529A Personnel Event 
    T529F Fast Data Entry for Events 
    T529T Personnel Event Texts 
    T52BT Texts For HR Objects 
    T52C0 Payroll Schemas 
    T52C1 Payroll Schemas 
    T52C2 Texts for Personnel Calculation Schemas 
    T52C3 Texts for Personnel Calculation Schemas 
    T52C5 Personnel Calculation Rules 
    T52CC Schema Directory 
    T52CD Schema Directory 
    T52CE Directory of Personnel Calculation Rules 
    T52CT Text Elements 
    T52CX Cross References via Generated Schemas 
    T52D1 Valid Processing Classes 
    T52D2 Valid Values for Processing Classes 
    T52D3 Valid Evaluation Classes 
    T52D4 Permitted Values for Evaluation Classes 
    T52D5 Wage Type Groups 
    T52D6 Wage Type Group Texts