C_ProductInspTypeSetting

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_ProductInspTypeSetting.
-- 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: CPRDPINSPTYPE

CREATE VIEW C_ProductInspTypeSetting AS
SELECT
  InspectionLotType,
  Product,
  Plant,
  InspLotIsTaskListRequired,
  InspLotHasMaterialSpec,
  InspLotHasConfignSpecification,
  InspLotHasBatchCharc,
  InspLotHasAutomSpecAssgmt,
  InspLotHasCharc,
  HasPostToInspectionStock,
  InspLotIsAutomUsgeDcsnPossible,
  SamplingProcedure,
  InspLotDynamicRule,
  InspLotSampleQuantityInPercent,
  InspectionLotIsFullInspection,
  InspLotSkipIsAllowed,
  InspLotHasManualSampleSize,
  InspLotIsSmplCalcMnlTriggered,
  InspLotIsSerialNmbrPossible,
  InspLotDurationInDays,
  InspLotSummaryControl,
  InspQualityScoreProcedure,
  InspLotAcceptedScrapRatioInPct,
  InspectionLotHasAppraisalCosts,
  QualityCostCollector,
  ProdInspTypeSettingIsActive,
  InspTypeIsPrfrd,
  InspLotHasHandlingUnit,
  InspLotHasMultipleSpec,
  InspLotOfEWMSummaryControl,
  _InspLotOriginVariant.InspectionLotOriginText AS InspectionLotOriginText,
  _InspLotOriginVariant.InspectionLotOrigin AS InspectionLotOrigin
FROM I_ProductInspTypeSttgWthDrftTP AS PlantQltyMgmtInspType
LEFT OUTER JOIN I_InspectionLotTypeText AS _InspectionLotTypeText ON InspectionLotType = _InspectionLotTypeText.InspectionLotType AND _InspectionLotTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_Product AS _ProductWD ON Product = _ProductWD.Product  -- association [1..1]
LEFT OUTER JOIN C_Productplantqtmanagement AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [1..1]
LEFT OUTER JOIN C_ProductInspLotOriginVariant AS _InspLotOriginVariant ON InspectionLotType = _InspLotOriginVariant.InspectionLotType  -- association [1..1]
LEFT OUTER JOIN I_InspLotSummaryControlText AS _InspLotSummaryControl ON InspLotSummaryControl = _InspLotSummaryControl.InspLotSummaryControl AND inspectionlotorigin = _InspLotSummaryControl.InspectionLotOrigin AND _InspLotSummaryControl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InspQltyScoreProcedureTxt AS _InspQualityScoreProcedure ON InspQualityScoreProcedure = _InspQualityScoreProcedure.InspQualityScoreProcedure AND _InspQualityScoreProcedure.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InspLotOfEWMSmmryCtrlText AS _InspLotOfEWMSmmryCtrl ON InspLotOfEWMSummaryControl = _InspLotOfEWMSmmryCtrl.InspLotOfEWMSummaryControl AND _InspLotOfEWMSmmryCtrl.Language = $session.system_language  -- association [0..1]
;