I_InspPlanOpCharcTP

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_InspPlanOpCharcTP.
-- 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: IINSPPLOPCHARCTP

CREATE VIEW I_InspPlanOpCharcTP AS
SELECT
  _InspPlanCharc.InspectionPlanGroup AS InspectionPlanGroup,
  _InspPlanCharc.InspectionPlan AS InspectionPlan,
  InspectionPlanInternalVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BOOCharacteristic,
  BOOCharacteristicVersion,
  _InspPlanCharc.BillOfOperationsType AS BillOfOperationsType,
  _InspPlanOperationVersion.OperationText AS OperationText,
  _InspPlanOperationVersion.Operation AS Operation,
  _InspPlanCharc._InspectionPlanVersion.BillOfOperationsDesc AS BillOfOperationsDesc,
  _InspPlanCharc.IsDeleted AS IsDeleted,
  BOOOperationPRTInternalID,
  cast( 'X' as abap.char(1) ) AS IsValid,
  InspectionMethod,
  InspectionMethodVersion,
  InspectionMethodPlant,
  InspSpecImportanceCode,
  InspectorQualification,
  InspectionSpecification,
  InspectionSpecificationVersion,
  InspectionSpecificationPlant,
  cast( '' as vdm_qvollst preserving type ) AS InspSpecTransferType,
  BOOCharcHasInspSpecReference,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspectionSpecificationText,
  _InspPlanOpPRT.ProductionResourceTool AS ProductionResourceTool,
  _InspPlanOpPRT.ProductionResourceToolDesc AS ProductionResourceToolDesc,
  InspSpecControlIndicators,
  cast ( InspSpecIsQuantitative as qkzqunmk preserving type ) AS InspSpecIsQuantitative,
  InspSpecCharacteristicType,
  InspSpecIsMeasuredValueRqd,
  InspSpecIsSelectedSetRequired,
  InspSpecIsUpperLimitRequired,
  InspSpecIsLowerLimitRequired,
  InspSpecIsTargetValueInLimit,
  InspectionScope,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspResultIsDocumentationRqd,
  InspSpecCharcCategory,
  InspSpecIsSampleQtyAdditive,
  InspSpecIsDestructive,
  InspSpecResultCalculation,
  InspSpecIsSamplingProcedRqd,
  InspSpecIsScrapRelevant,
  InspSpecHasFixedCtrlIndicators,
  InspSpecIsTestEquipmentRqd,
  InspSpecIsDefectsRecgAutomatic,
  InspSpecIsChgDocRequired,
  InspSpecIsControlChartUsed,
  InspSpecPrintControl,
  InspSpecIsDefectRecordingRqd,
  InspToleranceSpecification,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasLowerLimit,
  InspSpecHasUpperLimit,
  InspSpecInputProcedure,
  InspSpecHasFormula,
  InspSpecFormula1,
  InspSpecFormula2,
  InspSpecNumberOfClasses,
  InspSpecClassWidthQty,
  InspSpecHasClassWidth,
  InspSpecClassMidpointQty,
  InspSpecHasClassMidpoint,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAdditionalCatalog5,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecAddlSeldCodeSetPlant5,
  SamplingProcedure,
  InspCharacteristicSampleUnit,
  BOOCharcSampleQuantity,
  QltyCtrlChartAggrgnCriterion,
  InspLotDynamicRule,
  InspCharcDynModifRef,
  MatlIsConsideredForDynModif,
  SuplrIsConsideredForDynModif,
  MfrIsConsideredForDynModif,
  CustIsConsideredForDynModif,
  _InspPlanCharc.CreatedByUser AS CreatedByUser,
  _InspPlanCharc.CreationDate AS CreationDate,
  _InspPlanCharc.LastChangedByUser AS LastChangedByUser,
  _InspPlanCharc.LastChangeDate AS LastChangeDate,
  _InspPlanCharc.ValidityStartDate AS ValidityStartDate,
  _InspPlanCharc.ValidityEndDate AS ValidityEndDate,
  _InspPlanCharc.ChangeNumber AS ChangeNumber,
  BillOfOperationsVersion,
  _InspPlanCharc._InspectionPlan AS _InspectionPlan
LEFT OUTER JOIN I_InspPlanOperationTP AS _InspPlanOp ON InspectionPlanGroup = _InspPlanOp.InspectionPlanGroup AND InspectionPlan = _InspPlanOp.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanOp.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanOp.BOOOpInternalVersionCounter AND BillOfOperationsType = _InspPlanOp.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanTP AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_InspPlanDpndantCharcTP AS _InspPlanDpndantCharc ON InspectionPlanGroup = _InspPlanDpndantCharc.InspectionPlanGroup AND InspectionPlan = _InspPlanDpndantCharc.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanDpndantCharc.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanDpndantCharc.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanDpndantCharc.BOOOpInternalVersionCounter AND BOOCharacteristic = _InspPlanDpndantCharc.BOOCharacteristic AND BOOCharacteristicVersion = _InspPlanDpndantCharc.BOOCharacteristicVersion AND BillOfOperationsType = _InspPlanDpndantCharc.BillOfOperationsType  -- association [0..*]
LEFT OUTER JOIN I_InspPlanOpPRT AS _InspPlanOpPRT ON InspectionPlanGroup = _InspPlanOpPRT.InspectionPlanGroup AND InspectionPlan = _InspPlanOpPRT.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanOpPRT.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanOpPRT.BOOOpInternalVersionCounter AND BOOOperationPRTInternalID = _InspPlanOpPRT.BOOOperationPRTInternalID  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
;