I_InspCharacteristicTP

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_InspCharacteristicTP.
-- 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: IINSPCHARCTP

CREATE VIEW I_InspCharacteristicTP AS
SELECT
  _InspCharc.InspectionLot AS InspectionLot,
  _InspCharc.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspCharc.InspectionCharacteristic AS InspectionCharacteristic,
  _InspCharc.InspectionSpecificationText AS InspectionSpecificationText,
  _InspCharc.HasInspCharcPrtlSmpl AS HasInspCharcPrtlSmpl,
  _InspCharc.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspCharc.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspCharc.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  _InspCharc.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  _InspCharc.InspSpecRecordingType AS InspSpecRecordingType,
  _InspCharc.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  _InspCharc.InspSpecCharcCategory AS InspSpecCharcCategory,
  _InspCharc.InspSpecResultCalculation AS InspSpecResultCalculation,
  _InspCharc.InspCharcIsNotPlanned AS InspCharcIsNotPlanned,
  _InspCharc.InspectionMethod AS InspectionMethod,
  _InspCharc.InspectionMethodPlant AS InspectionMethodPlant,
  _InspCharc.InspectionMethodVersion AS InspectionMethodVersion,
  _InspCharc.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspCharc.InspectionSpecification AS InspectionSpecification,
  _InspCharc.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspCharc.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  _InspCharc.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspCharc.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspCharc.InspSampleValuationRule AS InspSampleValuationRule,
  _InspCharc.QuantityUnit AS QuantityUnit,
  _InspCharc.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspCharc.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspCharc.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspCharc.InspSpecTargetValue AS InspSpecTargetValue,
  _FrmtdVal.InspSpecFrmtdTargetValue AS InspSpecFrmtdTargetValue,
  _InspCharc.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  _InspCharc.InspSpecUpperLimit AS InspSpecUpperLimit,
  _FrmtdVal.InspSpecFrmtdUpperLimit AS InspSpecFrmtdUpperLimit,
  _InspCharc.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspCharc.InspSpecLowerLimit AS InspSpecLowerLimit,
  _FrmtdVal.InspSpecFrmtdLowerLimit AS InspSpecFrmtdLowerLimit,
  _InspCharc.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspCharc.InspSpecImportanceCode AS InspSpecImportanceCode,
  _InspCharc.InspLotTestEquipInternalID AS InspLotTestEquipInternalID,
  _InspCharc.SelectedCodeSet AS SelectedCodeSet,
  _InspCharc.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _InspCharc.InspectorQualification AS InspectorQualification,
  _InspCharc.InspSpecFormula1 AS InspSpecFormula1,
  _InspCharc.InspSpecFormula2 AS InspSpecFormula2,
  _InspCharc.InspSpecInformationField1 AS InspSpecInformationField1,
  _InspCharc.InspSpecInformationField2 AS InspSpecInformationField2,
  _InspCharc.InspSpecInformationField3 AS InspSpecInformationField3,
  _InspCharc.InspSpecDefectCodeGrpRjcnLower AS InspSpecDefectCodeGrpRjcnLower,
  _InspCharc.InspSpecDefectCodeRjcnLower AS InspSpecDefectCodeRjcnLower,
  _InspCharc.InspSpecDefectCodeGrpRjcnUpper AS InspSpecDefectCodeGrpRjcnUpper,
  _InspCharc.InspSpecDefectCodeRjcnUpper AS InspSpecDefectCodeRjcnUpper,
  _InspCharc.InspSpecDefectCodeGrpRejection AS InspSpecDefectCodeGrpRejection,
  _InspCharc.InspSpecDefectCodeRejection AS InspSpecDefectCodeRejection,
  _InspCharc.InspectionScope AS InspectionScope,
  _InspCharc.InspCharcQuantity AS InspCharcQuantity,
  _InspCharc.InspSpecControlIndicators AS InspSpecControlIndicators,
  _InspCharc.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspCharc.UnplndCharcInspSubsetIntID AS UnplndCharcInspSubsetIntID,
  _InspCharc.InspLotDynamicRule AS InspLotDynamicRule,
  _InspCharc.QualityLevelInternalID AS QualityLevelInternalID,
  _InspCharc.BOOCharcGroup AS BOOCharcGroup,
  _InspCharc.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  _InspCharc.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  _InspCharc.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  _InspCharc.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  _InspCharc.InspCharcConfirmationNumber AS InspCharcConfirmationNumber,
  _InspCharc.InspCharcCreationDate AS InspCharcCreationDate,
  _InspCharc.InspSpecAdditionalCatalog2 AS InspSpecAdditionalCatalog2,
  _InspCharc.InspSpecAdditionalCatalog3 AS InspSpecAdditionalCatalog3,
  _InspCharc.InspSpecAdditionalCatalog4 AS InspSpecAdditionalCatalog4,
  _InspCharc.InspSpecAdditionalCatalog5 AS InspSpecAdditionalCatalog5,
  _InspCharc.InspSpecAddlSeldCodeSetPlant2 AS InspSpecAddlSeldCodeSetPlant2,
  _InspCharc.InspSpecAddlSeldCodeSetPlant3 AS InspSpecAddlSeldCodeSetPlant3,
  _InspCharc.InspSpecAddlSeldCodeSetPlant4 AS InspSpecAddlSeldCodeSetPlant4,
  _InspCharc.InspSpecAddlSeldCodeSetPlant5 AS InspSpecAddlSeldCodeSetPlant5,
  _InspCharc.InspSpecAdditionalSelectedSet2 AS InspSpecAdditionalSelectedSet2,
  _InspCharc.InspSpecAdditionalCodeGroup2 AS InspSpecAdditionalCodeGroup2,
  _InspCharc.InspSpecAdditionalSelectedSet3 AS InspSpecAdditionalSelectedSet3,
  _InspCharc.InspSpecAdditionalCodeGroup3 AS InspSpecAdditionalCodeGroup3,
  _InspCharc.InspSpecAdditionalSelectedSet4 AS InspSpecAdditionalSelectedSet4,
  _InspCharc.InspSpecAdditionalCodeGroup4 AS InspSpecAdditionalCodeGroup4,
  _InspCharc.InspSpecAdditionalSelectedSet5 AS InspSpecAdditionalSelectedSet5,
  _InspCharc.InspSpecAdditionalCodeGroup5 AS InspSpecAdditionalCodeGroup5,
  _InspLot.ChangedDateTime AS ChangedDateTime,
  _InspLot.Plant AS Plant,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspOper._WorkCenter.WorkCenter AS WorkCenter,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionCharacteristic AS _InspCharc
INNER JOIN I_InspectionLot AS _InspLot ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionOperation AS _InspOper ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspCharcFrmtdValues AS _FrmtdVal ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionResultTP AS _InspResult ON InspectionLot = _InspResult.InspectionLot AND InspPlanOperationInternalID = _InspResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultValueTP AS _InspResultValue ON InspectionLot = _InspResultValue.InspectionLot AND InspPlanOperationInternalID = _InspResultValue.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResultValue.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_InspSampleCharcTP AS _InspSmplCharc ON InspectionLot = _InspSmplCharc.InspectionLot AND InspPlanOperationInternalID = _InspSmplCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSmplCharc.InspectionCharacteristic  -- association [1..*]
LEFT OUTER JOIN I_InspSampleResultTP AS _InspSmplResult ON InspectionLot = _InspSmplResult.InspectionLot AND InspPlanOperationInternalID = _InspSmplResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSmplResult.InspectionCharacteristic  -- association [1..*]
LEFT OUTER JOIN E_InspectionCharacteristic AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic  -- association [1..1]
;