cancel
Showing results for 
Search instead for 
Did you mean: 

tables

Former Member
0 Kudos

could u plz tell me the different tables and fields used in PP...

Accepted Solutions (1)

Accepted Solutions (1)

former_member184655
Active Contributor
0 Kudos

Dear Mr.Shrinivas,

The following list has been taken from the net.

<b>Demand Management</b>

PBED Independent Requirements Data

PBIM Independent Requirements by Material

<b>Repetitive Manufacturing</b>

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

<b>MRP Records</b>

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

<b>

Reservations</b>

RESB Reservations/Dependent Requirements

<b>Planned Orders</b>

PLAF Planned Orders

<b>Discrete Production</b>

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

<b>

Classification</b>

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

<b>Engineering Change Management</b>

AENR Customer and priority

AEOI Revision Numbers

<b>Work Center</b>

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

<b>Routing</b>

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

<b>Bill of Material</b>

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

<b>Line Design</b>

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

<b>PRT's</b>

CRFH PRT Master Data

CRVD_A Link of PRT to Document

CRVD_B Link of Document to PRT

CRVE_A Assignment of PRT data to Equipment

CRVE_B Assignment of equipment to PRT data

CRVM_A Link of PRT data to Material

CRVM_B Link of Material to PRT data

CRVS_A Link of PRT Internal number to PRT External number

CRVS_B Link of PRT External number to PRT Internal number

<b>If useful reward points and close this thread.</b>

<b>As such there are no important fields,but for a field if u want to know the field name means,

For Eg,IF u want to know the field name for material in MM01,then click on material and press F1,then in the pop up window,click on Technical Information.

The System shows the table name,field name etc.</b>

Regards

Mangal

Message was edited by:

Mangal

Message was edited by:

Mangal

Answers (1)

Answers (1)

former_member184655
Active Contributor
0 Kudos

Hi Mr.Shrinivas,

These are some of the tables of PP module which are frequently used.

AFFW Goods Movements with Errors from Confirmations

AFKO Order header data PP orders

AFPO Order item

AFRU Order Confirmations

AUFK Order master data

BSEG Accounting Document Segment

COSB CO Object: Total Variances/Results Analyses

CRCA Work Center Capacity Allocation

CRCO Assignment of Work Center to Cost Center

CRHD Work Center Header

JCDS Change Documents for System/User Statuses (Table JEST)

JEST Individual Object Status

KAKO Capacity Header Segment

KAKT Capacity 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

MBEW Material Valuation

MKAL Production Versions of Material

MKPF Header: Material Document

MSEG Document Segment: Material

PAPL Applicant master data

PBED Independent Requirements Data

PLAF Planned order

PLKO Task list - header

PLKZ Task list: main header

PLPO Task list - operation/activity

RESB Reservation/dependent requirements

STKO BOM Header

STPO BOM item

DRAD Document-Object Link

DRAD_LAST_CHANGE DMS: Last Changes to Object Link

DRAD_PORDER Attributes for Links: Document to Production Order

DRAO Originals for documents

DRAOZ Additional Files for DMS Originals

DRAP Document Log File

DRAT Texts for Document Info Records

DRATEXT Industry texts

DRAW Document Info Record

DRAW_LAST_CHANGE DMS: Last Changes to Document

DRAZ Table for Additional Files for DMS Originals

PLAS Task list - selection of operations/activities

PLFH Task list - production resources/tools

PLFL Task list - sequences

PLFT Process Instructions

PLFV PI Characteristics/Sub-Operation Parameter Values

PLKO Task list - header

PLKZ Task list: main header

PLMK Inspection plan characteristics

PLMW MAPL-Dependent Charac. Specifications (Inspection Plan)

PLMZ Allocation of bill of material items to operations

PLPH CAPP: Sub-operations

PLPLAN_PARAM BOM-dependent planning parameter

PLPO Task list - operation/activity

PLPR Log collector for task lists

PLSR Scheduling results

PLZU Routing data for group

QALS Inspection lot record

QASH Quality control chart

QMIH Quality message - maintenance data excerpt

AEDT Engineering Change Management: Alternative Dates

AEEF ECM: effectivity

AEHI Change hierarchy

AENR Change Master

AENRCNV Data for Converting Change Numbers

<b>If useful reward points.</b>

Regards

Mangal