When loading data with LSMW, you can be stuck by incorrect date formating : Here is how to convert a field read in the file in DDMY (no matter what date separator the loading file provide) to SAP Date format YYYYMMDD : Add the following in the Mapping & Conversion Rules :
MATMAS9-ZKDAT+0(2) = MATMAS09-ZKDAT+6.
MATMAS9-ZKDAT+2(2) = MATMAS09-ZKDA+4.
MATMAS9-ZKDAT+4(4) = MATMAS09-ZKDAT.
TCode AL11 to Browse through directories.
TCode FILE to define logical path & logical file names.
Use report AFX_CODE_SCANNER in SE38, to look for a chain of character in programs. Can be filtered to Z* programs.
Ex: Z* programs, looking for *AUART= »* to identify filters by hardcoded Order types.
Basic Masterdata template : Fields by views/Tables
SPAD
From MSDP_ADMIN , right click on a planning area to Generate export Datasource
Masterdata
Transactional data
MDKP – Image du dernier MRP (utilisé pour MD07). Contient les couvertures 1, 2 et 3. A utiliser après avoir lancé un MRP.
Taken from : https://sap4tech.net/sap-production-order-tables/
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.
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
Source: Production Orders (PP-SFC)
The main Production order tables name in sap are
Check also SAP Production Orders Tcodes and SAP Planning Order Transactions
To retrieve Order Header from PP Production Order, join between
AUFK (Order header) and AFPO on field AUFNR
The main Production Order Status tables are:
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: call function ‘STATUS_READ’ exporting OBJNR = L_AUFNR ONLY_ACTIVE = ‘X’ tables STATUS = IT_JEST exceptions OBJECT_NOT_FOUND = 1 others = 2.
The Production Order Operation can be found in the following Tables
The Routing for Production Orders tables are:
The link between AFKO (Order header) & AFVC (order routing) is set on field AUFPL
SAP Order Confirmations are stored in
To retrieve the confirmation of a SAP Production Order;
join between AFVC (order routing) and AFRU (confirmation) on : AUFPL & APLZL & PLNFL & VORN
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.
The following list is the SAP Tables for Production Orders Confirmation in SAP PP
| Tables | SAP PRODUCTION ORDER TABLES |
|---|---|
| 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
The following list is the SAP Production Order Tables in SAP PP.
These SAP PO Tables stored all the PO Data:
| Tables | SAP PRODUCTION ORDER TABLES |
|---|---|
| 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 handles 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 |
The following List contains Related SAP CIM Tables in PP.
| Tables | SAP CIM ORDER TABLES |
|---|---|
| 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 |
Here another list of SAP PP Tables related to Production Order Process.
The main SAP Missing Parts Tables are:
| Tables | SAP MISSING PARTS TABLES |
|---|---|
| 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 |
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.
| Tables | SAP PRODUCTION ORDER TABLES |
|---|---|
| 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 | Profileavailability 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 |
|| – Concatener des chaines – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS
ltrim(table.champ,0) – Left trim du caractère en paramètre – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS
Like + % – Filtrer sur un début de chaine avec % comme caractère générique : MARC.DISPO like ‘R5%’
Report de stock agrégé par type de mouvements.
J3RFLVMOBVEDH
A customiser dans SPRO – Gestion des articles …