P_MaintenanceItemSearch

DDL: P_MAINTENANCEITEMSEARCH SQL: PMAINITEMSEARCH Type: view COMPOSITE

P_MaintenanceItemSearch is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItem) and exposes 75 fields with key field MaintenanceItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItem I_MaintenanceItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.MaintenanceItem = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'MPOS' and _LongText.TextObjectType = 'LTXT'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMAINITEMSEARCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MaintenanceItem view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
MaintenancePlannerGroup MaintenancePlannerGroup
MaintenancePlanningPlant MaintenancePlanningPlant
BusinessArea BusinessArea
MainWorkCenterInternalID MainWorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
TaskListType TaskListType
TaskListGroup TaskListGroup
TaskListGroupCounter TaskListGroupCounter
Equipment Equipment
Assembly Assembly
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
MaintenanceItemDescription MaintenanceItemDescription
MaintenancePlan MaintenancePlan
MaintenancePlanItemPosition MaintenancePlanItemPosition
MaintenanceStrategy MaintenanceStrategy
MaintenancePlanCategory MaintenancePlanCategory
NotificationType NotificationType
MaintenanceNotification MaintenanceNotification
MaintPriorityType MaintPriorityType
MaintPriority MaintPriority
MaintenanceOrder MaintenanceOrder
MaintenanceActivityType MaintenanceActivityType
MaintenanceOrderType MaintenanceOrderType
SerialNumber SerialNumber
Material Material
MaintenanceItemObjectList MaintenanceItemObjectList
OperationSystemCondition OperationSystemCondition
MaintenanceItemIsInactive MaintenanceItemIsInactive
ObjectInternalID ObjectInternalID
MaintObjectCategory MaintObjectCategory
SalesDocument SalesDocument
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
SettlementOrder SettlementOrder
LastChangeDateTime LastChangeDateTime
ImmediateReleaseIsBlocked ImmediateReleaseIsBlocked
CycleSetSequence CycleSetSequence
ReferenceElement ReferenceElement
MaintenancePlanCallObject MaintenancePlanCallObject
_BusinessArea _BusinessArea
_Equipment _Equipment
_LocationAccountAssignment _LocationAccountAssignment
_MaintenanceActivityType _MaintenanceActivityType
_MaintenanceItemObject _MaintenanceItemObject
_MaintenanceNotification _MaintenanceNotification
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderType _MaintenanceOrderType
_MaintenancePlan _MaintenancePlan
_MaintenancePlanCatParam _MaintenancePlanCatParam
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenanceStrategy _MaintenanceStrategy
_MaintenanceTaskList _MaintenanceTaskList
_MaintOperationSystCondition _MaintOperationSystCondition
_MaintOrderTypeControlParam _MaintOrderTypeControlParam
_MainWorkCenter _MainWorkCenter
_Material _Material
_PMNotificationPriority _PMNotificationPriority
_PMNotificationPriorityType _PMNotificationPriorityType
_PMNotificationType _PMNotificationType
_PMReferenceElement _PMReferenceElement
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_SalesDocument _SalesDocument
_SettlementOrder _SettlementOrder
_TaskListGroup _TaskListGroup
_TaskListGroupCounter _TaskListGroupCounter
_TaskListType _TaskListType
_WorkCenterType _WorkCenterType
_LongText _LongText
//Anchor View for Maintenance  Item Search CDS Search Model

@AbapCatalog.sqlViewName: 'PMAINITEMSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MaintenanceItem'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintenanceItemSearch as select from I_MaintenanceItem
association [0..*] to I_TextObjectPlainLongText                    as _LongText          on  $projection.MaintenanceItem = _LongText.TextObjectKey
                                                                                         and _LongText.TextObjectCategory = 'MPOS'
                                                                                         and _LongText.TextObjectType = 'LTXT'
{
   //I_MaintenanceItem 

   key MaintenanceItem, 
   MaintObjectLocAcctAssgmtNmbr, 
   MaintenancePlannerGroup, 
   MaintenancePlanningPlant, 
   BusinessArea, 
   MainWorkCenterInternalID, 
   WorkCenterTypeCode, 
   TaskListType, 
   TaskListGroup, 
   TaskListGroupCounter, 
   Equipment, 
   Assembly, 
   CreationDate, 
   CreatedByUser, 
   LastChangeDate, 
   LastChangedByUser, 
   MaintenanceItemDescription, 
   MaintenancePlan, 
   MaintenancePlanItemPosition, 
   MaintenanceStrategy, 
   MaintenancePlanCategory, 
   NotificationType, 
   MaintenanceNotification, 
   MaintPriorityType, 
   MaintPriority, 
   MaintenanceOrder, 
   MaintenanceActivityType, 
   MaintenanceOrderType, 
   SerialNumber, 
   Material, 
   MaintenanceItemObjectList, 
   OperationSystemCondition, 
   MaintenanceItemIsInactive, 
   ObjectInternalID, 
   MaintObjectCategory, 
   SalesDocument, 
   PurchaseOrder, 
   PurchaseOrderItem, 
   SettlementOrder, 
   LastChangeDateTime, 
   ImmediateReleaseIsBlocked, 
   CycleSetSequence, 
   ReferenceElement, 
   //added CE2008

   MaintenancePlanCallObject, 
   /* Associations */ 
   //I_MaintenanceItem 

//   _Assembly, //Association to I_Material

   _BusinessArea, 
   _Equipment, 
   _LocationAccountAssignment, 
   _MaintenanceActivityType, 
   _MaintenanceItemObject, 
   _MaintenanceNotification, 
   _MaintenanceOrder, 
   _MaintenanceOrderType, 
   _MaintenancePlan, 
   //_MaintenancePlanBasic,

   _MaintenancePlanCatParam, 
   _MaintenancePlannerGroup, 
   _MaintenancePlanningPlant, 
   _MaintenanceStrategy, 
   _MaintenanceTaskList, 
   _MaintOperationSystCondition, 
   _MaintOrderTypeControlParam, 
   _MainWorkCenter, 
   _Material, 
   _PMNotificationPriority, 
   _PMNotificationPriorityType, 
   _PMNotificationType, 
   _PMReferenceElement, 
   _PurchaseOrder, 
   _PurchaseOrderItem, 
   _SalesDocument, 
   _SettlementOrder, 
   _TaskListGroup, 
   _TaskListGroupCounter, 
   _TaskListType, 
   _WorkCenterType,
   _LongText 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEITEM"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BUSINESSAREA",
"I_EQUIPMENT",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEACTIVITYTYPE",
"I_MAINTENANCEITEMOBJECT",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDER",
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANCATPARAM",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCESTRATEGY",
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTTYPE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERTYPECONTROLPARAM",
"I_MATERIAL",
"I_ORDER",
"I_ORDERTYPE",
"I_PLANT",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTYPE",
"I_PMNOTIFICATIONTYPE",
"I_PMREFERENCEELEMENT",
"I_PURCHASEORDERAPI01",
"I_PURCHASEORDERITEMAPI01",
"I_SALESDOCUMENT",
"I_TEXTOBJECTPLAINLONGTEXT",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_MAINTENANCEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/