I_ProductInspTypeSttgWthDrftTP

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_ProductInspTypeSttgWthDrftTP.
-- 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: IPRDINSPTYPESTTG

CREATE VIEW I_ProductInspTypeSttgWthDrftTP AS
SELECT
  InspectionLotType,
  Product,
  Plant,
  PlantQltyMgmtInspType.Plant AS PlantForEdit,
  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
FROM I_ProductInspTypeSetting AS PlantQltyMgmtInspType
LEFT OUTER JOIN I_ProductWD AS _ProductWD ON Product = _ProductWD.Product  -- association [1..1]
LEFT OUTER JOIN I_Productplantqtmanagementwd AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [1..1]
;