Skip to Content
author's profile photo Former Member
Former Member

tables related to PP

Hi

Could anyone provide the information on the tables used in PP/PI like MARA/MARC for material master.I would like to know the tables used to display details of Process order.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 05:13 PM

    Important tables are as below

    Planned Orders

    PLAF

    MSEG

    Discrete Production

    AFKO - Order header

    AFPO - Order item detail

    AFVC - Order operation detai

    AFFL - Order sequence

    AFFH - Order PRT assignment

    AFBP - Order batch print request

    AFRU - Order confirmation

    Master Data

    RESB - Reservations

    CRFH - PRT Master data

    STKO - BOM Header

    STPO - BOM Item details

    PLKO - Routing header

    PLPO - Routing operation

    PLMK - Inspection characteristics

    CRHD - Work center header

    KAKO - Capacity header

    CRCA - Work center capacity allocation

    Rgds

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2008 at 02:43 PM

    Hi,

    AUFK Production order headers

    AUFM Goods movement for prod. order

    AFKO Order header data PP orders

    AFPO Order item

    AFRU Order completion confirmations

    are the tab;es where Process order data are stored.

    Thanks & regards

    Mahesh

    Reward points if useful.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2008 at 07:50 PM

    Hi,

    Please refer,

    http://dannysaosap.blogspot.com/2007/11/pp-pi-tables.html

    Regards,

    Senthilkumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 01:22 AM

    Hi,

    pls refer below tables

    1.1 Work center

    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 workcenter

    1.2 Routings/operations

    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

    1.3 Bill of material

    STKO BOM - header

    STPO BOM - item

    STAS BOMs - Item Selection

    STPN BOMs - 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

    1.4 Production orders

    AUFK Production order headers

    AFIH Maintenance order header

    AUFM Goods movement for prod. order

    AFKO Order header data PP orders

    AFPO Order item

    RESB Order componenten

    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

    1.5 Planned orders

    PLAF Planned orders

    1.6 KANBAN

    PKPS Kanban identification, control cycle

    PKHD Kanban control cycle (header data)

    PKER Error log for Kanban containers

    1.7 Reservations

    RESB Material reservations

    RKPF header

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 06:25 AM

    Hi,

    Tables used for master data are,

    MARA Material master

    MAKT Material text

    MARC Material per plant / stock

    MVKE Material master, sales data

    MARD Storage location / stock

    MSKA Sales order stock

    MSPR Project stock

    MARM Units of measure

    MEAN International article number

    PGMI Planning material

    PROP Forecast parameters

    MAPR Link MARC <=> PROP

    MBEW Material valuation

    MVER Material consumption

    MLGN Material / Warehouse number

    MLGT Material / Storage type

    MPRP Forecast profiles

    MDTB MRP table

    MDKP Header data for MRP document

    MLAN Tax data material master

    MTQSS Material master view: QM

    And for the orders,

    AUFK Production order headers

    AFIH Maintenance order header

    AUFM Goods movement for prod. order

    AFKO Order header data PP orders

    AFPO Order item

    RESB Order componenten

    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

    Reward points if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.