1. SAP Tutorial
  2. PS

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

    • VSPLAF_CN related tables

    • VSAFAB_CN : Version: Network relationships
    • VSAFPO_CN : Version: Order items in PP orders
    • PROJVS_ENQ : Block key project (project versions)
    • VSAFVC_CN : Version: Operation in order
    • VSPRTX_CN : Version: PS texts (WBS)
    • VSAFFL_CN : Version: Order sequences PP orders
    • TCNVSCT : Customizing: Short description of possible version numbers
    • VSEBKN_CN : Version: Purchase requisition account assignment
    • VSVBEP_CN : Version: Sales document: Schedule line data
    • VSHIST_OV : Transfer history activity
    • VSVBAP_CN : Version: Sales document: Item data
    • VSAFVU_CN : Version: User fields in operation in order
    • VSKOPF : Version: Header – general data for a version –
    • VSFPLT_CN : Version: Billing schedule: Dates
    • VSKBED_CN : Version: Capacity requirement records
    • VSVBKD_CN : Version: Sales document – commercial data
    • VSHIST_OR : Transfer history order
    • VSKPER_CN : Version: Workforce Planning
    • VSHIST_PR : Transfer history WBS element
    • VSHIST_NP : Tranfer history for network

    VSPLAF_CN related transaction codes under SAP package CNVS

    • CJV5 : Delete simulation version
    • CJV3 : Display Project Version (Simulation)
    • CJV7 : Display transfer log
    • CJV6 : Maintenance: Version administration
    • CJV2 : Change project version (simulation)
    • CJV4 : Transfer project
    • CN72 : Create Project Version
    • CJV1 : Create project version (simulation)

    Related References

    Related Tutorials

    VSAFFH_CN SAP table for – Version: PRT allocation to work order

    VSAFFH_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: PRT allocation...

    VSFPLT_CN SAP table for – Version: Billing schedule: Dates

    VSFPLT_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Billing schedule:...

    VSRPSCO_CN SAP table for – Version: Cumulation table for project reporting

    VSRPSCO_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Cumulation table...

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

    VSAFPO_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Order items...

    VSAFVV_CN SAP table for – Version: Quantities/Dates/Values in order operation

    VSAFVV_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Quantities/Dates/Values in...

    VSAFKO_CN SAP table for – Version: Order header data for PP orders

    VSAFKO_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Order header...

    VSPRTE_CN SAP table for – Version: Scheduling data for project item

    VSPRTE_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Scheduling data...

    «
    »