SAP Production Order Tables and Join Between PO Tables

SAP Production Order Tables: find the most important SAP Tables used for Production Orders: Status, Operation, Routines, Confirmations… with the join condition to retrieve the following Production Order data. 

SAP Production Order Tables

The main Production order tables name in sap are

  • AUFK Production order headers
  • AFKO Order header data PP orders
  • AFPO Order item

To retrieve Order Header from PP Production Order, join between

AUFK (Order header) and AFPO on field AUFNR

Sap production order status table

The main Production Order Status tables are:

  • JSTO Status profile
  • JEST Object status
  • TJ30 user status codes
  • TJ31 process control user status

In order to find SAP Production Order Status make a join between
AUFK (Order header) & JEST (active Status) on OBJNR

Link between JEST and TJ31 is set on STSMAS and ESTAT .

Sap production order operation table

The Production Order Operation can be found in

  • AFVC Order operations
  • AFVV Quantities/dates/values in the operation
  • AFVU User fields of the operation

Sap production order routing table

The Routing for Production Orders tables are:

  • AFFL Work order sequence
  • AFFH PRT assignment data for the work order (routing)

The link between AFKO (Order header) & AFVC (order routing) is set on field AUFPL

Sap production order confirmation table

SAP Order Confirmations are stored in

  • AFRU (confirmation)

To retrieve the confirmation of a SAP Production Order;
join between  AFVC (order routing) and AFRU (confirmation) on : AUFPL & APLZL & PLNFL & VORN

Check also   Statement SUBMIT is not allowed in this form

Sap production order Tcode and Transaction

Find the list of the most important SAP Tcodes for SAP Production Orders and Planned Order in SAP PP in the following Post SAP Production Orders Tcodes.

Production Order Tables in SAP PP

SAP PP Confirmations for SAP Production Orders Tables

The following list is the SAP Tables for Production Orders Confirmation in SAP PP

SAP Production Order Tables Description
AFFW        Goods movements with errors from confirmation
AFRC        Table of planned changes to conf.: Automatic
AFRD        Default values for collective confirmation
AFRH        Header information for confirmation pool
AFRP1       Table of planned changes to conf.: Automatic
AFRP2       Table of planned changes for confirmation: B
AFRP3       Table of planned changes for confirmation: C
AFRP4       Table of planned changes to confirmatn: Data
AFRU        Order completion confirmations
AFWI        Subsequently posted goods movements for conf
TAFWD       CORU: Messages that are not interpreted
TCORD       Table for field-dependent check routines
TCORU       Parameters for order confirmations
TCORV       Table with Routines for structureing variablz
TCORW       Confirmation: Window Control
TPARU       Control parallelized confirmation processes
TPRRU       Control table for process chain for confirmation
TPRRUT      Text table for process control of confirmation
TRUGS       User status caused by deviation

Source: Table name& field name for production order & operation confirmation

SAP PP Production Orders Tables

The following list is the SAP Production Order Tables in SAP PP

SAP Production Order Tables Description
AFBP        CIM order: Batch print requests
AFFL        Work order sequence
AFKO        Order header data PP orders
AFPO        Order item
AFVC        Operation within an order
AFVU        DB structure of the user fields of the opera
AFVV        DB structure of the quantities/dates/values
FAPW        Index of production-/issuing plant for produ
FTIND       Missing parts index
ORDCOM      Communication control Operation download
T024F       Production scheduler
T399X       Parameters dependent on order type
T441C       Profile – availability check
T441CT      Texts for Profile "Display Availability Chec
T490        Transactions PP – orders – order category
T496B       CIM order: Assigning document types to refer
T496D       CIM: Destination/lists/spool parameters per
T496F       CIM order: Form description of the list
T496K       CIM order: Entity table of possible table id
T496N       CIM order: List descriptions
T496P       Print PP documents: Determination of output
T496R       Print PP shop papers: Report control
T496T       Print PP shop papers: Transaction control
T496V       PP Print: Default Value for Printing Online
T496Z       CIM order: Table-controlled table access
TC32        Assigning subscreen to processing location
TC34         Allocating operation to object type for the
TC62         Sequence of detail screens when processing h
TCO01        Sequence/operations control in logicstics or
TCO03        CIM order: Texts for TCO01
TCO04        Table for controlling the screen sequence gr
TCO05        CUA status depending on panel & trans. type
TCO06        Exclusive functions for PP orders
TCO09        CIM order: Text IDs of objects in orders
TCO10        Valuation variant for order costing
TCO11        Control table for production orders – availa
TCO12        Control table production orders – stock dete
TCO36        PP orders: Control table for calling up pop-
TCO41        CIM order: Default values for generating ope
TCO43        PP-SFC order profile
TCO43T       Description of production scheduler profile
TCO60        Sequence keys for input facility and verification
TCO61        Sequence key for PP orders
TCO62        Defining screen sequences for input facility
TCO63        Sequence of detail screens when maintaining
TCODB        Database fields development class CO per order
TCOF         Profile for missing parts info system
TCOFF        Profile for Missing Parts Info System: Display
TCOFFT       Texts for Missing Parts Info System: Display
TCOFG        Profile for missing parts info system: Criteria
TCOFGT       Texts for Missing Parts Info System: Criteria
TCOFK        Texts for functions in milestones/trigger
TCOFS        Profile for Missing Parts Info System: Sort
TCOFST       Texts for Missing Parts Info System: Sort
TCOFT        Texts for Missing Parts Info System
TCOKO        Constants for PP orders
TCOKT        Account assignment categories for order
TCOP         Field selection profile
TCOPS        Field selection profile
TCOPT        Description of Profile for Field Selection
TRUG         Reason for variances in completion confirmat
TRUGT        Text describing the reason for a variance in
TXPR1        XPRA control – missing parts info system
TXPR1        XPRA control – missing parts info system
Check also   SAP BOM Main Tcodes

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ... Sab

Leave a Reply

Your email address will not be published. Required fields are marked *