R_MaintenanceChecklistTP

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 R_MaintenanceChecklistTP.
-- 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 R_MaintenanceChecklistTP AS
SELECT
  InspectionLot,
  MaintenanceOrder,
  cast(_MaintenanceOrderOp.MaintenanceOrderOperation as maintenanceorderoperation preserving type) AS MaintenanceOrderOperation,
  _MaintenanceOrderOp.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  MaintenanceBusinessSubobject,
  Plant,
  InspectionLotType,
  InspectionLotText,
  MainChecklistIsDeactivated,
  _OrderTechnicalObject._TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  _InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _MaintenanceOrderOp._MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintenanceOrderOp._MaintenanceOrder.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _MaintenanceOrderOp._MaintenanceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _MaintenanceOrderOp._MaintenanceOrder.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  StatusObject,
  MaintenanceOrderDesc,
  MaintenancePlanningPlant,
  MaintenanceOrderType,
  _MaintenanceOrderOp._MaintenanceOrder.MaintenancePlan AS MaintenancePlan,
  _MaintenanceOrderOp._MaintenanceOrder.MaintenanceItem AS MaintenanceItem,
  _MaintenanceOrderOp._MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  MaintenancePlannerGroup,
  _MaintenanceOrderOp._MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  _MaintenanceOrderOp._MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _MaintenanceOrderOp.OperationDescription AS OperationDescription,
  _MaintenanceOrderOp.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _MaintenanceOrderOp.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  _MaintenanceOrderOp.OperationControlKey AS OperationControlKey,
  _MaintenanceOrderOp.OperationStandardTextCode AS OperationStandardTextCode,
  InspectionLotCreatedOn,
  InspectionLotCreatedOnTime,
  InspectionLotCreatedBy,
  InspectionLotChangeDate,
  InspectionLotChangeTime,
  InspectionLotChangedBy,
  _InspectionLot.Plant AS InspectionLotPlant,
  Material,
  Supplier,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsType,
  BillOfOperationsUsage,
  BillOfOperationsChangeStateID
FROM I_MaintOrderInspectionLot
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOp ON MaintenanceOrder = _MaintenanceOrderOp.MaintenanceOrder AND MaintenanceBusinessSubobject = _MaintenanceOrderOp.MaintOrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _OrderTechnicalObject ON MaintenanceOrder = _OrderTechnicalObject.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _OperationWorkCenter ON operationworkcenterinternalid = _OperationWorkCenter.WorkCenterInternalID AND operationworkcentertypecode = _OperationWorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistTypeText AS _CheckListType ON maintoperationalchecklisttype = _CheckListType.MaintOperationalChecklistType AND _CheckListType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotAggregate AS _InspectionLotAggregate ON InspectionLot = _InspectionLotAggregate.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardText ON operationstandardtextcode = _OperationStandardText.OperationStandardTextCode  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspectionLotWithStatus ON InspectionLot = _InspectionLotWithStatus.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspLotCompltnStatusText AS _InspLotCompltnStatusText ON InspLotCompltnStatus = _InspLotCompltnStatusText.InspLotCompltnStatus AND _InspLotCompltnStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotStatus AS _InspLotStatusLocked ON StatusObject = _InspLotStatusLocked.StatusObject AND _InspLotStatusLocked.StatusCode = 'I0043'  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BillOfOperationsChangeStateID = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON BillOfOperationsUsage = _BillOfOperationsUsage.BillOfOperationsUsage  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = InspectionLotCreatedBy  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = InspectionLotChangedBy  -- association [0..1]
LEFT OUTER JOIN I_TechObjAuthznGrpText AS _AuthorizationGroup ON _AuthorizationGroup.TechObjAuthorizationGroup = authorizationgroup AND _AuthorizationGroup.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderComponent AS _OrderComponent ON MaintenanceOrder = _OrderComponent.OrderID AND MaintenanceOrderOperation = _OrderComponent.OrderOperation AND Reservation = _OrderComponent.Reservation AND ReservationItem = _OrderComponent.ReservationItem AND _OrderComponent.RecordType = ''  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObject AS _InspectionLotTechnicalObject ON _InspectionLotTechnicalObject.TechnicalObject = InspectionLotTechnicalObject AND _InspectionLotTechnicalObject.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..1]
;