MLST

Transparent Table Application Table
110 Fields 3 CDS Views

Milestone

MLST is an SAP database table in S/4HANA. Milestone. It contains 110 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_ProjectMilestone view from EXTENSION Project Milestone - Extension Include View
I_Projectmilestone view from BASIC Project Milestone Details
I_ProjectMilestoneData view from BASIC Project Milestone Data

Fields (110)

KeyField Data ElementDescription DomainTypeLength
KEY mlst_mandt MANDT Client
KEY mlst_zaehl MLST_ZAEHL Milestone no.
KEY zaehl CIM_COUNT Counter
datuv DATUV Valid From
techv TECHV Tech st from
aennr AENNR Change Number
loekz LKENZ Deletion Ind.
mlstn MILESTONE Usage
userh MLST_USERH Created by
dateh MLST_DATEH Created on
userv MLST_USERV Changed by
datev MLST_DATEV Changed on
plnnr CN_PLNNR Std network
plnty CN_PLNTY Std. netwk type
plnal CN_PLNAL Alternative
plnkn PLNKN Node
autyp AUFTYP Order category
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter
pspnr PS_POSNR WBS Element
tedat MLST_TEDAT Scheduled date
tetim MLST_TETIM Time
tpdat MLST_TPDAT Scheduled date
tptim MLST_TPTIM Time
edatu MLST_EDATU Fixed date basic
ezeit MLST_EZEIT Time
pdatu MLST_PDATU Fixed date forecast
pzeit MLST_PZEIT Time
lated MLST_LATE_CHG Latest dates
dltas MLST_DLTAS_CHG Offset to fin.
delta MLST_DELTA Offset
delte MLST_DELTE Offset unit
prcnt MLST_PRCNT Offset %
sddat MLST_SDDAT Date key
kz_trend MLST_TREND_CHG Trend analysis
kz_lstwr MLST_LSTWR Prog. analysis
kz_wflow MLST_WFLOW_CHG Milestone func.
kz_faktp MLST_FAKTP Sales doc. date
kz_frmst MLST_FRMST_CHG Release stop
lst_fertg MLST_FERTG Perc of compl.
lst_actdt MLST_ACTDT Actual date
lst_acttm MLST_ACTTM Time
rueck CO_RUECK Confirmation
rmzhl CIM_COUNT Counter
auart_icnw MLST_AUART Network type
stdnr_icnw CN_PLNNR Std network
altnr_icnw CN_PLNAL Alternative
stdnr_icpn CN_PLNNR Std network
altnr_icpn CN_PLNAL Alternative
vornr_icpn CN_VORNR Activity
stdnr_icsn CN_PLNNR_CHG Std network
altnr_icsn CN_PLNAL_CHG Alternative
oprst_icsn OPR_START Prec. activity
opren_icsn OPR_END Subseq.activity
task_id MLST_TASK_CHG Task
relsu MLST_RELSU_CHG Selection func.
relms MLST_RELMS_CHG Selection func.
incpn MLST_INCPN Selection func.
incnw MLST_INCNW Selection func.
incsn MLST_INCSN_CHG Selection func.
wkflw MLST_WKFLW_CHG Selection func.
relsu_al ACTLV Process. stage
relms_al ACTLV Process. stage
incpn_al ACTLV Process. stage
incnw_al ACTLV Process. stage
incsn_al ACTLV Process. stage
wkflw_al ACTLV Process. stage
relsu_ss SYSTA_CHG System status
relms_ss SYSTA_CHG System status
incpn_ss SYSTA System status
incnw_ss SYSTA System status
incsn_ss SYSTA_CHG System status
wkflw_ss SYSTA_CHG System status
relsu_us USSTA User Status
relms_us USSTA User Status
incpn_us USSTA User Status
incnw_us USSTA User Status
incsn_us USSTA User Status
wkflw_us USSTA User Status
relsu_sm SESMA Selection prof.
relms_sm SESMA Selection prof.
incpn_sm SESMA Selection prof.
incnw_sm SESMA Selection prof.
incsn_sm SESMA Selection prof.
wkflw_sm SESMA Selection prof.
relsu_ch CHANG_CHG Status change
relms_ch CHANG_CHG Status change
incpn_ch CHANG Status change
incnw_ch CHANG Status change
incsn_ch CHANG_CHG Status change
wkflw_ch CHANG_CHG Status change
relsu_sg SGACT_CHG Execute once
relms_sg SGACT_CHG Execute once
incpn_sg SGACT Execute once
incnw_sg SGACT Execute once
incsn_sg SGACT_CHG Execute once
wkflw_sg SGACT_CHG Execute once
relsu_tr TRIGG_CHG Activate
relms_tr TRIGG_CHG Activate
incpn_tr TRIGG Activate
incnw_tr TRIGG Activate
incsn_tr TRIGG_CHG Activate
wkflw_tr TRIGG_CHG Activate
begru BEGRU AuthorizGroup
stsma J_STSMA Status Profile
spsnr PS_SPSNR Std WBS element
fproz FPROZ InvoicePercentg
comp_res OCM_COMP_RES OCM: Result of comparison of two order objects
ch_proc OCM_CH_PROC ChangeProcType
eew_mlst_ps_dummy DUMMY Dummy function in length 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Milestone
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLST (
    MLST_MANDT,         -- Client [MANDT]
    MLST_ZAEHL,         -- Milestone no. [MLST_ZAEHL]
    ZAEHL,              -- Counter [CIM_COUNT]
    DATUV,              -- Valid From [DATUV]
    TECHV,              -- Tech st from [TECHV]
    AENNR,              -- Change Number [AENNR]
    LOEKZ,              -- Deletion Ind. [LKENZ]
    MLSTN,              -- Usage [MILESTONE]
    USERH,              -- Created by [MLST_USERH]
    DATEH,              -- Created on [MLST_DATEH]
    USERV,              -- Changed by [MLST_USERV]
    DATEV,              -- Changed on [MLST_DATEV]
    PLNNR,              -- Std network [CN_PLNNR]
    PLNTY,              -- Std. netwk type [CN_PLNTY]
    PLNAL,              -- Alternative [CN_PLNAL]
    PLNKN,              -- Node [PLNKN]
    AUTYP,              -- Order category [AUFTYP]
    AUFPL,              -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,              -- Counter [CIM_COUNT]
    PSPNR,              -- WBS Element [PS_POSNR]
    TEDAT,              -- Scheduled date [MLST_TEDAT]
    TETIM,              -- Time [MLST_TETIM]
    TPDAT,              -- Scheduled date [MLST_TPDAT]
    TPTIM,              -- Time [MLST_TPTIM]
    EDATU,              -- Fixed date basic [MLST_EDATU]
    EZEIT,              -- Time [MLST_EZEIT]
    PDATU,              -- Fixed date forecast [MLST_PDATU]
    PZEIT,              -- Time [MLST_PZEIT]
    LATED,              -- Latest dates [MLST_LATE_CHG]
    DLTAS,              -- Offset to fin. [MLST_DLTAS_CHG]
    DELTA,              -- Offset [MLST_DELTA]
    DELTE,              -- Offset unit [MLST_DELTE]
    PRCNT,              -- Offset % [MLST_PRCNT]
    SDDAT,              -- Date key [MLST_SDDAT]
    KZ_TREND,           -- Trend analysis [MLST_TREND_CHG]
    KZ_LSTWR,           -- Prog. analysis [MLST_LSTWR]
    KZ_WFLOW,           -- Milestone func. [MLST_WFLOW_CHG]
    KZ_FAKTP,           -- Sales doc. date [MLST_FAKTP]
    KZ_FRMST,           -- Release stop [MLST_FRMST_CHG]
    LST_FERTG,          -- Perc of compl. [MLST_FERTG]
    LST_ACTDT,          -- Actual date [MLST_ACTDT]
    LST_ACTTM,          -- Time [MLST_ACTTM]
    RUECK,              -- Confirmation [CO_RUECK]
    RMZHL,              -- Counter [CIM_COUNT]
    AUART_ICNW,         -- Network type [MLST_AUART]
    STDNR_ICNW,         -- Std network [CN_PLNNR]
    ALTNR_ICNW,         -- Alternative [CN_PLNAL]
    STDNR_ICPN,         -- Std network [CN_PLNNR]
    ALTNR_ICPN,         -- Alternative [CN_PLNAL]
    VORNR_ICPN,         -- Activity [CN_VORNR]
    STDNR_ICSN,         -- Std network [CN_PLNNR_CHG]
    ALTNR_ICSN,         -- Alternative [CN_PLNAL_CHG]
    OPRST_ICSN,         -- Prec. activity [OPR_START]
    OPREN_ICSN,         -- Subseq.activity [OPR_END]
    TASK_ID,            -- Task [MLST_TASK_CHG]
    RELSU,              -- Selection func. [MLST_RELSU_CHG]
    RELMS,              -- Selection func. [MLST_RELMS_CHG]
    INCPN,              -- Selection func. [MLST_INCPN]
    INCNW,              -- Selection func. [MLST_INCNW]
    INCSN,              -- Selection func. [MLST_INCSN_CHG]
    WKFLW,              -- Selection func. [MLST_WKFLW_CHG]
    RELSU_AL,           -- Process. stage [ACTLV]
    RELMS_AL,           -- Process. stage [ACTLV]
    INCPN_AL,           -- Process. stage [ACTLV]
    INCNW_AL,           -- Process. stage [ACTLV]
    INCSN_AL,           -- Process. stage [ACTLV]
    WKFLW_AL,           -- Process. stage [ACTLV]
    RELSU_SS,           -- System status [SYSTA_CHG]
    RELMS_SS,           -- System status [SYSTA_CHG]
    INCPN_SS,           -- System status [SYSTA]
    INCNW_SS,           -- System status [SYSTA]
    INCSN_SS,           -- System status [SYSTA_CHG]
    WKFLW_SS,           -- System status [SYSTA_CHG]
    RELSU_US,           -- User Status [USSTA]
    RELMS_US,           -- User Status [USSTA]
    INCPN_US,           -- User Status [USSTA]
    INCNW_US,           -- User Status [USSTA]
    INCSN_US,           -- User Status [USSTA]
    WKFLW_US,           -- User Status [USSTA]
    RELSU_SM,           -- Selection prof. [SESMA]
    RELMS_SM,           -- Selection prof. [SESMA]
    INCPN_SM,           -- Selection prof. [SESMA]
    INCNW_SM,           -- Selection prof. [SESMA]
    INCSN_SM,           -- Selection prof. [SESMA]
    WKFLW_SM,           -- Selection prof. [SESMA]
    RELSU_CH,           -- Status change [CHANG_CHG]
    RELMS_CH,           -- Status change [CHANG_CHG]
    INCPN_CH,           -- Status change [CHANG]
    INCNW_CH,           -- Status change [CHANG]
    INCSN_CH,           -- Status change [CHANG_CHG]
    WKFLW_CH,           -- Status change [CHANG_CHG]
    RELSU_SG,           -- Execute once [SGACT_CHG]
    RELMS_SG,           -- Execute once [SGACT_CHG]
    INCPN_SG,           -- Execute once [SGACT]
    INCNW_SG,           -- Execute once [SGACT]
    INCSN_SG,           -- Execute once [SGACT_CHG]
    WKFLW_SG,           -- Execute once [SGACT_CHG]
    RELSU_TR,           -- Activate [TRIGG_CHG]
    RELMS_TR,           -- Activate [TRIGG_CHG]
    INCPN_TR,           -- Activate [TRIGG]
    INCNW_TR,           -- Activate [TRIGG]
    INCSN_TR,           -- Activate [TRIGG_CHG]
    WKFLW_TR,           -- Activate [TRIGG_CHG]
    BEGRU,              -- AuthorizGroup [BEGRU]
    STSMA,              -- Status Profile [J_STSMA]
    SPSNR,              -- Std WBS element [PS_SPSNR]
    FPROZ,              -- InvoicePercentg [FPROZ]
    COMP_RES,           -- OCM: Result of comparison of two order objects [OCM_COMP_RES]
    CH_PROC,            -- ChangeProcType [OCM_CH_PROC]
    EEW_MLST_PS_DUMMY,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MLST_MANDT, MLST_ZAEHL, ZAEHL)
);

Learn More