1. Home
  2. Resources
  3. SAP Tables
  4. MLST - Milestone

SAP Table MLST

Milestone

MLST (Milestone) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MLST to other SAP tables.

MLST table fields

Field Data element Checktable Datatype Length Decimals
MLST_MANDT Client MANDT T000 CLNT 3 0
MLST_ZAEHL Milestone number MLST_ZAEHL NUMC 12 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
DATUV Valid-From Date DATUV DATS 8 0
TECHV Technical status from TECHV CHAR 12 0
AENNR Change Number AENNR AENR CHAR 12 0
LOEKZ Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
MLSTN Usage MILESTONE T433 CHAR 5 0
USERH Milestone created by MLST_USERH CHAR 12 0
DATEH Milestone created on MLST_DATEH DATS 8 0
USERV Milestone changed by MLST_USERV CHAR 12 0
DATEV Milestone changed on MLST_DATEV DATS 8 0
PLNNR Standard network number CN_PLNNR CHAR 8 0
PLNTY Standard network type CN_PLNTY TCA01 CHAR 1 0
PLNAL Alternative to a standard network CN_PLNAL CHAR 2 0
PLNKN Number of the task list node PLNKN NUMC 8 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
PSPNR WBS Element PS_POSNR PRPS NUMC 8 0
TEDAT Scheduled milestone date (Basic) MLST_TEDAT DATS 8 0
TETIM Scheduled milestone time (Basic) MLST_TETIM TIMS 6 0
TPDAT Scheduled milestone date (Forecast) MLST_TPDAT DATS 8 0
TPTIM Scheduled milestone time (Forecast) MLST_TPTIM TIMS 6 0
EDATU Fixed milestone date (basic) MLST_EDATU DATS 8 0
EZEIT Fixed milestone time (Basic) MLST_EZEIT TIMS 6 0
PDATU Fixed milestone date (F) MLST_PDATU DATS 8 0
PZEIT Fixed milestone time (F) MLST_PZEIT TIMS 6 0
LATED Indicator: Latest dates MLST_LATE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DLTAS Ind: Reference for offset (start/finish activity date) MLST_DLTAS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DELTA Offset for milestone date MLST_DELTA QUAN 5 0
DELTE Time unit for offset of milestone date MLST_DELTE T006 UNIT 3 0
PRCNT Percentual offset of milestone to activity date MLST_PRCNT DEC 3 0
SDDAT Key determining the date for milestone in sales order MLST_SDDAT CHAR 2 0
01 Date in billing schedule
KZ_TREND Milestone relevant for trend analysis MLST_TREND CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_LSTWR Milestone relevant for progress analysis MLST_LSTWR CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_WFLOW Indicator: Milestone is used for milestone functions MLST_WFLOW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_FAKTP Milestone is relevant for date in sales document MLST_FAKTP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_FRMST Release stop indicator MLST_FRMST CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
LST_FERTG Percentage of completion (%) MLST_FERTG NUMC 3 0
0
LST_ACTDT Actual date (Milestone met) MLST_ACTDT DATS 8 0
LST_ACTTM Actual date/time (Milestone met) MLST_ACTTM TIMS 6 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Internal counter CIM_COUNT NUMC 8 0
AUART_ICNW Network type MLST_AUART T003O CHAR 4 0
STDNR_ICNW Standard network number CN_PLNNR CHAR 8 0
ALTNR_ICNW Alternative to a standard network CN_PLNAL CHAR 2 0
STDNR_ICPN Standard network number CN_PLNNR CHAR 8 0
ALTNR_ICPN Alternative to a standard network CN_PLNAL CHAR 2 0
VORNR_ICPN Activity number in network and standard network CN_VORNR CHAR 4 0
STDNR_ICSN Standard network number CN_PLNNR CHAR 8 0
ALTNR_ICSN Alternative to a standard network CN_PLNAL CHAR 2 0
OPRST_ICSN Activity preceding the standard network to be included OPR_START CHAR 4 0
OPREN_ICSN Activity following the standard network to be included OPR_END CHAR 4 0
TASK_ID Workflow task MLST_TASK CHAR 14 0
RELSU Selection function MLST_RELSU CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELMS Selection function MLST_RELMS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCPN Selection function MLST_INCPN CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCNW Selection function MLST_INCNW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCSN Selection function MLST_INCSN CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
WKFLW Selection function MLST_WKFLW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELSU_AL Processing stage ACTLV CHAR 1 0
RELMS_AL Processing stage ACTLV CHAR 1 0
INCPN_AL Processing stage ACTLV CHAR 1 0
INCNW_AL Processing stage ACTLV CHAR 1 0
INCSN_AL Processing stage ACTLV CHAR 1 0
WKFLW_AL Processing stage ACTLV CHAR 1 0
RELSU_SS Function - activated system status SYSTA CHAR 5 0
RELMS_SS Function - activated system status SYSTA CHAR 5 0
INCPN_SS Function - activated system status SYSTA CHAR 5 0
INCNW_SS Function - activated system status SYSTA CHAR 5 0
INCSN_SS Function - activated system status SYSTA CHAR 5 0
WKFLW_SS Function - activated system status SYSTA CHAR 5 0
RELSU_US Function - activated user status USSTA CHAR 5 0
RELMS_US Function - activated user status USSTA CHAR 5 0
INCPN_US Function - activated user status USSTA CHAR 5 0
INCNW_US Function - activated user status USSTA CHAR 5 0
INCSN_US Function - activated user status USSTA CHAR 5 0
WKFLW_US Function - activated user status USSTA CHAR 5 0
RELSU_SM Selection profile (status) SESMA TJ48 CHAR 7 0
RELMS_SM Selection profile (status) SESMA TJ48 CHAR 7 0
INCPN_SM Selection profile (status) SESMA TJ48 CHAR 7 0
INCNW_SM Selection profile (status) SESMA TJ48 CHAR 7 0
INCSN_SM Selection profile (status) SESMA TJ48 CHAR 7 0
WKFLW_SM Selection profile (status) SESMA TJ48 CHAR 7 0
RELSU_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
RELMS_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCPN_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCNW_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCSN_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
WKFLW_CH Status change triggering the function CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
RELSU_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELMS_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCPN_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCNW_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCSN_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
WKFLW_SG Ind: Function should only be executed once SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELSU_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
RELMS_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
INCPN_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
INCNW_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
INCSN_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
WKFLW_TR Activate function TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
BEGRU Authorization Group BEGRU CHAR 4 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
SPSNR Std WBS: Internal project item number (w/exit on ID) PS_SPSNR PRPSS NUMC 8 0
FPROZ Percentage of value to be invoiced FPROZ DEC 5 2
COMP_RES OCM: Result of comparison of two order objects OCM_COMP_RES CHAR 1 0
E '=' Objects are equal
A '+' object also exists
M '-' Object missing
D '<>' Object differs from comparison object
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1 0
NULL Not changed
1 Manually changed
2 Change sales order
3 Release of change number
4 Change assembly order
5 Change number supplement
6 Change number shift
7 Direct assignment

