_MAINTENANCEPLAN

44 Fields

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

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AuthorizationGroup AuthorizationGroup 2
KEY FactoryCalendar FactoryCalendar 3
KEY MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType 3
KEY MaintenancePlan MaintenancePlan 1
KEY MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib 3
KEY MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode 2
KEY MaintPlanSchedgIndicator MaintPlanSchedgIndicator 3
KEY SchedulingDurationUnit SchedulingDurationUnit 2
_MaintenancePlanCatParam _MaintenancePlanCatParam 2
_MaintenanceStrategy _MaintenanceStrategy 1
BasicStartDate BasicStartDate 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Customer Customer 1
CycleModificationRatio CycleModificationRatio 1
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent 2
EarlyCompletionTolerancePct EarlyCompletionTolerancePct 2
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LateCompletionShiftInPercent LateCompletionShiftInPercent 2
LateCompletionTolerancePercent LateCompletionTolerancePercent 2
MaintenanceCall MaintenanceCall 1
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays 1
MaintenancePlanCallObject MaintenancePlanCallObject 1
MaintenancePlanCategory MaintenancePlanCategory 3
MaintenancePlanDesc MaintenancePlanDesc 12
MaintenancePlanInternalID MaintenancePlanInternalID 2
MaintenancePlanIsNotStrategy MaintenancePlanIsNotStrategy 1
MaintenancePlanType MaintenancePlanType 1
MaintenanceStrategy MaintenanceStrategy 2
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue 1
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls 1
MaintPlanIsNotPerformanceBased MaintPlanIsNotPerformanceBased 1
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue 1
MaintPlanStatusCriticality MaintPlanStatusCriticality 1
MaintPlnStrtBufDurationInDays MaintPlnStrtBufDurationInDays 1
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor 1
NumberOfMaintenanceItems NumberOfMaintenanceItems 1
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd 2
SchedulingDuration SchedulingDuration 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 (
    AUTHORIZATIONGROUP,
    FACTORYCALENDAR,
    MAINTENANCECALLHORIZONCALCTYPE,
    MAINTENANCEPLAN,
    MAINTPLANFREEDEFINEDATTRIB,
    MAINTPLANLOGICALOPERATORCODE,
    MAINTPLANSCHEDGINDICATOR,
    SCHEDULINGDURATIONUNIT,
    _MAINTENANCEPLANCATPARAM,
    _MAINTENANCESTRATEGY,
    BASICSTARTDATE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    CYCLEMODIFICATIONRATIO,
    EARLYCOMPLETIONSHIFTINPERCENT,
    EARLYCOMPLETIONTOLERANCEPCT,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LATECOMPLETIONSHIFTINPERCENT,
    LATECOMPLETIONTOLERANCEPERCENT,
    MAINTENANCECALL,
    MAINTENANCELEADFLOATINDAYS,
    MAINTENANCEPLANCALLOBJECT,
    MAINTENANCEPLANCATEGORY,
    MAINTENANCEPLANDESC,
    MAINTENANCEPLANINTERNALID,
    MAINTENANCEPLANISNOTSTRATEGY,
    MAINTENANCEPLANTYPE,
    MAINTENANCESTRATEGY,
    MAINTPLANENDCNTRREADINGVALUE,
    MAINTPLANISLOCKEDAGAINSTCALLS,
    MAINTPLANISNOTPERFORMANCEBASED,
    MAINTPLANSTARTCNTRREADINGVALUE,
    MAINTPLANSTATUSCRITICALITY,
    MAINTPLNSTRTBUFDURATIONINDAYS,
    MULTIPLECOUNTERPLANSHIFTFACTOR,
    NUMBEROFMAINTENANCEITEMS,
    PRDCSSRCALLOBJCOMPLTNISRQD,
    SCHEDULINGDURATION,
    SCHEDULINGENDDATE,
    SCHEDULINGSTARTDATE,
    SCHEDULINGSTARTTIME,
    PRIMARY KEY (AUTHORIZATIONGROUP, FACTORYCALENDAR, MAINTENANCECALLHORIZONCALCTYPE, MAINTENANCEPLAN, MAINTPLANFREEDEFINEDATTRIB, MAINTPLANLOGICALOPERATORCODE, MAINTPLANSCHEDGINDICATOR, SCHEDULINGDURATIONUNIT)
);

Learn More