I_SamplingValuationMode

DDL: I_SAMPLINGVALUATIONMODE Type: view_entity BASIC Package: VDM_QM_PLANNING

Valuation Mode for Inspection Charc

I_SamplingValuationMode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_SamplingValuationMode is a Basic CDS View that provides data about "Valuation Mode for Inspection Charc" in SAP S/4HANA. It reads from 1 data source (qdbm) and exposes 10 fields with key field SamplingValuationMode. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F2255). Part of development package VDM_QM_PLANNING.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentQM-PT-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the valuation mode for inspection characteristics which defines how a decision is made to accept or reject inspection characteristics. The valuation mode is used in sampling procedures. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
qdbm qdbm from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SamplingValuationModeText _Text $projection.SamplingValuationMode = _Text.SamplingValuationMode

Annotations (12)

NameValueLevelField
EndUserText.label Valuation Mode for Inspection Charc view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey SamplingValuationMode view
Analytics.technicalName ISMPLGVALUMODE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2255 ASQL_F2255 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SamplingValuationMode qdbm bewertmod Valuation Mode
SmplgValnIsByNcnfrmngUnits qdbm kzattrfe Attributive Inspection by Nonconforming Units
SamplingValuationIsByDefects qdbm kzattrfz Attributive Inspection by Number of Defects
SmplgValnIsByStdDvtnMethod qdbm kzvars Variable Inspection by S-Method
SamplingValuationIsByCode qdbm kzcod Valuation by Code
SamplingValuationIsManually qdbm kzman Manual Valuation
SmplgValnIsByQltyCtrlChart qdbm kzqrk Acceptance Using Control Chart
SmplgValnIsByToleranceLimits qdbm kzknull Check Against Specification Limits (k = 0)
SmplgValnIsWithoutParameter qdbm kzohnebewp Without Valuation Parameters
_Text _Text

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_SamplingValuationMode.
-- 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_SamplingValuationMode AS
SELECT
  qdbm.bewertmod AS SamplingValuationMode,
  qdbm.kzattrfe AS SmplgValnIsByNcnfrmngUnits,
  qdbm.kzattrfz AS SamplingValuationIsByDefects,
  qdbm.kzvars AS SmplgValnIsByStdDvtnMethod,
  qdbm.kzcod AS SamplingValuationIsByCode,
  qdbm.kzman AS SamplingValuationIsManually,
  qdbm.kzqrk AS SmplgValnIsByQltyCtrlChart,
  qdbm.kzknull AS SmplgValnIsByToleranceLimits,
  qdbm.kzohnebewp AS SmplgValnIsWithoutParameter
FROM qdbm
LEFT OUTER JOIN I_SamplingValuationModeText AS _Text ON SamplingValuationMode = _Text.SamplingValuationMode  -- association [0..*]
;