MLST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MLST AENNR MLST MLST_MANDT AENR Change Master MANDT
MLST AENNR MLST AENNR AENR Change Master AENNR
MLST AUART_ICNW MLST AUART_ICNW T003O Order Types AUART
MLST AUART_ICNW MLST MLST_MANDT T003O Order Types CLIENT
MLST DELTE MLST MLST_MANDT T006 Units of Measurement MANDT
MLST DELTE MLST DELTE T006 Units of Measurement MSEHI
MLST INCNW_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST INCNW_SM MLST INCNW_SM TJ48 Check Table for Selection IDs SELID
MLST INCPN_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST INCPN_SM MLST INCPN_SM TJ48 Check Table for Selection IDs SELID
MLST INCSN_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST INCSN_SM MLST INCSN_SM TJ48 Check Table for Selection IDs SELID
MLST MLSTN MLST MLST_MANDT T433 Milestone Indicator MANDT
MLST MLSTN MLST MLSTN T433 Milestone Indicator MLSTN
MLST MLST_MANDT MLST MLST_MANDT T000 Clients MANDT
MLST PLNTY MLST PLNTY TCA01 Task list types PLNTY
MLST PLNTY MLST MLST_MANDT TCA01 Task list types MANDT
MLST PSPNR MLST PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
MLST PSPNR MLST MLST_MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
MLST RELMS_SM MLST RELMS_SM TJ48 Check Table for Selection IDs SELID
MLST RELMS_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST RELSU_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST RELSU_SM MLST RELSU_SM TJ48 Check Table for Selection IDs SELID
MLST SPSNR MLST MLST_MANDT PRPSS Standard WBS Element (WBS element) - Master Data MANDT
MLST SPSNR MLST SPSNR PRPSS Standard WBS Element (WBS element) - Master Data PSPNR
MLST STSMA MLST MLST_MANDT TJ20 Status profiles MANDT
MLST STSMA MLST STSMA TJ20 Status profiles STSMA
MLST WKFLW_SM MLST MLST_MANDT TJ48 Check Table for Selection IDs MANDT
MLST WKFLW_SM MLST WKFLW_SM TJ48 Check Table for Selection IDs SELID