master database tables

[former_member196517]

Hi All,

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

Regards

Anuj

[Former Member]

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.

[Former Member]

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