P_MaintOrderSearch

DDL: P_MAINTORDERSEARCH SQL: PMAINTSEARCH Type: view BASIC Package: BSESH_PM

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)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OrderLongText _LongText $projection.MaintenanceOrder = _LongText.OrderID

Annotations (10)

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

KeyFieldSource TableSource FieldDescription
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
}