I_MaintenancePlanSituation

DDL: I_MAINTENANCEPLANSITUATION Type: view_entity COMPOSITE
44 Fields 1 Data Sources 2 Associations

Situation Handling Maint Plan Header

I_MaintenancePlanSituation (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Asset Management

I_MaintenancePlanSituation is a Composite CDS View that provides data about "Situation Handling Maint Plan Header" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanBasic) and exposes 44 fields with key field MaintenancePlan. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-MP
CapabilitiesData Structure
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanBasic _MaintenancePlanBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintenancePlanStatus _MaintPlanActiveSystemStatus $projection.MaintenancePlan = _MaintPlanActiveSystemStatus.MaintenancePlan -- Extensions, do not expose as association:
[0..1] E_MaintenancePlan _MaintenancePlanExtension $projection.MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Situation Handling Maint Plan Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #DATA_STRUCTURE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MPN view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 5000 view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan Maintenance Plan
MaintenancePlanDesc MaintenancePlanDesc Maintenance Plan Description
CreationDate CreationDate Date of creation
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
SchedulingDuration SchedulingDuration Scheduling Duration
Customer Customer Customer Number
NumberOfMaintenanceItems NumberOfMaintenanceItems Number of maintenance items in the maintenance plan
CycleModificationRatio CycleModificationRatio Cycle Modification Factor
MaintPlanSchedgIndicator MaintPlanSchedgIndicator Scheduling Indicator
CallHorizonPercent CallHorizonPercent Call horizon for maintenance plan calls
CallHorizonInDays CallHorizonInDays Call horizon for maintenance plan calls
AuthorizationGroup AuthorizationGroup Technical Object Authorization Group
MaintenanceCall MaintenanceCall Maintenance Plan Call Number
MaintenancePlanCategory MaintenancePlanCategory Maintenance plan category
SchedulingDurationUnit SchedulingDurationUnit Unit for Scheduling Period
BasicStartDate BasicStartDate Start Date
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib Sort field for maintenance plans
FactoryCalendar FactoryCalendar Factory calendar key
LateCompletionShiftInPercent LateCompletionShiftInPercent Shift Factor for Late Completion
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent Shift Factor for Early Completion
LateCompletionTolerancePercent LateCompletionTolerancePercent Tolerance for Late Completion (%)
EarlyCompletionTolerancePct EarlyCompletionTolerancePct Tolerance for Early Completion (%)
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType Calculation Type of Call Horizon
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode Indicator for OR or AND link
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor Shift Factor for Multiple Counter Plan
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue Start Counter Reading for Scheduling
SchedulingStartDate SchedulingStartDate Start Date for Scheduling
SchedulingStartTime SchedulingStartTime Start Time for Scheduling
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue End Counter Reading for Scheduling
SchedulingEndDate SchedulingEndDate End Date for Scheduling
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead Float in Days
MaintPlnStrtBufDurationInDays MaintPlnStrtBufDurationInDays Scheduling to reoccur when lead float reached
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd Only Create New Call Object After Completing Predecessor
MaintenancePlanHasLongText MaintenancePlanHasLongText Maintenance Plan has Long Text
Language Language Language key of the long text
MaintenancePlanInternalID MaintenancePlanInternalID Maintenance Plan Internal ID
MaintPlanStartBufferUnit MaintPlanStartBufferUnit Unit for Scheduling Period
MaintenancePlanCallObject MaintenancePlanCallObject Call Object for Maintenance Plan
LastChangeDateTime LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls Indicator: maintenance plan locked against calls
_MaintenancePlanCatParam _MaintenancePlanCatParam

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaintenancePlanSituation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MaintenancePlanSituation AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  SchedulingDuration,
  Customer,
  NumberOfMaintenanceItems,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  AuthorizationGroup,
  MaintenanceCall,
  MaintenancePlanCategory,
  SchedulingDurationUnit,
  BasicStartDate,
  MaintPlanFreeDefinedAttrib,
  FactoryCalendar,
  LateCompletionShiftInPercent,
  EarlyCompletionShiftInPercent,
  LateCompletionTolerancePercent,
  EarlyCompletionTolerancePct,
  MaintenanceCallHorizonCalcType,
  MaintPlanLogicalOperatorCode,
  MultipleCounterPlanShiftFactor,
  MaintPlanStartCntrReadingValue,
  SchedulingStartDate,
  SchedulingStartTime,
  MaintPlanEndCntrReadingValue,
  SchedulingEndDate,
  MaintenanceLeadFloatInDays,
  MaintPlnStrtBufDurationInDays,
  PrdcssrCallObjCompltnIsRqd,
  MaintenancePlanHasLongText,
  Language,
  MaintenancePlanInternalID,
  MaintPlanStartBufferUnit,
  MaintenancePlanCallObject,
  LastChangeDateTime,
  MaintPlanIsLockedAgainstCalls
FROM I_MaintenancePlanBasic AS _MaintenancePlanBasic
LEFT OUTER JOIN I_MaintenancePlanStatus AS _MaintPlanActiveSystemStatus ON MaintenancePlan = _MaintPlanActiveSystemStatus.MaintenancePlan  -- association [1..1]
LEFT OUTER JOIN E_MaintenancePlan AS _MaintenancePlanExtension ON MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan  -- association [0..1]
;

Learn More