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