I_BOOCharcInspSpecUnion

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_BOOCharcInspSpecUnion.
-- 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: IBOOCINSPSPUNION

CREATE VIEW I_BOOCharcInspSpecUnion AS
SELECT
  I_BOOCharacteristicVersion.BillOfOperationsType AS BillOfOperationsType,
  I_BOOCharacteristicVersion.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_BOOCharacteristicVersion.BOOOperationInternalID AS BOOOperationInternalID,
  I_BOOCharacteristicVersion.BOOCharacteristic AS BOOCharacteristic,
  I_BOOCharacteristicVersion.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  I_BOOCharacteristicVersion.ValidityStartDate AS ValidityStartDate,
  I_BOOCharacteristicVersion.ValidityEndDate AS ValidityEndDate,
  I_BOOCharacteristicVersion.ChangeNumber AS ChangeNumber,
  I_BOOCharacteristicVersion.IsDeleted AS IsDeleted,
  I_BOOCharacteristicVersion.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  I_BOOCharacteristicVersion.InspectionMethod AS InspectionMethod,
  I_BOOCharacteristicVersion.InspectionMethodVersion AS InspectionMethodVersion,
  I_BOOCharacteristicVersion.InspectionMethodPlant AS InspectionMethodPlant,
  I_BOOCharacteristicVersion.InspectionSpecification AS InspectionSpecification,
  I_BOOCharacteristicVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  I_BOOCharacteristicVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_BOOCharacteristicVersion.BOOCharcHasInspSpecReference AS BOOCharcHasInspSpecReference,
  case I_BOOCharacteristicVersion.BOOCharcHasInspSpecReference when 'X' then _InspSpecificationVersion.InspectionScope else I_BOOCharacteristicVersion.InspectionScope end as InspectionScope AS InspectionScopeendasInspectionScope,
  case I_BOOCharacteristicVersion.BOOCharcHasInspSpecReference when 'X' then _AssgmtInspMethInspSpec.SelectedCodeSet else I_BOOCharacteristicVersion.SelectedCodeSet end as SelectedCodeSet AS SelectedCodeSetendasSelectedCodeSet,
  I_BOOCharacteristicVersion.SamplingProcedure AS SamplingProcedure,
  I_BOOCharacteristicVersion.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  I_BOOCharacteristicVersion.BOOCharcSampleQuantity AS BOOCharcSampleQuantity,
  I_BOOCharacteristicVersion.CreatedByUser AS CreatedByUser,
  I_BOOCharacteristicVersion.CreationDate AS CreationDate,
  I_BOOCharacteristicVersion.LastChangedByUser AS LastChangedByUser,
  I_BOOCharacteristicVersion.LastChangeDate AS LastChangeDate,
  I_BOOCharacteristicVersion.BillOfOperationsVersion AS BillOfOperationsVersion,
  I_BOOCharacteristicVersion._BOOCharacteristic AS _BOOCharacteristic,
  I_BOOCharacteristicVersion._BOOOperationInternalID AS _BOOOperationInternalID,
  I_BOOCharacteristicVersion._BillOfOperationsGroup AS _BillOfOperationsGroup,
  I_BOOCharacteristicVersion._BillOfOperationsType AS _BillOfOperationsType,
  I_BOOCharacteristicVersion._InspSpecificationVersion AS _InspSpecificationVersion,
  I_BOOCharacteristicVersion._InspectionMethod AS _InspectionMethod,
  I_BOOCharacteristicVersion._InspectionMethodPlant AS _InspectionMethodPlant,
  I_BOOCharacteristicVersion._InspectionMethodVersion AS _InspectionMethodVersion,
  I_BOOCharacteristicVersion._InspectionSpecification AS _InspectionSpecification,
  I_BOOCharacteristicVersion._InspectionSpecificationPlant AS _InspectionSpecificationPlant,
  I_BOOCharacteristicVersion._SampleUnitOfMeasure AS _SampleUnitOfMeasure,
  I_BOOCharacteristicVersion._SamplingProcedure AS _SamplingProcedure
