I_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 I_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: IPRDCTINSPTPST

CREATE VIEW I_ProductInspTypeSetting AS
SELECT
  art AS InspectionLotType,
  matnr AS Product,
  werks AS Plant,
  ppl AS InspLotIsTaskListRequired,
  spezueber AS InspLotHasMaterialSpec,
  conf AS InspLotHasConfignSpecification,
  tls AS InspLotHasBatchCharc,
  app AS InspLotHasAutomSpecAssgmt,
  mer AS InspLotHasCharc,
  insmk AS HasPostToInspectionStock,
  ave AS InspLotIsAutomUsgeDcsnPossible,
  stichprver AS SamplingProcedure,
  dynregel AS InspLotDynamicRule,
  sproz AS InspLotSampleQuantityInPercent,
  hpz AS InspectionLotIsFullInspection,
  dyn AS InspLotSkipIsAllowed,
  mpb AS InspLotHasManualSampleSize,
  mst AS InspLotIsSmplCalcMnlTriggered,
  ein AS InspLotIsSerialNmbrPossible,
  mpdau AS InspLotDurationInDays,
  chg AS InspLotSummaryControl,
  qkzverf AS InspQualityScoreProcedure,
  qpmat AS InspLotAcceptedScrapRatioInPct,
  kzprfkost AS InspectionLotHasAppraisalCosts,
  aufnr_co AS QualityCostCollector,
  aktiv AS ProdInspTypeSettingIsActive,
  apa AS InspTypeIsPrfrd,
  afr AS InspLotHasHandlingUnit,
  ms_flag AS InspLotHasMultipleSpec,
  chg_orig_17 AS InspLotOfEWMSummaryControl
FROM qmat
LEFT OUTER JOIN I_InspectionLotType AS _InspectionLotType ON InspectionLotType = _InspectionLotType.InspectionLotType  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;