I_SupplierEvalResponseLanguage

DDL: I_SUPPLIEREVALRESPONSELANGUAGE SQL: ISUPLEVALRESPLNG Type: view BASIC Package: VDM_SLC_SRS

Supplier Evaluation Response Language

I_SupplierEvalResponseLanguage is a Basic CDS View that provides data about "Supplier Evaluation Response Language" in SAP S/4HANA. It reads from 1 data source (/srmsmc/d_srs_ln) and exposes 11 fields with key field SuplrEvalRspLanguageUUID. It has 5 associations to related views. Part of development package VDM_SLC_SRS.

Data Sources (1)

SourceAliasJoin Type
/srmsmc/d_srs_ln /srmsmc/d_srs_ln from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Language _Language _Language.Language = $projection.Language and _Language.Language = $projection.Language
[1..1] I_SupplierEvalResponseQnaire _SupplierEvalResponseQnaire $projection.SuplrEvalRspQuestionnaireUUID = _SupplierEvalResponseQnaire.SuplrEvalRspQuestionnaireUUID
[1..1] I_Indicator _IsSelectedLanguage $projection.IsSelectedLanguage = _IsSelectedLanguage.IndicatorValue
[1..1] I_Indicator _IsMasterLanguage $projection.IsMasterLanguage = _IsMasterLanguage.IndicatorValue
[1..1] I_SupplierEvalResponse _SupplierEvalResponse $projection.SuplrEvalRspUUID = _SupplierEvalResponse.SuplrEvalRspUUID

Annotations (9)

NameValueLevelField
EndUserText.label Supplier Evaluation Response Language view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISUPLEVALRESPLNG view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SuplrEvalRspLanguageUUID UUID
SuplrEvalRspUUID UUID
SuplrEvalRspQuestionnaireUUID UUID
Language Language Code
IsSelectedLanguage Indicator
IsMasterLanguage Indicator
_Language _Language
_SupplierEvalResponseQnaire _SupplierEvalResponseQnaire
_SupplierEvalResponse _SupplierEvalResponse
_IsSelectedLanguage _IsSelectedLanguage
_IsMasterLanguage _IsMasterLanguage

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_SupplierEvalResponseLanguage.
-- 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.
-- SQL view name: ISUPLEVALRESPLNG

CREATE VIEW I_SupplierEvalResponseLanguage AS
SELECT
  cast(db_key as /srmsmc/srs_lang_uuid preserving type) AS SuplrEvalRspLanguageUUID,
  cast(root_key as /srmsmc/srs_uuid preserving type) AS SuplrEvalRspUUID,
  cast(parent_key as /srmsmc/srs_qnr_uuid preserving type) AS SuplrEvalRspQuestionnaireUUID,
  cast( language_code as /srmsmc/language preserving type) AS Language,
  cast(sel_lang_ind as /srmsmc/selected_language preserving type) AS IsSelectedLanguage,
  cast(master_lang_ind as /srmsmc/master_language preserving type) AS IsMasterLanguage
FROM /srmsmc/d_srs_ln
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language AND _Language.Language = Language  -- association [1..1]
LEFT OUTER JOIN I_SupplierEvalResponseQnaire AS _SupplierEvalResponseQnaire ON SuplrEvalRspQuestionnaireUUID = _SupplierEvalResponseQnaire.SuplrEvalRspQuestionnaireUUID  -- association [1..1]
LEFT OUTER JOIN I_Indicator AS _IsSelectedLanguage ON IsSelectedLanguage = _IsSelectedLanguage.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicator AS _IsMasterLanguage ON IsMasterLanguage = _IsMasterLanguage.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_SupplierEvalResponse AS _SupplierEvalResponse ON SuplrEvalRspUUID = _SupplierEvalResponse.SuplrEvalRspUUID  -- association [1..1]
;