Thursday, September 23, 2010

Table Names for Creating Basic Pay Infotype

How can one find which table we are updating when adding/updating an entry in IMG?
The first step of creating a basic pay infotype is 
Payroll India - Basic Settings - Environment of Wage type Maintainence - Create Wage type Catalogue . 
Here when you copy from MB10 and make a new wage type for your client you will find a list of tables displayed. 
Attached is a screen shot for the same.
Module Variant for India is Inval and for rest of the world is PERZT. The table which in which module variants A,B,C,D are maintained is T511.

Finding the list of HR module Tables

Is anybody is having a complete list of HR module tables?
 
All personnel administration tables start with PA and the infotype number behind it. 
All personnel development/OM tables start with HRP and infotype (e.g. 1000) behind it. 
All recruitment tables start with PB and infotype number behind it. 
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).
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. 
PA* - PA infotype tables 
PCL* - HR clusters 
PB* - recruitment tables 
PCERT - payroll posting runs 

Transparent tables for WCM

Need to generate a report for WCM. I need the trasparent tables (Not structures).  Where these fields are located. These are the fields required.
I have checked but these fields are mentioned with reference to structures and not transparent tables.
 
1) WCA= Field Name: WAPINR
2) WCD =Field Name: WCNR
3) Short description = Field Name: STXT
4) User Status =Field Name: USRST
5) System Status =Field Name: SYSST
6) Created on = Field Name = GENDATUM
7) Created by = Field Name =GENNAME
8) Approved by = Field Name= GENVNAME

Have you tried the multi level list reports – WCLE & WCLB. 




Sometimes it also pays the SE16n the tables because those fields could exist there. We have a lot of custom tables so these are the SAP standard I think.



















 
















Transparent Table Relate With PM Module

Like to know all transparent Table relate with PM module. 
Try SE80 than fill the program related to PM transaction.
View Dictionary structures you'll get all table that related with PM
Trasaction code that used in PM eq. IW31, IW21, IW41
Try tcode DB15 
Fill the object that related to PM Module 
PM_EQUI              Equipment
PM_IBASE            IBase
PM_IFLOT            Functional locations
PM_IMRG             Measurement documents
PM_MPLAN         Maintenance plans
PM_NET               Object links, master data
PM_OBJLIST        Serial Number History
PM_ORDER          Service and maintenance orders
PM_PLAN             Routings
PM_QMEL            Maintenance Notifications
You can get all table that related to PM Object.

Important QM Tables

Area Table Description 
Master Data QMAT Inspection type - material parameters 
Master Data QMHU QM Link Between Inspection Lot and Handling Unit Item 
Master Data QMTB Inspection method master record 
Master Data QMTT Inspection Method Texts 
Master Data QPAC Inspection catalog codes for selected sets 
Master Data QPAM Inspection catalog selected sets 
Master Data QPMK Inspection characteristic master 
Master Data QPMT Master Inspection Characteristics Texts 
Master Data QPMZ Assignment table - insp. methods/master insp. characteristic 

Master Data TQ01D Authorization groups for QM master data 
Master Data TQ01E Text authorization groups for QM master data 
Master Data TQ21 Assignment of screens to screen groups 
Master Data TQ25 QM:screen sequence for master and inspection characteristics 
QM Master Data 
Catalog QPCD Inspection catalog codes 
Catalog QPCT Code texts 
Catalog QPGR Inspection catalog code groups 
Catalog QPGT Code group texts 
Catalog TQ07 Follow-Up Action for Usage Decision of Inspection Lot 
Catalog TQ07A QM: Function Modules for Follow-Up Action 
Catalog TQ07T Language-dependent texts for Table TQ07 
Catalog TQ15 Inspection catalog type index 
Catalog TQ15T Language-dependent texts for table TQ15 
Catalog TQ17 Defect classes 
Catalog TQ17T Language-dependent texts for table TQ17 
Catalog 
Sample Determination QDEB Allwd. Relationships: Sampling Procedures/Dynamic Mod. Rules 
Sample Determination QDEBT Allowed combinations of procedures/dynamic mod. rules: texts 
Sample Determination QDPA Sampling scheme-instructions 
Sample Determination QDPK Sampling scheme header 
Sample Determination QDPKT Sampling scheme: texts 
Sample Determination QDPP Sampling scheme item 
Sample Determination QDQL Quality level 
Sample Determination 

Table of the Order Production Operation

Which is the table of the order production operation details?  I need to get the activities for production order : 

Setup, Labor, Machine, Confirmed and to confirm.

I can see look at this in CO02 / Operation Overview (f5) / Operation Detalis / Qty-Activities
 
That is probably the hardest information to piece together, I used 5 tables with multiple joins to get User Fields for operations in a production order. Maybe you can use something simular.

AFKO - this is for your basic production header info - order number, basic finish date etc

S022 - this is for your operation header details - operation number, Work centre etc if you are only after the header details such as setup time and execution time, you can probably stop here without going to AFVC or AUFV (you definitely need AUFK if you want order status)

AUFK - this is for your order master data - Order released flag, order complete flag, technically complete date, you'll need this to filter out closed orders

SAP PP Master Data Tables

MASTER DATA
 
Engineering Change Management

AENR        Customer and priority
AEOI          Revision Numbers

Work Center

CRHD         Workcenter Header Data
CRCA         Workcenter Capacity Allocation
CRCO         Workcenter Cost Center Assignment
CRHH          Hierarchy Header
CRHS           Hierarchy Structure
CRTX          Workcenter Text
KAKO         Capacity Header
KAZY          Intervals of Capacity