SAP TABLES | Production Planning and Control | Production Orders(PP-SFC) SAP PP

AFPO SAP Order item Table and data







AFPO is a standard SAP Table which is used to store Order item data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP AFPO Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP AFPO Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
AUFNRAUFNRCHAR12 AUFKOrder NumberALPHA
POSNRCO_POSNRNUMC4 Order Item Number
.INCLUDEAFPO_INC Order item (Include structure)
PSOBSSOBESCHAR1 Special procurement type
QUNUMQUNUMCHAR10 Number of Quota ArrangementALPHA
QUPOSQUPOSNUMC3 Quota Arrangement Item
PROJNPS_PSP_ELENUMC8 PRPSWork breakdown structure element (WBS element)ABPSP
PLNUMPLNUMCHAR10
*
Planned order numberALPHA
STRMPCO_STRMPDATS8 Start date of the planned order
ETRMPCO_ETRMPDATS8 Opening date of the planned order
KDAUFCO_KDAUFCHAR10 VBUKSales order numberALPHA
KDPOSCO_KDPOSNUMC6 VBUPSales order item
KDEINKDEINNUMC4 Delivery Schedule for Sales Order
BESKZBESKZCHAR1 Procurement Type
PSAMGCO_PSAMGQUAN13(3) Scrap quantity in item
PSMNGCO_PSMNGQUAN13(3) Order item quantity
WEMNGCO_WEMNGQUAN13(3) Quantity of goods received for the order item
IAMNGCO_IAMNGQUAN13(3) Expected surplus/deficit for goods receipt
AMEINCO_AUFMEUNIT3 T006Unit of measure for in-house productionCUNIT
MEINSLAGMEUNIT3 T006Base Unit of MeasureCUNIT
MATNRCO_MATNRCHAR18 MARAMaterial Number for OrderMATN1
PAMNGAVMNGQUAN13(3) Fixed quantity of scrap from production
PGMNGGSMNGQUAN13(3) Total planned order quantity
KNTTPKNTTPCHAR1 T163KAccount Assignment Category
TPAUFTPAUFCHAR1 Indicator: Partial conversion
LTRMICO_LTRMIDATS8 Actual delivery/finish date
LTRMPCO_LTRMPDATS8 Delivery date from planned order
KALNRCK_KALNRNUMC12 CKHSCost Estimate Number for Cost Est. w/o Qty Structure
UEBTOUEBTODEC3(1) Overdelivery Tolerance Limit
UEBTKUEBTKCHAR1 Indicator: Unlimited Overdelivery Allowed
UNTTOUNTTODEC3(1) Underdelivery Tolerance Limit
INSMKINSMKCHAR1 Stock Type
WEPOSWEPOSCHAR1 Goods Receipt Indicator
BWTARBWTAR_DCHAR10 T149DValuation Type
BWTTYBWTTY_DCHAR1 T149CValuation Category
PWERKCO_PWERKCHAR4 T001WPlanning plant for the order
LGORTLGORT_DCHAR4 T001LStorage Location
UMREZUMREZDEC5 Numerator for Conversion to Base Units of Measure


