MLST SAP (Milestone) Table details
Dictionary Type: Table
Description: Milestone
Description: Milestone
Table field list including key, data, relationships and ABAP select examples
MLST is a standard SAP Table which is used to store Milestone data and is available within R/3 SAP systems depending on the version and release level.
The MLST table consists of various fields, each holding specific information or linking keys about Milestone data available in SAP. These include MLST_ZAEHL (Milestone number), ZAEHL (Internal counter), DATUV (Valid-From Date), TECHV (Technical status from).. 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 MLST 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 |
MLST_MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table MLST using ABAP code
The following ABAP code Example will allow you to do a basic selection on MLST to SELECT all data from the tableDATA: WA_MLST TYPE MLST.
SELECT SINGLE *
FROM MLST
INTO CORRESPONDING FIELDS OF WA_MLST
WHERE...
How to access SAP table MLST
Within an ECC or HANA version of SAP you can also view further information about MLST 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