SAP Production and Planning (SAP PP) module has multiple tables that can be accessed to view the data. Knowing SAP PP tables is useful when working in the PP module of SAP. These tables can be viewed using the transaction codes SE16 or SE16N. SAP PP tables can be segregated according to the master data and transactional data which are handled through the PP module.
SAP PP Tables for Master Data
Main master data objects that belong to SAP PP are:
- Bill of Materials (BOM)
- Work Centers
- Routing
- Production Versions
BOM Tables
| Table |
Description |
| STKO |
BOM HEADER |
| STPO |
BOM ITEM |
| STAS |
BOMS ITEM SELECTION |
| STPN |
BOM FOLLOW UP CONTROL |
| STPU |
BOM SUB ITEM |
| STZU |
PERMANENT BOM DATA |
| PLMZ |
ALLOCATION OF BOM - ITEMS TO OPERATIONS |
| MAST |
MATERIAL TO BOM LINK |
| KDST |
SALES ORDER TO BOM LINK – USED TO VIEW SALES ORDER BOM DATA |
Work Center Tables
| Table |
Description |
| CRHD |
WORK CENTER HEADER |
| CRHH |
WORK CENTER HIERARCHY |
| CRHS |
HIERARCHY STRUCTURE |
| CRTX |
TEXT FOR THE WORK CENTER OR PRODUCTION RESOURCE/TOOL |
| CRCO |
ASSIGNMENT OF WORK CENTER TO COST CENTER |
| KAKO |
CAPACITY HEADER SEGMENT |
| CRCA |
WORK CENTER CAPACITY ALLOCATION |
| TC24 |
PERSON RESPONSIBLE FOR THE WORK CENTER |
Routing Tables
| Table |
Description |
| MAPL |
ALLOCATION OF TASK LISTS TO MATERIALS |
| PLAS |
TASK LIST: SELECTION OF OPERATIONS/ACTIVITIES |
| PLFH |
TASK LIST: PRODUCTION RESOURCES/TOOLS |
| PLFL |
TASK LIST: SEQUENCES |
| PLKO |
TASK LIST: HEADER |
| PLKZ |
TASK LIST: MAIN HEADER |
| PLPH |
PHASES/SUBOPERATIONS |
| PLPO |
TASK LIST OPERATION/ACTIVITY (THIS CONTAINS SMV) |
| PLPR |
LOG COLLECTOR FOR TASK LISTS |
| PLMZ |
ALLOCATION OF BOM ITEMS TO OPERATIONS |
SAP PP Tables for Transactional Data
Other than the above master data tables, there are tables that belong to transactional data such as production orders, planned orders, and reservations. MRP tables also fall on the PP domain. Let us look at some of the important tables which are important to know when executing production and planning-related transactions.
Production Version Tables
| Table |
Description |
| MKAL |
PRODUCTION VERSIONS OF MATERIALS |
Production Order Tables
| Table |
Description |
| AUFK |
PRODUCTION ORDER HEADERS |
| AFIH |
MAINTENANCE ORDER HEADER |
| AUFM |
GOODS MOVEMENT FOR PRODUCTION ORDER |
| AFKO |
ORDER HEADER DATA PP ORDERS |
| AFPO |
ORDER ITEM |
| RESB |
ORDER COMPONENTS |
| AFVC |
ORDER OPERATIONS |
| AFVV |
QUANTITIES/DATES/VALUES IN THE OPERATION |
| AFVU |
USER FIELDS OF THE OPERATION |
| AFFL |
WORK ORDER SEQUENCE |
| AFFH |
PRT ASSIGNMENT DATA FOR THE WORK ORDER (ROUTING) |
| JSTO |
STATUS PROFILE |
| JEST |
OBJECT STATUS |
| TJ02T |
SYSTEM STATUS TEXT |
| AFRU |
ORDER COMPLETION CONFIRMATIONS |
Planned Order Tables
| Table |
Description |
| PLAF |
PLANNED ORDER DETAILS |
MRP Tables
| Table |
Description |
| MDKP |
MRP DOCUMENT HEADER DATA |
| MDTB |
MRP ABLE STRUCTURE |
| PLSC |
PLANNING SCENARIOS |
| MDFD |
MRP FIRMING DATES |
| MDVM |
PLANNING FILE ENTRIES |
| PBVPV |
MATERIAL INDEX FOR CONSUMPTION OF PLANNING |
| REUL |
MATERIAL STOCK TRANSFER RESERVATION INDEX |
| SAFK |
RUN SCHEDULE MASTER DATA |
Planned Independent Requirement Tables
| Table |
Description |
| PBIM |
INDEPENDENT REQUIREMENTS FOR MATERIAL |
| PBED |
INDEPENDENT REQUIREMENT DATA |
| PBHI |
INDEPENDENT REQUIREMENT HISTORY |
| PBIV |
INDEPENDENT REQUIREMENT INDEX |
| PBIC |
INDEPENDENT REQUIREMENT INDEX FOR CUSTOMER REQ. |
Capacity Planning Tables
| Table |
Description |
| KBKO |
HEADER RECORD FOR CAPACITY REQUIREMENTS |
| KBED |
CAPACITY REQUIREMENTS RECORDS |
| KBEZ |
ADDITIONAL DATA FOR TABLE KBED (FOR INDIVIDUAL CAPACITIES/SPLITS) |
Reservation Tables
| Table |
Description |
| RESB |
MATERIAL RESERVATIONS |
| RKPF |
HEADER |
KANBAN Tables
| Table |
Description |
| PKPS |
KANBAN IDENTIFICATION, CONTROL CYCLE |
| PKHD |
KANBAN CONTROL CYCLE (HEADER DATA) |
| PKER |
ERROR LOG FOR KANBAN CONTAINERS |
—
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully, it’s something we can address for you in the improvement of our free SAP PP tutorials.
Want to learn SAP PP different tables functions and details. Please provide the documents