Skip to Content
avatar image
Former Member

master database tables

Hi All,

Can you please let me know the master database tables for Project System..

Regards

Anuj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 21, 2007 at 06:05 AM

    Hi,

    Following are the some of the 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)

    Hope this helps.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 27, 2007 at 05:27 AM

    Hi Anuj,

    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

    Regards

    Tushar

    P.S. Reward points for useful answer.

    Add comment
    10|10000 characters needed characters exceeded