SAP table MLST (Milestone)

SAP table MLST has 3 primary key fields being MLST_MANDT,MLST_ZAEHL,ZAEHL.

Field Description Data Type Length Decimals Checktable Data Element
MLST_MANDT Client CLNT 3 0 T000 MANDT
MLST_ZAEHL Milestone number NUMC 12 0 MLST_ZAEHL
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
LOEKZ Deletion Indicator CHAR 1 0 LKENZ
MLSTN Usage CHAR 5 0 T433 MILESTONE
USERH Milestone created by CHAR 12 0 MLST_USERH
DATEH Milestone created on DATS 8 0 MLST_DATEH
USERV Milestone changed by CHAR 12 0 MLST_USERV
DATEV Milestone changed on DATS 8 0 MLST_DATEV
PLNNR Standard network number CHAR 8 0 CN_PLNNR
PLNTY Standard network type CHAR 1 0 TCA01 CN_PLNTY
PLNAL Alternative to a standard network CHAR 2 0 CN_PLNAL
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
AUTYP Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
PSPNR WBS Element NUMC 8 0 PRPS PS_POSNR
TEDAT Scheduled milestone date (Basic) DATS 8 0 MLST_TEDAT
TETIM Scheduled milestone time (Basic) TIMS 6 0 MLST_TETIM
TPDAT Scheduled milestone date (Forecast) DATS 8 0 MLST_TPDAT
TPTIM Scheduled milestone time (Forecast) TIMS 6 0 MLST_TPTIM
EDATU Fixed milestone date (basic) DATS 8 0 MLST_EDATU
EZEIT Fixed milestone time (Basic) TIMS 6 0 MLST_EZEIT
PDATU Fixed milestone date (F) DATS 8 0 MLST_PDATU
PZEIT Fixed milestone time (F) TIMS 6 0 MLST_PZEIT
LATED Indicator: Latest dates CHAR 1 0 MLST_LATE_CHG
DLTAS Ind: Reference for offset (start/finish activity date) CHAR 1 0 MLST_DLTAS_CHG
DELTA Offset for milestone date QUAN 5 0 MLST_DELTA
DELTE Time unit for offset of milestone date UNIT 3 0 T006 MLST_DELTE
PRCNT Percentual offset of milestone to activity date DEC 3 0 MLST_PRCNT
SDDAT Key determining the date for milestone in sales order CHAR 2 0 MLST_SDDAT
01 Date in billing schedule
KZ_TREND Milestone relevant for trend analysis CHAR 1 0 MLST_TREND_CHG
KZ_LSTWR Milestone relevant for progress analysis CHAR 1 0 MLST_LSTWR
KZ_WFLOW Indicator: Milestone is used for milestone functions CHAR 1 0 MLST_WFLOW_CHG
KZ_FAKTP Milestone is relevant for date in sales document CHAR 1 0 MLST_FAKTP
KZ_FRMST Release stop indicator CHAR 1 0 MLST_FRMST_CHG
LST_FERTG Percentage of completion (%) NUMC 3 0 MLST_FERTG
LST_ACTDT Actual date (Milestone met) DATS 8 0 MLST_ACTDT
LST_ACTTM Actual date/time (Milestone met) TIMS 6 0 MLST_ACTTM
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Internal counter NUMC 8 0 CIM_COUNT
AUART_ICNW Network type CHAR 4 0 T003O MLST_AUART
STDNR_ICNW Standard network number CHAR 8 0 CN_PLNNR
ALTNR_ICNW Alternative to a standard network CHAR 2 0 CN_PLNAL
STDNR_ICPN Standard network number CHAR 8 0 CN_PLNNR
ALTNR_ICPN Alternative to a standard network CHAR 2 0 CN_PLNAL
VORNR_ICPN Activity number in network and standard network CHAR 4 0 CN_VORNR
STDNR_ICSN Standard network number CHAR 8 0 CN_PLNNR_CHG
ALTNR_ICSN Alternative to a standard network CHAR 2 0 CN_PLNAL_CHG
OPRST_ICSN Activity preceding the standard network to be included CHAR 4 0 OPR_START
OPREN_ICSN Activity following the standard network to be included CHAR 4 0 OPR_END
TASK_ID Workflow task CHAR 14 0 MLST_TASK_CHG
RELSU Selection function CHAR 1 0 MLST_RELSU_CHG
RELMS Selection function CHAR 1 0 MLST_RELMS_CHG
INCPN Selection function CHAR 1 0 MLST_INCPN
INCNW Selection function CHAR 1 0 MLST_INCNW
INCSN Selection function CHAR 1 0 MLST_INCSN_CHG
WKFLW Selection function CHAR 1 0 MLST_WKFLW_CHG
RELSU_AL Processing stage CHAR 1 0 ACTLV
RELMS_AL Processing stage CHAR 1 0 ACTLV
INCPN_AL Processing stage CHAR 1 0 ACTLV
INCNW_AL Processing stage CHAR 1 0 ACTLV
INCSN_AL Processing stage CHAR 1 0 ACTLV
WKFLW_AL Processing stage CHAR 1 0 ACTLV
RELSU_SS Function - activated system status CHAR 5 0 SYSTA_CHG
RELMS_SS Function - activated system status CHAR 5 0 SYSTA_CHG
INCPN_SS Function - activated system status CHAR 5 0 SYSTA
INCNW_SS Function - activated system status CHAR 5 0 SYSTA
INCSN_SS Function - activated system status CHAR 5 0 SYSTA_CHG
WKFLW_SS Function - activated system status CHAR 5 0 SYSTA_CHG
RELSU_US Function - activated user status CHAR 5 0 USSTA
RELMS_US Function - activated user status CHAR 5 0 USSTA
INCPN_US Function - activated user status CHAR 5 0 USSTA
INCNW_US Function - activated user status CHAR 5 0 USSTA
INCSN_US Function - activated user status CHAR 5 0 USSTA
WKFLW_US Function - activated user status CHAR 5 0 USSTA
RELSU_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
RELMS_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
INCPN_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
INCNW_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
INCSN_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
WKFLW_SM Selection profile (status) CHAR 7 0 TJ48 SESMA
RELSU_CH Status change triggering the function CHAR 1 0 CHANG_CHG
RELMS_CH Status change triggering the function CHAR 1 0 CHANG_CHG
INCPN_CH Status change triggering the function CHAR 1 0 CHANG
INCNW_CH Status change triggering the function CHAR 1 0 CHANG
INCSN_CH Status change triggering the function CHAR 1 0 CHANG_CHG
WKFLW_CH Status change triggering the function CHAR 1 0 CHANG_CHG
RELSU_SG Ind: Function should only be executed once CHAR 1 0 SGACT_CHG
RELMS_SG Ind: Function should only be executed once CHAR 1 0 SGACT_CHG
INCPN_SG Ind: Function should only be executed once CHAR 1 0 SGACT
INCNW_SG Ind: Function should only be executed once CHAR 1 0 SGACT
INCSN_SG Ind: Function should only be executed once CHAR 1 0 SGACT_CHG
WKFLW_SG Ind: Function should only be executed once CHAR 1 0 SGACT_CHG
RELSU_TR Activate function CHAR 1 0 TRIGG_CHG
RELMS_TR Activate function CHAR 1 0 TRIGG_CHG
INCPN_TR Activate function CHAR 1 0 TRIGG
INCNW_TR Activate function CHAR 1 0 TRIGG
INCSN_TR Activate function CHAR 1 0 TRIGG_CHG
WKFLW_TR Activate function CHAR 1 0 TRIGG_CHG
BEGRU Authorization Group CHAR 4 0 BEGRU
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
SPSNR Std WBS: Internal project item number (w/exit on ID) NUMC 8 0 PRPSS PS_SPSNR
FPROZ Percentage of value to be invoiced DEC 5 2 FPROZ
COMP_RES OCM: Result of comparison of two order objects CHAR 1 0 OCM_COMP_RES
A '+' object also exists
D '<>' Object differs from comparison object
E '=' Objects are equal
M '-' Object missing
CH_PROC Process that has lead to the change of an object CHAR 1 0 OCM_CH_PROC
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
EEW_MLST_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY

MLST foreign key relationships

Table Field Check Table Check Field
0 MLST AENNR AENR Change Master AENNR
1 MLST AUART_ICNW T003O Order Types AUART
0 MLST DELTE T006 Units of Measurement MSEHI
1 MLST MLSTN T433 Milestone Indicator MANDT
0 MLST MLST_MANDT T000 Clients MANDT
1 MLST PLNTY TCA01 Task list types MANDT
0 MLST PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 MLST PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 MLST SPSNR PRPSS Standard WBS Element (WBS element) - Master Data MANDT
1 MLST SPSNR PRPSS Standard WBS Element (WBS element) - Master Data PSPNR
0 MLST STSMA TJ20 Status profiles MANDT
0 MLST STSMA TJ20 Status profiles STSMA