If you work with SAP Production Planning (PP), you know that it can be a complex module with a lot of moving parts. One of the keys to getting the most out of PP is understanding the various tables that store data related to production planning. In this article, we’ll take a deep dive into the most important SAP PP tables, what they do, and how they’re used.
Table of Contents
- Introduction
- Understanding SAP PP Tables
- SAP PP Tables Overview
- Understanding Master Data Tables
- Material Master Table (MARA)
- Bill of Material Table (STKO/STPO)
- Work Center Table (CRHD)
- Routing Table (MAPL/MARA)
- Understanding Transaction Data Tables
- Production Order Table (AFKO/AFPO)
- Planned Order Table (MDVL)
- Capacity Requirement Planning Table (ACFC/ACRP)
- Order Settlement Table (COEP)
- Understanding Information System Tables
- Order Information System Table (COOIS)
- Material Information System Table (MCIM)
- Other Important SAP PP Tables
- Sales and Operations Planning Table (MC88)
- Long-Term Planning Table (MSLD)
- Conclusion
- FAQs
1. Introduction
Production planning is an important part of any manufacturing process, and SAP PP is one of the most popular modules for managing this process. With so much data to keep track of, it’s important to have a good understanding of the tables that store this data. In this article, we’ll provide an overview of the most important SAP PP tables and their functions.
2. Understanding SAP PP Tables
2.1 SAP PP Tables Overview
SAP PP tables can be broadly categorized into three types: master data tables, transaction data tables, and information system tables. Master data tables contain information about various objects used in production planning, such as materials, bills of material, and work centers. Transaction data tables contain data related to production orders, planned orders, and capacity requirements. Information system tables are used to generate reports and analyze data.
2.2 Understanding Master Data Tables
2.2.1 Material Master Table (MARA)
The material master table (MARA) contains information about all materials that are used in the production process. This includes information such as the material type, base unit of measure, and description. This table is essential for managing inventory and determining which materials are used in which production processes.
2.2.2 Bill of Material Table (STKO/STPO)
The bill of material table (STKO/STPO) contains information about the components that make up a finished product. This table is used to manage the structure of a product and to determine the materials needed to produce it.
2.2.3 Work Center Table (CRHD)
The work center table (CRHD) contains information about the work centers used in the production process. This includes information such as the work center description, capacity, and scheduling data. This table is essential for scheduling production operations and ensuring that work centers are used effectively.
2.2.4 Routing Table (MAPL/MARA)
The routing table (MAPL/MARA) contains information about the steps required to produce a finished product. This includes information such as the sequence of operations, work center assignments, and operation times. This table is used to plan and schedule production operations.
2.3 Understanding Transaction Data Tables
2.3.1 Production Order Table (AFKO/AFPO)
The production order table (AFKO/AFPO) contains data related to production orders. This includes information such as the order number, material number, and planned quantity. This table is used to track the progress of production orders and to monitor production costs.
2.3.2 Planned Order Table (MDVL)
The planned order table (MDVL) contains data related to planned orders. This includes information such as the planned order number, material number, and planned quantity. This table is used to plan production activities and to ensure that materials are available when needed.
2.3.3 Capacity Requirement Planning Table (ACFC/ACRP)
The capacity requirement planning table (ACFC/ACRP) contains data related to capacity planning. This includes information such as the work center, capacity category, and planned capacity. This table is used to ensure that there is enough capacity available to meet production needs.
2.3.4 Order Settlement Table (COEP)
The order settlement table (COEP) contains data related to the settlement of production orders. This includes information such as the order number, cost center, and settlement amount. This table is used to track production costs and to allocate costs to the appropriate cost centers.
2.4 Understanding Information System Tables
2.4.1 Order Information System Table (COOIS)
The order information system table (COOIS) contains data related to production orders. This includes information such as the order number, material number, and planned quantity. This table is used to generate reports and to analyze production data.
2.4.2 Material Information System Table (MCIM)
The material information system table (MCIM) contains data related to materials used in production. This includes information such as the material number, plant, and movement type. This table is used to generate reports and to analyze material usage data.
2.5 Other Important SAP PP Tables
2.5.1 Sales and Operations Planning Table (MC88)
The sales and operations planning table (MC88) is used to plan and manage production activities based on sales forecasts. This table is used to ensure that there is enough production capacity to meet forecasted demand.
2.5.2 Long-Term Planning Table (MSLD)
The long-term planning table (MSLD) is used to plan and manage production activities over a longer time horizon. This table is used to ensure that production capacity is aligned with long-term business goals.
3. Conclusion
Understanding the key SAP PP tables is essential for effective production planning. By knowing which tables store which types of data, you can ensure that you have the information you need to make informed production decisions. Whether you’re working with master data, transaction data, or information system data, having a clear understanding of the relevant tables will help you manage production more effectively.