VSPLAF_CN SAP table for – Version: Planned order

Here we would like to draw your attention to VSPLAF_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). VSPLAF_CN is a SAP standard transparent table used for storing Version: Planned order related data in SAP. It comes under the package CNVS.

SAP VSPLAF_CN table

Table VSPLAF_CN technical data

TableVSPLAF_CN
Data storingVersion: Planned order
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VSPLAF_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 VSPLAF_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SOBES
    Its data type is C (Character String) with field length 1
  • 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
  • ERFMG : Quantity in unit of entry
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ERFME : Unit of entry
    Its data type is C (Character String) with field length 3
  • RQNUM
    Its data type is N (Character String with Digits Only) with field length 10
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • 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
  • WAMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EDGNO
    Its data type is N (Character String with Digits Only) with field length 17
  • LBLKZ
    Its data type is C (Character String) with field length 1
  • GSMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EMLIF
    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
  • UBERI
    Its data type is C (Character String) with field length 10
  • EMATN
    Its data type is C (Character String) with field length 18
  • REMFL
    Its data type is C (Character String) with field length 1
  • PSTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PUSER
    Its data type is C (Character String) with field length 12
  • BADI
    Its data type is C (Character String) with field length 1
  • STAEX
    Its data type is C (Character String) with field length 2
  • RESLO
    Its data type is C (Character String) with field length 4
  • TLMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEDKZ
    Its data type is C (Character String) with field length 1
  • CNFQTY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is MMPUR_CCM_KONNR
  • SRM_CONTRACT_ID
    Its data type is C (Character String) with field length 10
  • SRM_CONTRACT_ITM
    Its data type is N (Character String with Digits Only) with field length 10
  • AVMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BDMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PSTTR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PEDTR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PERTR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • DISPO : MRP controller
    Its data type is C (Character String) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • UMSKZ : Special G/L Indicator
    Its data type is C (Character String) with field length 1
  • AUFFX
    Its data type is C (Character String) with field length 1
  • STLFX
    Its data type is C (Character String) with field length 1
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • 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
  • PROJN : Work breakdown structure element (WBS element)
    Its data type is C (Character String) with field length 16
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • QUNUM : Number of quota arrangement
    Its data type is C (Character String) with field length 10
  • VSNMR
    Its a key field. Its data type is C (Character String) with field length 12
  • QUPOS : Quota arrangement item
    Its data type is N (Character String with Digits Only) with field length 3
  • FLIEF
    Its data type is C (Character String) with field length 10
  • KONNR
    Its data type is C (Character String) with field length 10
  • KTPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • EKORG : Purchasing organization
    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
  • NUMVR
    Its data type is N (Character String with Digits Only) with field length 2
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • PSPEL
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNUM : Quota or Ceiling Number for Import Processing
    Its a key field. Its data type is C (Character String) with field length 10
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • PALTR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TECHS : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12
  • STLAN : BOM Usage
    Its data type is C (Character String) with field length 1
  • STALT
    Its data type is C (Character String) with field length 2
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • 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
  • VERTO : MRP Distribution Key
    Its data type is C (Character String) with field length 4
  • VERID : Production Version
    Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • TRART
    Its data type is C (Character String) with field length 1
  • PLGRP : Responsible planner group/department
    Its data type is C (Character String) with field length 3
  • TERST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TERED
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BEDID : ID of the capacity requirements record
    Its data type is N (Character String with Digits Only) with field length 12
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • LINID
    Its data type is N (Character String with Digits Only) with field length 15
  • TRMKZ
    Its data type is C (Character String) with field length 1
  • TRMER
    Its data type is C (Character String) with field length 2
  • PLWRK
    Its data type is C (Character String) with field length 4
  • REDKZ : Reduction indicator for scheduling
    Its data type is C (Character String) with field length 1
  • TRMHK
    Its data type is C (Character String) with field length 1
  • PLNNR : Key for Task List Group
    Its data type is C (Character String) with field length 8
  • PLNAL : Group Counter
    Its data type is C (Character String) with field length 2
  • PLNTY : Task List Type
    Its data type is C (Character String) with field length 1
  • FRTHW
    Its data type is C (Character String) with field length 1
  • RGEKZ : Indicator: Backflushing for order
    Its data type is C (Character String) with field length 1
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • REVLV : Revision Level
    Its data type is C (Character String) with field length 2
  • PWWRK
    Its data type is C (Character String) with field length 4
  • ABMNG : Reduced quantity in the planned order
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RATID : ID of the capacity requirements record
    Its data type is N (Character String with Digits Only) with field length 12
  • GROID : ID of the capacity requirements record
    Its data type is N (Character String with Digits Only) with field length 12
  • RATER
    Its data type is C (Character String) with field length 2
  • GROER
    Its data type is C (Character String) with field length 2
  • OBART : Object Type
    Its data type is C (Character String) with field length 1
  • PLSCN
    Its data type is N (Character String with Digits Only) with field length 3
  • SBNUM
    Its data type is N (Character String with Digits Only) with field length 10
  • KBNKZ : Kanban Indicator
    Its data type is C (Character String) with field length 1
  • KAPFX
    Its data type is C (Character String) with field length 1
  • PAART
    Its data type is C (Character String) with field length 4
  • SEQNR : Flight Scheduling: Flight Sequence Number
    Its data type is N (Character String with Digits Only) with field length 14
  • PSTTI
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PEDTI
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • MONKZ
    Its data type is C (Character String) with field length 1
  • STSTA
    Its data type is N (Character String with Digits Only) with field length 2
  • PRNKZ
    Its data type is C (Character String) with field length 1
  • MDPBV
    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
  • MDACH
    Its data type is C (Character String) with field length 2
  • MDACC
    Its data type is C (Character String) with field length 4
  • BESKZ : Procurement Type
    Its data type is C (Character String) with field length 1
  • MDACD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • MDACT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • GSBTR : Overall commitment date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PLETX
    Its data type is C (Character String) with field length 1
  • PRSCH
    Its data type is C (Character String) with field length 1
  • LVSCH
    Its data type is C (Character String) with field length 1
  • KZAVC : Indicator for type of availability check
    Its data type is C (Character String) with field length 1
  • VRPLA
    Its data type is C (Character String) with field length 1
  • PBDNR
    Its data type is C (Character String) with field length 10
  • AGREQ
    Its data type is C (Character String) with field length 1