P_MaintenanceItemSearch
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)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceItem | I_MaintenanceItem | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_TextObjectPlainLongText | _LongText | $projection.MaintenanceItem = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'MPOS' and _LongText.TextObjectType = 'LTXT' |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
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