I_MaintenanceOrderCheckList

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_MaintenanceOrderCheckList.
-- 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.

CREATE VIEW I_MaintenanceOrderCheckList AS
SELECT
  I_MaintOrderInspectionLot.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderInspectionLot.InspectionLot AS InspectionLot,
  cast(_MaintenanceOrderOperation.MaintenanceOrderOperation as maintenanceorderoperation preserving type) AS MaintenanceOrderOperation,
  I_MaintOrderInspectionLot.MaintenanceBusinessSubobject AS MaintenanceBusinessSubobject,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  I_MaintOrderInspectionLot.Plant AS Plant,
  I_MaintOrderInspectionLot.MainChecklistIsDeactivated AS MainChecklistIsDeactivated,
  _MaintenanceOrderOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintOrderInspectionLot._InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  BillOfOperationsGroup,
  BillOfOperationsType,
  BillOfOperationsVariant,
  BillOfOperationsChangeStateID,
  _InspectionLot._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS InspLotFunctionalLocation,
  _InspectionLot.Equipment AS InspectionLotEquipment,
  _InspectionLot._Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
  _InspectionLot._FunctionalLocation._FunctionalLocationText[1:Language=$session.system_language].FunctionalLocationName AS InspLotFunctionalLocationName,
  _InspectionLot.BillOfOperationsUsage AS BillOfOperationsUsage,
  _InspectionLot.Material AS Material,
  _InspectionLot._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _InspectionLot.Supplier AS Supplier,
  _InspectionLot._Supplier.SupplierName AS SupplierName,
  _InspectionLot.Plant AS InspectionLotPlant,
  _InspectionLot._Plant.PlantName AS InspectionLotPlantName,
  I_MaintOrderInspectionLot.StatusObject AS StatusObject,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  I_MaintOrderInspectionLot.FunctionalLocation AS FunctionalLocation,
  I_MaintOrderInspectionLot.Equipment AS Equipment,
  _Plant.PlantName AS PlantName,
  _InspLotWithStatus.InspLotStatusCanceled AS InspLotStatusCanceled
FROM I_MaintOrderInspectionLot
LEFT OUTER JOIN I_MaintOrderOperAndSubOper AS _MaintenanceOrderOperation ON MaintenanceBusinessSubobject = _MaintenanceOrderOperation.MaintOrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON TechnicalObject = _TechnicalObject.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = TechnicalObject  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = TechnicalObject  -- association [0..*]
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspLotWithStatus ON InspectionLot = _InspLotWithStatus.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotStatus AS _InspLotStatusLocked ON StatusObject = _InspLotStatusLocked.StatusObject AND _InspLotStatusLocked.StatusCode = 'I0043'  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsLocked ON IsLocked = _IsLocked.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON maintoperationalchecklisttype = _ChecklistType.MaintOperationalChecklistType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON billofoperationsusage = _BillOfOperationsUsage.BillOfOperationsUsage  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant  -- association [0..1]
;