I_MaintenancePackageData

DDL: I_MAINTENANCEPACKAGEDATA SQL: IMAINTPCKGDATA Type: view COMPOSITE
12 Fields 1 Data Sources

Maintenance Package Data

I_MaintenancePackageData is a Composite CDS View (Dimension) that provides data about "Maintenance Package Data" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePackage) and exposes 12 fields with key fields MaintenanceStrategy, MaintenancePackage.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Purpose
This CDS view provides the prerequisites for answering the following business questions: Which maintenance strategy contains the maintenance package? What are the scheduling details of the maintenance package? On what level is the maintenance package in the package hierarchy? What is the unit of measurement for the maintenance tasks related to the maintenance package? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Structure
Business Objects This view is built on the maintenance package 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 package cycle Maintenance strategy Scheduling data, for example Lead Float in Days and Call horizon in days Hierarchy level Maintenance task unit of measurement

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePackage I_MaintenancePackage from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTPCKGDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Maintenance Package Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaintenancePackage view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
ObjectModel.sapObjectNodeType.name MaintenancePackage view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceStrategy MaintenanceStrategy Strategy Fields
KEY MaintenancePackage MaintenancePackage Sort pos.
MaintenanceTaskPerformanceUnit MaintenanceTaskPerformanceUnit Unit
MaintenancePackageCycle MaintenancePackageCycle Package cycle
MaintPackageTimeStartOffset MaintPackageTimeStartOffset TimeOffset
MaintenancePackageNature MaintenancePackageNature Hierarchy
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead float
FollowUpFloat FollowUpFloat Follow-up float
MaintPackagePeriodType MaintPackagePeriodType PeriodIndic.
CallHorizonInDays CallHorizonInDays Call horizon
_MaintenanceStrategy _MaintenanceStrategy
_MaintenancePackageUnit _MaintenancePackageUnit

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_MaintenancePackageData.
-- 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: IMAINTPCKGDATA

CREATE VIEW I_MaintenancePackageData AS
SELECT
  MaintenanceStrategy,
  MaintenancePackage,
  MaintenanceTaskPerformanceUnit,
  MaintenancePackageCycle,
  MaintPackageTimeStartOffset,
  MaintenancePackageNature,
  MaintenanceLeadFloatInDays,
  FollowUpFloat,
  MaintPackagePeriodType,
  CallHorizonInDays
FROM I_MaintenancePackage
;

Learn More