SAP各种表的用法.docx

SAP 多种表使用方法
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 (. 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 . PA0001 for the Org Man infotype.
用事务se11,输入PA*后按F4, 一样输入HRP*,你会看见大多HR用transaparent Tables, 在表TRMAC中访问RP_read_*和RP_provide*.
PA* - PA infotype tables
PCL* - HR clusters
PB* - recruitment tables
PCERT - payroll posting runs
Another useful table is CATSDB for CATS, and PTEX for the CATS transfer table for infotype / .
The rest of the HR Tables are as follows:
DD01L Domains
DD02L SAP tables
DD03L Table Fields
DD03T DD: Texts for fields (language dependent)