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,
  InspectionLotText,
  _InspChar.InspectionSpecificationText AS InspectionSpecificationText,
  _InspChar._InspectionResult.InspectionResultText AS InspectionResultText,
  MainChecklistIsDeactivated,
  _OrderTechnicalObject._TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  _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,
  _MaintenanceOrderOp._MaintenanceOrder.MaintenancePlannerGroup AS 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,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsUsage,
  BillOfOperationsChangeStateID,
  _InspectionLot.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _InspChar.SamplingProcedure AS SamplingProcedure,
  _InspChar.InspectionSpecification AS InspectionSpecification,
  _InspChar.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspChar.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspChar.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspChar.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspChar.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspChar.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspChar.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspChar.InspectionMethod AS InspectionMethod,
  _InspChar._InspectionMethodVersion._InspectionMethodText[1:Language=$session.system_language].InspectionMethodText AS InspectionMethodText,
  _InspChar.InspectionMethodPlant AS InspectionMethodPlant,
  _InspChar.InspectionMethodVersion AS InspectionMethodVersion,
  _InspChar.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  _InspChar.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  _InspChar.InspSpecTargetValue AS InspSpecTargetValue,
  _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,
  _InspChar._InspSubsetCharacteristic._InspectionSubset.MaterialSample AS MaterialSample,
  _InspChar._InspSubsetCharacteristic._InspectionSubset._MaterialSample.MaterialSampleText AS MaterialSampleText,
  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.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspChar.SelectedCodeSet AS SelectedCodeSet,
  _InspChar._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _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.DefectClass AS DefectClass,
  _InspChar._InspectionResult.InspectionValuationResult AS InspectionValuationResult,
  _InspChar._InspectionResult._InspectionValuationResult._Text[1:Language=$session.system_language].InspectionValuationResultText AS InspectionValuationResultText,
  _InspChar.InspLotTestEquipInternalID AS InspLotTestEquipInternalID
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 _OperationWorkCenter.WorkCenterInternalID = operationworkcenterinternalid AND _OperationWorkCenter.WorkCenterTypeCode = operationworkcentertypecode  -- 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_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_OrderProdnResourceTool AS _OrderProdnResourceTool ON orderinternalbillofoperations = _OrderProdnResourceTool.OrderInternalBillOfOperations AND insplottestequipinternalid = _OrderProdnResourceTool.OrderProdnRsceToolInternalID  -- association [0..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 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_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_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 AND _AuthorizationGroup.Language = $session.system_language  -- 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]
LEFT OUTER JOIN I_InspLotMatlSmplCharcRsltRecg AS _InspectionResultRec ON InspectionLot = _InspectionResultRec.InspectionLot AND inspplanoperationinternalid = _InspectionResultRec.InspPlanOperationInternalID AND inspectioncharacteristic = _InspectionResultRec.InspectionCharacteristic AND _InspectionResultRec.MaterialSample = ''  -- association [1..1]
LEFT OUTER JOIN I_TechnicalObject AS _InspectionLotTechnicalObject ON _InspectionLotTechnicalObject.TechnicalObject = InspectionLotTechnicalObject AND _InspectionLotTechnicalObject.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..1]
;