I_BOOCharacteristicVersion

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_BOOCharacteristicVersion.
-- 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: IPPBOOCHARCVERS

CREATE VIEW I_BOOCharacteristicVersion AS
SELECT
  plmk.plnty AS BillOfOperationsType,
  plmk.plnnr AS BillOfOperationsGroup,
  plmk.plnkn AS BOOOperationInternalID,
  plmk.merknr AS BOOCharacteristic,
  plmk.zaehl AS BOOCharacteristicVersion,
  plmk.gueltigab AS ValidityStartDate,
  plmk.valid_to_on_db AS ValidityEndDate,
  plmk.aendergnr AS ChangeNumber,
  plmk.loekz AS IsDeleted,
  plmk.qmtb_werks AS InspectionMethodPlant,
  plmk.pmethode AS InspectionMethod,
  plmk.pmtversion AS InspectionMethodVersion,
  plmk.merkgew AS InspSpecImportanceCode
FROM plmk
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 BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_BOOCharacteristic AS _BOOCharacteristic ON BillOfOperationsType = _BOOCharacteristic.BillOfOperationsType AND BillOfOperationsGroup = _BOOCharacteristic.BillOfOperationsGroup AND BOOOperationInternalID = _BOOCharacteristic.BOOOperationInternalID AND BOOCharacteristic = _BOOCharacteristic.BOOCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_InspectionMethod AS _InspectionMethod ON InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant AND InspectionMethod = _InspectionMethod.InspectionMethod  -- association [1..1]
LEFT OUTER JOIN I_InspectionMethodVersion AS _InspectionMethodVersion ON InspectionMethodPlant = _InspectionMethodVersion.InspectionMethodPlant AND InspectionMethod = _InspectionMethodVersion.InspectionMethod AND InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion  -- association [1..1]
LEFT OUTER JOIN I_InspectionSpecification AS _InspectionSpecification ON InspectionSpecificationPlant = _InspectionSpecification.InspectionSpecificationPlant AND InspectionSpecification = _InspectionSpecification.InspectionSpecification  -- association [1..1]
LEFT OUTER JOIN I_InspSpecificationVersion AS _InspSpecificationVersion ON InspectionSpecificationPlant = _InspSpecificationVersion.InspectionSpecificationPlant AND InspectionSpecification = _InspSpecificationVersion.InspectionSpecification AND InspectionSpecificationVersion = _InspSpecificationVersion.InspectionSpecificationVersion  -- association [1..1]
LEFT OUTER JOIN I_InspSpecImportanceCode AS _InspSpecImportanceCode ON InspSpecImportanceCode = _InspSpecImportanceCode.InspSpecImportanceCode  -- association [0..1]
LEFT OUTER JOIN I_InspectorQualification AS _InspectorQualification ON InspectorQualification = _InspectorQualification.InspectorQualification  -- association [0..1]
LEFT OUTER JOIN I_SamplingProcedure AS _SamplingProcedure ON SamplingProcedure = _SamplingProcedure.SamplingProcedure  -- association [0..1]
LEFT OUTER JOIN I_InspToleranceSpecification AS _InspToleranceSpecification ON InspToleranceSpecification = _InspToleranceSpecification.InspToleranceSpecification  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _InspDefectCodeGrpRejection ON _InspDefectCodeGrpRejection.DefectCodeGroup = InspSpecDefectCodeGrpRejection  -- 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_DefectCode AS _InspDefectCodeRjcnUpper ON _InspDefectCodeRjcnUpper.DefectCodeGroup = InspSpecDefectCodeGrpRjcnUpper AND _InspDefectCodeRjcnUpper.DefectCode = InspSpecDefectCodeRjcnUpper  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _InspDefectCodeGrpRjcnLower ON _InspDefectCodeGrpRjcnLower.DefectCodeGroup = InspSpecDefectCodeGrpRjcnLower  -- 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_CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet ON SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant AND SelectedCodeSet = _CharcAttribSelectedCodeSet.SelectedCodeSet  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _InspectionMethodPlant ON InspectionMethodPlant = _InspectionMethodPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _InspectionSpecificationPlant ON InspectionSpecificationPlant = _InspectionSpecificationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SelectedCodeSetPlant ON SelectedCodeSetPlant = _SelectedCodeSetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspSpecUnitOfMeasure ON InspectionSpecificationUnit = _InspSpecUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SampleUnitOfMeasure ON InspCharacteristicSampleUnit = _SampleUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_InspSpecCharcType AS _InspSpecCharcType ON InspSpecCharacteristicType = _InspSpecCharcType.InspSpecCharacteristicType  -- association [1..1]
LEFT OUTER JOIN I_InspectionScope AS _InspectionScope ON InspectionScope = _InspectionScope.InspectionScope  -- association [0..1]
LEFT OUTER JOIN I_InspSpecRecordingType AS _InspSpecRecordingType ON InspSpecRecordingType = _InspSpecRecordingType.InspSpecRecordingType  -- association [0..1]
LEFT OUTER JOIN I_InspResultDocuRequired AS _InspResultDocuRequired ON InspResultIsDocumentationRqd = _InspResultDocuRequired.InspResultIsDocumentationRqd  -- association [0..1]
LEFT OUTER JOIN I_Inspspeccharccategory AS _InspSpecCharcCategory ON InspSpecCharcCategory = _InspSpecCharcCategory.InspSpecCharcCategory  -- association [0..1]
LEFT OUTER JOIN I_InspSpecRsltCalculation AS _InspSpecRsltCalculation ON InspSpecResultCalculation = _InspSpecRsltCalculation.InspSpecResultCalculation  -- association [0..1]
LEFT OUTER JOIN I_InspSpecPrintControl AS _InspSpecPrintControl ON InspSpecPrintControl = _InspSpecPrintControl.InspSpecPrintControl  -- association [0..1]
LEFT OUTER JOIN I_BOOCharcInspRelevance AS _BOOCharcInspRelevance ON BOOCharacteristicInspRelevance = _BOOCharcInspRelevance.BOOCharacteristicInspRelevance  -- association [0..1]
LEFT OUTER JOIN E_BOOCharacteristic AS _Extension ON BillOfOperationsType = _Extension.BillOfOperationsType AND BillOfOperationsGroup = _Extension.BillOfOperationsGroup AND BOOOperationInternalID = _Extension.BOOOperationInternalID AND BOOCharacteristic = _Extension.BOOCharacteristic AND BOOCharacteristicVersion = _Extension.BOOCharacteristicVersion  -- association [1..1]
LEFT OUTER JOIN I_InspSpecificationVersionText AS _InspSpecificationVersionText ON InspectionSpecificationPlant = _InspSpecificationVersionText.InspectionSpecificationPlant AND InspectionSpecification = _InspSpecificationVersionText.InspectionSpecification AND InspectionSpecificationVersion = _InspSpecificationVersionText.InspectionSpecificationVersion AND _InspSpecificationVersionText.Language = $session.system_language  -- association [0..1]
;