I_MaintOrderInspectionLot

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_MaintOrderInspectionLot.
-- 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: IMAINTORDINSPLOT

CREATE VIEW I_MaintOrderInspectionLot AS
SELECT
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  _InspectionLot.InspectionLot AS InspectionLot,
  _InspectionLot.Material AS Material,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspectionLot.StatusObject AS StatusObject,
  _InspectionLot.StatusObjectCategory AS StatusObjectCategory,
  _InspectionLot.StatusProfile AS StatusProfile,
  _InspectionLot.GoodsReceiptIsMovedToBlkdStock AS GoodsReceiptIsMovedToBlkdStock,
  _InspectionLot.InspectionLotIsSkipped AS InspectionLotIsSkipped,
  _InspectionLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _InspectionLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _InspectionLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _InspectionLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _InspectionLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _InspectionLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspectionLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  _InspectionLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  _InspectionLot.ChangedDateTime AS ChangedDateTime,
  _InspectionLot.InspectionLotStartDate AS InspectionLotStartDate,
  _InspectionLot.InspectionLotStartTime AS InspectionLotStartTime,
  _InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspectionLot.InspectionLotEndTime AS InspectionLotEndTime,
  _InspectionLot.BillOfOperationsType AS BillOfOperationsType,
  _InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _InspectionLot.BillOfOperationsUsage AS BillOfOperationsUsage,
  _InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  _InspectionLot.InspLotSelBillOfOperationsUsge AS InspLotSelBillOfOperationsUsge,
  _InspectionLot.InspLotSelectionValidFromDate AS InspLotSelectionValidFromDate,
  _InspectionLot.ManufacturingOrder AS ManufacturingOrder,
  _InspectionLot.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _InspectionLot.InspLotSelectionCustomer AS InspLotSelectionCustomer,
  _InspectionLot.Customer AS Customer,
  _InspectionLot.InspLotSelectionSupplier AS InspLotSelectionSupplier,
  _InspectionLot.Supplier AS Supplier,
  _InspectionLot.Language AS Language,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  _InspectionLot.InspectionLotObjectText AS InspectionLotObjectText,
  _InspectionLot.InspLotNmbrAddlRecordedCharc AS InspLotNmbrAddlRecordedCharc,
  _InspectionLot.InspLotNmbrOpenShortTermCharc AS InspLotNmbrOpenShortTermCharc,
  _InspectionLot.InspLotNmbrOpenLongTermCharc AS InspLotNmbrOpenLongTermCharc,
  _InspectionLot.InspLotUsageDecisionTool AS InspLotUsageDecisionTool,
  _InspectionLot.InspectionLotHasUsageDecision AS InspectionLotHasUsageDecision,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintenanceOrder._Equipment.AuthorizationGroup AS AuthorizationGroup,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceChecklist.MaintBusinessSubobjectType AS MaintBusinessSubobjectType,
  _MaintenanceChecklist.MaintenanceBusinessSubobject AS MaintenanceBusinessSubobject,
  _MaintenanceChecklist.MaintChecklistTemplateType AS MaintChecklistTemplateType,
  _MaintenanceChecklist.MaintenanceChecklistTemplate AS MaintenanceChecklistTemplate,
  _MaintenanceChecklist.Equipment AS Equipment,
  cast ( _MaintenanceChecklist.FunctionalLocation as vdm_eam_tplnr preserving type ) AS FunctionalLocation,
  _MaintenanceChecklist.MaintChklstAddlInformationText AS MaintChklstAddlInformationText,
  _MaintenanceChecklist.MainChecklistIsDeactivated AS MainChecklistIsDeactivated,
  _MaintenanceChecklist.MaintenanceBusinessObjectType AS MaintenanceBusinessObjectType,
  _MaintenanceChecklist.MaintenanceChecklistType AS MaintenanceChecklistType,
  _MaintenanceChecklist.MaintChklstAdditionalObjectKey AS MaintChklstAdditionalObjectKey,
  _MaintenanceOrder._LocationAccountAssignment AS _LocationAccountAssignment
FROM I_MaintenanceOrder AS _MaintenanceOrder
INNER JOIN I_MaintenanceChecklist AS _MaintenanceChecklist ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionLot AS _InspectionLot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspLotUsageDecision ON InspectionLot = _InspLotUsageDecision.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotType AS _InspectionLotType ON InspectionLotType = _InspectionLotType.InspectionLotType  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotOrigin AS _InspectionLotOrigin ON InspectionLotOrigin = _InspectionLotOrigin.InspectionLotOrigin  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _InspLotSelectionCustomer ON InspLotSelectionCustomer = _InspLotSelectionCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InspLotSelectionSupplier ON InspLotSelectionSupplier = _InspLotSelectionSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _InspectionLotHasUsgeDcsn ON InspectionLotHasUsageDecision = _InspectionLotHasUsgeDcsn.IndicatorValue  -- association [1..1]
;