Wednesday, April 17, 2013

PS Tables



Master Data:


PROJ Project definition
PRPS WBS elements
PRTE Scheduling data
PRHI WBS hierarchy
AUFK Orders/networks headers
AFKO Production Orders/networks
AFVC Network activities
AFVU Network activities
AFVV Network activities
RESB Network Components
MLST Milestones

Transaction data and totals:


RPSCO Project info database (cost, revenues)
RPSQT Project info database (quantities)
COSP Cost totals for external postings
COSS Cost totals for internal postings
COSB Total variances/result analysis
COEP Line items, actuals
COOI Line items, commitments
COEJ Line items, planned orders
BPGE Budget, overall cost
BPJA Budget, annual values
QBEW Project stock valuation
MSPR Project stock (incl. non-valuated)

AUFK Order master data
AFVU DB structure of the user fields of the operation
AFKO Order header data PP orders
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
JEST Individual Object Status
LFM1 Vendor master record purchasing organization data
EKKO Purchasing Document Header
EKPO Purchasing Document Item
CSKU Cost Element Texts
CSKT Cost Center Texts
ANLA Asset Master Record Segment
JCDS Change Documents for System/User Statuses (Table JEST)
COSP CO Object: Cost Totals for External Postings
COSS CO Object: Cost Totals for Internal Postings
COEP CO Object: Line Items (by Period)
BKPF Accounting Document Header
BSEG Accounting Document Segment
CSKS Cost Center Master Data
COBK CO Object: Document Header
CEPC Profit Center Master Data Table
PRPS WBS (Work Breakdown Structure) Element Master Data
PROJ Project definition
PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
TJ02 System status
BPJA Totals Record for Annual Total

COSP CO object: Cost Totals for External Reports
COSS CO Object: Cost Totals for Internal Reports
COSB CO Object : Total Variances / Results Analsys
COEP CO Object :Line Items : Actual Costs ( by period )
COOI Line Items : Commitments
COEP CO Object :Line Items : Actual Costs ( by period )
BPGE Budget. Overall Planning ( Totals record Total Value - Controlling object )
BPJA Budget, Cost Planning annual values ( Totals record for total Annual values Conrolling Object )
QBEW Project Stock Valuation
MSPR Project Stock ( Non-Valuated )
COBK CO Object: Document Header
COVP CO Object: Line Items ( by Period & Document Header )

IMAK Appropriation requests - general data
IMAV Appropriation request variant
IMPR Investment Program Positions
IMPU Texts for cap. inv. program positions
IMTP Investment programs
IMZO Assignment Table- CO Object - Capital Investment Prog.Pos.
PMCO Cost structure of maintenance order
PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data

Version Tables

VSKOPF
VSRPSCO_CN,
VSPRPS_CN,
EVOP_VS

VSAFVC_CN Version: Operation in order
VSAFVV_CN Version: Quantities/Dates/Values in order operation
VSAUFK_CN Version: Order master data
VSEBAN_CN Version: Purchase requisition
VSEBKN_CN Version: Purchase requisition account assignment
VSJEST_CN Version: Individual status per object
VSJSTO_CN Version: Information on status object
VSKBED_CN Version: Capacity requirement records
VSKBEZ_CN Version: Additional data for table KBED (ind. capacities)
VSKBKO_CN Version: Capacity requirements header for an order
VSKOPF Version: Header - general data for a version -
VSKPER_CN Version: Workforce Planning
VSMLST_CN Version: Milestone
VSNPTX_CN Version: PS texts (network)
VSPRHI_CN Version: WBS, edges (hierarchy pointer)
VSPROJ_CN Version: Project definition
VSPRPS_CN Version: WBS element (work breakdown struc. ele.) mast. data
VSPRTE_CN Version: Scheduling data for project item
VSPRTX_CN Version: PS texts (WBS)
VSPSTX_CN Version: PS texts (header)
VSRPSCO_CN Version: Cumulation table for project reporting
VSSTEU Version: Control table - one entry per version object –

Functinal module and execute in se37

TEM_DISPLAY_ANALYSIS
TEM_DISPLAY_VERSIONS



System and User status





TJ02 - a list of all System Status'. You can use transaction BS23 to see these, or SE16n via normal enquiry
JEST - current System/ User Status by object number (WBS and Network)
JCDS - history of System/ User Status by object number (WBS and Network)
   
Needless to say, you have to get the object number first by looking at PROJ, PRPS for Projects and AUFK, AFKO, AFVC, AFVU or AFVV for Networks.
   
Use SE16n to see the contents.

PS:  Status "code" contained in JEST for particular object number, after selecting object number of choice from JEST to obtain status text simply join JEST to TJ02T linking JEST-STAT to TJ02T-ISTAT and finally pick language TJ02T-SPRAS .
 

No comments:

Post a Comment