SAP PP SAP PP Common Tables
The SAP PP is an SAP Module of SAP Production Planning. The following are the topics of the most import Tables –
- Work Center
- Routings/Operations
- Bill of material
- Production Orders
- PRT Production Orders
- Planned Orders
- KANBAN
- Reservations
- Capacity Planning
- Planned Independent Requirements
Production Planning and Control (PP) Tables –
The production planning and control tables are –
| Table | Description |
|---|---|
| LPO_INTMODEL_WC | Integration model LPO: Integrated Work centers |
| ODATA_PP_POR_UV | Assignment of variant to user |
| LPO_INTMODEL_MAT | Integration model LPO: Integrated Materials |
SAP Basic Data Tables –
The basic data tables of SAP PP is –
| Table | Description |
|---|---|
| AFFH | PRT assignment data for the work order |
| CRCA | Work Center Capacity Allocation |
| KAKO | Capacity Header Segment |
| CRCO | Assignment of Work Center to Cost Center |
| CRFH | CIM production resource/tool master data |
| CRHD | Work Center Header |
| CRHH | Hierarchy Header Data |
| CRHS | Hierarchy Structure |
| CRID | CIM Resource - Entities |
| CRTX | Text for the Work Center or Production Resource/Tool |
SAP Sales and Operations Planning Tables –
The sales and operations planning tables is –
| Table | Description |
|---|---|
| ERKO | Event Header |
| LISR | Planning Object Index for Forecast |
| KZAZU | Key Figure Assignment for Aggregate Version Copy |
| SAUF | SOP Orders |
| VBTAB | Transfer Structure for Product Groups' Historical Values |
| S075 | DRP node information |
| PROH | Basic Values (for Forecast): Consumption or Actual Number |
| PGZU | Product Group/Member Quantity Conversions |
| PGPL | Sales & Operations Planning (SOP) |
| PGMI | Product Group/Member Allocation |
| PGAN | Proportional Factors per Planning Object Relation (SOP/LIS) |
| P44V | Planning Versions |
| PROGM | Forecast: Structure of Forecast Results |
| V_EVENT | Generierte Tabelle zu einem View |
| RMCP2 | I/O Table: Sales and Operations Planning |
| RMCP3 | I/O Table for Product Group Management |
| SCSCP_PERIOD_STR | Tupel of date from and date to with index and id |
Tables for Work Center –
The operations are performed at a work center. In R/3 System, the work centers are business objects may represent the real work centers such as –
- Machines, machine groups
- Production lines
- Assembly work centers
- Employees, groups of employees
The important tables name for Work Center is –
| Table | Description |
|---|---|
| CRHH | Work center hierarchy |
| CRHS | Hierarchy structure |
| CRHD | Work center header |
| 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 |
Tables for Routings/Operations –
The routing lists the operations required for manufacturing a product. It specifies the following for each operation –
- The work center at which the operation is performed.
- The default values used to calculate the dates, capacities, and production costs.
- If the costs of an operation are considered for costing.
- The material components required to process an operation.
In repetitive manufacturing, it allows to use rate routings along with normal routings and reference operation sets.
The important tables name for Routing/Operations list is –
| 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 |
| PLPR | Log collector for tasklists |
| PLMZ | Allocation of BOM :items to operations |
Tables for Bill of material (BOM) -
The list of materials needed in a process together with the quantities required.
The important tables name for Bill of material(BOM) is –
| Table | Description |
|---|---|
| STKO | Allocation of task lists to materials |
| STPO | Task list : selection of operations/activities |
| STAS | Task list : production resources/tools |
| STPN | Task list : sequences |
| STPU | Task list : header |
| STZU | Task list: main header |
| PLMZ | Phases / suboperations |
| MAST | Task list operation / activity |
| KDST | Log collector for tasklists |
Tables for Production Orders -
The production order defines the material to be processed, at which location, at what time and how much work is needed. It also defines the resources to be used and how the order costs are to be settled.
The important tables name for Production Orders is –
| Table | Description |
|---|---|
| AUFK | Production order headers |
| AFIH | Maintenance order header |
| AUFM | Goods movement for prod. order |
| AFKO | Order header data PP orders |
| AFPO | Order item |
| RESB | Reservation/dependent requirements |
| 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 |
| AFRU | Order completion confirmations |
| CAUFV | View Order Headers PP/CO |
| AFBP | CIM order: Batch print requests |
| AFFW | Goods Movements with Errors from Confirmations |
| AFRC | Incorrect cost calculations from confirmations |
| AFRD | Default values for collective confirmation |
| AFRH | Header information for confirmation pool |
| AFRV | Confirmation pool |
| AFVGD | Order: Dialog table for Table AFVG (order operation) |
| CAUFVD | Dialog Structure for Order Headers and Items |
| ORDCHG | Order values that are updated on the sales document |
Tables for PRT Production Orders –
In SAP PP, PRT stands for Production Resources and Tools (PRTs).
The important tables name for PRT Production Orders is –
| Table | Description |
|---|---|
| AFFH | PRT assignment data for the work order |
| CRVD_A | Link of PRT to Document |
| DRAW | Document Info Record |
| TDWA | Document Types |
| TDWD | Data Carrier/Network Nodes |
| TDWE | Data Carrier Type |
Tables for Planned Orders –
A planned order is sent to a plant and is a material requirement planning request for processing of a material at a defined time. It defines when the internal material movement should be made and quantity of material expected.
The important tables name for Planned Orders is –
| Table | Description |
|---|---|
| PLAF | Planned orders |
Tables for KANBAN –
The KANBAN method for controlling production and material flow is dependent on actual stock quantity of production.
The important tables name for KANBAN is –
| Table | Description |
|---|---|
| PKPS | Kanban identification control cycle |
| PKHD | Kanban control cycle (header data) |
| PKER | Error log for Kanban containers |
| B130 | Plant/JC prof. |
| B131 | Plant/JC prof./vendor |
| PKPR | Change Proposals from Kanban Calculation |
| PKSD | Control Cycle Item/Additional Data for Kanban With Delivery |
| PKCH | Batches and Quantities in KANBAN |
| PKEC | Error Log for Kanban Calculation |
| PKEK | Error Log for Kanban (Event-Driven KANBAN) |
| PVKT | Supply Area Short Text |
| PVBE | Production Supply Area |
| PKSL | Detailed Selection of the Dependent Requirements |
| PKEN | Dummy Table for Creating a Block.Object for Sec.Key Tab.PKHD |
| KARTE | Kanban Data Structure |
| BTCH | Batches for Availability Check |
| RMPKB | In/Output Fields for SAPMMPKB |
| PKPS5 | Download Struc. from SAP to BDE System for Kanban Container |
| V_PVBE | Generierte Tabelle zu einem View |
| PKST5 | Downl.Struc.Frm SAP to BDE Sys. for Kanban Container Status |
Tables for Reservations –
By using this component, one can make a request to the warehouse to keep materials ready for withdrawal at a later date and for a particular purpose. This simplifies and accelerates the goods receipt process.
A reservation for goods issue may requested by various departments for various account assignment objects like cost center, order, asset, etc.
The important tables name for Reservations is –
| Table | Description |
|---|---|
| RESB | Material reservations |
| RKPF | Header |
Tables for Capacity Planning –
Economic use of resources is primary objective in many areas of a company. For this the Capacity planning component is available in R/3 system.
The Capacity planning supports planning in all phases –
- long-term rough-cut planning
- medium-term planning
- short-term detailed planning
The important tables name for Capacity planning is –
| Table | Description |
|---|---|
| KBKO | Header record for capacity requirements |
| KBED | Capacity requirements records |
| KBEZ | Add. data for table KBED (for indiv. capacities/splits) |
| TCX00 | Scheduling: Planning Levels and Control Parameters |
| CYTSTR_TAB | Time stream keys |
| VERSIONEN | Production versions of a material |
| PCFILE | Components of a PC file name as structure |
| CYEXIT_1 | Interface table for USER_EXIT for operation change |
| RC65D | Fields of the detailed capacity list overview |
| CYUSER | CYPP: Customer-defined fields |
Tables for Planned Independent Requirements PIR –
The PIR is used to perform Demand Management functions. A PIR have one planned quantity and one date, or a number of planned independent requirements schedule lines i.e., one planned quantity split over time according to dates.
The important tables name for Planned Independent Requirements PIR is –
| Table | Description |
|---|---|
| PBED | Independent requirement data |
| PBHI | Independent requirement history |
| PBIV | Independent requirement index |
| PBIC | Independent requirement index for customer req. |
| PBID | Planned independent requirements index: MRP area |
| PBPT | Table of ind. requirements item data |
| PBIM | Independent Requirements for Material |
| T459U | Settings for Maintaining Planned Independent Requirements |
| PBET | Table for splitting data for ind. reequirements |
| RM60X | In/Output Fields for SAPMM60X |
| AM60X | Work fields for SAPMM60X |
| CHAR_VAL | Structure for characteristics and values + their descriptns |
Links and Relationship tables –
The important tables name for Links and Relationship tables is –
| Table | Description |
|---|---|
| AFFH_PRT | assignment data for the work order |
| CRVD_A | Link of PRT to Document |
| CRVD_B | Link of Document to PRT |
| CRVE_A | Assignment PRT data – equipment |
| CRVE_B | Assignment equipment – PRT data |
| CRVM_A | Link of PRT data to a material |
| CRVS_A | Relationship of PRT internal number to PRT external number |
| CRVS_B | Relationship of PRT external number to PRT internal number |
PRT Customizing Table –
The important tables name for PRT Customizing Table is –
| Table | Description |
|---|---|
| TCF02 | PRT categories |
| TCF03 | Texts for the production resources/tools category |
| TCF04 | Status of the PRT master |
| TCF05 | Language-dependent text table for PRT status |
| TCF06 | Field groups in the PRT master for reference |
| TCF07 | Language-dependent texts for field groups in PRT master |
| TCF08 | Assignment of PRT master fields to field groups |
| TCF10 | PRT control key |
| TCF11 | Language-dependent text table for PRT control keys |
| TCF12 | PRT group key |
| TCF13 | Language-dependent text table for PRT group keys |
For planning material requirements –
The important tables name for planning material requirements is –
| Table | Description |
|---|---|
| MDKP | Document header data |
| MDTB | Table structure |
| MDVM | Schedule file details |
| MDFD | MRP date details |
| S094 | Stock analysis |
| RSDB | Index of the RESB for the Direct Procurement Element |
| SNUM | BOM explosion number |
| MDIS | Period totals for availability check |
| MDME | MPS evaluation: matrix element key data |
| MDAS | Structure for Exception Statistics - MRP |
| MDVP | Corrected requirements |
| MDSS | View: reference BOM to BOM item for gross reqmts planning |
SAP Material Requirements Planning Tables –
The important tables name for Material requirements planning(MRP) is –
| Table | Description |
|---|---|
| BLPK | Document log header |
| BLPP | Document log item |
| DBPR | Material Index MRP Area for Forecast |
| DBVL | Planning File Entry, MRP Area, Long-Term Planning |
| DBVM | Planning File Entry, MRP Area |
| DVER | Material Consumption for MRP Area |
| KBVL | Individual Customer Plng File Entry, MRP Area Long-Term Plng |
| KBVM | Individual Customer Planning File Entry, MRP Area |
| KDPL | Index customer order -> planned order |
| KDVL | Individual Customer Planning File Entry, Long-Term Planning |
SAP Repetitive Manufacturing Tables –
The important tables name for Repetitive Manufacturing is –
| Table | Description |
|---|---|
| BLPR | Document Log Index and Planned Order (Backflush) |
| RMIO | Input Structure of Repetitive Manufacturing Confirmation |
| RMRP | HR Data of Repetitive Manufacturing Backflush |
| USPPT | Common User Table for Sequencing and REM Planning Table |
| AFWIS | Table of Reprocessing Records Already Reposted |
| UMD04 | Default Values for Planning Table in Repetitive Mfg |
| T460P | Procurement and Special Procurement Check |
| T450C | Table for Controlling the PF Status for Repet.Manufacturing |
| T450A | Control Table of PF Status for Run Schedule Modification |
| T437Z | Row Texts for Maintaining Run Schedule Headers |
| T437D | Control Parameter Plant for Repetitive Mfg |
| S025 | Runtime program quantities |
| S026 | Material usage |
| S028 | Reporting point statistics |
| SAFK | RS Header Master Data |
| RM61B | Input/Output Fields for Backflushing in Repetitive Mfg |
| RMUSER_TAV | Assigns User a Transaction Variant (for Example) |
| RESCO | Reprocessing Pointer Table |
| REM_RATE | Repetitive Manufacturing; Possible Production Rate |
| MDKS | Generierte Tabelle zu einem View |
| CRPES | Communication Bar for Setting Up MDPSX/MDEZX/MDSUX |
SAP Integration with Manufacturing Execution Systems Tables –
The important tables name for Integration with Manufacturing Execution Systems is –
| Table | Description |
|---|---|
| IST" | Control of Distribution of Production Orders to an MES |
| AFDIST | Distribution Information on Production Order |
| TCOSERNRCHECK | Serial Number Checks in MES Production Orders |
| COMES_CONF_PROG | Table for MES Confirmation Progress |
| E1AFSER | Serial numbers for finished product |
| E1QAMVL | Dep. Characteristic Specs in Inspection Processing (QAMV) |
| E1VCCHR | Characteristics for the Given Material Variant |
SAP Production Planning for Process Industries Tables –
The important tables name for Process industries Tables is –
| Table | Description |
|---|---|
| AFFT | Order - Process Instructions |
| AFFV | Order - Process Instruction Values |
| COCC | PP-PI: Attributes for Characteristics |
| COCH | Process Management: Control Recipe Header |
| COCQ | PPPI/QM Integration: Buffer Table for Reporting Results |
| COFT | Process Management: Process Instructions in Control Recipe |
| COFV | Process Management: Process Instr. Charact. in Ctrl Recipe |
| COMD | Process Management: Error Log for Message Destination |
| COME | Process Management: Message Characteristics |
| COMH | PP-PI: Header Data for Process Messages |
SAP Plant Data Collection Tables –
The important tables name for Plant Data Collection –
| Table | Description |
|---|---|
| PDERR | Error Table for Subsystem Confirmation |
| RUECK | Temp. storage for subsystem confirmations |
| T705R | Assignment of work center to subsystem link group |
| T705W | PDC Communication Parameters |
| E1BP_PP_TIMETICKET | BAPI Structure: PP Confirmation Time Ticket |
| E1BP_LINK_CONF_GOODSMOV | Link: Confirmation with Goods Movements |
SAP Flow Manufacturing Tables –
The important tables name for Flow Manufacturing –
| Table | Description |
|---|---|
| PROBLEM | Problem structure for Sequencing |
| LDLBC | Takts/no. of ind. capacities per line segment line balance |
| LDLBP | Line balance items |
| LDLH | Line hierarchy header |
| LDLP | Line hierarchy items |
| LDLT | Line hierarchy takt times |
| OPIT | Schedule record for planned order |
| LDLBH | Line balance/planned rate header record |
| LDLBT | Line hierarchy entry and exit takts |
| RSSV | Structure for collective availability check - planned orders |
| TSPP2 | Default Planning Profile (Sequencing) of Plant |
| TSPP1 | Processing profile for sequencing |
| TSPP0 | Planning profile for sequencing |
| TSPI0 | Initial profile for sequencing |
| TSPG5 | Default Visualization Profile (Sequencing) of Plant |
SAP Information System Tables –
The important tables name for Information System is –
| Table | Description |
|---|---|
| MCSFIS | R/2 SFIS Data: Old |
| MCAFKOV | Versions: Order Header Data - PP Orders |
| MCAFPOV | Versions: Order Item |
| MCAFVGV | Versions: Order Procedure |
| MCCOMPV | Versions: Material Components |
| MCKALKV | Versions: Cost Itemization |
| MCKALKW | Versions: Cost Itemization |
| MCPPCUST | Performance Customizing: PPIS |
| MCAFKO | Order header data PP orders |
| MCCOMP | Material Components |
| MCAFPO | Order Item |
| MCAFVG | Order Operation |
| MCFKENNZ | Additional key figures PP |
| MCSFIS | R/2 SFIS Data: Old |
| MCCOMPB | Material Components |
SAP Production Network Tables –
The important tables name for Production Network is –
| Table | Description |
|---|---|
| GHO_OTS | GHO Order Template Structures |
| GHO_STAT | Network Object Status |
| GHO_DISP_T | Disposition Texts |
| GHO_MEASDT | Measurement Details |
| GHO_MEAS_T | Measurement Text Table |
| GHO_MTR_OM | Operating Mode |
| GHO_PE_TYP | Oil and Gas Entity Types Customings |
| GHO_SIMU_H | Simulation Header |
| GHO_STAT_T | Text Table for Netobj Status |
| GHO_TB_TYP | Turbine Type of Driven Unit |
Engineering Change Management –
The tables name for Engineering change Management is –
| Table | Description |
|---|---|
| AENR | Customer and priority |
| AEOI | Revision Numbers |
Line Design –
The tables name for Line Design –
| Table | Description |
|---|---|
| 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 |
Material Management-Link in Production Planning and Manufacturing –
The tables name for Material Management-Link in Production Planning and Manufacturing is –
| Table | Description |
|---|---|
| MAKT | Material Descriptions |
| MAPL | Assignment of Task Lists to Materials |
| MARA | General Material Data |
| MARC | Plant Data for Material |
| MARD | Storage Location Data for Material |
| MAST | Material to BOM Link |
Enterprise Structure Part of the Customizing –
The tables name for Enterprise Structure Part of the Customizing is –
| Table | Description |
|---|---|
| T001K | Valuation area |
| T001L | Storage Locations |
| T001W | Plants/Branches |
| T499S | Location |
| TSPA | Organizational Unit: Sales Divisions |
Customizing –
The tables name for customizing is –
| Table | Description |
|---|---|
| T003O | Order Types |
| TCX00 | Scheduling: Planning Levels and Control Parameters |
Demand-Driven Replenishment Tables (PP-DD) –
The tables name for Demand-Driven Replenishment Tables is –
| Table | Description |
|---|---|
| PUOM | Generated Table for View |
| PPH_BF_PRFLDET_V | Generated Table for View |
| PPH_DD_STK | Time Dependent Actual Stock Levels |
| PPH_BF_PRFLASG_V | Generated Table for View |
How to View SAP PP Tables in SAP ERP System? –
How to View SAP PP Tables in SAP ERP System is described in the following steps –
Step-1: - Enter transaction code SE16 in the SAP command field and press Enter to continue.
Step-2: - Data Browser: Initial Screen window appears. Click on the copying icon.
Step-3: - Input Help Personal Value List pop-up window appears. Click on the Sap application option at below right corner of screen.
Step-4: - Component View: Database Tables window appears. Click on the folder to extend the tables components in it.
