P_MaintOrderSearch
Maintenance Order anchor view for CDS search model
P_MaintOrderSearch is a Basic CDS View that provides data about "Maintenance Order anchor view for CDS search model" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 79 fields with key field MaintenanceOrder. It has 1 association to related views. Part of development package BSESH_PM.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrder | I_MaintenanceOrder | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_Language | abap.lang |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_OrderLongText | _LongText | $projection.MaintenanceOrder = _LongText.OrderID |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PMAINTSEARCH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.private | true | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (79)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | ||
| MaintPriorityType | MaintPriorityType | |||
| MaintPriority | MaintPriority | |||
| MaintenanceProcessingPhase | I_MaintenanceOrder | MaintenanceProcessingPhase | ||
| MaintObjectLocAcctAssgmtNmbr | MaintObjectLocAcctAssgmtNmbr | |||
| MaintenanceNotification | MaintenanceNotification | |||
| Equipment | Equipment | |||
| Assembly | Assembly | |||
| SerialNumber | SerialNumber | |||
| MaintenancePlanningPlant | MaintenancePlanningPlant | |||
| MaintenancePlannerGroup | MaintenancePlannerGroup | |||
| MaintenanceRevision | MaintenanceRevision | |||
| MaintenancePlan | MaintenancePlan | |||
| MaintenanceItem | MaintenanceItem | |||
| MaintenanceActivityType | MaintenanceActivityType | |||
| WorkCenterInternalID | WorkCenterInternalID | |||
| WorkCenterTypeCode | WorkCenterTypeCode | |||
| MaintOrderReferenceDate | MaintOrderReferenceDate | |||
| MaintenanceOrderPlanningCode | MaintenanceOrderPlanningCode | |||
| OperationSystemCondition | OperationSystemCondition | |||
| ReferenceElement | ReferenceElement | |||
| MaintenanceItemObjectList | MaintenanceItemObjectList | |||
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | |||
| BusinessArea | BusinessArea | |||
| MaintenanceOrderType | MaintenanceOrderType | |||
| MaintenanceOrderCategory | MaintenanceOrderCategory | |||
| MaintenanceOrderDesc | MaintenanceOrderDesc | |||
| ControllingArea | ControllingArea | |||
| ResponsibleCostCenter | ResponsibleCostCenter | |||
| BasicSchedulingType | BasicSchedulingType | |||
| MaintOrdBasicStartDate | MaintOrdBasicStartDate | |||
| MaintOrdBasicEndDate | MaintOrdBasicEndDate | |||
| MaintenanceOrderInternalID | MaintenanceOrderInternalID | |||
| MaintenancePlant | MaintenancePlant | |||
| CreatedByUser | CreatedByUser | |||
| OrderHasLongText | OrderHasLongText | |||
| LastChangeDateTime | LastChangeDateTime | |||
| AdditionalDeviceData | AdditionalDeviceData | |||
| PlainLongText | _LongText | PlainLongText | ||
| LatestAcceptableCompletionDate | LatestAcceptableCompletionDate | |||
| MaintOrdProcessPhaseCode | MaintOrdProcessPhaseCode | |||
| MaintOrdProcessSubPhaseCode | MaintOrdProcessSubPhaseCode | |||
| MaintOrderProcessingContext | MaintOrderProcessingContext | |||
| _BasicSchedulingType | _BasicSchedulingType | |||
| _BusinessArea | _BusinessArea | |||
| _ControllingArea | _ControllingArea | |||
| _CreatedByUser | _CreatedByUser | |||
| _Equipment | _Equipment | |||
| _LocationAccountAssignment | _LocationAccountAssignment | |||
| _LocationPlant | _LocationPlant | |||
| _MaintenanceActivityType | _MaintenanceActivityType | |||
| _MaintenanceItem | _MaintenanceItem | |||
| _MaintenanceItemObject | _MaintenanceItemObject | |||
| _MaintenanceNotification | _MaintenanceNotification | |||
| _MaintenanceOrderCategory | _MaintenanceOrderCategory | |||
| _MaintenanceOrderComponent | _MaintenanceOrderComponent | |||
| _MaintenanceOrderCost | _MaintenanceOrderCost | |||
| _MaintenanceOrderOperation | _MaintenanceOrderOperation | |||
| _MaintenanceOrderPhase | _MaintenanceOrderPhase | |||
| _MaintenanceOrderType | _MaintenanceOrderType | |||
| _MaintenancePartner | _MaintenancePartner | |||
| _MaintenancePlan | _MaintenancePlan | |||
| _MaintenancePlannerGroup | _MaintenancePlannerGroup | |||
| _MaintenancePlanningPlant | _MaintenancePlanningPlant | |||
| _MaintenancePriority | _MaintenancePriority | |||
| _MaintenancePriorityType | _MaintenancePriorityType | |||
| _MaintenanceRevision | _MaintenanceRevision | |||
| _MaintOrderTypeControlParam | _MaintOrderTypeControlParam | |||
| _MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | |||
| _MainWorkCenter | _MainWorkCenter | |||
| _OperationSystemCondition | _OperationSystemCondition | |||
| _Order | _Order | |||
| _OrderHasLongText | _OrderHasLongText | |||
| _ResponsibleCostCenter | _ResponsibleCostCenter | |||
| _ResponsibleCostCenterText | _ResponsibleCostCenterText | |||
| _StatusObject | _StatusObject | |||
| _StatusObjectActiveStatus | _StatusObjectActiveStatus | |||
| _StatusObjectStatus | _StatusObjectStatus | |||
| _WorkCenterType | _WorkCenterType |
//Maintenance Order anchor view for CDS search model
@AbapCatalog.sqlViewName: 'PMAINTSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintenanceOrder'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintOrderSearch
with parameters
@Consumption.hidden: true
@Environment.systemField: #SYSTEM_LANGUAGE
P_Language : abap.lang
as select from I_MaintenanceOrder
association [0..*] to I_OrderLongText as _LongText on $projection.MaintenanceOrder = _LongText.OrderID
{
key MaintenanceOrder,
MaintPriorityType,
MaintPriority,
I_MaintenanceOrder.MaintenanceProcessingPhase,
MaintObjectLocAcctAssgmtNmbr,
MaintenanceNotification,
Equipment,
Assembly,
SerialNumber,
MaintenancePlanningPlant,
MaintenancePlannerGroup,
MaintenanceRevision,
MaintenancePlan,
MaintenanceItem,
MaintenanceActivityType,
WorkCenterInternalID,
WorkCenterTypeCode,
MaintOrderReferenceDate,
MaintenanceOrderPlanningCode,
OperationSystemCondition,
ReferenceElement,
MaintenanceItemObjectList,
MaintOrderRoutingNumber,
BusinessArea,
MaintenanceOrderType,
MaintenanceOrderCategory,
MaintenanceOrderDesc,
ControllingArea,
ResponsibleCostCenter,
BasicSchedulingType,
MaintOrdBasicStartDate,
MaintOrdBasicEndDate,
MaintenanceOrderInternalID,
MaintenancePlant,
CreatedByUser,
OrderHasLongText,
LastChangeDateTime,
AdditionalDeviceData,
_LongText.PlainLongText,
LatestAcceptableCompletionDate,
/* Adding Phase and Subphase based on New Scope Item for ESH Search integration with Joule*/
MaintOrdProcessPhaseCode,
MaintOrdProcessSubPhaseCode,
MaintOrderProcessingContext,
/* Associations */
_BasicSchedulingType,
_BusinessArea,
_ControllingArea,
_CreatedByUser,
_Equipment,
_LocationAccountAssignment,
_LocationPlant,
_MaintenanceActivityType,
_MaintenanceItem,
_MaintenanceItemObject,
_MaintenanceNotification,
_MaintenanceOrderCategory,
_MaintenanceOrderComponent,
_MaintenanceOrderCost,
_MaintenanceOrderOperation,
_MaintenanceOrderPhase,
_MaintenanceOrderType,
_MaintenancePartner,
_MaintenancePlan,
_MaintenancePlannerGroup,
_MaintenancePlanningPlant,
_MaintenancePriority,
_MaintenancePriorityType,
_MaintenanceRevision,
_MaintOrderTypeControlParam,
_MaintOrdPlngDegreeCode,
_MainWorkCenter,
_OperationSystemCondition,
_Order,
_OrderHasLongText,
_ResponsibleCostCenter,
_ResponsibleCostCenterText,
_StatusObject,
_StatusObjectActiveStatus,
_StatusObjectStatus,
_WorkCenterType
}
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