R_ProdnRtgInspCharcsAssgmtTP_2

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 R_ProdnRtgInspCharcsAssgmtTP_2.
-- 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 R_ProdnRtgInspCharcsAssgmtTP_2 AS
SELECT
  InspCharcs.BillOfOperationsGroup AS ProductionRoutingGroup,
  InspCharcs.BillOfOperationsVariant AS ProductionRouting,
  InspCharcs.BillOfOperationsSequence AS ProductionRoutingSequence,
  InspCharcs.BOOOperationInternalID AS ProductionRoutingOpIntID,
  InspCharcs.BOOCharacteristic AS BOOCharacteristic,
  InspCharcs.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  InspCharcs.ValidityStartDate AS ValidityStartDate,
  InspCharcs.ValidityEndDate AS ValidityEndDate,
  InspCharcs.ChangeNumber AS ChangeNumber,
  InspCharcs.IsDeleted AS IsDeleted,
  InspCharcs.InspectionMethodPlant AS InspectionMethodPlant,
  InspCharcs.InspectionMethod AS InspectionMethod,
  InspCharcs.InspectionMethodVersion AS InspectionMethodVersion,
  InspCharcs.InspSpecImportanceCode AS InspSpecImportanceCode,
  InspCharcs.InspectorQualification AS InspectorQualification,
  InspCharcs.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  InspCharcs.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  InspCharcs.InspectionSpecification AS InspectionSpecification,
  InspCharcs.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  InspCharcs.BOOCharcHasInspSpecReference AS BOOCharcHasInspSpecReference,
  InspCharcs.InspSpecControlIndicators AS InspSpecControlIndicators,
  InspCharcs.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  InspCharcs.InspSpecIsQualitative AS InspSpecIsQualitative,
  InspCharcs.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  InspCharcs.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  InspCharcs.InspSpecIsUpperLimitRequired AS InspSpecIsUpperLimitRequired,
  InspCharcs.InspSpecIsLowerLimitRequired AS InspSpecIsLowerLimitRequired,
  InspCharcs.InspSpecIsTargetValueInLimit AS InspSpecIsTargetValueInLimit,
  InspCharcs.InspectionScope AS InspectionScope,
  InspCharcs.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  InspCharcs.InspSpecRecordingType AS InspSpecRecordingType,
  InspCharcs.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  InspCharcs.InspSpecCharcCategory AS InspSpecCharcCategory,
  InspCharcs.InspSpecIsSampleQtyAdditive AS InspSpecIsSampleQtyAdditive,
  InspCharcs.InspSpecIsDestructive AS InspSpecIsDestructive,
  InspCharcs.InspSpecResultCalculation AS InspSpecResultCalculation,
  InspCharcs.InspSpecHasNoFormula AS InspSpecHasNoFormula,
  InspCharcs.InspSpecIsSamplingProcedRqd AS InspSpecIsSamplingProcedRqd,
  InspCharcs.InspSpecIsScrapRelevant AS InspSpecIsScrapRelevant,
  InspCharcs.InspSpecHasFixedCtrlIndicators AS InspSpecHasFixedCtrlIndicators,
  InspCharcs.InspSpecIsDefectRecordingRqd AS InspSpecIsDefectRecordingRqd,
  InspCharcs.InspSpecIsTestEquipmentRqd AS InspSpecIsTestEquipmentRqd,
  InspCharcs.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  InspCharcs.InspSpecIsChgDocRequired AS InspSpecIsChgDocRequired,
  InspCharcs.InspSpecIsControlChartUsed AS InspSpecIsControlChartUsed,
  InspCharcs.InspSpecPrintControl AS InspSpecPrintControl,
  InspCharcs.InspToleranceSpecification AS InspToleranceSpecification,
  InspCharcs.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  InspCharcs.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  InspCharcs.InspSpecTargetValue AS InspSpecTargetValue,
  InspCharcs.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  InspCharcs.InspSpecUpperLimit AS InspSpecUpperLimit,
  InspCharcs.InspSpecLowerLimit AS InspSpecLowerLimit,
  InspCharcs.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  InspCharcs.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  InspCharcs.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  InspCharcs.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  InspCharcs.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  InspCharcs.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  InspCharcs.InspSpecFirstUpperSpecLimit AS InspSpecFirstUpperSpecLimit,
  InspCharcs.InspSpecHasFirstUpperSpecLimit AS InspSpecHasFirstUpperSpecLimit,
  InspCharcs.InspSpecFirstLowerSpecLimit AS InspSpecFirstLowerSpecLimit,
  InspCharcs.InspSpecHasFirstLowerSpecLimit AS InspSpecHasFirstLowerSpecLimit,
  InspCharcs.InspSpecSecondUpperSpecLimit AS InspSpecSecondUpperSpecLimit,
  InspCharcs.InspSpecHasSecondUprSpecLimit AS InspSpecHasSecondUprSpecLimit,
  InspCharcs.InspSpecSecondLowerSpecLimit AS InspSpecSecondLowerSpecLimit,
  InspCharcs.InspSpecHasSecondLowrSpecLimit AS InspSpecHasSecondLowrSpecLimit,
  InspCharcs.InspSpecToleranceChgValidFrom AS InspSpecToleranceChgValidFrom,
  InspCharcs.InspSpecToleranceChgValidTo AS InspSpecToleranceChgValidTo,
  InspCharcs.InspSpecUpperSpecLimitChange AS InspSpecUpperSpecLimitChange,
  InspCharcs.InspSpecHasUprSpecLimitChange AS InspSpecHasUprSpecLimitChange,
  InspCharcs.InspSpecLowerSpecLimitChange AS InspSpecLowerSpecLimitChange,
  InspCharcs.InspSpecHasLowrSpecLimitChange AS InspSpecHasLowrSpecLimitChange,
  InspCharcs.InspSpecNumberOfClasses AS InspSpecNumberOfClasses,
  InspCharcs.InspSpecClassWidthQty AS InspSpecClassWidthQty,
  InspCharcs.InspSpecHasClassWidth AS InspSpecHasClassWidth,
  InspCharcs.InspSpecClassMidpointQty AS InspSpecClassMidpointQty,
  InspCharcs.InspSpecHasClassMidpoint AS InspSpecHasClassMidpoint,
  InspCharcs.InspSpecHasFormula AS InspSpecHasFormula,
  InspCharcs.InspSpecFormula1 AS InspSpecFormula1,
  InspCharcs.InspSpecFormula2 AS InspSpecFormula2,
  InspCharcs.InspSpecDefectCodeGrpRejection AS InspSpecDefectCodeGrpRejection,
  InspCharcs.InspSpecDefectCodeRejection AS InspSpecDefectCodeRejection,
  InspCharcs.InspSpecDefectCodeGrpRjcnUpper AS InspSpecDefectCodeGrpRjcnUpper,
  InspCharcs.InspSpecDefectCodeRjcnUpper AS InspSpecDefectCodeRjcnUpper,
  InspCharcs.InspSpecDefectCodeGrpRjcnLower AS InspSpecDefectCodeGrpRjcnLower,
  InspCharcs.InspSpecDefectCodeRjcnLower AS InspSpecDefectCodeRjcnLower,
  InspCharcs.SelectedCodeSet AS SelectedCodeSet,
  InspCharcs.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  InspCharcs.InspSpecAdditionalCatalog2 AS InspSpecAdditionalCatalog2,
  InspCharcs.InspSpecAdditionalSelectedSet2 AS InspSpecAdditionalSelectedSet2,
  InspCharcs.InspSpecAdditionalCodeGroup2 AS InspSpecAdditionalCodeGroup2,
  InspCharcs.InspSpecAddlSeldCodeSetPlant2 AS InspSpecAddlSeldCodeSetPlant2,
  InspCharcs.InspSpecAdditionalCatalog3 AS InspSpecAdditionalCatalog3,
  InspCharcs.InspSpecAdditionalSelectedSet3 AS InspSpecAdditionalSelectedSet3,
  InspCharcs.InspSpecAdditionalCodeGroup3 AS InspSpecAdditionalCodeGroup3,
  InspCharcs.InspSpecAddlSeldCodeSetPlant3 AS InspSpecAddlSeldCodeSetPlant3,
  InspCharcs.InspSpecAdditionalCatalog4 AS InspSpecAdditionalCatalog4,
  InspCharcs.InspSpecAdditionalSelectedSet4 AS InspSpecAdditionalSelectedSet4,
  InspCharcs.InspSpecAdditionalCodeGroup4 AS InspSpecAdditionalCodeGroup4,
  InspCharcs.InspSpecAddlSeldCodeSetPlant4 AS InspSpecAddlSeldCodeSetPlant4,
  InspCharcs.InspSpecAdditionalCatalog5 AS InspSpecAdditionalCatalog5,
  InspCharcs.InspSpecAdditionalSelectedSet5 AS InspSpecAdditionalSelectedSet5,
  InspCharcs.InspSpecAdditionalCodeGroup5 AS InspSpecAdditionalCodeGroup5,
  InspCharcs.InspSpecAddlSeldCodeSetPlant5 AS InspSpecAddlSeldCodeSetPlant5,
  InspCharcs.SamplingProcedure AS SamplingProcedure,
  InspCharcs.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  InspCharcs.BOOCharcSampleQuantity AS BOOCharcSampleQuantity,
  InspCharcs.InspSpecInformationField1 AS InspSpecInformationField1,
  InspCharcs.InspSpecInformationField2 AS InspSpecInformationField2,
  InspCharcs.InspSpecInformationField3 AS InspSpecInformationField3,
  InspCharcs.InspectionSpecificationText AS InspectionSpecificationText,
  InspCharcs.CreatedByUser AS CreatedByUser,
  InspCharcs.CreationDate AS CreationDate,
  InspCharcs.LastChangedByUser AS LastChangedByUser,
  InspCharcs.LastChangeDate AS LastChangeDate,
  InspCharcs.MatlIsConsideredForDynModif AS MatlIsConsideredForDynModif,
  InspCharcs.SuplrIsConsideredForDynModif AS SuplrIsConsideredForDynModif,
  InspCharcs.MfrIsConsideredForDynModif AS MfrIsConsideredForDynModif,
  InspCharcs.CustIsConsideredForDynModif AS CustIsConsideredForDynModif,
  InspCharcs.InspLotDynamicRule AS InspLotDynamicRule,
  InspCharcs.InspCharcDynModifRef AS InspCharcDynModifRef,
  InspCharcs.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  InspCharcs.InspSpecInputProcedure AS InspSpecInputProcedure,
  InspCharcs.BOOCharcGroup AS BOOCharcGroup,
  InspCharcs.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  InspCharcs.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  InspCharcs.BillOfOperationsVersion AS BillOfOperationsVersion,
  _NonSqncTP.ChangedDateTime AS ChangedDateTime
FROM I_ProdnRtgInspCharcsAssgmt AS InspCharcs
INNER JOIN I_ProdnRtgOpInspCharcsToOp AS OpInspcharcs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProductionRoutingHeaderTP_2 AS _Header ON ProductionRoutingGroup = _Header.ProductionRoutingGroup AND ProductionRouting = _Header.ProductionRouting AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
;