I_MaintenanceItemBasic

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 I_MaintenanceItemBasic.
-- 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: IMAINTITEMBASIC

CREATE VIEW I_MaintenanceItemBasic AS
SELECT
  wapos AS MaintenanceItem,
  iloan AS MaintObjectLocAcctAssgmtNmbr,
  iloai AS MaintObjLocAcctAssgmtIsIndiv,
  wpgrp AS MaintenancePlannerGroup,
  iwerk AS MaintenancePlanningPlant,
  gsber AS BusinessArea,
  gewrk AS MainWorkCenterInternalID,
  ind_abrvo AS SettlementRuleIsMaintained,
  ltknz AS MaintenanceItemHasLongText,
  objty AS WorkCenterTypeCode,
  plnty AS TaskListType,
  plnnr AS TaskListGroup,
  plnal AS TaskListGroupCounter,
  equnr AS Equipment,
  bautl AS Assembly,
  ersdt AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser,
  pstxt AS MaintenanceItemDescription,
  warpl AS MaintenancePlan,
  wppos AS MaintenancePlanItemPosition,
  wstra AS MaintenanceStrategy,
  cast(mityp as mptyp preserving type) AS MaintenancePlanCategory,
  deviceid AS AdditionalDeviceData,
  qmart AS NotificationType,
  qmnum AS MaintenanceNotification,
  priok AS MaintPriority,
  laufn AS MaintenanceOrder,
  ilart AS MaintenanceActivityType,
  auart AS MaintenanceOrderType,
  serialnr AS SerialNumber,
  sermat AS Material,
  obknr AS MaintenanceItemObjectList,
  anlzu AS OperationSystemCondition,
  apfkt AS NumberOfTaskListExecutions,
  inact AS MaintenanceItemIsInactive,
  objnr AS ObjectInternalID,
  mityp AS MaintObjectCategory,
  kdauf AS SalesDocument,
  bstnr AS PurchaseOrder,
  bstpo AS PurchaseOrderItem,
  aufnr AS SettlementOrder,
  task_determine AS MaintNotifTskIsAutomlyDtmnd,
  tstmp_bw AS LastChangeDateTime,
  cast(tstmp_bw as tzntstmps) AS MaintPlanLastChangeDateTime,
  no_aufrelkz AS ImmediateReleaseIsBlocked,
  cycleseqind AS CycleSetSequence,
  adpsp AS ReferenceElement,
  service_document_type AS ServiceDocumentType,
  service_contract AS ServiceContract,
  service_contract_item AS ServiceContractItem,
  service_template AS ServiceOrderTemplate,
  _MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject,
  _MaintenancePlanCatParam.MaintItemCausesAreDisplayed AS MaintItemCausesAreDisplayed,
  _MaintenancePlanCatParam.MaintItemReasonsAreDisplayed AS MaintItemReasonsAreDisplayed,
  Product,
  service_priority AS ServiceDocumentPriority,
  MaintCmplncCalculationMethod,
  MaintCmplncStrtDteOffsetInDays,
  MaintCmplncEndDateOffsetInDays
FROM mpos
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON _MaintenancePlannerGroup.MaintenancePlannerGroup = MaintenancePlannerGroup AND _MaintenancePlannerGroup.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON _MaintenancePlanningPlant.Plant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanBasic AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanCatParam AS _MaintenancePlanCatParam ON _MaintenancePlanCatParam.MaintenancePlanCategory = MaintenancePlanCategory  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON _MaintenanceTaskList.TaskListType = TaskListType AND _MaintenanceTaskList.TaskListGroup = TaskListGroup AND _MaintenanceTaskList.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskListType AS _TaskListType ON _TaskListType.TaskListType = TaskListType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _TaskListGroup ON _TaskListGroup.BillOfOperationsType = TaskListType AND _TaskListGroup.BillOfOperationsGroup = TaskListGroup AND ( _TaskListGroup.BillOfOperationsType = 'A' OR _TaskListGroup.BillOfOperationsType = 'E' OR _TaskListGroup.BillOfOperationsType = 'T' )  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskListGroup AS _TaskListGroup_2 ON _TaskListGroup_2.BillOfOperationsType = TaskListType AND _TaskListGroup_2.BillOfOperationsGroup = TaskListGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperations AS _TaskListGroupCounter ON _TaskListGroupCounter.BillOfOperationsType = TaskListType AND _TaskListGroupCounter.BillOfOperationsGroup = TaskListGroup AND _TaskListGroupCounter.BillOfOperationsVariant = TaskListGroupCounter AND ( _TaskListGroupCounter.BillOfOperationsType = 'A' OR _TaskListGroupCounter.BillOfOperationsType = 'E' OR _TaskListGroupCounter.BillOfOperationsType = 'T' )  -- association [0..1]
LEFT OUTER JOIN I_MaintTaskListGroupCounter AS _TaskListGroupCounter_2 ON _TaskListGroupCounter_2.BillOfOperationsType = TaskListType AND _TaskListGroupCounter_2.BillOfOperationsGroup = TaskListGroup AND _TaskListGroupCounter_2.BillOfOperationsVariant = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON _MaintenanceActivityType.MaintenanceActivityType = MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON _MaintenanceOrderType.OrderType = MaintenanceOrderType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _MainWorkCenter ON _MainWorkCenter.WorkCenterInternalID = MainWorkCenterInternalID AND _MainWorkCenter.WorkCenterTypeCode = WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON _Assembly.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationType AS _PMNotificationType ON _PMNotificationType.NotificationType = NotificationType  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON _SalesDocument.SalesDocument = SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItem.PurchaseOrderItem = PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Order AS _SettlementOrder ON SettlementOrder = _SettlementOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _MaintOperationSystCondition ON OperationSystemCondition = _MaintOperationSystCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItemObject AS _MaintenanceItemObject ON MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList  -- association [0..*]
LEFT OUTER JOIN I_PMReferenceElement AS _PMReferenceElement ON ReferenceElement = _PMReferenceElement.ReferenceElement  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTypeControlParam AS _MaintOrderTypeControlParam ON MaintenanceOrderType = _MaintOrderTypeControlParam.OrderType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ImmediateReleaseIsBlocked ON ImmediateReleaseIsBlocked = _ImmediateReleaseIsBlocked.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _ServiceContract ON ServiceContract = _ServiceContract.ServiceDocument AND _ServiceContract.ServiceObjectType = 'BUS2000112'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceContractItem ON ServiceContractItem = _ServiceContractItem.ServiceDocumentItem AND ServiceContract = _ServiceContractItem.ServiceDocument AND _ServiceContractItem.ServiceObjectType = 'BUS2000112'  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
;