I_MaintenancePackage

DDL: I_MAINTENANCEPACKAGE SQL: IMNTPCKG Type: view BASIC
13 Fields 1 Data Sources 3 Associations

Maintenance Package

I_MaintenancePackage (Basic)

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

Maintenance Package · Asset Management

I_MaintenancePackage is a Basic CDS View that provides data about "Maintenance Package" in SAP S/4HANA. It reads from 1 data source (t351p) and exposes 13 fields with key fields MaintenanceStrategy, MaintenancePackage. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Purpose
This CDS view helps you retrieve the details of the maintenance packages in a maintenance strategy. This CDS view provides the data to answer the following business questions: Where can you see a list of maintenance packages assigned to a maintenance strategy? Where can you see the details of a maintenance package cycle for a maintenance strategy? Where can you see the details of a maintenance package lead float and follow-up float for a maintenance strategy? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: MaintenanceStrategy MaintenancePackage MaintenanceTaskPerformanceUnit MaintenancePackageCycle MaintPackageTimeStartOffset MaintenancePackageNature MaintenanceLeadFloatInDays FollowUpFloat MaintPackagePeriodType CallHorizonInDays

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-TL
CapabilitiesData Source for Data Extraction
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t351p t351p from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceStrategy _MaintenanceStrategy _MaintenanceStrategy.MaintenanceStrategy = $projection.MaintenanceStrategy
[0..*] I_MaintenancePackageText _MaintenancePackageText _MaintenancePackageText.MaintenanceStrategy = $projection.MaintenanceStrategy and _MaintenancePackageText.MaintenancePackage = $projection.MaintenancePackage
[0..1] I_UnitOfMeasure _MaintenancePackageUnit _MaintenancePackageUnit.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit

Annotations (14)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMNTPCKG view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Package view
ObjectModel.representativeKey MaintenancePackage view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name MaintenancePackage view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceStrategy strat Maintenance Strategy
KEY MaintenancePackage zaehl Maintenance Package Number
MaintenanceTaskPerformanceUnit zeieh Unit for the performance of maintenance tasks
MaintenancePackageCycle zykzt Maintenance package cycle/offset
MaintPackageTimeStartOffset offzt Start offset of a time-based maintenance package
MaintenancePackageNature hiera Nature of the maintenance packages (additional, replacement)
MaintenanceLeadFloatInDays puffp Lead Float in Days
FollowUpFloat puffn Follow-up float in days
MaintPackagePeriodType perkn Period type indicator for maintenance package
CallHorizonInDays eroef Call horizon in days (per maintenance package)
_MaintenancePackageText _MaintenancePackageText
_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_MaintenancePackage.
-- 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: IMNTPCKG

CREATE VIEW I_MaintenancePackage AS
SELECT
  strat AS MaintenanceStrategy,
  zaehl AS MaintenancePackage,
  zeieh AS MaintenanceTaskPerformanceUnit,
  zykzt AS MaintenancePackageCycle,
  offzt AS MaintPackageTimeStartOffset,
  hiera AS MaintenancePackageNature,
  puffp AS MaintenanceLeadFloatInDays,
  puffn AS FollowUpFloat,
  perkn AS MaintPackagePeriodType,
  eroef AS CallHorizonInDays
FROM t351p
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePackageText AS _MaintenancePackageText ON _MaintenancePackageText.MaintenanceStrategy = MaintenanceStrategy AND _MaintenancePackageText.MaintenancePackage = MaintenancePackage  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaintenancePackageUnit ON _MaintenancePackageUnit.UnitOfMeasure = MaintenanceTaskPerformanceUnit  -- association [0..1]
;

Learn More