ErpDetails.Com

SAP Project System Tables and Details

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

  1. 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.

  1. PRTE – Project Texts

The PRTE table stores text data related to projects like project description, WBS element description, and network activity description.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. AUFM – Goods Movements for Order

The AUFM table stores goods movement data for production orders like order number, movement type, material number, and quantity.

  1. 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.

  1. 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

  1. What is SAP Project System?
  1. What are the key functionalities provided by SAP PS?
  1. What is the PRPS table used for in SAP PS?
Exit mobile version