I_InspSpecificationVersionTP

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_InspSpecificationVersionTP.
-- 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 I_InspSpecificationVersionTP AS
SELECT
  I_InspSpecificationVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_InspSpecificationVersion.InspectionSpecification AS InspectionSpecification,
  I_InspSpecificationVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  I_InspSpecificationVersion.Plant AS Plant,
  I_InspSpecificationVersion.ValidityStartDate AS ValidityStartDate,
  I_InspSpecificationVersion.InspectionSpecificationSrchTxt AS InspectionSpecificationSrchTxt,
  I_InspSpecificationVersion.InspSpecGlobalName AS InspSpecGlobalName,
  I_InspSpecificationVersion.InspectionSpecificationStatus AS InspectionSpecificationStatus,
  I_InspSpecificationVersion.InspSpecTransferType AS InspSpecTransferType,
  I_InspSpecificationVersion.InspSpecCreatedByUser AS InspSpecCreatedByUser,
  I_InspSpecificationVersion.InspSpecCreationDate AS InspSpecCreationDate,
  I_InspSpecificationVersion.InspSpecChangedByUser AS InspSpecChangedByUser,
  I_InspSpecificationVersion.InspSpecChangeDate AS InspSpecChangeDate,
  I_InspSpecificationVersion.ChangedDateTime AS ChangedDateTime,
  I_InspSpecificationVersion.InspSpecControlIndicators AS InspSpecControlIndicators,
  I_InspSpecificationVersion.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  I_InspSpecificationVersion.InspSpecCharacteristicType AS InspSpecCharacteristicType,
  I_InspSpecificationVersion.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  I_InspSpecificationVersion.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  I_InspSpecificationVersion.InspSpecIsUpperLimitRequired AS InspSpecIsUpperLimitRequired,
  I_InspSpecificationVersion.InspSpecIsLowerLimitRequired AS InspSpecIsLowerLimitRequired,
  I_InspSpecificationVersion.InspSpecIsTargetValueInLimit AS InspSpecIsTargetValueInLimit,
  I_InspSpecificationVersion.InspectionScope AS InspectionScope,
  I_InspSpecificationVersion.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  I_InspSpecificationVersion.InspSpecRecordingType AS InspSpecRecordingType,
  I_InspSpecificationVersion.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  I_InspSpecificationVersion.InspSpecCharcCategory AS InspSpecCharcCategory,
  I_InspSpecificationVersion.InspSpecIsSampleQtyAdditive AS InspSpecIsSampleQtyAdditive,
  I_InspSpecificationVersion.InspSpecIsDestructive AS InspSpecIsDestructive,
  I_InspSpecificationVersion.InspSpecResultCalculation AS InspSpecResultCalculation,
  I_InspSpecificationVersion.InspSpecIsSamplingProcedRqd AS InspSpecIsSamplingProcedRqd,
  I_InspSpecificationVersion.InspSpecIsScrapRelevant AS InspSpecIsScrapRelevant,
  I_InspSpecificationVersion.InspSpecHasFixedCtrlIndicators AS InspSpecHasFixedCtrlIndicators,
  I_InspSpecificationVersion.InspSpecIsDefectRecordingRqd AS InspSpecIsDefectRecordingRqd,
  I_InspSpecificationVersion.InspSpecIsTestEquipmentRqd AS InspSpecIsTestEquipmentRqd,
  I_InspSpecificationVersion.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  I_InspSpecificationVersion.InspSpecIsChgDocRequired AS InspSpecIsChgDocRequired,
  I_InspSpecificationVersion.InspSpecIsControlChartUsed AS InspSpecIsControlChartUsed,
  I_InspSpecificationVersion.InspSpecPrintControl AS InspSpecPrintControl,
  I_InspSpecificationVersion.InspSpecImportanceCode AS InspSpecImportanceCode,
  I_InspSpecificationVersion.InspectorQualification AS InspectorQualification,
  I_InspSpecificationVersion.InspSpecInformationField1 AS InspSpecInformationField1,
  I_InspSpecificationVersion.InspSpecInformationField2 AS InspSpecInformationField2,
  I_InspSpecificationVersion.InspSpecInformationField3 AS InspSpecInformationField3,
  I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup AS QltyMstrDataAuthorizationGroup,
  I_InspSpecificationVersion.InspToleranceSpecification AS InspToleranceSpecification,
  I_InspSpecificationVersion.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  I_InspSpecificationVersion.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  I_InspSpecificationVersion.InspSpecTargetValue AS InspSpecTargetValue,
  I_InspSpecificationVersion.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  I_InspSpecificationVersion.InspSpecUpperLimit AS InspSpecUpperLimit,
  I_InspSpecificationVersion.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  I_InspSpecificationVersion.InspSpecLowerLimit AS InspSpecLowerLimit,
  I_InspSpecificationVersion.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  I_InspSpecificationVersion.InspSpecFirstUpperSpecLimit AS InspSpecFirstUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecHasFirstUpperSpecLimit AS InspSpecHasFirstUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecFirstLowerSpecLimit AS InspSpecFirstLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecHasFirstLowerSpecLimit AS InspSpecHasFirstLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecSecondUpperSpecLimit AS InspSpecSecondUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecHasSecondUprSpecLimit AS InspSpecHasSecondUprSpecLimit,
  I_InspSpecificationVersion.InspSpecSecondLowerSpecLimit AS InspSpecSecondLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecHasSecondLowrSpecLimit AS InspSpecHasSecondLowrSpecLimit,
  I_InspSpecificationVersion.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  I_InspSpecificationVersion.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  I_InspSpecificationVersion.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  I_InspSpecificationVersion.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  I_InspSpecificationVersion.InspSpecUpperSpecLimitChange AS InspSpecUpperSpecLimitChange,
  I_InspSpecificationVersion.InspSpecHasUprSpecLimitChange AS InspSpecHasUprSpecLimitChange,
  I_InspSpecificationVersion.InspSpecLowerSpecLimitChange AS InspSpecLowerSpecLimitChange,
  I_InspSpecificationVersion.InspSpecHasLowrSpecLimitChange AS InspSpecHasLowrSpecLimitChange,
  I_InspSpecificationVersion.InspSpecToleranceChgValidFrom AS InspSpecToleranceChgValidFrom,
  I_InspSpecificationVersion.InspSpecToleranceChgValidTo AS InspSpecToleranceChgValidTo,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnLower AS InspSpecDefectCodeGrpRjcnLower,
  I_InspSpecificationVersion.InspSpecDefectCodeRjcnLower AS InspSpecDefectCodeRjcnLower,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnUpper AS InspSpecDefectCodeGrpRjcnUpper,
  I_InspSpecificationVersion.InspSpecDefectCodeRjcnUpper AS InspSpecDefectCodeRjcnUpper,
  I_InspSpecificationVersion.CharcInternalID AS CharcInternalID,
  I_InspSpecificationVersion.CharcInternalID AS CharacteristicInternalID,
  _ClfnCharacteristicForKeyDate(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  _ClfnCharcDescForKeyDate(P_KeyDate: $session.system_date)[1:Language = $session.system_language ].CharcDescription AS CharcDescription,
  _ClfnCharcDescForKeyDate(P_KeyDate: $session.system_date)[1:Language = $session.system_language ].CharcDescription AS CharacteristicDescription,
  I_InspSpecificationVersion.DefectFractionEstimationProced AS DefectFractionEstimationProced,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRejection AS InspSpecDefectCodeGrpRejection,
  I_InspSpecificationVersion.InspSpecDefectCodeRejection AS InspSpecDefectCodeRejection,
  I_InspSpecificationVersion.InspSpecDeterminationRule AS InspSpecDeterminationRule,
  I_InspSpecificationVersion.InspSpecIsDetnRuleActive AS InspSpecIsDetnRuleActive
FROM I_InspSpecificationVersion
LEFT OUTER JOIN E_InspSpecificationVersion AS _Extension ON InspectionSpecificationPlant = _Extension.InspectionSpecificationPlant AND InspectionSpecification = _Extension.InspectionSpecification AND InspectionSpecificationVersion = _Extension.InspectionSpecificationVersion  -- association [1..1]
LEFT OUTER JOIN I_InspSpecInspMethTP AS _InspectionMethod ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InspSpecCatalogTP AS _InspSpecCatalog ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InspSpecVersionTextTP AS _InspSpecVersionText ON /* condition not available in parsed metadata */  -- association [0..*]
;