R_MaintInspLotCharacteristic

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_MaintInspLotCharacteristic.
-- 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_MaintInspLotCharacteristic AS
SELECT
  InspectionLot,
  MaintenanceOrder,
  cast(_MaintenanceOrderOp.MaintenanceOrderOperation as maintenanceorderoperation preserving type) AS MaintenanceOrderOperation,
  _InspChar.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspChar.InspectionCharacteristic AS InspectionCharacteristic,
  _MaintenanceOrderOp.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  MaintenanceBusinessSubobject,
  Plant,
  InspectionLotType,
  _InspectionLotTypeText[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  InspectionLotText,
  _InspChar.InspectionSpecificationText AS InspectionSpecificationText,
  _InspChar._InspectionResult.InspectionResultText AS InspectionResultText,
  MainChecklistIsDeactivated,
  _MaintenanceOrderOp._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrderOp.OperationDescription AS OperationDescription,
  _Plant.PlantName AS PlantName,
  _OrderTechnicalObject._TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  I_MaintOrderInspectionLot._InspLotUsageDecision._UsageDecisionValuation._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  I_MaintOrderInspectionLot._InspLotUsageDecision._UsageDecisionCode._Text[1:Language=$session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  I_MaintOrderInspectionLot._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,
  MaintenancePlanningPlant,
  _MaintenanceOrder._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenanceOrderType,
  _MaintenanceOrder._MaintenanceOrderType._Text[1: Language=$session.system_language].OrderTypeName AS OrderTypeName,
  _MaintenanceOrder._MaintenancePlan.MaintenancePlan AS MaintenancePlan,
  _MaintenanceOrder._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  _MaintenanceOrder._MaintenancePlan._MaintenanceItem.MaintenanceItem AS MaintenanceItem,
  _MaintenanceOrder._MaintenancePlan._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  _MaintenanceOrder._MaintenanceActivityType._Text[1: Language=$session.system_language].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  _MaintenanceOrder._MainWorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _MaintenanceOrder._MainWorkCenter._Plant.PlantName AS WorkCenterPlantName,
  _MaintenanceOrderOp.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _MaintenanceOrderOp.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  _MaintenanceOrderOp.Plant AS OperationWorkCenterPlant,
  _MaintenanceOrderOp.OperationControlKey AS OperationControlKey,
  _MaintenanceOrderOp._OperationControlKey._Text[1:Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  _MaintenanceOrderOp.OperationStandardTextCode AS OperationStandardTextCode,
  I_MaintOrderInspectionLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  I_MaintOrderInspectionLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  I_MaintOrderInspectionLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  I_MaintOrderInspectionLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  I_MaintOrderInspectionLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  I_MaintOrderInspectionLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspectionLot.Plant AS InspectionLotPlant,
  _InspectionLot._Plant.PlantName AS InspectionLotPlantName,
  _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.BillOfOperationsType AS BillOfOperationsType,
  _InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  _InspectionLot.BillOfOperationsUsage AS BillOfOperationsUsage,
  _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,
  _InspChar.SamplingProcedure AS SamplingProcedure,
  _InspChar._InspectionSpecification.InspectionSpecification AS InspectionSpecification,
  _InspChar.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspChar.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspChar.InspSpecRecordingType AS InspSpecRecordingType,
  _InspChar.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspChar.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspChar.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspChar.InspectionMethod AS InspectionMethod,
  _InspChar.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  _InspChar.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  _InspChar.InspSpecInformationField1 AS InspSpecInformationField1,
  _InspChar.InspSpecInformationField2 AS InspSpecInformationField2,
  _InspChar.InspSpecInformationField3 AS InspSpecInformationField3,
  _InspChar.InspSpecImportanceCode AS InspSpecImportanceCode,
  _InspChar._InspSpecImportanceCode._Text[1:Language = $session.system_language].InspSpecImportanceCodeText AS InspSpecImportanceCodeText,
  cast ( _InspChar._InspectionOperation.InspectionOperation as vdm_qm_inspectionoperation preserving type ) AS InspectionOperation,
  _InspChar._InspectionResult.Inspector AS Inspector,
  _InspChar._InspectionResult.InspectionEndDate AS InspectionEndDate,
  _InspChar._InspectionResult.InspectionEndTime AS InspectionEndTime,
  _InspChar._InspectionResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  _InspChar.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspChar._CharcAttribSelectedCodeSet._CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp AS PlannedCodeGroup,
  _InspChar._CharcAttribSelectedCodeSet._CharcAttribSelectedSetCode._CharcAttributeCodeGrp._Text[1:Language=$session.system_language].CharacteristicAttribCodeGrpTxt AS PlannedCodeGroupText,
  _InspChar._InspectionResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspChar._InspectionResult._CharcAttributeCodeGrp._Text[1:Language=$session.system_language].CharacteristicAttribCodeGrpTxt AS CharacteristicAttribCodeGrpTxt,
  _InspChar._InspectionResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspChar._InspectionResult._CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _InspChar._InspectionResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  _InspChar._InspectionResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  _InspChar._InspectionResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  _InspChar._InspectionResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  _InspChar._InspectionResult._InspectionCharacteristic._InspSubsetCharacteristic._InspectionSubset.MaterialSample AS MaterialSample,
  _InspChar._InspectionResult._InspectionCharacteristic._InspSubsetCharacteristic._InspectionSubset._MaterialSample.MaterialSampleText AS MaterialSampleText,
  _InspChar._InspectionResult.DefectClass AS DefectClass,
  _InspChar._InspectionResult.InspectionValuationResult AS InspectionValuationResult,
  _InspChar._InspectionResult._InspectionValuationResult._Text[1:Language=$session.system_language].InspectionValuationResultText AS InspectionValuationResultText,
  _InspectionLot.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _InspChar.InspLotTestEquipInternalID AS InspLotTestEquipInternalID
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOp ON MaintenanceBusinessSubobject = _MaintenanceOrderOp.MaintOrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _OrderTechnicalObject ON MaintenanceOrder = _OrderTechnicalObject.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _OperationWorkCenter ON _OperationWorkCenter.WorkCenterInternalID = operationworkcenterinternalid AND _OperationWorkCenter.WorkCenterTypeCode = operationworkcentertypecode  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON maintoperationalchecklisttype = _ChecklistType.MaintOperationalChecklistType  -- association [0..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspChar ON InspectionLot = _InspChar.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND inspplanoperationinternalid = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotTypeText AS _InspectionLotTypeText ON InspectionLotType = _InspectionLotTypeText.InspectionLotType  -- association [0..1]
LEFT OUTER JOIN I_OrderProdnResourceTool AS _OrderProdnResourceTool ON orderinternalbillofoperations = _OrderProdnResourceTool.OrderInternalBillOfOperations AND insplottestequipinternalid = _OrderProdnResourceTool.OrderProdnRsceToolInternalID  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardText ON operationstandardtextcode = _OperationStandardText.OperationStandardTextCode  -- association [1..1]
LEFT OUTER JOIN I_DefectClass AS _DefectClass ON defectclass = _DefectClass.DefectClass  -- 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]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON billofoperationsusage = _BillOfOperationsUsage.BillOfOperationsUsage  -- association [0..1]
LEFT OUTER JOIN I_InspectionMethodVersionText AS _InspMethodText ON inspectionmethod = _InspMethodText.InspectionMethod AND _InspMethodText.Language = $session.system_language  -- association [1..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_User AS _Inspector ON _Inspector.UserID = inspector  -- association [0..1]
LEFT OUTER JOIN I_TechObjAuthznGrpText AS _AuthorizationGroup ON _AuthorizationGroup.TechObjAuthorizationGroup = authorizationgroup  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsLocked ON IsLocked = _IsLocked.IndicatorValue  -- 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_InspResultLongText AS _InspResultLongText ON InspectionLot = _InspResultLongText.InspectionLot AND inspplanoperationinternalid = _InspResultLongText.InspPlanOperationInternalID AND inspectioncharacteristic = _InspResultLongText.InspectionCharacteristic AND _InspResultLongText.Language = $session.system_language  -- association [0..1]
;