SAP Production Planning TableDemand Management
PBED Independent Requirements Data
PBIM Independent Requirements by Material
Repetitive Manufacturing
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
MRP Records
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
Reservations
RESB Reservations/Dependent Requirements
Planned Orders
PLAF Planned Orders
Discrete Production
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
Classification
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
SAP PP Master Data Tables
MASTER DATA
Engineering Change Management
AENR Customer and priority
AEOI Revision Numbers
Work Center
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
Routing
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
Bill of Material
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
Line Design
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
PRT’s
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
Table of the Order Production Operation
Which is the table of the order production operation details? I need to get the activities for production order :
Setup, Labor, Machine, Confirmed and to confirm.
I can see look at this in CO02 / Operation Overview (f5) / Operation Detalis / Qty-Activities
That is probably the hardest information to piece together, I used 5 tables with multiple joins to get User Fields for operations in a production order. Maybe you can use something simular.
AFKO – this is for your basic production header info – order number, basic finish date etc
S022 – this is for your operation header details – operation number, Work centre etc if you are only after the header details such as setup time and execution time, you can probably stop here without going to AFVC or AUFV (you definitely need AUFK if you want order status)
AUFK – this is for your order master data – Order released flag, order complete flag, technically complete date, you’ll need this to filter out closed orders
AFVC – this is to link to the detail table – however I used the control key field in it so I would know whether it was a MILE stone or GPP1 for confirmation’s sake
AUFV – this is the user field table – you may want to replace this with whatever detail you are after
Delete all the automatic joins:
AFKO -> AUFK on:
AUFNR -> AUFNR
AFKO -> S022 on:
AUFNR -> AUFNR
PLNBEZ -> MATNR
AFKO -> AFVC on:
AUFPL -> AUFPL
S022 -> AFVC on:
WERKS -> WERKS
PLNFL -> PLNFL
VORNR -> VORNR
The join below is for user fields in operation detail, you will have to find your own relevant table, but I assume the two key fields will be the same??
AFVC -> AFVU on:
AUFPL -> AUFPL – Routing number of operations in the order APLZL -> APLZL – General Counter for order
Popularity: 6% [?]
