VSPLAF_CN SAP (Version: Planned order) Table details

Dictionary Type: Table
Description: Version: Planned order




ABAP Code to SELECT data from VSPLAF_CN
Related tables to VSPLAF_CN
Access table VSPLAF_CN




Table field list including key, data, relationships and ABAP select examples

VSPLAF_CN is a standard SAP Table which is used to store Version: Planned order data and is available within R/3 SAP systems depending on the version and release level.

The VSPLAF_CN table consists of various fields, each holding specific information or linking keys about Version: Planned order data available in SAP. These include VSNMR (Number or description of a version), PLNUM (Planned order number), MATNR (Planning material), PLWRK (Planning Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VSPLAF_CN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
VSNMRNumber or description of a version VSNMRCHAR12VSNMRVS2
PLNUMPlanned order number PLNUMCHAR10Assigned to domainALPHAPLNUMPAF
MATNRPlanning material PLMATCHAR18Assigned to domainMATN1MATNRMAT
PLWRKPlanning Plant PLWRKCHAR4Assigned to domainWERKSWRK
PWWRKProduction plant in planned order PWWRKCHAR4Assigned to domainWERKS
PAARTOrder type PAARTCHAR4PAART
BESKZProcurement Type BESKZCHAR1BESKZMBS
SOBESSpecial procurement type SOBESCHAR1SOBES
GSMNGTotal planned order quantity GSMNGQUAN13(3) MENG13
TLMNGPartial lot quantity TLMNGQUAN13(3) MENG13
AVMNGFixed quantity of scrap from production AVMNGQUAN13(3) MENG13
BDMNGRequirement Quantity BDMNGQUAN13(3) MENG13
PSTTROrder start date in planned order PSTTRDATS8DATUM
PEDTROrder finish date in the planned order PEDTRDATS8DATUM
PERTRPlanned opening date in planned order PERTRDATS8DATUM
WEBAZGoods receipt processing time in days PLWEZDEC3DEC3
DISPOMRP controller PLDSPCHAR3Assigned to domainDISPO
UMSKZConversion indicator for planned order PLUMSCHAR1XFELD
AUFFXFirming indicator for planned order data PLAFXCHAR1XFELD
STLFXFixing indicator for BOM explosion PLSFXCHAR1XFELD
KNTTPAccount Assignment Category KNTTPCHAR1Assigned to domainKNTTPKNT
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
QUNUMNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
QUPOSQuota Arrangement Item QUPOSNUMC3NUM03
FLIEFFixed Vendor FLIEFCHAR10Assigned to domainALPHALIFNR
KONNRNumber of Principal Purchase Agreement KONNRCHAR10Assigned to domainALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5Assigned to domainEBELP
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
NUMVRVersion number NUMVRNUMC2NUMVR
KZVBRConsumption Posting KZVBRCHAR1KZVBR
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
PSPELWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
SERNRBOM explosion number SERNRCHAR8Assigned to domainSERNR
PALTRExplosion date PALTRDATS8DATUM
TECHSParameter Variant/Standard Variant TECHSCHAR12TECHS
STLANBOM Usage STLANCHAR1Assigned to domainSTLANCSV
STALTAlternative BOM STALTCHAR2ALPHAALTNR
AENNRChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN
ARSNRSettlement reservation number ARSNRNUMC10MDNUM
ARSPSItem number of the settlement reservation ARSPSNUMC4RSPOS
VERTODistribution key for quantity produced SA_VERTOCHAR4Assigned to domainSA_VERTL
VERIDProduction Version VERIDCHAR4Assigned to domainVERIDVER
AUFNRRun schedule header number SA_AUFNRCHAR12Assigned to domainALPHASA_AUFNR
TRARTScheduling type of the planned order TRARTCHAR1CHAR1
PLGRPResponsible planner group/department VAGRPCHAR3Assigned to domainVAGRPH_T024A
TERSTStart date for production TERSTDATS8DATUM
TEREDFinish date for production TEREDDATS8DATUM
BEDIDID of the capacity requirements record BEDIDNUMC12Assigned to domainBEDID
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
LINIDID for a schedule record SP_OPIDNUMC15SP_OPID
TRMKZScheduling indicator TRMKZCHAR1XFELD
TRMERScheduling error TRMERCHAR2TRMER
REDKZReduction indicator for scheduling REDKZCHAR1REDKZ
TRMHKScheduling source TRMHKCHAR1TRMHK
PLNNRKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLNALGroup Counter PLNALCHAR2ALPHAALTNRPAL
PLNTYTask List Type PLNTYCHAR1Assigned to domainPLNTYPTYH_TCA01
FRTHWProduction note in the planned order FRTHWCHAR1FRTHW
RGEKZIndicator: Backflushing for order CO_RGEKZCHAR1CO_RGEKZ
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
ABMNGReduced quantity in the planned order ABMNGQUAN13(3) MENGE
RATIDIndex for the results of scheduling production rates RATIDNUMC12Assigned to domainBEDID
GROIDIndex for rough scheduling results GROIDNUMC12Assigned to domainBEDID
RATERScheduling error in scheduling production rates RATERCHAR2TRMER
GROERScheduling error in rough scheduling GROERCHAR2TRMER
OBARTObject type OBARTCHAR1OBART
PLSCNPlanning Scenario of Long-Term Planning PLSCNNUMC3Assigned to domainPLSCNPLS
SBNUMSimulation requirements number SBNUMNUMC10Assigned to domainSBNUM
KBNKZKanban Indicator KBNKZCHAR1KBNKZ
KAPFXIndicator: capacity for planned order dispatched KAPFXCHAR1XFELD
SEQNRSeq. number order CY_SEQNRNUMC14CY_SEQNR
PSTTIStart Time of Planned Order PSTTITIMS6UZEIT
PEDTIEnd Time of Planned Order PEDTITIMS6UZEIT
MONKZIndicator: for assembly order procedures MONKZCHAR1XFELD
STSTABOM status STLSTNUMC2Assigned to domainSTLST
PRNKZInd.: Leading order in collective order is planned ordre PRNKZCHAR1KREUZ
MDPBVPlanned order: confirmation of availability MDPBVCHAR1MDPBV
VFMNGPlanned order: committed quantity VFMNGQUAN13(3) MENG13
MDACHAction control: planned order processing MDACHCHAR2Assigned to domainMDACH
MDACCAction: planned order processing MDACCCHAR4Assigned to domainMDACC
MDACDDate of action: planned order MDACDDATS8DATUM
MDACTTime of action: Planned order processing MDACTTIMS6UZEIT
GSBTRTotal commitment date of plnd ord. after ATP check f.comps. GSBTR_PLAFDATS8DATUM
PLETXPlanned order shift quantities exist PLETXCHAR1XFELD
PRSCHPlanned order: scheduling using production dates MD_PRSCHEDCHAR1XFELD
LVSCHPlanned order: leading scheduling level (determines dates) MD_LVSCHEDCHAR1SCHED_TYPE
KZAVCIndicator for type of availability check KZAVCCHAR1KZAVC
VRPLAIndicator: planning without final assembly VRPLACHAR1XFELD
PBDNRRequirements Plan Number PBDNRCHAR10CHAR10PBN
AGREQRequirements totaling AGREQCHAR1AGREQ
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
RQNUMRequirements record number RQNUMNUMC10Assigned to domainRQNUMPLA
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
WEMNGQuantity of Goods Received WEMNGQUAN13(3) MENG13
WAMNGIssued Quantity WAMNGQUAN13(3) MENG13
EDGNOInternal number for edge of object dependencies tree EDGNONUMC17M60IEDGNO
LBLKZSubcontracting vendor LBLKZCHAR1XFELD
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10Assigned to domainALPHALIFNR
BERIDMRP Area BERIDCHAR10Assigned to domainBERIDBERID
UBERIIssuing MRP area when transferring stock UBERICHAR10Assigned to domainBERID
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18Assigned to domainMATN1MATNRHTN
REMFLRepetitive Manufacturing indicator REMFLCHAR1REMFL
PSTMPLast Change to Planned Order: Time Stamp PSTMPDEC15TZNTSTMPS
PUSERLast Change to Planned Order: User PUSERCHAR12UNAME
BADIObject change via active Business Add-In MD_BADICHAR1MD_BADI
STAEXStatus information on BOM explosion in planned order MD_STAEXCHAR2MD_STAEX
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
MEDKZIndicator for Distributed Planned Order MEDKZCHAR1MEDKZ
CNFQTYTotal Confirmed Qty Planned Order (Repetitive Manufacturing) MD_MES_CNF_QTYQUAN13(3) MENG13
.INCLU--AP 0
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
.INCLU--AP 0
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO
.INCLU--AP 0
M_MRPIndicator: Matrix Is Activated MMRP_ACTIVECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table VSPLAF_CN using ABAP code

The following ABAP code Example will allow you to do a basic selection on VSPLAF_CN to SELECT all data from the table
DATA: WA_VSPLAF_CN TYPE VSPLAF_CN.

SELECT SINGLE *
FROM VSPLAF_CN
INTO CORRESPONDING FIELDS OF WA_VSPLAF_CN
WHERE...

How to access SAP table VSPLAF_CN

Within an ECC or HANA version of SAP you can also view further information about VSPLAF_CN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!