P_MaintOrderSearch

DDL: P_MAINTORDERSEARCH SQL: PMAINTSEARCH Type: view BASIC
79 Fields 1 Data Sources 1 Associations

P_MaintOrderSearch is a Basic CDS View 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.

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 Order
MaintPriorityType MaintPriorityType PriorityType
MaintPriority MaintPriority Priority
MaintenanceProcessingPhase I_MaintenanceOrder MaintenanceProcessingPhase Phase
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
MaintenanceNotification MaintenanceNotification Notification
Equipment Equipment Equipment check
Assembly Assembly Pegged Reqmt
SerialNumber SerialNumber Serial Number
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenanceRevision MaintenanceRevision Revision
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenanceItem MaintenanceItem MaintItem
MaintenanceActivityType MaintenanceActivityType MaintActivType
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
MaintOrderReferenceDate MaintOrderReferenceDate Reference Date
MaintenanceOrderPlanningCode MaintenanceOrderPlanningCode OrderPlanInd.
OperationSystemCondition OperationSystemCondition SystemCondition
ReferenceElement ReferenceElement Ref. Element PM/PS
MaintenanceItemObjectList MaintenanceItemObjectList Object list
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
BusinessArea BusinessArea Business Area
MaintenanceOrderType MaintenanceOrderType Order Type
MaintenanceOrderCategory MaintenanceOrderCategory Order category
MaintenanceOrderDesc MaintenanceOrderDesc Description
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode Process Phase
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode Process Subphase
MaintOrderProcessingContext MaintOrderProcessingContext Processing Context
ControllingArea ControllingArea Controlling Area
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
BasicSchedulingType BasicSchedulingType Scheduling type
MaintOrdBasicStartDate MaintOrdBasicStartDate Bas. Start Date
MaintOrdBasicEndDate MaintOrdBasicEndDate Basic fin. date
MaintenanceOrderInternalID MaintenanceOrderInternalID Object number
MaintenancePlant MaintenancePlant Plant
CreatedByUser CreatedByUser User Name
OrderHasLongText OrderHasLongText Order Has Long Text
LastChangeDateTime LastChangeDateTime Timestamp
AdditionalDeviceData AdditionalDeviceData Device Data
PlainLongText _LongText PlainLongText Long Text
LatestAcceptableCompletionDate LatestAcceptableCompletionDate Final Due Date
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MaintOrderSearch.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMAINTSEARCH
-- Parameters: P_Language : abap.lang

CREATE VIEW P_MaintOrderSearch AS
SELECT
  MaintenanceOrder,
  MaintPriorityType,
  MaintPriority,
  I_MaintenanceOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenanceNotification,
  Equipment,
  Assembly,
  SerialNumber,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceRevision,
  MaintenancePlan,
  MaintenanceItem,
  MaintenanceActivityType,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  MaintOrderReferenceDate,
  MaintenanceOrderPlanningCode,
  OperationSystemCondition,
  ReferenceElement,
  MaintenanceItemObjectList,
  MaintOrderRoutingNumber,
  BusinessArea,
  MaintenanceOrderType,
  MaintenanceOrderCategory,
  MaintenanceOrderDesc,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintOrderProcessingContext,
  ControllingArea,
  ResponsibleCostCenter,
  BasicSchedulingType,
  MaintOrdBasicStartDate,
  MaintOrdBasicEndDate,
  MaintenanceOrderInternalID,
  MaintenancePlant,
  CreatedByUser,
  OrderHasLongText,
  LastChangeDateTime,
  AdditionalDeviceData,
  _LongText.PlainLongText AS PlainLongText,
  LatestAcceptableCompletionDate
FROM I_MaintenanceOrder
LEFT OUTER JOIN I_OrderLongText AS _LongText ON MaintenanceOrder = _LongText.OrderID  -- association [0..*]
;

Learn More