R_MaintPlanToMaintItemTP

DDL: R_MAINTPLANTOMAINTITEMTP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
R_MaintenanceItemTP R_MaintenanceItemTP from

Associations (2)

CardinalityTargetAliasCondition
[1] R_MaintenanceItemTP _MaintenanceItemEdit $projection.MaintenanceItemForEdit = _MaintenanceItemEdit.MaintenanceItem
[1] R_MaintenanceItemTextTP _MaintenanceItemText $projection.MaintenanceItemForEdit = _MaintenanceItemText.MaintenanceItem and _MaintenanceItemText.Language = $session.system_language

Annotations (8)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/