VSPLAF_CN SAP (Version: Planned order) Table details
Dictionary Type: Table
Description: Version: Planned order
Description: Version: Planned order
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
MATNR | Planning material | PLMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PLWRK | Planning Plant | PLWRK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
PWWRK | Production plant in planned order | PWWRK | CHAR | 4 | Assigned to domain | WERKS | |||
PAART | Order type | PAART | CHAR | 4 | PAART | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBES | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
GSMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
TLMNG | Partial lot quantity | TLMNG | QUAN | 13(3) | MENG13 | ||||
AVMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13(3) | MENG13 | ||||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
PSTTR | Order start date in planned order | PSTTR | DATS | 8 | DATUM | ||||
PEDTR | Order finish date in the planned order | PEDTR | DATS | 8 | DATUM | ||||
PERTR | Planned opening date in planned order | PERTR | DATS | 8 | DATUM | ||||
WEBAZ | Goods receipt processing time in days | PLWEZ | DEC | 3 | DEC3 | ||||
DISPO | MRP controller | PLDSP | CHAR | 3 | Assigned to domain | DISPO | |||
UMSKZ | Conversion indicator for planned order | PLUMS | CHAR | 1 | XFELD | ||||
AUFFX | Firming indicator for planned order data | PLAFX | CHAR | 1 | XFELD | ||||
STLFX | Fixing indicator for BOM explosion | PLSFX | CHAR | 1 | XFELD | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | ALPHA | QUNUM | |||
QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | NUM03 | ||||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
NUMVR | Version number | NUMVR | NUMC | 2 | NUMVR | ||||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
PSPEL | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
PALTR | Explosion date | PALTR | DATS | 8 | DATUM | ||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
STLAN | BOM Usage | STLAN | CHAR | 1 | Assigned to domain | STLAN | CSV | ||
STALT | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | Assigned to domain | SA_VERTL | |||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | SA_AUFNR | ||
TRART | Scheduling type of the planned order | TRART | CHAR | 1 | CHAR1 | ||||
PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
TERST | Start date for production | TERST | DATS | 8 | DATUM | ||||
TERED | Finish date for production | TERED | DATS | 8 | DATUM | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
LINID | ID for a schedule record | SP_OPID | NUMC | 15 | SP_OPID | ||||
TRMKZ | Scheduling indicator | TRMKZ | CHAR | 1 | XFELD | ||||
TRMER | Scheduling error | TRMER | CHAR | 2 | TRMER | ||||
REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | REDKZ | ||||
TRMHK | Scheduling source | TRMHK | CHAR | 1 | TRMHK | ||||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PLNTY | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
FRTHW | Production note in the planned order | FRTHW | CHAR | 1 | FRTHW | ||||
RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | CO_RGEKZ | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13(3) | MENGE | ||||
RATID | Index for the results of scheduling production rates | RATID | NUMC | 12 | Assigned to domain | BEDID | |||
GROID | Index for rough scheduling results | GROID | NUMC | 12 | Assigned to domain | BEDID | |||
RATER | Scheduling error in scheduling production rates | RATER | CHAR | 2 | TRMER | ||||
GROER | Scheduling error in rough scheduling | GROER | CHAR | 2 | TRMER | ||||
OBART | Object type | OBART | CHAR | 1 | OBART | ||||
PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | Assigned to domain | PLSCN | PLS | ||
SBNUM | Simulation requirements number | SBNUM | NUMC | 10 | Assigned to domain | SBNUM | |||
KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
KAPFX | Indicator: capacity for planned order dispatched | KAPFX | CHAR | 1 | XFELD | ||||
SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | CY_SEQNR | ||||
PSTTI | Start Time of Planned Order | PSTTI | TIMS | 6 | UZEIT | ||||
PEDTI | End Time of Planned Order | PEDTI | TIMS | 6 | UZEIT | ||||
MONKZ | Indicator: for assembly order procedures | MONKZ | CHAR | 1 | XFELD | ||||
STSTA | BOM status | STLST | NUMC | 2 | Assigned to domain | STLST | |||
PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1 | KREUZ | ||||
MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1 | MDPBV | ||||
VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13(3) | MENG13 | ||||
MDACH | Action control: planned order processing | MDACH | CHAR | 2 | Assigned to domain | MDACH | |||
MDACC | Action: planned order processing | MDACC | CHAR | 4 | Assigned to domain | MDACC | |||
MDACD | Date of action: planned order | MDACD | DATS | 8 | DATUM | ||||
MDACT | Time of action: Planned order processing | MDACT | TIMS | 6 | UZEIT | ||||
GSBTR | Total commitment date of plnd ord. after ATP check f.comps. | GSBTR_PLAF | DATS | 8 | DATUM | ||||
PLETX | Planned order shift quantities exist | PLETX | CHAR | 1 | XFELD | ||||
PRSCH | Planned order: scheduling using production dates | MD_PRSCHED | CHAR | 1 | XFELD | ||||
LVSCH | Planned order: leading scheduling level (determines dates) | MD_LVSCHED | CHAR | 1 | SCHED_TYPE | ||||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | KZAVC | ||||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | XFELD | ||||
PBDNR | Requirements Plan Number | PBDNR | CHAR | 10 | CHAR10 | PBN | |||
AGREQ | Requirements totaling | AGREQ | CHAR | 1 | AGREQ | ||||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
ERFME | Unit of Entry | ERFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
RQNUM | Requirements record number | RQNUM | NUMC | 10 | Assigned to domain | RQNUM | PLA | ||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WAMNG | Issued Quantity | WAMNG | QUAN | 13(3) | MENG13 | ||||
EDGNO | Internal number for edge of object dependencies tree | EDGNO | NUMC | 17 | M60I | EDGNO | |||
LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | XFELD | ||||
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
BERID | MRP Area | BERID | CHAR | 10 | Assigned to domain | BERID | BERID | ||
UBERI | Issuing MRP area when transferring stock | UBERI | CHAR | 10 | Assigned to domain | BERID | |||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | HTN | |
REMFL | Repetitive Manufacturing indicator | REMFL | CHAR | 1 | REMFL | ||||
PSTMP | Last Change to Planned Order: Time Stamp | PSTMP | DEC | 15 | TZNTSTMPS | ||||
PUSER | Last Change to Planned Order: User | PUSER | CHAR | 12 | UNAME | ||||
BADI | Object change via active Business Add-In | MD_BADI | CHAR | 1 | MD_BADI | ||||
STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2 | MD_STAEX | ||||
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | Assigned to domain | LGORT | |||
MEDKZ | Indicator for Distributed Planned Order | MEDKZ | CHAR | 1 | MEDKZ | ||||
CNFQTY | Total Confirmed Qty Planned Order (Repetitive Manufacturing) | MD_MES_CNF_QTY | QUAN | 13(3) | MENG13 | ||||
.INCLU--AP | 0 | ||||||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
.INCLU--AP | 0 | ||||||||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | BBP_ITEMNO | ||||
.INCLU--AP | 0 | ||||||||
M_MRP | Indicator: Matrix Is Activated | MMRP_ACTIVE | CHAR | 1 | XFELD |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects