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.
Thursday, September 23, 2010
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
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.
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.
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
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
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
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
Labels:
Sap,
SAP Application Modules,
Sap Appliction,
Sap feauters,
SAP PP,
SAP PP Master Data Tables
Subscribe to:
Posts (Atom)