UMRENUMRENDEC5 Denominator for conversion to base units of measure
WEBAZPLWEZDEC3 Goods receipt processing time in days
ELIKZELIKZCHAR1 "Delivery Completed" Indicator
SAFNRSA_AUFNRCHAR12
*
Run schedule header numberALPHA
VERIDVERIDCHAR4
*
Production Version
SERNRSERNRCHAR8 SNUMBOM explosion number
TECHSTECHSCHAR12 Parameter Variant/Standard Variant
DWERKWERKS_DCHAR4 T001WPlant
DAUTYAUFTYPNUMC2 Order category
DAUATAUFARTCHAR4 T003OOrder Type
DGLTPCO_GLTRPDATS8 Basic finish date
DGLTSCO_GLTRSDATS8 Scheduled finish
DFREICO_FREICHAR1 Indicator: Order released/partially released (for MRP)
DNRELCO_DNRELCHAR1 Indicator: Order item not relevant for MRP
VERTOSA_VERTLCHAR4 T437VMRP Distribution Key
SOBKZSOBKZCHAR1 T148Special Stock Indicator
KZVBRKZVBRCHAR1 Consumption Posting
WEWRTWEWRTCURR13(2) Value of goods received in local currency
WEUNBWEUNBCHAR1 Goods Receipt, Non-Valuated
ABLADABLADCHAR25 Unloading Point
WEMPFWEMPFCHAR12 Goods Recipient/Ship-To Party
CHARGCHARG_DCHAR10 MCHABatch Number
GSBERGSBERCHAR4 TGSBBusiness Area
WEAEDCO_WEAECHAR1 Indicator: Goods receipt indicator can be changed
CUOBJCUOBJNUMC18 Configuration (internal object number)
KBNKZKBNKZCHAR1 Kanban Indicator
ARSNRARSNRNUMC10 Settlement reservation number
ARSPSARSPSNUMC4 Item number of the settlement reservation
KRSNRRSNUMNUMC10
*
Number of Reservation/Dependent Requirement
KRSPSRSPOSNUMC4 Item Number of Reservation/Dependent Requirement
KCKEYCCKEYCHAR23
*
Cost collector key
RTP01RTP01CHAR1 Cost collector for repetitive manufacturing
RTP02RTP02CHAR1 Cost collector for KANBAN
RTP03RTP03CHAR1 Cost collector for valuated sales order stock
RTP04RTP04CHAR1 Cost collector for external PPC
KSVONKSVONDATS8 Cost collector valid from
KSBISKSBISDATS8 Cost collector valid to
OBJNPJ_OBJNRCHAR22 ONR00Object number
NDISRCO_NDISRCHAR1 Ind.: Material in order item is not relevant for MRP


VFMNGCO_VFMNGQUAN13(3) Committed quantity for order acc. to ATP check components
GSBTRCO_GSBTRDATS8 Overall commitment date
KZAVCKZAVCCHAR1 Indicator for type of availability check
KZBWSKZBWSCHAR1 Valuation of Special Stock
XLOEKAUFLOEKZCHAR1 Deletion flag
SERNPSERAILCHAR4 T377PSerial Number Profile
ANZSNANZSNINT410 Number of serial numbers
OBJTYPEOCM_OBJ_TYPECHAR1 Change indicator
CH_PROCOCM_CH_PROCCHAR1 Process that has lead to the change of an object
FXPRUCK_FIXPRKUCHAR1 Fixed-Price Co-Product
CUOBJ_ROOTCUOBJNUMC18 Configuration (internal object number)
BERIDBERIDCHAR10
*
MRP Area
TECHS_COPYTECHSCHAR12 Parameter Variant/Standard Variant
.APPENDADPM_ROT_KUNNR A&D Rotable Control (DI_ROT) Append for order position
KUNNR2KUNNRCHAR10
*
Customer NumberALPHA
.APPENDMILL_OC Appends to Table AFPO for Order Combination / ARTKZ
MILL_OC_AUFNR_UMILL_OC_AUFNR_UCHAR12
*
Number of original orderALPHA
MILL_OC_RUMNGMILL_OC_RUMNGQUAN13(3) Confirmed Quantity for Item
MILL_OC_SORTMILL_OC_SORTNUMC8 Item Sequence



Key field
Non-key field

AFPO relationships with other tables


CAUFVD-Dialog structure for order headers and items
     AFPO-Order Item
     AFFLD-Order: Dialog table for operation sequence (AFFL)
          MOPER-Operation for production order - logical DB
               KBED-Capacity requirements records
               AFRU-Order Confirmations
               AFFHD-Structure of the PRTs in orders
               RESB-Reservation/dependent requirements
               SOPER-Sub-operation for production order - log. DB
                    SKBED-Capacity requirements for sub-operation - log. DB
                    SAFRU-Sib-operation confirmations - log. DB


