C_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 C_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 C_MaintenanceOrderCheckList AS
SELECT
  MaintenanceOrder,
  InspectionLot,
  MaintenanceOrderOperation,
  OperationDescription,
  MaintenanceBusinessSubobject,
  Plant,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  MainChecklistIsDeactivated,
  cast('' as abap.char(15) ) AS ActivationStatusName,
  cast('' as abap.char(15) ) AS InspLotUsgeDcsnValuationText,
  cast(0 as abap.int4(10) ) AS InspCharAcceptedCount,
  cast(0 as abap.int4(10) ) AS InspCharOpenCount,
  cast(0 as abap.int4(10) ) AS InspCharRejectedCount,
  cast(0 as abap.int4(10) ) AS InspCharacteristicCount,
  InspectionLotText,
  PlantName,
  _InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  MaintOperationalChecklistType,
  _ChecklistType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText,
  _InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _BillOfOperationsChangeState.BillOfOperationsDesc AS InspectionPlanDescription,
  BillOfOperationsGroup,
  BillOfOperationsType,
  BillOfOperationsVariant,
  BillOfOperationsChangeStateID,
  _InspectionLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  InspectionLotEquipment,
  EquipmentName,
  InspLotFunctionalLocation,
  InspLotFunctionalLocationName,
  _InspectionLot.Material AS Material,
  MaterialName,
  _InspectionLot.Supplier AS Supplier,
  _InspectionLot._Supplier.SupplierName AS SupplierName,
  InspectionLotPlant,
  InspectionLotPlantName,
  BillOfOperationsUsage,
  _BillOfOperationsUsage._Text[1:Language = $session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  _InspectionLot.StatusObject AS StatusObject,
  IsLocked,
  Equipment,
  FunctionalLocation
FROM I_MaintenanceOrderCheckList
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_MaintOrdInspChkListCharc AS _Characteristics ON _Characteristics.InspectionLot = InspectionLot  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _Status ON statusobject = _Status.StatusObject  -- association [0..*]
;