VSAFPO_CN SAP table for – Version: Order items in PP orders

Here we would like to draw your attention to VSAFPO_CN table in SAP. As we know it is being mainly used with the SAP PS-SIM (Simulation in PS) component which is coming under PS module (Project Systems). VSAFPO_CN is a SAP standard transparent table used for storing Version: Order items in PP orders related data in SAP. It comes under the package CNVS.

SAP VSAFPO_CN table

Table VSAFPO_CN technical data

TableVSAFPO_CN
Data storingVersion: Order items in PP orders
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VSAFPO_CN 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 VSAFPO_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PROJN : Work breakdown structure element (WBS element)
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNUM : Quota or Ceiling Number for Import Processing
    Its data type is C (Character String) with field length 10
  • 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 : Item number in Sales Order
    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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • 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
  • 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
    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
  • VSNMR
    Its a key field. Its data type is C (Character String) with field length 12
  • 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
  • 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
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • 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
  • 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
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) 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
  • 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
  • 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 : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • ARSPS : Order item number
    Its data type is N (Character String with Digits Only) with field length 4
  • PSOBS : Special procurement type
    Its data type is C (Character String) with field length 1
  • 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
  • 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
  • QUNUM : Number of quota arrangement
    Its data type is C (Character String) with field length 10
  • 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
  • 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 : ACL: Object Type
    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
  • QUPOS : Quota arrangement item
    Its data type is N (Character String with Digits Only) with field length 3
  • 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
  • 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