What is I_MaintenanceStrategyData in SAP S/4HANA?

I_MaintenanceStrategyData is a composite CDS view in SAP S/4HANA. Maintenance Strategy Data It contains 16 fields.

Which tables does I_MaintenanceStrategyData read from?

I_MaintenanceStrategyData reads data from: I_MaintenanceStrategy.

What VDM layer is I_MaintenanceStrategyData?

I_MaintenanceStrategyData is classified as a Composite view that combines data from multiple basic views.

I_MaintenanceStrategyData

DDL: I_MAINTENANCESTRATEGYDATA SQL: IMAINTSTRATDATA Type: view COMPOSITE

16 Fields 1 Data Sources

Maintenance Strategy Data

I_MaintenanceStrategyData is a Composite CDS View (Dimension) that provides data about "Maintenance Strategy Data" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceStrategy) and exposes 16 fields with key field MaintenanceStrategy.

SAP Help Documentation

Category	CDS Views for Maintenance Management
Data Category	Dimension
Status	Released
Data Extraction Type	Full (physical deletions are possible in source tables)

Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the scheduling details of the maintenance strategy? Which authorization group did you assign to the maintenance strategy? How many maintenance packages are in the maintenance strategy? What is the total cycle duration of the maintenance strategy? What is the unit of performance of the related maintenance tasks? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Prerequisites
You have authorizations to create, change, and display the relevant maintenance plans and change and display the maintenance strategies in transactions IP01 , IP02 , IP03 , IP11 , and IP12 . This check is based on the following fields: Authorization Group ( I_BEGRP ) Transaction Code ( I_TCODE )

Structure
Business Objects This view is built on the maintenance strategy business object. Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Maintenance strategy Scheduling parameters, for example Call horizon , Shift Factor for Late Completion and Shift Factor for Early Completion Authorization group Number of maintenance packages Total cycle duration Unit of performance of the maintenance tasks

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_MaintenanceStrategy	I_MaintenanceStrategy	from

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IMAINTSTRATDATA	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Maintenance Strategy Data	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	MaintenanceStrategy	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.usageType.dataClass	#ORGANIZATIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
Metadata.allowExtensions	true	view
ObjectModel.modelingPattern	#EXTRACTION_DATA_SOURCE	view
ObjectModel.sapObjectNodeType.name	MaintenanceStrategy	view

Fields (16)

Key	Field	Source Field	Description
KEY	MaintenanceStrategy	MaintenanceStrategy	Strategy Fields
	MaintenanceStrategyUnit	MaintenanceTaskPerformanceUnit	Unit
	MaintenanceStrategyCycTotDurn	MaintenanceStrategyCycTotDurn	Cycle length
	MaintPackageMinimumStepValue	MaintPackageMinimumStepValue	Smallest step
	NumberOfMaintenancePackages	NumberOfMaintenancePackages	No. packages
	LateCompletionTolerancePercent	LateCompletionTolerancePercent	Tolerance (+)
	EarlyCompletionTolerancePct	EarlyCompletionTolerancePct	Tolerance (-)
	LateCompletionShiftFactor	LateCompletionShiftInPercent	Late Completion
	EarlyCompletionShiftFactor	EarlyCompletionShiftInPercent	EarlyCompletion
	MaintStrategySchedulingCode	MaintStrategySchedulingCode	SchedIndic.
	MaintenanceCallHorizonPercent	MaintenanceCallHorizonPercent	Horizon
	MaintenanceCallHorizonCalcType	MaintenanceCallHorizonCalcType
	FactoryCalendar	FactoryCalendar	Factory Calendar
	AuthorizationGroup	AuthorizationGroup	AuthorizGroup
	_MaintenanceStrategyUnit	_MaintenanceStrategyUnit
	_FactoryCalendar	_FactoryCalendar

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_MaintenanceStrategyData.
-- 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.
-- SQL view name: IMAINTSTRATDATA

CREATE VIEW I_MaintenanceStrategyData AS
SELECT
  MaintenanceStrategy,
  MaintenanceTaskPerformanceUnit AS MaintenanceStrategyUnit,
  MaintenanceStrategyCycTotDurn,
  MaintPackageMinimumStepValue,
  NumberOfMaintenancePackages,
  LateCompletionTolerancePercent,
  EarlyCompletionTolerancePct,
  LateCompletionShiftInPercent AS LateCompletionShiftFactor,
  EarlyCompletionShiftInPercent AS EarlyCompletionShiftFactor,
  MaintStrategySchedulingCode,
  MaintenanceCallHorizonPercent,
  MaintenanceCallHorizonCalcType,
  FactoryCalendar,
  AuthorizationGroup
FROM I_MaintenanceStrategy
;

Depth:

I_MaintenanceStrategyData view

I_MaintenanceStrategy view