How to Understand Tables for SAP ERP Supply Chain Areas

Executive Summary

  • This article covers the tables and fields that relate to the SAP ERP supply chain functionality.

Table Description

MDTB MRP

  • MAST Material BOM
  • STKO BOM Header
  • STPO BOM Positions (detail)
  • MAPL Assignment fo Task Lists to Materials
  • PLKO Routing Group Header
  • PLSO Routing Group Sequence
  • PLPO Routing Group Operations
  • AFKO Production Order Header
  • AFPO Production Order Position (details)
  • EINA Purchasing Info Record- General Data
  • EINE Purchasing Info Record- Purchasing Organization Data

Demand Management

  • PBED Independent Requirements Data
  • PBIM Independent Requirements by Material

Repetitive Manufacturing

  • SAFK RS Header Master Data
  • S025 LIS — Run Schedule Quantities
  • S026 LIS — Material Usage
  • S028 LIS — Reporting Point Statistics
  • CEZP Reporting Point Document Logs
  • CPZP Reporting Points – Periodic Totals

MRP Records

  • MDKP MRP Document Header Data
  • MDTB MRP Table Structure (no data)
  • PLSC Planning Scenario (Long-term Planning)
  • MDFD MRP Firming Dates
  • MDVM Planning File Entries
  • S094 LIS — Stock/Requirements Analysis

Reservations

  • RESB Reservations/Dependent Requirements

Planned Orders

  • PLAF Planned Orders

Discrete Production

  • AFKO Order Header
  • AFPO Order Item Detail
  • AFVC Order Operations Detail
  • AFFL Order Sequence Details
  • AFFH Order PRT Assignment
  • AFBP Order Batch Print Requests
  • AFRU Order Completion Confirmations
  • AFFW Confirmations — Goods Movements with Errors
  • AFRC Confirmations — Incorrect Cost Calculations
  • AFRD Confirmations — Defaults for Collective Confirmation
  • AFRH Confirmations — Header Info for Confirmation Pool
  • AFRV Confirmation Pool
  • AFWI Confirmations — Subsequently Posted Goods Movements

Classification

  • KLAH Class Detail
  • CABN Characteristic Detail
  • AUSP Characteristic Values
  • CAWN Characteristic Values
  • CAWNT Characteristic Value Texts
  • KSML Characteristic Allocation to Class
  • KSSK Material Allocation to Class

Master Data

Engineering Change Management

  • AENR Customer and priority
  • AEOI Revision Numbers

Work Center

  • CRHD Workcenter Header Data
  • CRCA Workcenter Capacity Allocation
  • CRCO Workcenter Cost Center Assignment
  • CRHH Hierarchy Header
  • CRHS Hierarchy Structure
  • CRTX Workcenter Text
  • KAKO Capacity Header
  • KAZY Intervals of Capacity

Routing

  • PLPO Routing Operation Details
  • PLKO Routing Header Details
  • MAPL Routing Link to Material
  • PLAB Relationships – Standard Network
  • PLAS Task List – Selection of Operations
  • PLMZ Component Allocation
  • PLPH CAPP Sub-operations
  • PLFH PRT Allocation
  • PLWP Maintenance Package Allocation
  • PLMK Inspection Characteristics

Bill of Material

  • STPO BOM Item Details
  • STPU BOM Sub Items (designators)
  • STKO BOM Header Details
  • MAST BOM Group to Material
  • STZU BOM History Records
  • STAS BOM Item Selection
  • STPF BOM Explosion Structure

Line Design

  • LDLH Line Hierarchy Header
  • LDLP Line Hierarchy Items
  • LDLT Line Hierarchy Takt Times
  • LDLBC Takts/No. Individual Capacities per Line
  • LDLBH Line Balance Header
  • LDLBP Line Balance Items
  • LDLBT Line Hierarchy Entry and Exit Takts

PRT’s

  • CRFH PRT Master Data
  • CRVDA Link of PRT to Document
  • CRVDB Link of Document to PRT
  • CRVEA Assignment of PRT data to Equipment
  • CRVEB Assignment of equipment to PRT data
  • CRVMA Link of PRT data to Material
  • CRVMB Link of Material to PRT data
  • CRVSA Link of PRT Internal number to PRT External number
  • CRVSB Link of PRT External number to PRT Internal number

MM

  • MAKT Material Descriptions
  • MARA General Material Data
  • MARC Plant Data for Material
  • MARD Storage Location Data for Material
  • MAST Material to BOM Link
  • MBEW Material Valuation
  • MKPF Header- Material Document
  • MSEG Document Segment- Material
  • MVER Material Consumption
  • MVKE Sales Data for materials
  • RKPF Document Header- Reservation
  • T023 Mat. groups
  • T024 Purchasing Groups
  • T156 Movement Type
  • T157H Help Texts for Movement Types
  • MOFF Lists what views have not been created

References