X

SAP PP Tables

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:

  1. Bill of Materials (BOM)
  2. Work Centers
  3. Routing
  4. 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.

Navigation Links

Go to the next lesson: SAP Production Version

Go to the previous lesson: SAP Material Staging

Go to the overview of the course: SAP PP Training

View Comments (1)