C_SamplingProcObjectPage

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_SamplingProcObjectPage.
-- 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.
-- Parameters: P_Language : sylangu

CREATE VIEW C_SamplingProcObjectPage AS
SELECT
  I_SamplingProcedure.SamplingProcedure AS SamplingProcedure,
  I_SamplingProcedure._Text[1:Language = $parameters.P_Language].SamplingProcedureText AS SamplingProcedureText,
  I_SamplingProcedure.SamplingType AS SamplingType,
  I_SamplingProcedure.SamplingValuationMode AS SamplingValuationMode,
  I_SamplingProcedure.QualityControlChartType AS QualityControlChartType,
  I_SamplingProcedure.SampleDeterminationRule AS SampleDeterminationRule,
  _SampleDeterminationRule._Text[1:Language = $parameters.P_Language].SampleDeterminationRuleTxt AS SampleDeterminationRuleTxt,
  I_SamplingProcedure.SamplingScheme AS SamplingScheme,
  I_SamplingProcedure.SamplingProcedureInspSubset AS SamplingProcedureInspSubset,
  I_SamplingProcedure.SamplingProcedureIsBlocked AS SamplingProcedureIsBlocked,
  I_SamplingProcedure.SamplingProcedIsUsedInspPlan AS SamplingProcedIsUsedInspPlan,
  I_SamplingProcedure.SamplingProcedHasNoInspStgeChg AS SamplingProcedHasNoInspStgeChg,
  SamplingProcedureMltplSamples,
  I_SamplingProcedure.SamplingProcedSmplSizeInPct * cast(100 as abap.fltp) AS SamplingProcedSmplSizeInPct,
  cast ( '' as abap.char( 16 ) ) AS SamplingProcedSmplSizeInPctTxt,
  I_SamplingProcedure.SamplingProcedHasSmplSizeInPct AS SamplingProcedHasSmplSizeInPct,
  I_SamplingProcedure.SamplingProcedAccptcCountInPct * cast(100 as abap.fltp) AS SamplingProcedAccptcCountInPct,
  cast ( '' as abap.char( 16 ) ) AS SmplgProcedAccptcCountInPctTxt,
  SamplingProcedHasAccptcCtInPct,
  I_SamplingProcedure.SamplingProcedureNumberOfUnits AS SamplingProcedureNumberOfUnits,
  I_SamplingProcedure.SmplgProcedAcceptableQltyLevel AS SmplgProcedAcceptableQltyLevel,
  I_SamplingProcedure.SmplgProcedNmbrOfMltplSamples AS SmplgProcedNmbrOfMltplSamples,
  _InspSampleValuationRule._Text[1:Language=$parameters.P_Language].InspSampleValuationRuleTxt AS InspSampleValuationRuleTxt,
  I_SamplingProcedure.CreatedByUser AS CreatedByUser,
  _CreatedByUserContactCard.FullName AS CreatedByUserFullName,
  I_SamplingProcedure.SamplingProcedureCreationDate AS SamplingProcedureCreationDate,
  I_SamplingProcedure.LastChangedByUser AS LastChangedByUser,
  _ChangedByUserContactCard.FullName AS LastChangedByUserFullName,
  I_SamplingProcedure.SamplingProcedureChangeDate AS SamplingProcedureChangeDate,
  cast( ' ' as is_cloud_system preserving type ) AS IsCloudSystem,
  I_SamplingProcedure._SamplingType AS _SamplingType,
  I_SamplingProcedure._SamplingTypeText AS _SamplingTypeText,
  I_SamplingProcedure._SmplgProcedureInspSubset AS _SmplgProcedureInspSubset,
  I_SamplingProcedure._SampleProcedInspSubsetText AS _SampleProcedInspSubsetText,
  I_SamplingProcedure._SamplingValuationMode AS _SamplingValuationMode,
  I_SamplingProcedure._SamplingValuationModeText AS _SamplingValuationModeText,
  I_SamplingProcedure._SamplingScheme AS _SamplingScheme,
  I_SamplingProcedure._SamplingSchemeText AS _SamplingSchemeText,
  I_SamplingProcedure._SampleDeterminationRule AS _SampleDeterminationRule,
  I_SamplingProcedure._InspSampleValuationRule AS _InspSampleValuationRule,
  I_SamplingProcedure._QualityControlChartType AS _QualityControlChartType,
  I_SamplingProcedure._QualityControlChartTypeText AS _QualityControlChartTypeText,
  I_SamplingProcedure._SmplgProcedMltplSamples AS _SmplgProcedMltplSamples,
  I_SamplingProcedure._SmplgProcedMltplSamplesText AS _SmplgProcedMltplSamplesText
FROM I_SamplingProcedure
LEFT OUTER JOIN I_SamplingProcedureValueHelp AS _SamplingProcedureValueHelp ON SamplingProcedure = _SamplingProcedureValueHelp.SamplingProcedure  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUserContactCard ON LastChangedByUser = _ChangedByUserContactCard.ContactCardID  -- association [0..1]
;