I_MaintPackageTextData

DDL: I_MAINTPACKAGETEXTDATA SQL: IMNTPCKGTXTDATA Type: view COMPOSITE
10 Fields 1 Data Sources 3 Associations

Maintenance Package - Text

I_MaintPackageTextData (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_MaintPackageTextData is a Composite CDS View that provides data about "Maintenance Package - Text" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePackageText) and exposes 10 fields with key fields Language, MaintenanceStrategy, MaintenancePackage. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryBasic, Text
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the description of the maintenance package in all languages? What is the description of the maintenance package hierarchy in all languages? What is the description of the maintenance package cycle in all languages? What is the description of the start offset for maintenance package in all languages? 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 display the relevant maintenance strategies in transaction 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 package text 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 description Maintenance package hierarchy description Maintenance package cycle description Language

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
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the description of the maintenance package in all languages?</p></li> <li><p>What is the description of the maintenance package hierarchy in all languages?</p></li> <li><p>What is the description of the maintenance package cycle in all languages?</p></li> <li><p>What is the description of the start offset for maintenance package in all languages?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePackageText I_MaintenancePackageText from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceStrategyData _MaintenanceStrategy _MaintenanceStrategy.MaintenanceStrategy = $projection.MaintenanceStrategy
[0..1] I_MaintenancePackageData _MaintenancePackage _MaintenancePackage.MaintenanceStrategy = $projection.MaintenanceStrategy and _MaintenancePackage.MaintenancePackage = $projection.MaintenancePackage
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (14)

NameValueLevelField
EndUserText.label Maintenance Package - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IMNTPCKGTXTDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MaintenancePackage view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
KEY MaintenancePackage MaintenancePackage Maintenance Package Number
MaintenancePackageText MaintenancePackageText Text for maintenance package/cycle (time/performance)
MaintPackageHierarchyShortText MaintPackageHierarchyShortText Short text of the maintenance package hierarchy
MaintenanceCycleShortText MaintenanceCycleShortText Short text for the maintenance cycle (time/performance)
StartOffsetShortText StartOffsetShortText Short text for the start offset (time/performance)
_Language _Language
_MaintenancePackage _MaintenancePackage
_MaintenanceStrategy _MaintenanceStrategy

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_MaintPackageTextData.
-- 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: IMNTPCKGTXTDATA

CREATE VIEW I_MaintPackageTextData AS
SELECT
  Language,
  MaintenanceStrategy,
  MaintenancePackage,
  MaintenancePackageText,
  MaintPackageHierarchyShortText,
  MaintenanceCycleShortText,
  StartOffsetShortText
FROM I_MaintenancePackageText
LEFT OUTER JOIN I_MaintenanceStrategyData AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePackageData AS _MaintenancePackage ON _MaintenancePackage.MaintenanceStrategy = MaintenanceStrategy AND _MaintenancePackage.MaintenancePackage = MaintenancePackage  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
;

Learn More