Attention: open in a new window. PDFPrintE-mail

2008
05
Mar

Frequently accessed tables in PS

User Rating: / 3
PoorBest 
Frequently accessed tables in Project Systems List of tables frequently used in the PS module  By Swarna.S, Tata Consultancy Services  

AS : This document gives the list of frequently accessed tables in the

 

Project systems module with the table links .       
Table NameTable Description
PROJProject Definition
PRPSWBS Element Master Data
PRTEScheduling of WBS elements
PRHIWBS element Hierarchy pointer
AFVCOperation within an order Activities
AFVVScheduling of Activities
AFRUActivity Confirmations
EVPOCPercentage of completion
BPJATotal costs for Annual period CO Object(WBS related Budgets)
RPSCOWBS and Activities /Network related Actual costs
CAUFVView Orders (PP/CO)- Networks

        Table Links :  

1.) Links to PRPS Table  

Ÿ  PROJ : PROJ-PSPNR = PRPS-PSPHI

 

Ÿ  PRTE : PRTE- POSNR = PRPS-PSPNR ,

 

               PRPS-PSPHI = PRTE-PSPHI

 

Ÿ  PRHI : PRPS-PSPNR = PRHI-POSNR

 

Ÿ  AFVC : PRPS-PSPNR = AFVC-PROJN

 

Ÿ  BPJA : PRPS-OBJNR = BPJA-OBJNR

 Ÿ  RPSCO : PRPS-OBJNR = RPSCO-OBJNR 

 

 

 

2.) Links to AFVC Table   

Ÿ  CAUFV :AFVC-AUFPL = CAUFV-AUFPL

 

Ÿ  RPSCO :AFVC-OBJNR = RPSCO-OBJNR

 

Ÿ  EVPOC : AFVC-OBJNR = EVPOC-OBJNR

 

Ÿ  AFRU: AFVC-AUFPL = AFRU-AUFPL         

 

Ÿ  AFVV: AFVC-AUFPL = AFVV-AUFPL ,

 

              AFVC-APLZL = AFVV-APLZL                                                            
Last Updated (Wednesday, 05 March 2008 22:47)
Please register or login to add your comments to this article.
Banner