MPLA

Transparent Table Application Table
42 Fields 4 CDS Views

Maintenance plan

MPLA is an SAP database table in S/4HANA. Maintenance plan. It contains 42 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 (42)

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

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]
    PRIMARY KEY (MANDT, WARPL)
);

Learn More