AUFK-Order master data
     AFKO-Header Data in PP Orders
          AFPO-Order Item
     CDHDR-Change document header
          CDPOS-Change document items
     THEAD-SAPscript: Text Header
          TLINE-SAPscript: Text Lines
     JSTO-Status object information
          JCDO-Change Documents for Status Object (Table JSTO)
          JEST-Individual Status per Object
               JCDS-Change docs. for system/user status (table JEST)
     COBRA-Settlement Rule for Order Settlement
          COBRB-Distribution rules for sett. rule for order sett.
     BPHI1-Cross-hierarchy data Control
     BPTR1-Object data Control
          BPGE1-Totals record total value Control
               BPVG1-Table generated for view BPVG1
               BKHS1-Header: Unit Costing (Control + Totals)
                    HEAD10-SAPscript: Text Header
                         LINE10-SAPscript: Text Lines
                    BKHT1-Texts for CKHS
                    BKIS1-Individual calculation/verification item gen.
                         BKIT1-Texts for CKIS
                    BKIP1-Periodic Values for Unit Costing Item
          BPJA1-Totals record for total year value Control
               BPVJ1-Table Generated for View BPVJ1
               BKHS2-Header: Unit Costing (Control + Totals)
                    HEAD20-SAPscript: Text Header
                         LINE20-SAPscript: Text Lines
                    BKHT2-Texts for CKHS
                    BKIS2-Individual calculation/verification item gen.
                         BKIT2-Texts for CKIS
                    BKIP2-Periodic Values for Unit Costing Item
          BPIG1-Budget Object Index (Overall Budget)
          BPIJ1-Budget Object Index (Annual Budget)
     COKA1-CO Object: Control Data for Cost Elements
     COKP1-CO Object: Control Data for Primary Planning
          HEAD11-SAPscript: Text Header
               LINE11-SAPscript: Text Lines
          CKHS1-Header: Unit Costing (Control + Totals)
               CKHT1-Texts for CKHS
               HEAD12-SAPscript: Text Header
                    LINE12-SAPscript: Text Lines
               CKIS1-Individual calculation/verification item gen.
                    CKIT1-Texts for CKIS
               CKIP1-Periodic Values for Unit Costing Item
     COSP1-CO Object: Cost Totals for External Postings
          COVP11-CO object: Line items with doc. header (by period)
               COEPD11-CO object: Unvaluated ln. item settlement w/status
                    COEPBR11-CO Object: Valuated Line Item Settlement
               EBII11-CO/SD doc. flow: Billed parts of resource item
          COVJ11-CO object: Line items with doc header (by year)
          COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
     COSPD1-CO object: External cost totals - calculated
     COKS1-CO Object: Control Data for Secondary Planning
          HEAD13-SAPscript: Text Header
               LINE13-SAPscript: Text Lines
     COSS1-CO Object: Cost Totals for Internal Postings
          COVP12-CO object: Line items with doc. header (by period)
               COEPD12-CO object: Unvaluated ln. item settlement w/status
                    COEPBR12-CO Object: Valuated Line Item Settlement
               EBII12-CO/SD doc. flow: Billed parts of resource item
          COVJ12-CO object: Line items with doc header (by year)
     COSSD1-CO object: Internal cost totals - calculated
     COKR1-CO Object: Control Data for Statistical Key Figs
          HEAD14-SAPscript: Text Header
               LINE14-SAPscript: Text Lines
     COSR1-CO Object: Statistical Key Figure Totals
          COVPR1-CO object: Stat. key figure line items by period
               EBII1-CO/SD doc. flow: Billed parts of resource item
          COVJR1-CO object: Line items stat. key figures (by year)
     COSL1-CO Object: Activity Type Totals
          COVPL1-CO object: Activity type line items by period
          COVJL1-CO object: Line items for acty types (by year)
     COSB1-CO Object: Total Variances/Results Analyses
          COVPB1-CO object: Variance/accrual line items by period
     COSBD1-CO object: Sums of variance/accrual - calculated
     ANIA1-Depr. simulation for invest. projects
          ANIB1-Invest. projects: Depr. simulation analysis report
     ANLI1-Link table for capital investment measure -> AuC
     FMSU1-FM totals records for financial data
          COVFP1-CO object: Financial data line items with doc. hdr
     RPSCO1-Summarization Table for Project Reporting
     RPSQT-Project info database: quantities
     TPI031-CO Objects: Date of Last Interest Run


CAUFV-Generated Table for View CAUFV
     AFFL-Work order sequence
          MOPER-Operation for production order - logical DB
               KBED-Capacity requirements records
               AFRU-Order Confirmations
               AFFH-PRT assignment data for the work order
               RESB-Reservation/dependent requirements
               SOPER-Sub-operation for production order - log. DB
                    SKBED-Capacity requirements for sub-operation - log. DB
                    SAFRU-Sib-operation confirmations - log. DB
     AFPO-Order Item


ARKOPF-Archiving run header data
     VSKOPF-Version: Header - general data for a
          RSTHIE-BRST structure of the hierarchy table
               PSDYRH-LDB PSJ: Dummy structure under RSTHIE
          PROJ-Project definition
               PSDYPD-LDB PSJ: Dummy structure under PROJ
          VBAK-Sales Document: Header Data
               VBUK-Sales Doc.: Header Status and Administrative Data
               VBKD-Sales Document: Business Data
               VBAP-Sales Document: Item Data
                    VBUP-Sales Document: Item Status
                    VBKDPO-Sales document: Business item data (POSNR > 0)
                         FPLA-Billing plan
                              FPLT-Billing Plan: Dates
                    PSDYVB-LDB PSJ: Dummy structure under VBAP
               PSDYVK-LDB PSJ: Dummy structure under VBAK
          PRPS_R-Project Hierarchy Reporting Structure
               PRTE-Scheduling Data for Project Item
               PSMLST-Milestone I/O Table
               PSTX-PS Texts (Header)
               PLAF-Planned order
               PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements
                    KBED04-Capacity Requirement Recs for Planned Orders (LDB)
                    RESB04-Reservation/dependent reqs for plan order (LDB)
               PSDYPR-LDB PSJ: Dummy structure under PRPS_R
          AUFK-Order master data
               AFKO-Order Header Data PP Orders
                    AFPO-Order Item
                    AFFL-Work order sequence
                         ACT01-Activity for LDB 01
                              AFAB01-Network Relationship (for LDB) - 01
                              MLSTD-Milestone I/O Table
                              PSTX1-PS Texts (Header) for Activity (1)
                              AFFH01-Order PRT Data (for LDB) - 01
                              KBED01-Capacity Requirement Records (for LDB) - 01
                                   KBEZ-Additional data for table KBED (for ind.req/split)
                                        KPER-Additional data for KBEZ (person split in days)
                                   AFRU02-Order Confirmations (for LDB) -02
                              RESB01-Reservation/Dependent Requirement for LDB-01
                                   PSDYOK-LDB PSJ: Dummy structure under RESB01
                              AFRU01-Order Confirmations (for LDB) - 01
                              PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity
                              PSDYNV-LDB PSJ: Dummy structure under ACT01
               AFIH-Maintenance order header
               PSDYNP-LDB PSJ: Dummy structure under AUFK
          IMTP-Investment programs
               IMPR-Investment Program Positions
                    PSDYIP-LDB PSJ: Dummy structure under IMPR
               PSDYPG-LDB PSJ: Dummy structure under IMTP
          PEGOB-Peg (master data of the CO object)
               PEGQTY-Assigned pegging object quantities
               PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB
          ELM_PS-Additional data for hierarchy nodes (LDB PSJ)
               JSTO-Status object information
                    PSTAT-Condensed status display
                    JCDO-Change Documents for Status Object (Table JSTO)
                    JEST-Individual Status per Object
                         JCDS-Change docs. for system/user status (table JEST)
               ONR00-General Object Number
                    RPSCO1-Summarization Table for Project Reporting
                    RPSQT-Summarization table for project reporting (quants)
                    EVOP (EV_PARAM)-Object parameters for earned value analysis
                    EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion
                    EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value
                    COBRA-Settlement Rule for Order Settlement
                         COBRB-Distribution rules for sett. rule for order sett.
                    BPHI1-Cross-hierarchy data Control
                    BPTR1-Object Data Control
                         BPGE1-Totals record total value Control
                              BPVG1-Table Generated for View BPVG1
                              BKHS1-Header - Unit Costing (Control + Totals)
                                   HEAD10-SAPscript: Text Header
                                        LINE10-SAPscript: Text Lines
                                   BKHT1-Texts for CKHS
                                   BKIS1-Individual calculation/verification item gen.
                                        BKIT1-Texts for CKIS
                                   BKIP1-Periodic Values for Unit Costing Item
                         BPJA1-Totals record for total year value Control
                              BPVJ1-Table Generated for View BPVJ1
                              BKHS2-Header - Unit Costing (Control + Totals)
                                   HEAD20-SAPscript: Text Header
                                        LINE20-SAPscript: Text Lines
                                   BKHT2-Texts for CKHS
                                   BKIS2-Individual calculation/verification item gen.
                                        BKIT2-Texts for CKIS
                                   BKIP2-Periodic Values for Unit Costing Item
                         BPPE1-Totals Record for Period Values Control
                              BPVP1-Table Generated for View BPVP1
                         BPIG1-Budget Object Index (Overall Budget)
                         BPIJ1-Budget Object Index (Annual Budget)
                    COKA1-CO Object: Cost Element Control Data
                    COKP1-CO Object: Primary Planning Control Data
                         HEAD11-SAPscript: Text Header
                              LINE11-SAPscript: Text Lines
                         CKHS1-Header - Unit Costing (Control + Totals)
                              CKHT1-Texts for CKHS
                              HEAD12-SAPscript: Text Header
                                   LINE12-SAPscript: Text Lines
                              CKIS1-Individual calculation/verification item gen.
                                   CKIT1-Texts for CKIS
                              CKIP1-Periodic Values for Unit Costing Item
                    COSP1-CO Object: Cost Totals for External Postings
                         COVP11-CO object: Line items with doc. header (by period)
                              COEPD11-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR11-CO Object: Valuated Line Item Settlement
                         COVJ11-CO object: Line items with doc header (by year)
                         COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
                    COSPD1-CO object: External cost totals - calculated
                    COSPP-Transfer of Order in the COSP Table to the Project
                    COKS1-CO Object: Control Data for Secondary Planning
                         HEAD13-SAPscript: Text Header
                              LINE13-SAPscript: Text Lines
                    COSS1-CO Object: Cost Totals for Internal Postings
                         COVP12-CO object: Line items with doc. header (by period)
                              COEPD12-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR12-CO Object: Valuated Line Item Settlement
                         COVJ12-CO object: Line items with doc header (by year)
                         COVO12-CO object: Fxd price agreement commitment ln items
                    COSSD1-CO object: Internal cost totals - calculated
                    COSSP-Transfer of the Order COSS Table to the Project
                    COKR1-CO Object: Control Data for Statistical Key Figs
                         HEAD14-SAPscript: Text Header
                              LINE14-SAPscript: Text Lines
                    COSR1-CO Object: Statistical Key Figure Totals
                         COVPR1-CO object: Stat. key figure line items by period
                         COVJR1-CO object: Line items stat. key figures (by year)
                    COSL1-CO Object: Activity Type Totals
                         COVPL1-CO object: Activity type line items by period
                         COVJL1-CO object: Line items for acty types (by year)
                    COSLD-CO object: Activity type sums - calculated
                    COSB1-CO Object: Total Variances/Results Analyses
                         COVPB1-CO object: Variance/accrual line items by period
                    COSBD1-CO object: Sums of variance/accrual - calculated
                    ANIA1-Depr. simulation for invest. projects
                         ANIB1-Invest. projects: Depr. simulation analysis report
                    ANLI1-Link table for capital investment measure -> AuC
                    FMSU1-FM totals records for financial data
                         COVFP1-CO object: Financial data line items with doc. hdr
                    TPI031-CO Objects: Date of Last Interest Run
               EKKO-Purchasing Document Header
                    EKPO-Purchasing Document Item
                         EKET-Scheduling Agreement Schedule Lines
                         EKKN-Account Assignment in Purchasing Document
                         EKBE-Purchasing Document History
               EBAN-Purchase requisition
                    EBKN-Purchase Requisition Account Assignment
               FPLA (FPLAPS)-Billing plan for PSP network plan
                    FPLT (FPLTPS)-Billing plan for PSP/network (dates)
               LIKP-SD Document: Delivery Header Data
                    LIPS-SD document: Delivery: Item data
               PSMERK-Characteristics for summarization wo.classificatn
               DRAD-Document-object link