I_SampleDeterminationRuleText

DDL: I_SAMPLEDETERMINATIONRULETEXT Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Sample Determination Rule - Text

I_SampleDeterminationRuleText (Basic)

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

Manufacturing

I_SampleDeterminationRuleText is a Basic CDS View that provides data about "Sample Determination Rule - Text" in SAP S/4HANA. It reads from 1 data source (qdfbt) and exposes 5 fields with key fields Language, SampleDeterminationRule. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-PT
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Language-Dependent Text
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the rules for determining sampling procedures. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
qdfbt qdfbt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SampleDeterminationRule _SampleDeterminationRule $projection.SampleDeterminationRule = _SampleDeterminationRule.SampleDeterminationRule
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISMPLDETNRULET view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sample Determination Rule - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SampleDeterminationRule view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language qdfbt sprache Language Key
KEY SampleDeterminationRule qdfbt fbkey Identifier for the Sample Determination Rule
SampleDeterminationRuleTxt Determination Rule Text
_SampleDeterminationRule _SampleDeterminationRule
_Language _Language

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_SampleDeterminationRuleText.
-- 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_SampleDeterminationRuleText AS
SELECT
  qdfbt.sprache AS Language,
  qdfbt.fbkey AS SampleDeterminationRule,
  cast( qdfbt.kurztext as vdm_qfbkey_text preserving type ) AS SampleDeterminationRuleTxt
FROM qdfbt
LEFT OUTER JOIN I_SampleDeterminationRule AS _SampleDeterminationRule ON SampleDeterminationRule = _SampleDeterminationRule.SampleDeterminationRule  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More