If you are working with SAP Project System (PS) module, you might need to access or analyze data stored in various tables. In this article, we will explore some of the key tables and their details in SAP PS.
Overview of SAP Project System
Before diving into the tables, let’s quickly understand what SAP Project System is. SAP PS is a module that helps to plan, execute, and monitor projects in an organization. It provides functionalities like project planning, budgeting, scheduling, resource allocation, and progress tracking. SAP PS integrates with other modules like SAP Finance, Material Management (MM), and Sales and Distribution (SD) to provide a comprehensive project management solution.
Key Tables in SAP PS
- PRPS – Project Master Data
The PRPS table stores project-related data like project definition, project profile, WBS elements, network activities, and milestones. It also contains fields for budget and cost planning, scheduling, and resource allocation.
- PRTE – Project Texts
The PRTE table stores text data related to projects like project description, WBS element description, and network activity description.
- AFKO – Order Header Data
The AFKO table stores order header data like order number, order type, plant, and material number. It also contains fields for planned and actual start and finish dates, planned and actual quantities, and production orders.
- AFPO – Order Item Data
The AFPO table stores order item data like order number, item number, and material number. It also contains fields for planned and actual quantities, planned and actual costs, and reservations.
- JEST – Object Status
The JEST table stores the status of objects like projects, WBS elements, and network activities. It contains fields for status type, status code, and status text.
- JSTO – Status Object Information
The JSTO table stores information about the objects for which statuses are set. It contains fields for object type, object key, and status type.
- AUFK – Order Master Data
The AUFK table stores order master data like order number, order type, and order status. It also contains fields for planned and actual costs, and production orders.
- AUFM – Goods Movements for Order
The AUFM table stores goods movement data for production orders like order number, movement type, material number, and quantity.
- AFVC – Order Operation Data
The AFVC table stores order operation data like order number, operation number, work center, and activity type. It also contains fields for planned and actual start and finish dates, planned and actual quantities, and production orders.
- AFVV – Order Operations: Relationships
The AFVV table stores relationships between order operations like predecessor and successor operations. It contains fields for order number, operation number, and relationship type.
Conclusion
SAP Project System is a powerful module that helps organizations to manage projects efficiently. The tables discussed in this article are some of the key tables that store project-related data. By understanding these tables, you can easily access or analyze project data in SAP PS.
FAQs
- What is SAP Project System?
- SAP Project System is a module that helps to plan, execute, and monitor projects in an organization.
- What are the key functionalities provided by SAP PS?
- SAP PS provides functionalities like project planning, budgeting, scheduling, resource allocation, and progress tracking.
- What is the PRPS table used for in SAP PS?
- The PRPS table stores project-related data like project definition, project profile, WBS elements, network activities, and milestones.