SAP VSPLAF_CN Version: Planned order Table
Overview
VSPLAF_CN is a standard SAP S/4HANA table that stores Version: Planned order data. There are total 133 fields in the VSPLAF_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSPLAF_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSPLAF_CN to other SAP tables and standard CDS views available based on VSPLAF_CN table in S/4HANA 2020.
Techincal Settings of VSPLAF_CN
Below are technical details of the table VSPLAF_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSPLAF_CN Fields
The following table gives you an overview of the fields available in VSPLAF_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| PLNUM | Planned Order | PLNUM | CHAR | 10 | |
| MATNR | Planning material | PLMAT | CHAR | 40 | |
| PLWRK | Planning Plant | PLWRK | CHAR | 4 | |
| PWWRK | Production Plant in Planned Order | PWWRK | CHAR | 4 | |
| PAART | Planned Order Type | PAART | CHAR | 4 | |
| BESKZ | Procurement Type | BESKZ | CHAR | 1 | |
| SOBES | Special procurement type | SOBES | CHAR | 1 | |
| GSMNG | Planned Total Order Quantity | GSMNG | QUAN | 13 | |
| TLMNG | Partial Lot Quantity | TLMNG | QUAN | 13 | |
| AVMNG | Planned Scrap Quantity | AVMNG | QUAN | 13 | |
| BDMNG | Requirement Quantity | BDMNG | QUAN | 13 | |
| PSTTR | Planned Order Start Date | PSTTR | DATS | 8 | |
| PEDTR | Planned Order End Date | PEDTR | DATS | 8 | |
| PERTR | Planned Opening Date in Planned Order | PERTR | DATS | 8 | |
| WEBAZ | Goods Receipt Processing Duration in Days | PLWEZ | DEC | 3 | |
| DISPO | MRP controller | PLDSP | CHAR | 3 | |
| UMSKZ | Planned Order Conversion Indicator | PLUMS | CHAR | 1 | |
| AUFFX | Firming Indicator for Planned Order Data | PLAFX | CHAR | 1 | |
| STLFX | Fixing Indicator for BOM Explosion | PLSFX | CHAR | 1 | |
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | |
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC | 6 | |
| KDEIN | Delivery schedule for sales order | KDEIN | NUMC | 4 | |
| PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | |
| RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 10 | |
| QUNUM | Number of quota arrangement | QUNUM | CHAR | 10 | |
| QUPOS | Quota arrangement item | QUPOS | NUMC | 3 | |
| FLIEF | Fixed vendor | FLIEF | CHAR | 10 | |
| KONNR | Number of principal purchase agreement | KONNR | CHAR | 10 | |
| KTPNR | Item number of principal purchase agreement | KTPNR | NUMC | 5 | |
| EKORG | Purchasing organization | EKORG | CHAR | 4 | |
| LGORT | Storage location | LGORT_D | CHAR | 4 | |
| NUMVR | Version number | NUMVR | NUMC | 2 | |
| KZVBR | Consumption posting | KZVBR | CHAR | 1 | |
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | |
| PSPEL | WBS Element | PS_POSNR | NUMC | 8 | |
| SERNR | BOM explosion number | SERNR | CHAR | 8 | |
| PALTR | Explosion date | PALTR | DATS | 8 | |
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | |
| STLAN | BOM Usage | STLAN | CHAR | 1 | |
| STALT | Alternative BOM | STALT | CHAR | 2 | |
| AENNR | Change Number | AENNR | CHAR | 12 | |
| ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | |
| ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | |
| VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | |
| VERID | Production Version | VERID | CHAR | 4 | |
| AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | |
| TRART | Scheduling Type of the Planned Order | TRART | CHAR | 1 | |
| PLGRP | Responsible Planner Group or Department | VAGRP | CHAR | 3 | |
| TERST | Start Date for Production | TERST | DATS | 8 | |
| TERED | End Date for Production | TERED | DATS | 8 | |
| BEDID | ID of the Capacity Requirements Record | BEDID | NUMC | 12 | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| LINID | ID for a schedule record | SP_OPID | NUMC | 15 | |
| TRMKZ | Scheduling indicator | TRMKZ | CHAR | 1 | |
| TRMER | Scheduling error | TRMER | CHAR | 2 | |
| REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | |
| TRMHK | Scheduling source | TRMHK | CHAR | 1 | |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | |
| PLNTY | Task List Type | PLNTY | CHAR | 1 | |
| FRTHW | Production note in the planned order | FRTHW | CHAR | 1 | |
| RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| REVLV | Revision Level | REVLV | CHAR | 2 | |
| ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13 | |
| RATID | -INVALID FOR S/4- Index for the rslts of schedg prod. rates | RATID | NUMC | 12 | |
| GROID | -INVALID FOR S/4- Index for rough scheduling results | GROID | NUMC | 12 | |
| RATER | -INVALID FOR S/4- Schedg error in schedg production rates | RATER | CHAR | 2 | |
| GROER | -INVALID FOR S/4- Scheduling error in rough scheduling | GROER | CHAR | 2 | |
| OBART | Object type | OBART | CHAR | 1 | |
| PLSCN | Planning Scenario in Long-Term Planning | PLSCN | NUMC | 3 | |
| SBNUM | Simulation requirements number | SBNUM | NUMC | 10 | |
| KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | |
| KAPFX | Indicator: Capacity for Planned Order is Dispatched | KAPFX | CHAR | 1 | |
| SEQNR | Sequence Number Order | CY_SEQNR | NUMC | 14 | |
| PSTTI | Planned Order Start Time | PSTTI | TIMS | 6 | |
| PEDTI | Planned Order End Time | PEDTI | TIMS | 6 | |
| MONKZ | Indicator: For Assembly Order Procedures | MONKZ | CHAR | 1 | |
| STSTA | Bill of Material Status | STLST | NUMC | 2 | |
| PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1 | |
| MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1 | |
| VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13 | |
| MDACH | Action Control: Planned Order Processing | MDACH | CHAR | 2 | |
| MDACC | Action: planned order processing | MDACC | CHAR | 4 | |
| MDACD | Date of action: planned order | MDACD | DATS | 8 | |
| MDACT | Time of action: Planned order processing | MDACT | TIMS | 6 | |
| GSBTR | Planned Order Total Commitment Date According to ATP Check | GSBTR_PLAF | DATS | 8 | |
| PLETX | Planned order shift quantities exist | PLETX | CHAR | 1 | |
| PRSCH | Planned order: scheduling using production dates | MD_PRSCHED | CHAR | 1 | |
| LVSCH | Planned order: leading scheduling level (determines dates) | MD_LVSCHED | CHAR | 1 | |
| KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | |
| VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | |
| PBDNR | Requirements Plan | PBDNR | CHAR | 10 | |
| AGREQ | Requirements totaling | AGREQ | CHAR | 1 | |
| UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | |
| UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | |
| ERFMG | Quantity in unit of entry | ERFMG | QUAN | 13 | |
| ERFME | Unit of entry | ERFME | T006 | UNIT | 3 |
| RQNUM | Requirements record number | RQNUM | NUMC | 10 | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | |
| WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13 | |
| WAMNG | Issued Quantity | WAMNG | QUAN | 13 | |
| EDGNO | Internal number for edge of object dependencies tree | EDGNO | M60I | NUMC | 17 |
| LBLKZ | Subcontracting Supplier | LBLKZ | CHAR | 1 | |
| EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | CHAR | 10 | |
| BERID | MRP Area | BERID | CHAR | 10 | |
| UBERI | Issuing MRP area when transferring stock | UBERI | CHAR | 10 | |
| EMATN | Material number corresponding to manufacturer part number | EMATN | CHAR | 40 | |
| REMFL | Repetitive Manufacturing indicator | REMFL | CHAR | 1 | |
| PSTMP | Last Change to Planned Order: Time Stamp | PSTMP | DEC | 15 | |
| PUSER | Last Change to Planned Order: User | PUSER | CHAR | 12 | |
| BADI | Object change via active Business Add-In | MD_BADI | CHAR | 1 | |
| STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2 | |
| RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | |
| MEDKZ | Indicator for Distributed Planned Order | MEDKZ | CHAR | 1 | |
| CNFQTY | Total Confirmed Qty Planned Order (Repetitive Manufacturing) | MD_MES_CNF_QTY | QUAN | 13 | |
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40 | |
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | |
| BOM_VERSN | BOM Version | CS_VERSN | CHAR | 4 | |
| ATRKZ | Request ID | ATRKZ | CHAR | 1 | |
| DAC_PP_COMPONENT | Component ID in Extended Passport (EPP) | EPP_COMPONENT_ID | CHAR | 32 | |
| DAC_INDIRECT_ACCESS | Digital Access: Object was created indirectly | DAC_INDIRECT_ACCESS | CHAR | 1 | |
| DAC_CREATION_DATE | System Date | SYDATUM | DATS | 8 | |
| KUNNR | Customer Number | KUNNR | CHAR | 10 | |
| FLG_BUNDLE | Indicates bundle information maintained | FLG_BUNDLE | CHAR | 1 | |
| FSH_MPLND_ORD | Master Planned Order Number | FSH_MPLO_ORD | CHAR | 12 | |
| SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | |
| SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | |
| M_MRP | Indicator: Matrix Is Activated | MMRP_ACTIVE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSPLAF_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSPLAF_CN | EDGNO | : | M60I |
| VSPLAF_CN | ERFME | 1: CN | T006 |