R_MaintPlanToMaintItemTP
Maintenance Items in a Maintenance Plan
R_MaintPlanToMaintItemTP is a Transactional CDS View that provides data about "Maintenance Items in a Maintenance Plan" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceItemTP) and exposes 38 fields with key fields MaintenancePlan, MaintenanceItem. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_MaintenanceItemTP | R_MaintenanceItemTP | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1] | R_MaintenanceItemTP | _MaintenanceItemEdit | $projection.MaintenanceItemForEdit = _MaintenanceItemEdit.MaintenanceItem |
| [1] | R_MaintenanceItemTextTP | _MaintenanceItemText | $projection.MaintenanceItemForEdit = _MaintenanceItemText.MaintenanceItem and _MaintenanceItemText.Language = $session.system_language |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Maintenance Items in a Maintenance Plan | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.modelingPattern | #TRANSACTIONAL_ENTITY | view |
Fields (38)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenancePlan | MaintenancePlan | ||
| KEY | MaintenanceItem | MaintenanceItem | ||
| MaintenanceItemForEdit | MaintenanceItem | |||
| MaintenancePlanCategory | _MaintenancePlan | MaintenancePlanCategory | ||
| MaintenanceStrategy | MaintenanceStrategy | |||
| MaintenanceItemLongText | _MaintenanceItemText | MaintenanceItemLongText | ||
| MaintenanceItemDescription | MaintenanceItemDescription | |||
| TechnicalObjectLabel | TechnicalObjectLabel | |||
| TechObjIsEquipOrFuncnlLoc | TechObjIsEquipOrFuncnlLoc | |||
| FunctionalLocationLabelName | FunctionalLocationLabelName | |||
| FunctionalLocation | FunctionalLocation | |||
| Equipment | Equipment | |||
| SerialNumber | SerialNumber | |||
| MaintenanceItemReferenceObject | MaintenanceItemReferenceObject | |||
| MaintenanceOrderType | MaintenanceOrderType | |||
| NotificationType | NotificationType | |||
| Assembly | Assembly | |||
| MaintItemRefObjectDescription | MaintItemRefObjectDescription | |||
| MaintItemReferenceObjectType | MaintItemReferenceObjectType | |||
| MaintItemRefObjTypeForService | MaintItemRefObjTypeForService | |||
| TaskList | TaskList | |||
| TaskListType | TaskListType | |||
| TaskListGroup | TaskListGroup | |||
| TaskListGroupCounter | TaskListGroupCounter | |||
| ServiceContract | ServiceContract | |||
| ServiceContractItem | ServiceContractItem | |||
| ServiceOrderTemplate | ServiceOrderTemplate | |||
| LastChangeDateTime | LastChangeDateTime | |||
| _MaintenancePlan | _MaintenancePlan | |||
| _MaintenanceItemEdit | _MaintenanceItemEdit | |||
| _MaintenanceItemCause | _MaintenanceItemCause | |||
| _MaintenanceItemText | _MaintenanceItemText | |||
| _MaintenancePlanCatParam | _MaintenancePlan | _MaintenancePlanCatParam | ||
| _FunctionalLocationText | _FunctionalLocationText | |||
| _EquipmentText | _EquipmentText | |||
| _ReferenceObjectTypeText | _ReferenceObjectTypeText | |||
| _RefObjectTypeForSrvcText | _RefObjectTypeForSrvcText | |||
| _ServiceContract | _ServiceContract |
@EndUserText.label: 'Maintenance Items in a Maintenance Plan'
@AccessControl.authorizationCheck: #CHECK
@VDM: {
usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel : {
usageType : {
dataClass: #TRANSACTIONAL,
serviceQuality: #X,
sizeCategory: #XL
},
modelingPattern: #TRANSACTIONAL_ENTITY,
supportedCapabilities: [ #TRANSACTIONAL_PROVIDER ]
}
define view entity R_MaintPlanToMaintItemTP
as select from R_MaintenanceItemTP
association to parent R_MaintenancePlanTP as _MaintenancePlan on $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
association [1] to R_MaintenanceItemTP as _MaintenanceItemEdit on $projection.MaintenanceItemForEdit = _MaintenanceItemEdit.MaintenanceItem
association [1] to R_MaintenanceItemTextTP as _MaintenanceItemText on $projection.MaintenanceItemForEdit = _MaintenanceItemText.MaintenanceItem and
_MaintenanceItemText.Language = $session.system_language
{
key MaintenancePlan,
key MaintenanceItem,
@ObjectModel.editableFieldFor: 'MaintenanceItem'
MaintenanceItem as MaintenanceItemForEdit,
_MaintenancePlan.MaintenancePlanCategory as MaintenancePlanCategory,
MaintenanceStrategy,
_MaintenanceItemText.MaintenanceItemLongText,
MaintenanceItemDescription,
TechnicalObjectLabel,
TechObjIsEquipOrFuncnlLoc,
FunctionalLocationLabelName,
FunctionalLocation,
Equipment,
SerialNumber,
MaintenanceItemReferenceObject,
MaintenanceOrderType,
NotificationType,
Assembly,
MaintItemRefObjectDescription,
MaintItemReferenceObjectType,
MaintItemRefObjTypeForService,
TaskList,
TaskListType,
TaskListGroup,
TaskListGroupCounter,
ServiceContract,
ServiceContractItem,
ServiceOrderTemplate,
LastChangeDateTime,
_MaintenancePlan,
_MaintenanceItemEdit,
_MaintenanceItemCause,
_MaintenanceItemText,
_MaintenancePlan._MaintenancePlanCatParam,
//Associations
_FunctionalLocationText,
_EquipmentText,
_ReferenceObjectTypeText,
_RefObjectTypeForSrvcText,
_ServiceContract
} where MaintenancePlan is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_MAINTENANCEITEMTEXTTP",
"R_MAINTENANCEITEMTP",
"R_MAINTENANCEPLANTP"
],
"ASSOCIATED":
[
"I_EQUIPMENTTEXT",
"I_FUNCTIONALLOCATIONTEXT",
"I_MAINTENANCEPLANCATPARAM",
"I_MAINTITEMREFOBJECTTYPETEXT",
"I_MAINTITMREFOBJTYPEFORSRVCTXT",
"I_SERVICEDOCUMENT",
"R_MAINTENANCEITEMCAUSETP",
"R_MAINTENANCEITEMTEXTTP",
"R_MAINTENANCEITEMTP",
"R_MAINTENANCEPLANTP"
],
"BASE":
[
"R_MAINTENANCEITEMTP",
"R_MAINTENANCEPLANTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA