1. Home
  2. Resources
  3. SAP Tables
  4. SMLS - Standard milestone

SAP Table SMLS

Standard milestone

SMLS (Standard 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 SMLS to other SAP tables.

SMLS table fields

Field Data element Checktable Datatype Length Decimals
MLST_MANDT Client MANDT T000 CLNT 3 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
MLST_SMLNR Name of standard milestone MLST_SMLNR CHAR 10 0
MLSET Milestone group MLSET SMLG CHAR 10 0
MLSTN Usage MILESTONE T433 CHAR 5 0
USERH Standard milestone created by SMLS_USERH CHAR 12 0
DATEH Standard milestone created on SMLS_DATEH DATS 8 0
USERV Standard milestone changed by SMLS_USERV CHAR 12 0
DATEV Standard milestone changed on SMLS_DATEV DATS 8 0
LST_FERTG Percentage of completion (%) SMLS_FERTG NUMC 3 0
0
LATED Indicator: Latest dates SMLS_LATE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DLTAS Ind: Offset for time interval (start/finish activity date) SMLS_DLTAS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DELTA Offset between standard milestone and activity dates SMLS_DELTA QUAN 5 0
DELTE Unit for time interval std. milestone/activity date SMLS_DELTE T006 UNIT 3 0
PRCNT Time interval in percentage std. milestone/activity date SMLS_PRCNT DEC 3 0
SDDAT Key that determines the date for milestone in sales order SMLS_SDDAT CHAR 2 0
01 Date in billing schedule
KZ_LSTWR Indicator: Milestone relevant for progress analysis SMLS_LSTWR CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_WFLOW Indicator: Milestone is used for milestone functions SMLS_WFLOW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_FAKTP Indicator: Milestone is relevant for date in sales document SMLS_FAKTP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZ_FRMST Milestone: Release stop indicator SMLS_FRMST CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELSU Selection function SMLS_RELSU CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELMS Selection function SMLS_RELMS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCPN Selection function SMLS_INCPN CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCNW Selection function SMLS_INCNW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCSN Selection function SMLS_INCSN CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
WKFLW Selection function SMLS_WKFLW CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
RELMS_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
INCPN_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
INCNW_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
INCSN_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
WKFLW_SM Selection profile for standard milestone status SMLS_SESMA TJ48 CHAR 7 0
RELSU_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
RELMS_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCPN_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCNW_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
INCSN_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
WKFLW_CH Status change triggering the function SMLS_CHANG CHAR 1 0
- Reset status
+ Status set
* Status set and reset
RELSU_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELMS_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCPN_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCNW_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCSN_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
WKFLW_SG Ind: Function should only be executed once SMLS_SGACT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RELSU_TR Activate function SMLS_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 SMLS_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 SMLS_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 SMLS_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 SMLS_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 SMLS_TRIGG CHAR 1 0
NULL Function is activated by status
1 Function is only activated manually
2 Function is activated by status and manually
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
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
BEGRU Authorization Group BEGRU CHAR 4 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
FPROZ Percentage of value to be invoiced FPROZ DEC 5 2
KZ_TREND Indicator: Milestone relevant for trend analysis SMLS_TREND CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

SMLS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SMLS AUART_ICNW SMLS MLST_MANDT T003O Order Types CLIENT
SMLS AUART_ICNW SMLS AUART_ICNW T003O Order Types AUART
SMLS DELTE SMLS MLST_MANDT T006 Units of Measurement MANDT
SMLS DELTE SMLS DELTE T006 Units of Measurement MSEHI
SMLS INCNW_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS INCNW_SM SMLS INCNW_SM TJ48 Check Table for Selection IDs SELID
SMLS INCPN_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS INCPN_SM SMLS INCPN_SM TJ48 Check Table for Selection IDs SELID
SMLS INCSN_SM SMLS INCSN_SM TJ48 Check Table for Selection IDs SELID
SMLS INCSN_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS MLSET SMLS AUTYP SMLG Standard milestone group AUTYP
SMLS MLSET SMLS MLSET SMLG Standard milestone group MLSET
SMLS MLSET SMLS MLST_MANDT SMLG Standard milestone group MANDT
SMLS MLSTN SMLS MLST_MANDT T433 Milestone Indicator MANDT
SMLS MLSTN SMLS MLSTN T433 Milestone Indicator MLSTN
SMLS MLST_MANDT SMLS MLST_MANDT T000 Clients MANDT
SMLS RELMS_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS RELMS_SM SMLS RELMS_SM TJ48 Check Table for Selection IDs SELID
SMLS RELSU_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS RELSU_SM SMLS RELSU_SM TJ48 Check Table for Selection IDs SELID
SMLS STSMA SMLS MLST_MANDT TJ20 Status profiles MANDT
SMLS STSMA SMLS STSMA TJ20 Status profiles STSMA
SMLS WKFLW_SM SMLS MLST_MANDT TJ48 Check Table for Selection IDs MANDT
SMLS WKFLW_SM SMLS WKFLW_SM TJ48 Check Table for Selection IDs SELID