I_SamplingProcedure

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_SamplingProcedure.
-- 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.

CREATE VIEW I_SamplingProcedure AS
SELECT
  qdsv.stichprver AS SamplingProcedure,
  kzumfs AS SamplingProcedureMltplSamples,
  cast( kzrast as vdm_qkzrast preserving type ) AS SamplingProcedureInspSubset,
  bewertmod AS SamplingValuationMode,
  stichprart AS SamplingType,
  qrkart AS QualityControlChartType,
  stprplan AS SamplingScheme,
  cast( kznvwsv as vdm_qkznvwsv preserving type ) AS SamplingProcedureIsBlocked,
  cast( qdsv.kzohi as vdm_qkzohi preserving type ) AS SamplingProcedHasNoInspStgeChg,
  qdsv.stpranz AS SmplgProcedNmbrOfMltplSamples,
  qdsv.stprumf AS SamplingProcedureNumberOfUnits,
  qdsv.annahmez AS SamplingProcedAcceptanceCount,
  cast( qdsv.kzvwsvpl as vdm_qkzvwsvpl preserving type ) AS SamplingProcedIsUsedInspPlan,
  qdsv.fbkey AS SampleDeterminationRule,
  qdsv.fbkeymfs AS InspSampleValuationRule,
  qdsv.prschaerfe AS SamplingProcedInspSeverity,
  qdsv.aqlwert AS SmplgProcedAcceptableQltyLevel,
  qdsv.prozumf AS SamplingProcedSmplSizeInPct,
  cast( qdsv.prozumfni as vdm_qninitial preserving type ) AS SamplingProcedHasSmplSizeInPct,
  qdsv.prozazl AS SamplingProcedAccptcCountInPct,
  cast( qdsv.prozazlni as vdm_qninitial preserving type ) AS SamplingProcedHasAccptcCtInPct,
  qdsv.ersteller AS CreatedByUser,
  qdsv.aenderer AS LastChangedByUser,
  qdsv.erstelldat AS SamplingProcedureCreationDate,
  qdsv.aenderdat AS SamplingProcedureChangeDate,
  qdsv.raster AS SamplingProcedInspFrequency
FROM qdsv
LEFT OUTER JOIN I_SamplingProcedureText AS _Text ON SamplingProcedure = _Text.SamplingProcedure  -- association [0..*]
LEFT OUTER JOIN I_SamplingProcedureInspSubset AS _SmplgProcedureInspSubset ON SamplingProcedureInspSubset = _SmplgProcedureInspSubset.SamplingProcedureInspSubset  -- association [0..1]
LEFT OUTER JOIN I_SamplingProcedureInspSubsetT AS _SampleProcedInspSubsetText ON SamplingProcedureInspSubset = _SampleProcedInspSubsetText.SamplingProcedureInspSubset  -- association [0..*]
LEFT OUTER JOIN I_SamplingValuationMode AS _SamplingValuationMode ON SamplingValuationMode = _SamplingValuationMode.SamplingValuationMode  -- association [0..1]
LEFT OUTER JOIN I_SamplingValuationModeText AS _SamplingValuationModeText ON SamplingValuationMode = _SamplingValuationModeText.SamplingValuationMode  -- association [0..*]
LEFT OUTER JOIN I_SamplingType AS _SamplingType ON SamplingType = _SamplingType.SamplingType  -- association [0..1]
LEFT OUTER JOIN I_SamplingTypeText AS _SamplingTypeText ON SamplingType = _SamplingTypeText.SamplingType  -- association [0..*]
LEFT OUTER JOIN I_SamplingScheme AS _SamplingScheme ON SamplingScheme = _SamplingScheme.SamplingScheme  -- association [0..1]
LEFT OUTER JOIN I_SamplingSchemeText AS _SamplingSchemeText ON SamplingScheme = _SamplingSchemeText.SamplingScheme  -- association [0..*]
LEFT OUTER JOIN I_QualityControlChartType AS _QualityControlChartType ON QualityControlChartType = _QualityControlChartType.QualityControlChartType  -- association [0..1]
LEFT OUTER JOIN I_QualityControlChartTypeText AS _QualityControlChartTypeText ON QualityControlChartType = _QualityControlChartTypeText.QualityControlChartType  -- association [0..*]
LEFT OUTER JOIN I_SampleDeterminationRule AS _SampleDeterminationRule ON SampleDeterminationRule = _SampleDeterminationRule.SampleDeterminationRule  -- association [0..1]
LEFT OUTER JOIN I_SampleDeterminationRuleText AS _SampleDeterminationRuleText ON SampleDeterminationRule = _SampleDeterminationRuleText.SampleDeterminationRule  -- association [0..*]
LEFT OUTER JOIN I_InspSampleValuationRule AS _InspSampleValuationRule ON InspSampleValuationRule = _InspSampleValuationRule.InspSampleValuationRule  -- association [0..1]
LEFT OUTER JOIN I_InspSampleValuationRuleTxt AS _InspSampleValuationRuleTxt ON InspSampleValuationRule = _InspSampleValuationRuleTxt.InspSampleValuationRule  -- association [0..*]
LEFT OUTER JOIN I_SmplgProcedMltplSamples AS _SmplgProcedMltplSamples ON SamplingProcedureMltplSamples = _SmplgProcedMltplSamples.SamplingProcedureMltplSamples  -- association [0..1]
LEFT OUTER JOIN I_SmplgProcedMltplSamplesText AS _SmplgProcedMltplSamplesText ON SamplingProcedureMltplSamples = _SmplgProcedMltplSamplesText.SamplingProcedureMltplSamples  -- association [0..*]
LEFT OUTER JOIN E_SamplingProcedure AS _Extension ON SamplingProcedure = _Extension.SamplingProcedure  -- association [1..1]
;