sap各种表的用法x.docxVIP

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 (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 SAPs 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,HR等等打头的表也是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. 用事务sell输入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