SAP ABAP Table VSPLAF_CN (Version: Planned order)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ CNVS (Package) R/3 Application development: Version Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VSPLAF_CN | Table Relationship Diagram |
Short Description | Version: Planned order |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Version: PS version, version-related key fields | |||||
3 | VSNMR | VSNMR | VSNMR | CHAR | 12 | 0 | Number or description of a version | ||
4 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | * | |
5 | MATNR | PLMAT | MATNR | CHAR | 18 | 0 | Planning material | * | |
6 | PLWRK | PLWRK | WERKS | CHAR | 4 | 0 | Planning Plant | * | |
7 | PWWRK | PWWRK | WERKS | CHAR | 4 | 0 | Production plant in planned order | * | |
8 | PAART | PAART | PAART | CHAR | 4 | 0 | Order type | ||
9 | BESKZ | BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
10 | SOBES | SOBES | SOBES | CHAR | 1 | 0 | Special procurement type | ||
11 | GSMNG | GSMNG | MENG13 | QUAN | 13 | 3 | Total planned order quantity | ||
12 | TLMNG | TLMNG | MENG13 | QUAN | 13 | 3 | Partial lot quantity | ||
13 | AVMNG | AVMNG | MENG13 | QUAN | 13 | 3 | Fixed quantity of scrap from production | ||
14 | BDMNG | BDMNG | MENG13 | QUAN | 13 | 3 | Requirement Quantity | ||
15 | PSTTR | PSTTR | DATUM | DATS | 8 | 0 | Order start date in planned order | ||
16 | PEDTR | PEDTR | DATUM | DATS | 8 | 0 | Order finish date in the planned order | ||
17 | PERTR | PERTR | DATUM | DATS | 8 | 0 | Planned opening date in planned order | ||
18 | WEBAZ | PLWEZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
19 | DISPO | PLDSP | DISPO | CHAR | 3 | 0 | MRP controller | * | |
20 | UMSKZ | PLUMS | XFELD | CHAR | 1 | 0 | Conversion indicator for planned order | ||
21 | AUFFX | PLAFX | XFELD | CHAR | 1 | 0 | Firming indicator for planned order data | ||
22 | STLFX | PLSFX | XFELD | CHAR | 1 | 0 | Fixing indicator for BOM explosion | ||
23 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | * | |
24 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
25 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
26 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
27 | PROJN | PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
28 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
29 | QUNUM | QUNUM | QUNUM | CHAR | 10 | 0 | Number of quota arrangement | ||
30 | QUPOS | QUPOS | NUM03 | NUMC | 3 | 0 | Quota arrangement item | ||
31 | FLIEF | FLIEF | LIFNR | CHAR | 10 | 0 | Fixed vendor | * | |
32 | KONNR | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | * | |
33 | KTPNR | KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | * | |
34 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
35 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
36 | NUMVR | NUMVR | NUMVR | NUMC | 2 | 0 | Version number | ||
37 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
38 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
39 | PSPEL | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
40 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
41 | PALTR | PALTR | DATUM | DATS | 8 | 0 | Explosion date | ||
42 | TECHS | TECHS | TECHS | CHAR | 12 | 0 | Parameter Variant/Standard Variant | ||
43 | STLAN | STLAN | STLAN | CHAR | 1 | 0 | BOM Usage | * | |
44 | STALT | STALT | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
45 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | * | |
46 | ARSNR | ARSNR | MDNUM | NUMC | 10 | 0 | Settlement reservation number | ||
47 | ARSPS | ARSPS | RSPOS | NUMC | 4 | 0 | Item number of the settlement reservation | ||
48 | VERTO | SA_VERTO | SA_VERTL | CHAR | 4 | 0 | Distribution key for quantity produced | * | |
49 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | * | |
50 | AUFNR | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | * | |
51 | TRART | TRART | CHAR1 | CHAR | 1 | 0 | Scheduling type of the planned order | ||
52 | PLGRP | VAGRP | VAGRP | CHAR | 3 | 0 | Responsible planner group/department | * | |
53 | TERST | TERST | DATUM | DATS | 8 | 0 | Start date for production | ||
54 | TERED | TERED | DATUM | DATS | 8 | 0 | Finish date for production | ||
55 | BEDID | BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | * | |
56 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
57 | LINID | SP_OPID | SP_OPID | NUMC | 15 | 0 | ID for a schedule record | ||
58 | TRMKZ | TRMKZ | XFELD | CHAR | 1 | 0 | Scheduling indicator | ||
59 | TRMER | TRMER | TRMER | CHAR | 2 | 0 | Scheduling error | ||
60 | REDKZ | REDKZ | REDKZ | CHAR | 1 | 0 | Reduction indicator for scheduling | ||
61 | TRMHK | TRMHK | TRMHK | CHAR | 1 | 0 | Scheduling source | ||
62 | PLNNR | PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
63 | PLNAL | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
64 | PLNTY | PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
65 | FRTHW | FRTHW | FRTHW | CHAR | 1 | 0 | Production note in the planned order | ||
66 | RGEKZ | CO_RGEKZ | CO_RGEKZ | CHAR | 1 | 0 | Indicator: Backflushing for order | ||
67 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
68 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
69 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
70 | ABMNG | ABMNG | MENGE | QUAN | 13 | 3 | Reduced quantity in the planned order | ||
71 | RATID | RATID | BEDID | NUMC | 12 | 0 | Index for the results of scheduling production rates | * | |
72 | GROID | GROID | BEDID | NUMC | 12 | 0 | Index for rough scheduling results | * | |
73 | RATER | RATER | TRMER | CHAR | 2 | 0 | Scheduling error in scheduling production rates | ||
74 | GROER | GROER | TRMER | CHAR | 2 | 0 | Scheduling error in rough scheduling | ||
75 | OBART | OBART | OBART | CHAR | 1 | 0 | Object type | ||
76 | PLSCN | PLSCN | PLSCN | NUMC | 3 | 0 | Planning Scenario of Long-Term Planning | * | |
77 | SBNUM | SBNUM | SBNUM | NUMC | 10 | 0 | Simulation requirements number | * | |
78 | KBNKZ | KBNKZ | KBNKZ | CHAR | 1 | 0 | Kanban Indicator | ||
79 | KAPFX | KAPFX | XFELD | CHAR | 1 | 0 | Indicator: capacity for planned order dispatched | ||
80 | SEQNR | CY_SEQNR | CY_SEQNR | NUMC | 14 | 0 | Seq. number order | ||
81 | PSTTI | PSTTI | UZEIT | TIMS | 6 | 0 | Start Time of Planned Order | ||
82 | PEDTI | PEDTI | UZEIT | TIMS | 6 | 0 | End Time of Planned Order | ||
83 | MONKZ | MONKZ | XFELD | CHAR | 1 | 0 | Indicator: for assembly order procedures | ||
84 | STSTA | STLST | STLST | NUMC | 2 | 0 | BOM Statuses | * | |
85 | PRNKZ | PRNKZ | KREUZ | CHAR | 1 | 0 | Ind.: Leading order in collective order is planned ordre | ||
86 | MDPBV | MDPBV | MDPBV | CHAR | 1 | 0 | Planned order: confirmation of availability | ||
87 | VFMNG | VFMNG | MENG13 | QUAN | 13 | 3 | Planned order: committed quantity | ||
88 | MDACH | MDACH | MDACH | CHAR | 2 | 0 | Action control: planned order processing | * | |
89 | MDACC | MDACC | MDACC | CHAR | 4 | 0 | Action: planned order processing | * | |
90 | MDACD | MDACD | DATUM | DATS | 8 | 0 | Date of action: planned order | ||
91 | MDACT | MDACT | UZEIT | TIMS | 6 | 0 | Time of action: Planned order processing | ||
92 | GSBTR | GSBTR_PLAF | DATUM | DATS | 8 | 0 | Total commitment date of plnd ord. after ATP check f.comps. | ||
93 | PLETX | PLETX | XFELD | CHAR | 1 | 0 | Planned order shift quantities exist | ||
94 | PRSCH | MD_PRSCHED | XFELD | CHAR | 1 | 0 | Planned order: scheduling using production dates | ||
95 | LVSCH | MD_LVSCHED | SCHED_TYPE | CHAR | 1 | 0 | Planned order: leading scheduling level (determines dates) | ||
96 | KZAVC | KZAVC | KZAVC | CHAR | 1 | 0 | Indicator for type of availability check | ||
97 | VRPLA | VRPLA | XFELD | CHAR | 1 | 0 | Indicator: planning without final assembly | ||
98 | PBDNR | PBDNR | CHAR10 | CHAR | 10 | 0 | Requirements Plan Number | ||
99 | AGREQ | AGREQ | AGREQ | CHAR | 1 | 0 | Requirements totaling | ||
100 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
101 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
102 | ERFMG | ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
103 | ERFME | ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
104 | RQNUM | RQNUM | RQNUM | NUMC | 10 | 0 | Requirements record number | * | |
105 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
106 | WEMNG | WEMNG | MENG13 | QUAN | 13 | 3 | Quantity of goods received | ||
107 | WAMNG | WAMNG | MENG13 | QUAN | 13 | 3 | Issued quantity | ||
108 | EDGNO | EDGNO | EDGNO | NUMC | 17 | 0 | Internal number for edge of object dependencies tree | M60I | |
109 | LBLKZ | LBLKZ | XFELD | CHAR | 1 | 0 | Subcontracting vendor | ||
110 | EMLIF | EMLIF | LIFNR | CHAR | 10 | 0 | Vendor to be supplied/who is to receive delivery | * | |
111 | BERID | BERID | BERID | CHAR | 10 | 0 | MRP Area | * | |
112 | UBERI | UBERI | BERID | CHAR | 10 | 0 | Issuing MRP area when transferring stock | * | |
113 | EMATN | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
114 | REMFL | REMFL | REMFL | CHAR | 1 | 0 | Repetitive Manufacturing indicator | ||
115 | PSTMP | PSTMP | TZNTSTMPS | DEC | 15 | 0 | Last Change to Planned Order: Time Stamp | ||
116 | PUSER | PUSER | UNAME | CHAR | 12 | 0 | Last Change to Planned Order: User | ||
117 | BADI | MD_BADI | MD_BADI | CHAR | 1 | 0 | Object change via active Business Add-In | ||
118 | STAEX | MD_STAEX | MD_STAEX | CHAR | 2 | 0 | Status information on BOM explosion in planned order | ||
119 | RESLO | RESLO | LGORT | CHAR | 4 | 0 | Issuing Storage Location for Stock Transport Order | * | |
120 | MEDKZ | MEDKZ | MEDKZ | CHAR | 1 | 0 | Indicator for Distributed Planned Order | ||
121 | CNFQTY | MD_MES_CNF_QTY | MENG13 | QUAN | 13 | 3 | Total Confirmed Qty Planned Order (Repetitive Manufacturing) | ||
122 | .INCLUDE | 0 | 0 | ||||||
123 | .INCLU--AP | 0 | 0 | SRM/ERP Integration: Central Contract | |||||
124 | SRM_CONTRACT_ID | SRM_CONTRACT_ID | BBP_BAPI_EBELN | CHAR | 10 | 0 | Central Contract | ||
125 | SRM_CONTRACT_ITM | SRM_CONTRACT_ITEM | BBP_ITEMNO | NUMC | 10 | 0 | Central Contract Item Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VSPLAF_CN | EDGNO | M60I | EDGNO | |||
2 | VSPLAF_CN | ERFME | T006 | MSEHI | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |