SAP MLSTD Table in S/4 HANA - Milestone I/O Table
MLSTD is a standard SAP Table which is used to store Milestone I/O Table data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MLSTD table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MLSTD
MLSTD table structure field list
Below is the full MLSTD field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MLST_MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
MLST_ZAEHL | Milestone number | MLST_ZAEHL | NUMC | 12(0) | NUM12 | |||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
TECHV | Technical status from | TECHV | CHAR | 12(0) | TECHS | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
MLSTN | Usage | MILESTONE | CHAR | 5(0) | T433 | MILESTONE | ||||
USERH | Milestone created by | MLST_USERH | CHAR | 12(0) | UNAME | |||||
DATEH | Milestone created on | MLST_DATEH | DATS | 8(0) | DATUM | |||||
USERV | Milestone changed by | MLST_USERV | CHAR | 12(0) | UNAME | |||||
DATEV | Milestone changed on | MLST_DATEV | DATS | 8(0) | DATUM | |||||
PLNNR | Standard network number | CN_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | STDN | PLNNR | |
PLNTY | Standard network type | CN_PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | |||
PLNAL | Alternative to a standard network | CN_PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
PLNKN | Number of the Task List Node | PLNKN | NUMC | 8(0) | KNTNR | |||||
AUTYP | Order category | AUFTYP | NUMC | 2(0) | AUFTYP | |||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
TEDAT | Scheduled milestone date (Basic) | MLST_TEDAT | DATS | 8(0) | DATUM | |||||
TETIM | Scheduled milestone time (Basic) | MLST_TETIM | TIMS | 6(0) | ATIME | |||||
TPDAT | Scheduled milestone date (Forecast) | MLST_TPDAT | DATS | 8(0) | DATUM | |||||
TPTIM | Scheduled milestone time (Forecast) | MLST_TPTIM | TIMS | 6(0) | ATIME | |||||
EDATU | Fixed milestone date (basic) | MLST_EDATU | DATS | 8(0) | DATUM | |||||
EZEIT | Fixed milestone time (Basic) | MLST_EZEIT | TIMS | 6(0) | ATIME | |||||
PDATU | Fixed milestone date (F) | MLST_PDATU | DATS | 8(0) | DATUM | |||||
PZEIT | Fixed milestone time (F) | MLST_PZEIT | TIMS | 6(0) | ATIME | |||||
LATED | Indicator: Latest dates | MLST_LATE | CHAR | 1(0) | FLAG | |||||
DLTAS | Ind: Reference for offset (start/finish activity date) | MLST_DLTAS | CHAR | 1(0) | FLAG | |||||
DELTA | Offset for milestone date | MLST_DELTA | QUAN | 5(0) | VNZTV | |||||
DELTE | Time unit for offset of milestone date | MLST_DELTE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PRCNT | Percentual offset of milestone to activity date | MLST_PRCNT | DEC | 3(0) | MLST_PRCNT | |||||
SDDAT | Key determining the date for milestone in sales order | MLST_SDDAT | CHAR | 2(0) | MLST_SDDAT | |||||
KZ_TREND | Milestone relevant for trend analysis | MLST_TREND | CHAR | 1(0) | FLAG | |||||
KZ_LSTWR | Milestone relevant for progress analysis | MLST_LSTWR | CHAR | 1(0) | FLAG | |||||
KZ_WFLOW | Indicator: Milestone is used for milestone functions | MLST_WFLOW | CHAR | 1(0) | FLAG | |||||
KZ_FAKTP | Milestone is relevant for date in sales document | MLST_FAKTP | CHAR | 1(0) | FLAG | |||||
KZ_FRMST | Release stop indicator | MLST_FRMST | CHAR | 1(0) | FLAG | |||||
LST_FERTG | Percentage of completion (%) | MLST_FERTG | NUMC | 3(0) | PROZENT100 | |||||
LST_ACTDT | Actual date (Milestone met) | MLST_ACTDT | DATS | 8(0) | DATUM | |||||
LST_ACTTM | Actual date/time (Milestone met) | MLST_ACTTM | TIMS | 6(0) | ATIME | |||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10(0) | CO_RUECK | RCK | ||||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
AUART_ICNW | Network type | MLST_AUART | CHAR | 4(0) | T003O | AUFART | ||||
STDNR_ICNW | Standard network number | CN_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | STDN | PLNNR | |
ALTNR_ICNW | Alternative to a standard network | CN_PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
STDNR_ICPN | Standard network number | CN_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | STDN | PLNNR | |
ALTNR_ICPN | Alternative to a standard network | CN_PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
VORNR_ICPN | Activity number in network and standard network | CN_VORNR | CHAR | 4(0) | NUMCV | VORNR | ||||
STDNR_ICSN | Standard network number | CN_PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | STDN | PLNNR | |
ALTNR_ICSN | Alternative to a standard network | CN_PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
OPRST_ICSN | Activity preceding the standard network to be included | OPR_START | CHAR | 4(0) | NUMCV | VORNR | ||||
OPREN_ICSN | Activity following the standard network to be included | OPR_END | CHAR | 4(0) | NUMCV | VORNR | ||||
TASK_ID | Workflow task | MLST_TASK | CHAR | 14(0) | HROBJEC_14 | |||||
RELSU | Selection function | MLST_RELSU | CHAR | 1(0) | FLAG | |||||
RELMS | Selection function | MLST_RELMS | CHAR | 1(0) | FLAG | |||||
INCPN | Selection function | MLST_INCPN | CHAR | 1(0) | FLAG | |||||
INCNW | Selection function | MLST_INCNW | CHAR | 1(0) | FLAG | |||||
INCSN | Selection function | MLST_INCSN | CHAR | 1(0) | FLAG | |||||
WKFLW | Selection function | MLST_WKFLW | CHAR | 1(0) | FLAG | |||||
RELSU_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
RELMS_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
INCPN_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
INCNW_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
INCSN_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
WKFLW_AL | Processing stage | ACTLV | CHAR | 1(0) | CHAR1 | |||||
RELSU_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
RELMS_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
INCPN_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
INCNW_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
INCSN_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
WKFLW_SS | Function - activated system status | SYSTA | CHAR | 5(0) | J_STATUS | |||||
RELSU_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
RELMS_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
INCPN_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
INCNW_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
INCSN_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
WKFLW_US | Function - activated user status | USSTA | CHAR | 5(0) | J_STATUS | |||||
RELSU_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
RELMS_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
INCPN_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
INCNW_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
INCSN_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
WKFLW_SM | Selection profile (status) | SESMA | CHAR | 7(0) | TJ48 | SELID | ||||
RELSU_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
RELMS_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
INCPN_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
INCNW_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
INCSN_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
WKFLW_CH | Status change triggering the function | CHANG | CHAR | 1(0) | FLDSE | |||||
RELSU_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
RELMS_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
INCPN_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
INCNW_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
INCSN_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
WKFLW_SG | Ind: Function should only be executed once | SGACT | CHAR | 1(0) | FLAG | |||||
RELSU_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
RELMS_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
INCPN_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
INCNW_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
INCSN_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
WKFLW_TR | Activate function | TRIGG | CHAR | 1(0) | MLST_TRIG | |||||
BEGRU | Authorization Group | BEGRU | CHAR | 4(0) | BEGRU | |||||
STSMA | Status Profile | J_STSMA | CHAR | 8(0) | TJ20 | J_STSMA | ||||
SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | NUMC | 8(0) | 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(0) | OCM_COMP_RES | |||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1(0) | OCM_CH_PROC | |||||
EEW_MLST_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
MLTX_MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
MLTX_ZAEHL | Milestone number | MLST_ZAEHL | NUMC | 12(0) | NUM12 | |||||
LANGU | Language Key | LANGU | LANG | 1(0) | T002 | ISOLA | SPRAS | |||
AEND_ZAEHL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
KTEXT | Description | MLST_KTEXT | CHAR | 40(0) | TEXT40 | |||||
LTXSP | Language: The long text was stored in this language | LTXSP | LANG | 1(0) | T002 | ISOLA | SPRAS | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12(0) | VSNMR | VS2 | ||||
MLST_ZAEHL_ORG | Milestone number | MLST_ZAEHL | NUMC | 12(0) | NUM12 | |||||
ZAEHL_EXT_ORG | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
MLST_ZAEHL_EXT | Milestone number | MLST_ZAEHL | NUMC | 12(0) | NUM12 | |||||
ZAEHL_EXT | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
SN_VORNR | Activity number in network and standard network | CN_VORNR | CHAR | 4(0) | NUMCV | VORNR | ||||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | NET | ||
NW_VORNR | Activity number in network and standard network | CN_VORNR | CHAR | 4(0) | NUMCV | VORNR | ||||
STTXT | System Status | CO_STTXT | CHAR | 40(0) | CHAR40 | |||||
SSTA | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
ASTA | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
ACTLV | Processing stage of the function | MLST_ACTLV | CHAR | 25(0) | CHAR25 | |||||
SELID_TXT | Text (30 Characters) | TEXT30 | CHAR | 30(0) | TEXT30 | |||||
CHANG_TXT | Text (length 35) | TEXT35 | CHAR | 35(0) | TEXT35 | |||||
RELSU_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
RELMS_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
INCNW_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
INCPN_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
INCSN_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
WKFLW_TSS | System status (4 character text) | MLST_SSTA | CHAR | 4(0) | STATUV_TXT | |||||
RELSU_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
RELMS_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
INCNW_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
INCPN_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
INCSN_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
WKFLW_TUS | User status (4 character text) | MLST_ASTA | CHAR | 4(0) | TEXT4 | |||||
FKT_RELSU | Description of the milestone function | MLST_FUNC1 | CHAR | 35(0) | TEXT35 | |||||
FKT_RELMS | Description of the milestone function | MLST_FUNC2 | CHAR | 35(0) | TEXT35 | |||||
FKT_INCSN | Description of the milestone function | MLST_FUNC3 | CHAR | 35(0) | TEXT35 | |||||
FKT_INCNW | Description of the milestone function | MLST_FUNC4 | CHAR | 35(0) | TEXT35 | |||||
FKT_INCPN | Description of the milestone function | MLST_FUNC5 | CHAR | 35(0) | TEXT35 | |||||
FKT_WKFLW | Description of the milestone function | MLST_FUNC6 | CHAR | 35(0) | TEXT35 | |||||
INDBT | Field defined as in SY-TABIX | TABIX_D | INT4 | 10(0) | TABIX | |||||
TASK_SHORT | Short ID for workflow task | MLST_TASKS | CHAR | 12(0) | TEXT12 | |||||
TASK_STEXT | Description of the workflow task | MLST_TASKT | CHAR | 40(0) | TEXT40 | |||||
DATUB | Valid-to date | DATUB | DATS | 8(0) | DATUM |
Search for further information about these or an SAP related objects