| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MLST_MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | AUTYP | Order category | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AUFTYP | Allow NULL? |
| 3 | MLST_SMLNR | Name of standard milestone | nvarchar | 10 | 0 | CHAR | (N' ') | No | | MLST_SMLNR | Allow NULL? |
| 4 | MLSET | Milestone group | nvarchar | 10 | 0 | CHAR | (N' ') | No | SMLG | MLSET | Allow NULL? |
| 5 | MLSTN | Usage | nvarchar | 5 | 0 | CHAR | (N' ') | No | T433 | MILESTONE | Allow NULL? |
| 6 | USERH | Standard milestone created by | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SMLS_USERH | Allow NULL? |
| 7 | DATEH | Standard milestone created on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SMLS_DATEH | Allow NULL? |
| 8 | USERV | Standard milestone changed by | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SMLS_USERV | Allow NULL? |
| 9 | DATEV | Standard milestone changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SMLS_DATEV | Allow NULL? |
| 10 | LST_FERTG | Percentage of completion (%) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SMLS_FERTG | Allow NULL? |
| 11 | LATED | Indicator: Latest dates | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_LATE | Allow NULL? |
| 12 | DLTAS | Ind: Offset for time interval (start/finish activity date) | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_DLTAS | Allow NULL? |
| 13 | DELTA | Offset between standard milestone and activity dates | decimal | 5 | 0 | QUAN | ((0)) | No | | SMLS_DELTA | |
| 14 | DELTE | Unit for time interval std. milestone/activity date | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | SMLS_DELTE | Allow NULL? |
| 15 | PRCNT | Time interval in percentage std. milestone/activity date | decimal | 3 | 0 | DEC | ((0)) | No | | SMLS_PRCNT | |
| 16 | SDDAT | Key that determines the date for milestone in sales order | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SMLS_SDDAT | Allow NULL? |
| 17 | KZ_LSTWR | Indicator: Milestone relevant for progress analysis | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_LSTWR | Allow NULL? |
| 18 | KZ_WFLOW | Indicator: Milestone is used for milestone functions | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_WFLOW | Allow NULL? |
| 19 | KZ_FAKTP | Indicator: Milestone is relevant for date in sales document | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_FAKTP | Allow NULL? |
| 20 | KZ_FRMST | Milestone: Release stop indicator | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_FRMST | Allow NULL? |
| 21 | RELSU | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_RELSU | Allow NULL? |
| 22 | RELMS | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_RELMS | Allow NULL? |
| 23 | INCPN | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_INCPN | Allow NULL? |
| 24 | INCNW | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_INCNW | Allow NULL? |
| 25 | INCSN | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_INCSN | Allow NULL? |
| 26 | WKFLW | Selection function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_WKFLW | Allow NULL? |
| 27 | RELSU_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 28 | RELMS_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 29 | INCPN_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 30 | INCNW_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 31 | INCSN_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 32 | WKFLW_SS | Function - activated system status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | SYSTA | Allow NULL? |
| 33 | RELSU_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 34 | RELMS_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 35 | INCPN_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 36 | INCNW_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 37 | INCSN_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 38 | WKFLW_SM | Selection profile for standard milestone status | nvarchar | 7 | 0 | CHAR | (N' ') | No | TJ48 | SMLS_SESMA | Allow NULL? |
| 39 | RELSU_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 40 | RELMS_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 41 | INCPN_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 42 | INCNW_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 43 | INCSN_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 44 | WKFLW_CH | Status change triggering the function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_CHANG | Allow NULL? |
| 45 | RELSU_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 46 | RELMS_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 47 | INCPN_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 48 | INCNW_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 49 | INCSN_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 50 | WKFLW_SG | Ind: Function should only be executed once | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_SGACT | Allow NULL? |
| 51 | RELSU_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 52 | RELMS_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 53 | INCPN_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 54 | INCNW_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 55 | INCSN_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 56 | WKFLW_TR | Activate function | char | 1 | 0 | CHAR | (N' ') | No | | SMLS_TRIGG | Allow NULL? |
| 57 | RELSU_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 58 | RELMS_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 59 | INCPN_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 60 | INCNW_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 61 | INCSN_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 62 | WKFLW_US | Function - activated user status | nvarchar | 5 | 0 | CHAR | (N' ') | No | | USSTA | Allow NULL? |
| 63 | AUART_ICNW | Network type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | MLST_AUART | Allow NULL? |
| 64 | STDNR_ICNW | Standard network number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | CN_PLNNR | Allow NULL? |
| 65 | ALTNR_ICNW | Alternative to a standard network | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CN_PLNAL | Allow NULL? |
| 66 | STDNR_ICPN | Standard network number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | CN_PLNNR | Allow NULL? |
| 67 | ALTNR_ICPN | Alternative to a standard network | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CN_PLNAL | Allow NULL? |
| 68 | VORNR_ICPN | Activity number in network and standard network | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CN_VORNR | Allow NULL? |
| 69 | STDNR_ICSN | Standard network number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | CN_PLNNR | Allow NULL? |
| 70 | ALTNR_ICSN | Alternative to a standard network | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CN_PLNAL | Allow NULL? |
| 71 | OPRST_ICSN | Activity preceding the standard network to be included | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OPR_START | Allow NULL? |
| 72 | OPREN_ICSN | Activity following the standard network to be included | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OPR_END | Allow NULL? |
| 73 | TASK_ID | Workflow task | nvarchar | 14 | 0 | CHAR | (N' ') | No | | MLST_TASK | Allow NULL? |
| 74 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | No | | BEGRU | Allow NULL? |
| 75 | STSMA | Status Profile | nvarchar | 8 | 0 | CHAR | (N' ') | No | TJ20 | J_STSMA | Allow NULL? |
| 76 | FPROZ | Percentage of value to be invoiced | decimal | 5 | 2 | DEC | ((0)) | Yes | | FPROZ | |
| 77 | KZ_TREND | Indicator: Milestone relevant for trend analysis | char | 1 | 0 | CHAR | (N' ') | Yes | | SMLS_TREND | Allow NULL? |
