C_InspPlanOpCharc

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 C_InspPlanOpCharc.
-- 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: CINSPPLOPCHARC

CREATE VIEW C_InspPlanOpCharc AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BOOCharacteristic,
  BOOCharacteristicVersion,
  BillOfOperationsType,
  _InspPlan.TaskListKeyDateText AS TaskListKeyDateText,
  OperationText,
  Operation,
  BillOfOperationsDesc,
  IsValid,
  IsDeleted,
  InspectionMethod,
  InspectionMethodVersion,
  InspectionMethodPlant,
  InspSpecImportanceCode,
  InspectionSpecification,
  InspectionSpecificationVersion,
  InspectionSpecificationPlant,
  InspSpecTransferType,
  BOOCharcHasInspSpecReference,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspectionSpecificationText,
  ProductionResourceTool,
  ProductionResourceToolDesc,
  InspSpecControlIndicators,
  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,
  _InspPlan.SamplingProcedureInspSubset AS SamplingProcedureInspSubset,
  cast( ' ' as xfeld preserving type ) AS SmplgProcedHasNoInspSbst,
  cast( ' ' as xfeld preserving type ) AS SamplingValuationIsByCode,
  cast( ' ' as xfeld preserving type ) AS SmplgValnIsByNcnfrmngUnits,
  cast( ' ' as xfeld preserving type ) AS SamplingValuationIsByDefects,
  cast( ' ' as xfeld preserving type ) AS SmplgValnIsByStdDvtnMethod,
  cast( ' ' as xfeld preserving type ) AS SmplgValnIsByToleranceLimits,
  SamplingProcedure,
  InspCharacteristicSampleUnit,
  BOOCharcSampleQuantity,
  QltyCtrlChartAggrgnCriterion,
  InspLotDynamicRule,
  InspCharcDynModifRef,
  MatlIsConsideredForDynModif,
  SuplrIsConsideredForDynModif,
  MfrIsConsideredForDynModif,
  CustIsConsideredForDynModif,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BillOfOperationsVersion
FROM I_InspPlanOpCharcTP AS _InspPlanCharc
LEFT OUTER JOIN C_InspPlanOperation 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 C_InspectionPlan AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN C_InspPlanDpndantCharc AS _InspPlanDpndantCharc ON InspectionPlanGroup = _InspPlanDpndantCharc.InspectionPlanGroup AND InspectionPlan = _InspPlanDpndantCharc.InspectionPlan AND BOOCharacteristic = _InspPlanDpndantCharc.BOOCharacteristic AND BOOOperationInternalID = _InspPlanDpndantCharc.BOOOperationInternalID AND BOOCharacteristicVersion = _InspPlanDpndantCharc.BOOCharacteristicVersion AND InspectionPlanInternalVersion = _InspPlanDpndantCharc.InspectionPlanInternalVersion AND BOOOpInternalVersionCounter = _InspPlanDpndantCharc.BOOOpInternalVersionCounter AND BillOfOperationsType = _InspPlanDpndantCharc.BillOfOperationsType  -- association [0..*]
LEFT OUTER JOIN I_InspSpecInputProcedureText AS _InspSpecInputProcText ON InspSpecInputProcedure = _InspSpecInputProcText.InspSpecInputProcedure  -- association [0..*]
;