I_SAMPLINGPROCEDURE

CDS View
32 Fields 5 CDS Views

Sampling Procedure

I_SAMPLINGPROCEDURE is a CDS View in S/4HANA. Sampling Procedure. It contains 32 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_QltyLvlSmplProced view from CONSUMPTION Quality Lvl Sampling Procedure
C_SamplingProcedureVH view from CONSUMPTION Value help view for sampling procedure
C_SamplingProcedureVH view union CONSUMPTION Value help view for sampling procedure
C_SamplingProcObjectPage view from CONSUMPTION Sampling Procedure
I_SamplingProcedureValueHelp view from COMPOSITE Sampling Procedure

Fields (32)

KeyField CDS FieldsUsed in Views
KEY SamplingProcedure SamplingProcedure 2
_InspSampleValuationRule _InspSampleValuationRule 1
_QualityControlChartType _QualityControlChartType 1
_QualityControlChartTypeText _QualityControlChartTypeText 1
_SampleDeterminationRule _SampleDeterminationRule 1
_SampleProcedInspSubsetText _SampleProcedInspSubsetText 1
_SamplingScheme _SamplingScheme 1
_SamplingSchemeText _SamplingSchemeText 1
_SamplingType _SamplingType 1
_SamplingTypeText _SamplingTypeText 1
_SamplingValuationMode _SamplingValuationMode 1
_SamplingValuationModeText _SamplingValuationModeText 1
_SmplgProcedMltplSamples _SmplgProcedMltplSamples 1
_SmplgProcedMltplSamplesText _SmplgProcedMltplSamplesText 1
_SmplgProcedureInspSubset _SmplgProcedureInspSubset 1
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 1
QualityControlChartType QualityControlChartType 1
SampleDeterminationRule SampleDeterminationRule 1
SamplingProcedHasNoInspStgeChg SamplingProcedHasNoInspStgeChg 1
SamplingProcedHasSmplSizeInPct SamplingProcedHasSmplSizeInPct 1
SamplingProcedIsUsedInspPlan SamplingProcedIsUsedInspPlan 1
SamplingProcedureChangeDate SamplingProcedureChangeDate 1
SamplingProcedureCreationDate SamplingProcedureCreationDate 1
SamplingProcedureInspSubset SamplingProcedureInspSubset 1
SamplingProcedureIsBlocked SamplingProcedureIsBlocked 1
SamplingProcedureNumberOfUnits SamplingProcedureNumberOfUnits 1
SamplingScheme SamplingScheme 1
SamplingType SamplingType 1
SamplingValuationMode SamplingValuationMode 1
SmplgProcedAcceptableQltyLevel SmplgProcedAcceptableQltyLevel 1
SmplgProcedNmbrOfMltplSamples SmplgProcedNmbrOfMltplSamples 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sampling Procedure
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SAMPLINGPROCEDURE (
    SAMPLINGPROCEDURE,
    _INSPSAMPLEVALUATIONRULE,
    _QUALITYCONTROLCHARTTYPE,
    _QUALITYCONTROLCHARTTYPETEXT,
    _SAMPLEDETERMINATIONRULE,
    _SAMPLEPROCEDINSPSUBSETTEXT,
    _SAMPLINGSCHEME,
    _SAMPLINGSCHEMETEXT,
    _SAMPLINGTYPE,
    _SAMPLINGTYPETEXT,
    _SAMPLINGVALUATIONMODE,
    _SAMPLINGVALUATIONMODETEXT,
    _SMPLGPROCEDMLTPLSAMPLES,
    _SMPLGPROCEDMLTPLSAMPLESTEXT,
    _SMPLGPROCEDUREINSPSUBSET,
    CREATEDBYUSER,
    LASTCHANGEDBYUSER,
    QUALITYCONTROLCHARTTYPE,
    SAMPLEDETERMINATIONRULE,
    SAMPLINGPROCEDHASNOINSPSTGECHG,
    SAMPLINGPROCEDHASSMPLSIZEINPCT,
    SAMPLINGPROCEDISUSEDINSPPLAN,
    SAMPLINGPROCEDURECHANGEDATE,
    SAMPLINGPROCEDURECREATIONDATE,
    SAMPLINGPROCEDUREINSPSUBSET,
    SAMPLINGPROCEDUREISBLOCKED,
    SAMPLINGPROCEDURENUMBEROFUNITS,
    SAMPLINGSCHEME,
    SAMPLINGTYPE,
    SAMPLINGVALUATIONMODE,
    SMPLGPROCEDACCEPTABLEQLTYLEVEL,
    SMPLGPROCEDNMBROFMLTPLSAMPLES,
    PRIMARY KEY (SAMPLINGPROCEDURE)
);

Learn More