SAP Project System Tables (SAP PS)

SAP Project System Tables (SAP PS)

SAP S/4HANA Project System (PS) is a comprehensive solution for efficient project management across industries. It offers key functionalities such as project structuring, network planning, and resource management. With seamless integration into other SAP modules like Finance (FI) and Controlling (CO), it ensures smooth collaboration between project and financial data. Real-time analytics and reporting empower businesses to maintain better control over project costs, milestones, and schedules. The intuitive user interface, including SAP Fiori apps, enhances usability and promotes user adoption. SAP S/4HANA PS supports a wide range of projects, from construction and engineering to IT implementations. Its real-time data processing capabilities allow early detection of deviations, enabling proactive decision-making. The integration within the S/4HANA ecosystem ensures high transparency and optimized workflows for end-to-end project management.

SAP Project System Tables (SAP PS)

TablesDescriptionNotes
AFKOOrder header data PP ordersIn logical database
ODK PSJ.
AFRUOrder confirmationsIn logical database
ODC OFC OHC OPC POH.
AFVCOperation within an orderIn logical database BTM.
AFVUDB structure of the user fields of the operation
AFVVDB structure of the quantities resp. dates resp. values in the operation
AUFKOrder master dataIn logical database ODK PSJ.
Order category (AUTYP) = 20 for network
CAUFVView order headers PP/COIn logical database
BTM POH.
CRCAWork center capacity allocationIn logical database CRC.
CRCOAssignment of work center to cost center
CRHDWork center header
CRHHHierarchy header data
CRHSHierarchy structure
CRTXText for the work center or tool
FPLABilling planIn logical database ERM PSJ SD_SALES_DOCUMENT. Category (FPTYP)=2 for billing plan in PS, category (FPTYP)=A for invoice plan in PS
KAKOCapacity header segment
TC24Person responsible for the work center
TablesDescriptionNotes
MLSTMilestone
PRHIWork breakdown structure, edges and hierarchy pointerFunction GET_PROJECT_HIERARCHY.
PROJProject definitionIn logical database IMA PSJ.
PRPSWork breakdown structure element master dataIn logical database IMA MEPOLDB MMIMRKPFRESB.
PRTEProject Item Scheduling DataIn logical database PSJ.
SETHEADERSet header & directory
SETLEAFValues in sets
SETNODELower-level sets in sets
SMLGStandard milestone group
SMLTStandard milestone description
TCJ04Responsible person Transaction: OPS6
TCJ05Project applicantTransaction: OPS7
TablesDescriptionNotes
IHPAPlant maintenance partners
MSPRProject stock
MSPRHProject stock history
MSSQHTotal project stocks history
PROJSStandard project definition
PRPSSStandard WBS element master data
QBEWProject stock valuation
RESBReservation resp. dependent requirementsIn logical database BBM ERM MEPOLDB MMIMRKPFRESB ODC OFC OHC OPC POH RMM RNM.
RPSQTProject info database quantitiesIn logical database ODK PSJ.
VSPROJ_CNVersion project definition
VSPRPS_CNVersion WBS element master data
TablesDescriptionNotes
BPGETotals record for total value controlling object
BPJATotals record for annual total controlling object
COBRASettlement rule for order settlementIn logical database ODK PSJ.
COBRBDistribution Rules Settlement Rule Order SettlementIn logical database ODK PSJ.
COEPCO object line Items by periodS/4: Actual data (WRTTP = 04 for actual data and WRTTP = 11 for statistical actual) are stored in table ACDOCA. All other values still stored in table COEP.
COOICommitments management line itemsProgram RKANBU01 to create commitments for purchase requisitions and purchase orders.
COSBCO object total variances resp. results analyses
COSPCO object cost totals for external postings
COSSCO object cost totals for internal postings
RPSCOProject info database costs, revenues, finances etc.
TablesDescriptionNotes
TCJ04
Responsible person
Transaction: OPS6.
TCJ05Project applicantTransaction: OPS7.
TCJ41Default values for work breakdown structureTransaction: OPSA.