FROM I_BOOCharacteristicVersion
LEFT OUTER JOIN I_AssgmtInspMethInspSpec AS _AssgmtInspMethInspSpec ON InspectionSpecificationPlant = _AssgmtInspMethInspSpec.InspectionSpecificationPlant AND InspectionSpecification = _AssgmtInspMethInspSpec.InspectionSpecification AND InspectionSpecificationVersion = _AssgmtInspMethInspSpec.InspectionSpecificationVersion AND InspectionMethodPlant = _AssgmtInspMethInspSpec.InspectionMethodPlant AND InspectionMethod = _AssgmtInspMethInspSpec.InspectionMethod AND InspectionMethodVersion = _AssgmtInspMethInspSpec.InspectionMethodVersion  -- association [0..1]
LEFT OUTER JOIN I_InspToleranceSpecification AS _InspToleranceSpecification ON InspToleranceSpecification = _InspToleranceSpecification.InspToleranceSpecification  -- association [0..1]
LEFT OUTER JOIN I_InspectionScope AS _InspectionScope ON InspectionScope = _InspectionScope.InspectionScope  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspSpecUnitOfMeasure ON InspectionSpecificationUnit = _InspSpecUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_InspSpecRsltCalculation AS _InspSpecRsltCalculation ON InspSpecResultCalculation = _InspSpecRsltCalculation.InspSpecResultCalculation  -- association [0..1]
LEFT OUTER JOIN I_InspSpecRecordingType AS _InspSpecRecordingType ON InspSpecRecordingType = _InspSpecRecordingType.InspSpecRecordingType  -- association [0..1]
LEFT OUTER JOIN I_InspSpecPrintControl AS _InspSpecPrintControl ON InspSpecPrintControl = _InspSpecPrintControl.InspSpecPrintControl  -- association [0..1]
LEFT OUTER JOIN I_InspSpecCharcType AS _InspSpecCharcType ON InspSpecCharacteristicType = _InspSpecCharcType.InspSpecCharacteristicType  -- association [1..1]
LEFT OUTER JOIN I_Inspspeccharccategory AS _InspSpecCharcCategory ON InspSpecCharcCategory = _InspSpecCharcCategory.InspSpecCharcCategory  -- association [0..1]
LEFT OUTER JOIN I_InspResultDocuRequired AS _InspResultDocnRequired ON InspResultIsDocumentationRqd = _InspResultDocnRequired.InspResultIsDocumentationRqd  -- association [0..1]
LEFT OUTER JOIN I_DefectCode AS _InspDefectCodeRjcnUpper ON _InspDefectCodeRjcnUpper.DefectCodeGroup = InspSpecDefectCodeGrpRjcnUpper AND _InspDefectCodeRjcnUpper.DefectCode = InspSpecDefectCodeRjcnUpper  -- association [0..1]
LEFT OUTER JOIN I_DefectCode AS _InspDefectCodeRjcnLower ON _InspDefectCodeRjcnLower.DefectCodeGroup = InspSpecDefectCodeGrpRjcnLower AND _InspDefectCodeRjcnLower.DefectCode = InspSpecDefectCodeRjcnLower  -- association [0..1]
LEFT OUTER JOIN I_DefectCode AS _InspDefectCodeRejection ON _InspDefectCodeRejection.DefectCodeGroup = InspSpecDefectCodeGrpRejection AND _InspDefectCodeRejection.DefectCode = InspSpecDefectCodeRejection  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _InspDefectCodeGrpRjcnUpper ON _InspDefectCodeGrpRjcnUpper.DefectCodeGroup = InspSpecDefectCodeGrpRjcnUpper  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _InspDefectCodeGrpRjcnLower ON _InspDefectCodeGrpRjcnLower.DefectCodeGroup = InspSpecDefectCodeGrpRjcnLower  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _InspDefectCodeGrpRejection ON _InspDefectCodeGrpRejection.DefectCodeGroup = InspSpecDefectCodeGrpRejection  -- association [0..1]
LEFT OUTER JOIN I_InspectorQualification AS _InspectorQualification ON InspectorQualification = _InspectorQualification.InspectorQualification  -- association [0..1]
LEFT OUTER JOIN I_InspSpecImportanceCode AS _InspSpecImportanceCode ON InspSpecImportanceCode = _InspSpecImportanceCode.InspSpecImportanceCode  -- association [0..1]
LEFT OUTER JOIN I_CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet ON SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant AND SelectedCodeSet = _CharcAttribSelectedCodeSet.SelectedCodeSet  -- association [0..1]
;