MPLA

Transparent Table Application Table
51 Fields 4 CDS Views

Maintenance plan

MPLA is an SAP database table in S/4HANA. Maintenance plan. It contains 51 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_MaintenancePlan view from EXTENSION Extension View of Maintenance Plan
I_MaintenancePlan view from BASIC Maintenance Plan
I_MaintenancePlanBasic view from BASIC Maintenance Plan
I_MaintPlanCallHistory view inner BASIC Maintenance Plan Call History

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY warpl WARPL MaintenancePlan
erknz ERKNZ CreatnIndic.
aeknz AEKNZ ChngeIndic.
ersdt EDATUM Created on
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
wptxt WPTXT MaintPlanText
strat STRAT Strategy
abrho ABRHO SchedPeriod
equnr EQUNR Equipment
tplnr TPLNR Functional loc.
kunum KUNUM Customer
ltknz MPLTX L-Text Indicat.
lvorm ABSTOP Locked
anzps ANZMPOS No. items
abnum ABNUM Call Number
langu MPLANGU Language
vspos VERSCHPLUS Late Completion
vsneg VERSCHNEG EarlyCompletion
topos TOLERPLUS Tolerance (+)
toneg TOLERNEG Tolerance (-)
sfakt SFAKT CycModifFactor
stich TERMKNZ SchedIndic.
tgoon TGON FurthrSchedulng
horiz HORIZONT Call horizon
horiz_days HORIZONT Call horizon
horiz_qualifier EAM_CC_CALLHORIZON_QUALIFIER Calculation Type
andor ANDOR Operation type
knaut KNZABR Reserved
begru IAUTG AuthorizGroup
objnr J_OBJNR Object number
mptyp MPTYP MPlan cat.
hunit HUNIT SchedIntUnit
stadt STADT Cycle start
szaeh SZAEHC StrtCtrReadg
call_confirm CALL_CONFIRM Compl.Requirmnt
plan_sort PLAN_SORT Sort field
fabkl FABKL Factory Calend.
puffp PUFF_VORL Lead float
puffn PUFF_NACHL Follow-up float
dummy_mpla_incl_eew_ps CFD_DUMMY Dummy
start_date DATE_START Start Date
start_time TIME_START Start Time
call_update_ind IND_CALL_UPDATE Adapt.BasicDate
ind_mpla_api IND_MPLA_API MPlan by API
mcp_sf MCP_SF Shift Fctr MCP
enddt_for_sched EAM_ENDDT_FOR_SCHED End Date for Sched.
end_counter EAM_END_COUNTER End Counter
changeddatetime TZNTSTMPS Time Stamp

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.

-- Maintenance plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPLA (
    MANDT,                   -- Client [MANDT]
    WARPL,                   -- MaintenancePlan [WARPL]
    ERKNZ,                   -- CreatnIndic. [ERKNZ]
    AEKNZ,                   -- ChngeIndic. [AEKNZ]
    ERSDT,                   -- Created on [EDATUM]
    ERNAM,                   -- Created By [ERNAM]
    AEDAT,                   -- Changed On [AEDAT]
    AENAM,                   -- Changed By [AENAM]
    WPTXT,                   -- MaintPlanText [WPTXT]
    STRAT,                   -- Strategy [STRAT]
    ABRHO,                   -- SchedPeriod [ABRHO]
    EQUNR,                   -- Equipment [EQUNR]
    TPLNR,                   -- Functional loc. [TPLNR]
    KUNUM,                   -- Customer [KUNUM]
    LTKNZ,                   -- L-Text Indicat. [MPLTX]
    LVORM,                   -- Locked [ABSTOP]
    ANZPS,                   -- No. items [ANZMPOS]
    ABNUM,                   -- Call Number [ABNUM]
    LANGU,                   -- Language [MPLANGU]
    VSPOS,                   -- Late Completion [VERSCHPLUS]
    VSNEG,                   -- EarlyCompletion [VERSCHNEG]
    TOPOS,                   -- Tolerance (+) [TOLERPLUS]
    TONEG,                   -- Tolerance (-) [TOLERNEG]
    SFAKT,                   -- CycModifFactor [SFAKT]
    STICH,                   -- SchedIndic. [TERMKNZ]
    TGOON,                   -- FurthrSchedulng [TGON]
    HORIZ,                   -- Call horizon [HORIZONT]
    HORIZ_DAYS,              -- Call horizon [HORIZONT]
    HORIZ_QUALIFIER,         -- Calculation Type [EAM_CC_CALLHORIZON_QUALIFIER]
    ANDOR,                   -- Operation type [ANDOR]
    KNAUT,                   -- Reserved [KNZABR]
    BEGRU,                   -- AuthorizGroup [IAUTG]
    OBJNR,                   -- Object number [J_OBJNR]
    MPTYP,                   -- MPlan cat. [MPTYP]
    HUNIT,                   -- SchedIntUnit [HUNIT]
    STADT,                   -- Cycle start [STADT]
    SZAEH,                   -- StrtCtrReadg [SZAEHC]
    CALL_CONFIRM,            -- Compl.Requirmnt [CALL_CONFIRM]
    PLAN_SORT,               -- Sort field [PLAN_SORT]
    FABKL,                   -- Factory Calend. [FABKL]
    PUFFP,                   -- Lead float [PUFF_VORL]
    PUFFN,                   -- Follow-up float [PUFF_NACHL]
    DUMMY_MPLA_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    START_DATE,              -- Start Date [DATE_START]
    START_TIME,              -- Start Time [TIME_START]
    CALL_UPDATE_IND,         -- Adapt.BasicDate [IND_CALL_UPDATE]
    IND_MPLA_API,            -- MPlan by API [IND_MPLA_API]
    MCP_SF,                  -- Shift Fctr MCP [MCP_SF]
    ENDDT_FOR_SCHED,         -- End Date for Sched. [EAM_ENDDT_FOR_SCHED]
    END_COUNTER,             -- End Counter [EAM_END_COUNTER]
    CHANGEDDATETIME,         -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WARPL)
);

Learn More