AFPO SAP table for – Order item

Here we would like to draw your attention to AFPO table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). AFPO is a SAP standard transparent table used for storing Order item related data in SAP. It comes under the package CO.

SAP AFPO table

Table AFPO technical data

TableAFPO
Data storingOrder item
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFPO Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AFPO table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • STRMP : Start date of the planned order
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ETRMP : Opening date of the planned order
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KDAUF : Sales order number
    Its data type is C (Character String) with field length 10
  • KDPOS : Sales order item
    Its data type is N (Character String with Digits Only) with field length 6
  • KDEIN : Delivery schedule for sales order
    Its data type is N (Character String with Digits Only) with field length 4
  • BESKZ : Procurement Type
    Its data type is C (Character String) with field length 1
  • PSAMG : Scrap quantity in item
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PSMNG : Order item quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WEMNG : Quantity of goods received for the order item
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • IAMNG : Expected surplus/deficit for goods receipt
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • AMEIN : Unit of measure for in-house production
    Its data type is C (Character String) with field length 3
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • MATNR : Material Number for Order
    Its data type is C (Character String) with field length 18
  • PAMNG : Fixed quantity of scrap from production
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PGMNG : Total planned order quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • TPAUF : Indicator: Partial conversion
    Its data type is C (Character String) with field length 1
  • LTRMI : Actual delivery/finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LTRMP : Delivery date from planned order
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its data type is N (Character String with Digits Only) with field length 12
  • POSNR : Order item number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • UEBTO : Overdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • UEBTK : Indicator: Unlimited Overdelivery Allowed
    Its data type is C (Character String) with field length 1
  • UNTTO : Underdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • INSMK : Stock Type
    Its data type is C (Character String) with field length 1
  • WEPOS : Goods Receipt Indicator
    Its data type is C (Character String) with field length 1
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • BWTTY : Valuation Category
    Its data type is C (Character String) with field length 1
  • PWERK : Planning plant for the order
    Its data type is C (Character String) with field length 4
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • UMREZ : Numerator for Conversion to Base Units of Measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • .INCLUDE : Order item (Include structure)
    Its include structure/component is is AFPO_INC
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • WEBAZ : Goods receipt processing time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • SAFNR : Run schedule header number
    Its data type is C (Character String) with field length 12
  • VERID : Production Version
    Its data type is C (Character String) with field length 4
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • TECHS : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12
  • DWERK : Plant
    Its data type is C (Character String) with field length 4
  • DAUTY : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • DAUAT : Order Type
    Its data type is C (Character String) with field length 4
  • PSOBS : Special procurement type
    Its data type is C (Character String) with field length 1
  • DGLTP : Basic finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DGLTS : Scheduled finish
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DFREI : Indicator: Order released/partially released (for MRP)
    Its data type is C (Character String) with field length 1
  • DNREL : Indicator: Order item not relevant for MRP
    Its data type is C (Character String) with field length 1
  • VERTO : MRP Distribution Key
    Its data type is C (Character String) with field length 4
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • WEWRT : Wareneingangswert in Hauswährung
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • ABLAD : Unloading Point
    Its data type is C (Character String) with field length 25
  • QUNUM : Number of quota arrangement
    Its data type is C (Character String) with field length 10
  • WEMPF : Goods recipient
    Its data type is C (Character String) with field length 12
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • WEAED : Indicator: Goods receipt indicator can be changed
    Its data type is C (Character String) with field length 1
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • KBNKZ : Kanban Indicator
    Its data type is C (Character String) with field length 1
  • ARSNR : Settlement reservation number
    Its data type is N (Character String with Digits Only) with field length 10
  • ARSPS : Item number of the settlement reservation
    Its data type is N (Character String with Digits Only) with field length 4
  • KRSNR : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • KRSPS : Item Number of Reservation / Dependent Requirements
    Its data type is N (Character String with Digits Only) with field length 4
  • QUPOS : Quota arrangement item
    Its data type is N (Character String with Digits Only) with field length 3
  • KCKEY : Cost collector key
    Its data type is C (Character String) with field length 23
  • RTP01 : Cost collector for repetitive manufacturing
    Its data type is C (Character String) with field length 1
  • RTP02 : Cost collector for KANBAN
    Its data type is C (Character String) with field length 1
  • RTP03 : Cost collector for valuated sales order stock
    Its data type is C (Character String) with field length 1
  • RTP04 : Cost collector for external PPC
    Its data type is C (Character String) with field length 1
  • KSVON : Cost collector valid from
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KSBIS : Cost collector valid to
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OBJNP : Object number
    Its data type is C (Character String) with field length 22
  • NDISR : Ind.: Material in order item is not relevant for MRP
    Its data type is C (Character String) with field length 1
  • VFMNG : Committed quantity for order acc. to ATP check components
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PROJN : Work breakdown structure element (WBS element)
    Its data type is N (Character String with Digits Only) with field length 8
  • GSBTR : Overall commitment date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KZAVC : Indicator for type of availability check
    Its data type is C (Character String) with field length 1
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • XLOEK : Deletion flag
    Its data type is C (Character String) with field length 1
  • SERNP : Serial Number Profile
    Its data type is C (Character String) with field length 4
  • ANZSN : Number of serial numbers
    Its data type is X (Byte string) with field length 4
  • OBJTYPE : Change indicator
    Its data type is C (Character String) with field length 1
  • CH_PROC : Process that has lead to the change of an object
    Its data type is C (Character String) with field length 1
  • FXPRU : Fixed-Price Co-Product
    Its data type is C (Character String) with field length 1
  • CUOBJ_ROOT : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • PLNUM : Planned order number
    Its data type is C (Character String) with field length 10
  • BERID : MRP Area
    Its data type is C (Character String) with field length 10
  • TECHS_COPY : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12