_MAINTENANCEPLAN

44 Fields

_MAINTENANCEPLAN is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY MaintenancePlan MaintenancePlan 1
_MaintenancePlanCatParam _MaintenancePlanCatParam 2
_MaintenanceStrategy _MaintenanceStrategy 1
AuthorizationGroup AuthorizationGroup 1
BasicStartDate BasicStartDate 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Customer Customer 1
CycleModificationRatio CycleModificationRatio 1
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent 2
EarlyCompletionTolerancePct EarlyCompletionTolerancePct 2
FactoryCalendar FactoryCalendar 2
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LateCompletionShiftInPercent LateCompletionShiftInPercent 2
LateCompletionTolerancePercent LateCompletionTolerancePercent 2
MaintenanceCall MaintenanceCall 1
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType 2
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays 1
MaintenancePlanCallObject MaintenancePlanCallObject 1
MaintenancePlanCategory MaintenancePlanCategory 3
MaintenancePlanDesc MaintenancePlanDesc 13
MaintenancePlanInternalID MaintenancePlanInternalID 2
MaintenancePlanIsNotStrategy MaintenancePlanIsNotStrategy 1
MaintenancePlanType MaintenancePlanType 1
MaintenanceStrategy MaintenanceStrategy 2
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue 1
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib 1
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls 1
MaintPlanIsNotPerformanceBased MaintPlanIsNotPerformanceBased 1
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode 1
MaintPlanSchedgIndicator MaintPlanSchedgIndicator 2
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue 1
MaintPlanStatusCriticality MaintPlanStatusCriticality 1
MaintPlnStrtBufDurationInDays MaintPlnStrtBufDurationInDays 1
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor 1
NumberOfMaintenanceItems NumberOfMaintenanceItems 1
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd 2
SchedulingDuration SchedulingDuration 1
SchedulingDurationUnit SchedulingDurationUnit 1
SchedulingEndDate SchedulingEndDate 2
SchedulingStartDate SchedulingStartDate 1
SchedulingStartTime SchedulingStartTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MAINTENANCEPLAN (
    MAINTENANCEPLAN,
    _MAINTENANCEPLANCATPARAM,
    _MAINTENANCESTRATEGY,
    AUTHORIZATIONGROUP,
    BASICSTARTDATE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    CYCLEMODIFICATIONRATIO,
    EARLYCOMPLETIONSHIFTINPERCENT,
    EARLYCOMPLETIONTOLERANCEPCT,
    FACTORYCALENDAR,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LATECOMPLETIONSHIFTINPERCENT,
    LATECOMPLETIONTOLERANCEPERCENT,
    MAINTENANCECALL,
    MAINTENANCECALLHORIZONCALCTYPE,
    MAINTENANCELEADFLOATINDAYS,
    MAINTENANCEPLANCALLOBJECT,
    MAINTENANCEPLANCATEGORY,
    MAINTENANCEPLANDESC,
    MAINTENANCEPLANINTERNALID,
    MAINTENANCEPLANISNOTSTRATEGY,
    MAINTENANCEPLANTYPE,
    MAINTENANCESTRATEGY,
    MAINTPLANENDCNTRREADINGVALUE,
    MAINTPLANFREEDEFINEDATTRIB,
    MAINTPLANISLOCKEDAGAINSTCALLS,
    MAINTPLANISNOTPERFORMANCEBASED,
    MAINTPLANLOGICALOPERATORCODE,
    MAINTPLANSCHEDGINDICATOR,
    MAINTPLANSTARTCNTRREADINGVALUE,
    MAINTPLANSTATUSCRITICALITY,
    MAINTPLNSTRTBUFDURATIONINDAYS,
    MULTIPLECOUNTERPLANSHIFTFACTOR,
    NUMBEROFMAINTENANCEITEMS,
    PRDCSSRCALLOBJCOMPLTNISRQD,
    SCHEDULINGDURATION,
    SCHEDULINGDURATIONUNIT,
    SCHEDULINGENDDATE,
    SCHEDULINGSTARTDATE,
    SCHEDULINGSTARTTIME,
    PRIMARY KEY (MAINTENANCEPLAN)
);

Learn More