I_InspPlanOpCharcVersion

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_InspPlanOpCharcVersion.
-- 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: IINSPOPCHVRS

CREATE VIEW I_InspPlanOpCharcVersion AS
SELECT
  _BOOCharacteristicVersion.BillOfOperationsGroup AS InspectionPlanGroup,
  _BOOCharacteristicVersion.BOOOperationInternalID AS BOOOperationInternalID,
  _BOOCharacteristicVersion.BOOCharacteristic AS BOOCharacteristic,
  _BOOCharacteristicVersion.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  _InspPlanOpAssgmt.InspectionPlan AS InspectionPlan,
  _BOOCharacteristicVersion.BillOfOperationsType AS BillOfOperationsType,
  _InspectionPlanVersion.InspectionPlanInternalVersion AS InspectionPlanInternalVersion,
  _InspPlanOperationVersion.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  _BOOCharacteristicVersion.IsDeleted AS IsDeleted,
  BOOOperationPRTInternalID,
  InspectionMethod,
  InspectionMethodVersion,
  InspectionMethodPlant,
  InspSpecImportanceCode,
  InspectorQualification,
  InspectionSpecification,
  InspectionSpecificationVersion,
  InspectionSpecificationPlant,
  BOOCharcHasInspSpecReference,
  InspSpecControlIndicators,
  InspSpecIsQuantitative,
  InspSpecCharacteristicType,
  InspSpecIsMeasuredValueRqd,
  InspSpecIsSelectedSetRequired,
  InspSpecIsUpperLimitRequired,
  InspSpecIsLowerLimitRequired,
  InspSpecIsTargetValueInLimit,
  InspectionScope,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspResultIsDocumentationRqd,
  InspSpecCharcCategory,
  InspSpecIsSampleQtyAdditive,
  InspSpecIsDestructive,
  InspSpecResultCalculation,
  InspSpecIsSamplingProcedRqd,
  InspSpecIsScrapRelevant,
  InspSpecHasFixedCtrlIndicators,
  InspSpecIsDefectRecordingRqd,
  InspSpecIsTestEquipmentRqd,
  InspSpecIsDefectsRecgAutomatic,
  InspSpecIsChgDocRequired,
  InspSpecIsControlChartUsed,
  InspSpecPrintControl,
  InspToleranceSpecification,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasLowerLimit,
  InspSpecHasUpperLimit,
  InspSpecInputProcedure,
  InspSpecHasFormula,
  InspSpecFormula1,
  InspSpecFormula2,
  InspSpecNumberOfClasses,
  InspSpecClassWidthQty,
  InspSpecHasClassWidth,
  InspSpecClassMidpointQty,
  InspSpecHasClassMidpoint,
  InspSpecFirstUpperSpecLimit,
  InspSpecHasFirstUpperSpecLimit,
  InspSpecFirstLowerSpecLimit,
  InspSpecHasFirstLowerSpecLimit,
  InspSpecSecondUpperSpecLimit,
  InspSpecHasSecondUprSpecLimit,
  InspSpecSecondLowerSpecLimit,
  InspSpecHasSecondLowrSpecLimit,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAdditionalCatalog5,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecAddlSeldCodeSetPlant5,
  SamplingProcedure,
  InspCharacteristicSampleUnit,
  BOOCharcSampleQuantity,
  QltyCtrlChartAggrgnCriterion,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspectionSpecificationText,
  InspLotDynamicRule,
  InspCharcDynModifRef,
  MatlIsConsideredForDynModif,
  SuplrIsConsideredForDynModif,
  MfrIsConsideredForDynModif,
  CustIsConsideredForDynModif,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BillOfOperationsVersion
FROM I_BOOCharacteristicVersion AS _BOOCharacteristicVersion
INNER JOIN I_InspPlanOpAssgmt AS _InspPlanOpAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionPlan AS _InspectionPlan ON InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup AND InspectionPlan = _InspectionPlan.InspectionPlan  -- association [1..1]
LEFT OUTER JOIN I_InspPlanOpCharc AS _InspPlanOpCharc ON InspectionPlanGroup = _InspPlanOpCharc.InspectionPlanGroup AND BOOOperationInternalID = _InspPlanOpCharc.BOOOperationInternalID AND BOOCharacteristic = _InspPlanOpCharc.BOOCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanVersion AS _InspectionPlanVersion ON InspectionPlanGroup = _InspectionPlanVersion.InspectionPlanGroup AND InspectionPlan = _InspectionPlanVersion.InspectionPlan AND BillOfOperationsType = _InspectionPlanVersion.BillOfOperationsType AND ValidityStartDate >= _InspectionPlanVersion.ValidityStartDate AND ValidityStartDate <= _InspectionPlanVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_InspPlanOperationVersion AS _InspPlanOperationVersion ON InspectionPlanGroup = _InspPlanOperationVersion.InspectionPlanGroup AND BOOOperationInternalID = _InspPlanOperationVersion.BOOOperationInternalID AND BillOfOperationsType = _InspPlanOperationVersion.BillOfOperationsType AND ValidityStartDate >= _InspPlanOperationVersion.ValidityStartDate AND ValidityStartDate <= _InspPlanOperationVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
;