VSMLST_CN SAP (Version: Milestone) Table details
Dictionary Type: Table
Description: Version: Milestone
Description: Version: Milestone
Table field list including key, data, relationships and ABAP select examples
VSMLST_CN is a standard SAP Table which is used to store Version: Milestone data and is available within R/3 SAP systems depending on the version and release level.
The VSMLST_CN table consists of various fields, each holding specific information or linking keys about Version: Milestone data available in SAP. These include VSNMR (Number or description of a version), MLST_ZAEHL (Milestone number), ZAEHL (Internal counter), DATUV (Valid-From Date).. 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 VSMLST_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 | T000 | MANDT | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
MLST_ZAEHL | Milestone number | MLST_ZAEHL | NUMC | 12 | NUM12 | ||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
MLSTN | Usage | MILESTONE | CHAR | 5 | T433 | MILESTONE | |||
USERH | Milestone created by | MLST_USERH | CHAR | 12 | UNAME | ||||
DATEH | Milestone created on | MLST_DATEH | DATS | 8 | DATUM | ||||
USERV | Milestone changed by | MLST_USERV | CHAR | 12 | UNAME | ||||
DATEV | Milestone changed on | MLST_DATEV | DATS | 8 | DATUM | ||||
PLNNR | Standard network number | CN_PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | STDN | |
PLNTY | Standard network type | CN_PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | ||
PLNAL | Alternative to a standard network | CN_PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
TEDAT | Scheduled milestone date (Basic) | MLST_TEDAT | DATS | 8 | DATUM | ||||
TETIM | Scheduled milestone time (Basic) | MLST_TETIM | TIMS | 6 | ATIME | ||||
TPDAT | Scheduled milestone date (Forecast) | MLST_TPDAT | DATS | 8 | DATUM | ||||
TPTIM | Scheduled milestone time (Forecast) | MLST_TPTIM | TIMS | 6 | ATIME | ||||
EDATU | Fixed milestone date (basic) | MLST_EDATU | DATS | 8 | DATUM | ||||
EZEIT | Fixed milestone time (Basic) | MLST_EZEIT | TIMS | 6 | ATIME | ||||
PDATU | Fixed milestone date (F) | MLST_PDATU | DATS | 8 | DATUM | ||||
PZEIT | Fixed milestone time (F) | MLST_PZEIT | TIMS | 6 | ATIME | ||||
LATED | Indicator: Latest dates | MLST_LATE | CHAR | 1 | FLAG | ||||
DLTAS | Ind: Reference for offset (start/finish activity date) | MLST_DLTAS | CHAR | 1 | FLAG | ||||
DELTA | Offset for milestone date | MLST_DELTA | QUAN | 5 | VNZTV | ||||
DELTE | Time unit for offset of milestone date | MLST_DELTE | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRCNT | Percentual offset of milestone to activity date | MLST_PRCNT | DEC | 3 | MLST_PRCNT | ||||
SDDAT | Key determining the date for milestone in sales order | MLST_SDDAT | CHAR | 2 | MLST_SDDAT | ||||
KZ_TREND | Milestone relevant for trend analysis | MLST_TREND | CHAR | 1 | FLAG | ||||
KZ_LSTWR | Milestone relevant for progress analysis | MLST_LSTWR | CHAR | 1 | FLAG | ||||
KZ_WFLOW | Indicator: Milestone is used for milestone functions | MLST_WFLOW | CHAR | 1 | FLAG | ||||
KZ_FAKTP | Milestone is relevant for date in sales document | MLST_FAKTP | CHAR | 1 | FLAG | ||||
KZ_FRMST | Release stop indicator | MLST_FRMST | CHAR | 1 | FLAG | ||||
LST_FERTG | Percentage of completion (%) | MLST_FERTG | NUMC | 3 | PROZENT100 | ||||
LST_ACTDT | Actual date (Milestone met) | MLST_ACTDT | DATS | 8 | DATUM | ||||
LST_ACTTM | Actual date/time (Milestone met) | MLST_ACTTM | TIMS | 6 | ATIME | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
AUART_ICNW | Network type | MLST_AUART | CHAR | 4 | T003O | AUFART | |||
STDNR_ICNW | Standard network number | CN_PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | STDN | |
ALTNR_ICNW | Alternative to a standard network | CN_PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
STDNR_ICPN | Standard network number | CN_PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | STDN | |
ALTNR_ICPN | Alternative to a standard network | CN_PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
VORNR_ICPN | Activity number in network and standard network | CN_VORNR | CHAR | 4 | NUMCV | VORNR | |||
STDNR_ICSN | Standard network number | CN_PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | STDN | |
ALTNR_ICSN | Alternative to a standard network | CN_PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
OPRST_ICSN | Activity preceding the standard network to be included | OPR_START | CHAR | 4 | NUMCV | VORNR | |||
OPREN_ICSN | Activity following the standard network to be included | OPR_END | CHAR | 4 | NUMCV | VORNR | |||
TASK_ID | Workflow task | MLST_TASK | CHAR | 14 | HROBJEC_14 | ||||
RELSU | Selection function | MLST_RELSU | CHAR | 1 | FLAG | ||||
RELMS | Selection function | MLST_RELMS | CHAR | 1 | FLAG | ||||
INCPN | Selection function | MLST_INCPN | CHAR | 1 | FLAG | ||||
INCNW | Selection function | MLST_INCNW | CHAR | 1 | FLAG | ||||
INCSN | Selection function | MLST_INCSN | CHAR | 1 | FLAG | ||||
WKFLW | Selection function | MLST_WKFLW | CHAR | 1 | FLAG | ||||
RELSU_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
RELMS_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
INCPN_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
INCNW_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
INCSN_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
WKFLW_AL | Processing stage | ACTLV | CHAR | 1 | CHAR1 | ||||
RELSU_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
RELMS_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
INCPN_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
INCNW_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
INCSN_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
WKFLW_SS | Function - activated system status | SYSTA | CHAR | 5 | J_STATUS | ||||
RELSU_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
RELMS_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
INCPN_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
INCNW_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
INCSN_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
WKFLW_US | Function - activated user status | USSTA | CHAR | 5 | J_STATUS | ||||
RELSU_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
RELMS_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
INCPN_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
INCNW_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
INCSN_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
WKFLW_SM | Selection profile (status) | SESMA | CHAR | 7 | TJ48 | SELID | |||
RELSU_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
RELMS_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
INCPN_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
INCNW_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
INCSN_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
WKFLW_CH | Status change triggering the function | CHANG | CHAR | 1 | FLDSE | ||||
RELSU_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
RELMS_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
INCPN_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
INCNW_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
INCSN_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
WKFLW_SG | Ind: Function should only be executed once | SGACT | CHAR | 1 | FLAG | ||||
RELSU_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
RELMS_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
INCPN_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
INCNW_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
INCSN_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
WKFLW_TR | Activate function | TRIGG | CHAR | 1 | MLST_TRIG | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
STSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | NUMC | 8 | PRPSS | KONPT | PS_SPSNR | ||
FPROZ | Percentage of value to be invoiced | FPROZ | DEC | 5(2) | PRZ32 | ||||
COMP_RES | OCM: Result of comparison of two order objects | OCM_COMP_RES | CHAR | 1 | OCM_COMP_RES | ||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | OCM_CH_PROC | ||||
MLTX_ZAEHL | Milestone number | MLST_ZAEHL | NUMC | 12 | NUM12 | ||||
LANGU | Language Key | LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
AEND_ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
KTEXT | Description | MLST_KTEXT | CHAR | 40 | TEXT40 | ||||
LTXSP | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
MLST_ZAEHL_ORG | Milestone number | MLST_ZAEHL | NUMC | 12 | NUM12 | ||||
ZAEHL_EXT_ORG | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
MLST_ZAEHL_EXT | Milestone number | MLST_ZAEHL | NUMC | 12 | NUM12 | ||||
ZAEHL_EXT | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT |
Key field | Non-key field |
How do I retrieve data from SAP table VSMLST_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSMLST_CN to SELECT all data from the tableDATA: WA_VSMLST_CN TYPE VSMLST_CN.
SELECT SINGLE *
FROM VSMLST_CN
INTO CORRESPONDING FIELDS OF WA_VSMLST_CN
WHERE...
How to access SAP table VSMLST_CN
Within an ECC or HANA version of SAP you can also view further information about VSMLST_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