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
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| AUFNR | AUFNR | CHAR | 12 | AUFK | Order Number | ALPHA |
| POSNR | CO_POSNR | NUMC | 4 | Order Item Number | ||
| .INCLUDE | AFPO_INC | Order item (Include structure) | ||||
| PSOBS | SOBES | CHAR | 1 | Special procurement type | ||
| QUNUM | QUNUM | CHAR | 10 | Number of Quota Arrangement | ALPHA | |
| QUPOS | QUPOS | NUMC | 3 | Quota Arrangement Item | ||
| PROJN | PS_PSP_ELE | NUMC | 8 | PRPS | Work breakdown structure element (WBS element) | ABPSP |
| PLNUM | PLNUM | CHAR | 10 |
* | Planned order number | ALPHA |
| STRMP | CO_STRMP | DATS | 8 | Start date of the planned order | ||
| ETRMP | CO_ETRMP | DATS | 8 | Opening date of the planned order | ||
| KDAUF | CO_KDAUF | CHAR | 10 | VBUK | Sales order number | ALPHA |
| KDPOS | CO_KDPOS | NUMC | 6 | VBUP | Sales order item | |
| KDEIN | KDEIN | NUMC | 4 | Delivery Schedule for Sales Order | ||
| BESKZ | BESKZ | CHAR | 1 | Procurement Type | ||
| PSAMG | CO_PSAMG | QUAN | 13(3) | Scrap quantity in item | ||
| PSMNG | CO_PSMNG | QUAN | 13(3) | Order item quantity | ||
| WEMNG | CO_WEMNG | QUAN | 13(3) | Quantity of goods received for the order item | ||
| IAMNG | CO_IAMNG | QUAN | 13(3) | Expected surplus/deficit for goods receipt | ||
| AMEIN | CO_AUFME | UNIT | 3 | T006 | Unit of measure for in-house production | CUNIT |
| MEINS | LAGME | UNIT | 3 | T006 | Base Unit of Measure | CUNIT |
| MATNR | CO_MATNR | CHAR | 18 | MARA | Material Number for Order | MATN1 |
| PAMNG | AVMNG | QUAN | 13(3) | Fixed quantity of scrap from production | ||
| PGMNG | GSMNG | QUAN | 13(3) | Total planned order quantity | ||
| KNTTP | KNTTP | CHAR | 1 | T163K | Account Assignment Category | |
| TPAUF | TPAUF | CHAR | 1 | Indicator: Partial conversion | ||
| LTRMI | CO_LTRMI | DATS | 8 | Actual delivery/finish date | ||
| LTRMP | CO_LTRMP | DATS | 8 | Delivery date from planned order | ||
| KALNR | CK_KALNR | NUMC | 12 | CKHS | Cost Estimate Number for Cost Est. w/o Qty Structure | |
| UEBTO | UEBTO | DEC | 3(1) | Overdelivery Tolerance Limit | ||
| UEBTK | UEBTK | CHAR | 1 | Indicator: Unlimited Overdelivery Allowed | ||
| UNTTO | UNTTO | DEC | 3(1) | Underdelivery Tolerance Limit | ||
| INSMK | INSMK | CHAR | 1 | Stock Type | ||
| WEPOS | WEPOS | CHAR | 1 | Goods Receipt Indicator | ||
| BWTAR | BWTAR_D | CHAR | 10 | T149D | Valuation Type | |
| BWTTY | BWTTY_D | CHAR | 1 | T149C | Valuation Category | |
| PWERK | CO_PWERK | CHAR | 4 | T001W | Planning plant for the order | |
| LGORT | LGORT_D | CHAR | 4 | T001L | Storage Location | |
| UMREZ | UMREZ | DEC | 5 | Numerator for Conversion to Base Units of Measure | ||
| UMREN | UMREN | DEC | 5 | Denominator for conversion to base units of measure | ||
| WEBAZ | PLWEZ | DEC | 3 | Goods receipt processing time in days | ||
| ELIKZ | ELIKZ | CHAR | 1 | "Delivery Completed" Indicator | ||
| SAFNR | SA_AUFNR | CHAR | 12 |
* | Run schedule header number | ALPHA |
| VERID | VERID | CHAR | 4 |
* | Production Version | |
| SERNR | SERNR | CHAR | 8 | SNUM | BOM explosion number | |
| TECHS | TECHS | CHAR | 12 | Parameter Variant/Standard Variant | ||
| DWERK | WERKS_D | CHAR | 4 | T001W | Plant | |
| DAUTY | AUFTYP | NUMC | 2 | Order category | ||
| DAUAT | AUFART | CHAR | 4 | T003O | Order Type | |
| DGLTP | CO_GLTRP | DATS | 8 | Basic finish date | ||
| DGLTS | CO_GLTRS | DATS | 8 | Scheduled finish | ||
| DFREI | CO_FREI | CHAR | 1 | Indicator: Order released/partially released (for MRP) | ||
| DNREL | CO_DNREL | CHAR | 1 | Indicator: Order item not relevant for MRP | ||
| VERTO | SA_VERTL | CHAR | 4 | T437V | MRP Distribution Key | |
| SOBKZ | SOBKZ | CHAR | 1 | T148 | Special Stock Indicator | |
| KZVBR | KZVBR | CHAR | 1 | Consumption Posting | ||
| WEWRT | WEWRT | CURR | 13(2) | Value of goods received in local currency | ||
| WEUNB | WEUNB | CHAR | 1 | Goods Receipt, Non-Valuated | ||
| ABLAD | ABLAD | CHAR | 25 | Unloading Point | ||
| WEMPF | WEMPF | CHAR | 12 | Goods Recipient/Ship-To Party | ||
| CHARG | CHARG_D | CHAR | 10 | MCHA | Batch Number | |
| GSBER | GSBER | CHAR | 4 | TGSB | Business Area | |
| WEAED | CO_WEAE | CHAR | 1 | Indicator: Goods receipt indicator can be changed | ||
| CUOBJ | CUOBJ | NUMC | 18 | Configuration (internal object number) | ||
| KBNKZ | KBNKZ | CHAR | 1 | Kanban Indicator | ||
| ARSNR | ARSNR | NUMC | 10 | Settlement reservation number | ||
| ARSPS | ARSPS | NUMC | 4 | Item number of the settlement reservation | ||
| KRSNR | RSNUM | NUMC | 10 |
* | Number of Reservation/Dependent Requirement | |
| KRSPS | RSPOS | NUMC | 4 | Item Number of Reservation/Dependent Requirement | ||
| KCKEY | CCKEY | CHAR | 23 |
* | Cost collector key | |
| RTP01 | RTP01 | CHAR | 1 | Cost collector for repetitive manufacturing | ||
| RTP02 | RTP02 | CHAR | 1 | Cost collector for KANBAN | ||
| RTP03 | RTP03 | CHAR | 1 | Cost collector for valuated sales order stock | ||
| RTP04 | RTP04 | CHAR | 1 | Cost collector for external PPC | ||
| KSVON | KSVON | DATS | 8 | Cost collector valid from | ||
| KSBIS | KSBIS | DATS | 8 | Cost collector valid to | ||
| OBJNP | J_OBJNR | CHAR | 22 | ONR00 | Object number | |
| NDISR | CO_NDISR | CHAR | 1 | Ind.: Material in order item is not relevant for MRP | ||
| VFMNG | CO_VFMNG | QUAN | 13(3) | Committed quantity for order acc. to ATP check components | ||
| GSBTR | CO_GSBTR | DATS | 8 | Overall commitment date | ||
| KZAVC | KZAVC | CHAR | 1 | Indicator for type of availability check | ||
| KZBWS | KZBWS | CHAR | 1 | Valuation of Special Stock | ||
| XLOEK | AUFLOEKZ | CHAR | 1 | Deletion flag | ||
| SERNP | SERAIL | CHAR | 4 | T377P | Serial Number Profile | |
| ANZSN | ANZSN | INT4 | 10 | Number of serial numbers | ||
| OBJTYPE | OCM_OBJ_TYPE | CHAR | 1 | Change indicator | ||
| CH_PROC | OCM_CH_PROC | CHAR | 1 | Process that has lead to the change of an object | ||
| FXPRU | CK_FIXPRKU | CHAR | 1 | Fixed-Price Co-Product | ||
| CUOBJ_ROOT | CUOBJ | NUMC | 18 | Configuration (internal object number) | ||
| BERID | BERID | CHAR | 10 |
* | MRP Area | |
| TECHS_COPY | TECHS | CHAR | 12 | Parameter Variant/Standard Variant | ||
| .APPEND | ADPM_ROT_KUNNR | A&D Rotable Control (DI_ROT) Append for order position | ||||
| .APPEND | MILL_OC | Appends to Table AFPO for Order Combination / ARTKZ | ||||
| MILL_OC_AUFNR_U | MILL_OC_AUFNR_U | CHAR | 12 |
* | Number of original order | ALPHA |
| MILL_OC_RUMNG | MILL_OC_RUMNG | QUAN | 13(3) | Confirmed Quantity for Item | ||
| MILL_OC_SORT | MILL_OC_SORT | NUMC | 8 | 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
