SAP Production Order Tables and Join Between PO Tables (AUFK,AFVC, AFFL,AFRU…)

SAP Production Order Tables: find the most important SAP Tables used for Production Orders.

SAP PO Tables, in this article, will be classified by topics including: AFKO, AFVC, Status, Operation, Routines, Confirmations, missing Parts Tables,? SAP CIM Order Tables.

As bonus, you will find some useful join condition to retrieve data of Production Order data for Standard SAP Tables.??

SAP Production Order Tables

What’s Production Order in SAP ?

Production orders are a fundamental part of Production Planning and Control (PP) . PP is fully integrated in the Logistics (LO) component and has, among others, interfaces to

  • Sales and Distribution (SD)
  • Materials Management (MM)
  • Controlling (CO)

Source: Production Orders (PP-SFC)

Main 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

Check also?SAP Production Orders Tcodes and SAP Planning Order Transactions

Join Between AUFK and AFPO

To retrieve Order Header from PP Production Order, join between

AUFK (Order header) and?AFPO on field AUFNR

SAP PO Status tables

The main Production Order Status tables are:

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

How to find Status of SAP Production Order? ?

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?.

Alternatively, you can use the SAP Standard BAPI to read Production Order status:

SAP Production Order: Operation Table AFVC …

The Production Order Operation can be found in the following Tables

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

SAP Production Order:? SAP Routing Tables

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

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/3/4? ? ?? Table of planned changes for confirmation: A/B/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 structuring variable
TCORW ????? Confirmation: Window Control
TPARU ????? Control paralleled 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

List of SAP PP Production Order Data Tables

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

These SAP PO Tables stored all the PO Data:

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 production
ORDCOM????? Communication control Operation download

SAP Print PP Tables

SAP Print PP Tables hnadles the output of PP Documents.

Print PP Tables Description
T496P ????? Print PP documents: Determination of output
T496R ????? Print PP shop papers: Report control
T496T ????? SAP Print PP shop papers: Transaction control
T496V ????? PP Print: Default Value for Printing Online

SAP CIM Order Tables in PP

The following List contains Related SAP CIM Tables in PP.

SAP CIM Order Tables Description
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 ????? List descriptions for CIM order Table
T496Z CIM order: Table-controlled table access
TCO03 CIM order: Texts for TCO01
TCO41 ?Default values for generating operation in CIM order
TCO09 CIM order: Text IDs of objects in orders

SAP Missing Parts Tables

Here an other list of SAP PP Tables related to Production Order Process.

The main SAP Missing Parts Tables are:

SAP Missing Parts Tables Description
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
TXPR1? ???? ?XPRA control – missing parts info system
TXPR1? ????? XPRA control – missing parts info system
FTIND ????? Missing parts index

Text & Customizing Tables for Production Order

In the next part, you will find the list to related SAP PP Production Order? Tables starting with T*.

In fact, this Tables’s List is more for customizing and Text Tables.

SAP Production Order Tables Description
T024F ????? Production scheduler
T399X ????? Parameters dependent on order type
T441C ????? Profile – availability check
T441CT????? Texts for Profile "Display Availability Check"
T490? ????? Transactions PP – orders – order category
T024F ? ? ? Production scheduler
T024F ? ? ? Production scheduler
T399X ? ? ? Parameters dependent on order type
T441C? ? ? Profile ? availability check
T441CT ? ? Texts for Profile "Display Availability Check"
T490? ? ? ? Transactions PP ? orders ? order category
TC32? ????? Assigning subscreen to processing location
TC34?? ???? ?Allocating operation to object type for the
TC62?? ???? ?Sequence of detail screens when processing
TCO01? ???? ?Sequence/operations control in logistics
TCO04? ???? ?Table for controlling the screen sequence
TCO05? ???? ?CUA status depending on panel & trans. type
TCO06? ???? ?Exclusive functions for PP orders
TCO10? ???? ?Valuation variant for order costing
TCO11? ???? ?Control table for production orders – available
TCO12? ???? ?Control table production orders – stock
TCO36? ???? ?PP orders: Control table for calling up pop-
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
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 confirmation
TRUGT? ???? ?Text describing the reason for a variance in

SAP and SAP logo are registered trademarks of SAP AG. Sap4tech.net is not associated with SAP AG.
We have made every effort to make sure provide relevant search results, use the content on this site at your own risk.

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.