I_SADL_VOC_CurrencyCode_Text

DDL: I_SADL_VOC_CURRENCYCODE_TEXT SQL: ISADL_VOC_CC Type: view
3 Fields 1 Data Sources

Sadl Vocan Test: Currency Code

I_SADL_VOC_CurrencyCode_Text is a CDS View that provides data about "Sadl Vocan Test: Currency Code" in SAP S/4HANA. It reads from 1 data source (tcurt) and exposes 3 fields with key fields Currency_Code, Language.

Data Sources (1)

SourceAliasJoin Type
tcurt text from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ISADL_VOC_CC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sadl Vocan Test: Currency Code view
Search.searchable true view
ObjectModel.dataCategory #TEXT view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Currency_Code tcurt waers Transaction Currency
KEY Language tcurt spras Off. Language
Text tcurt ltext Text exists

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_SADL_VOC_CurrencyCode_Text.
-- 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: ISADL_VOC_CC

CREATE VIEW I_SADL_VOC_CurrencyCode_Text AS
SELECT
  text.waers AS Currency_Code,
  text.spras AS Language,
  text.ltext AS Text
FROM tcurt AS text
;

Learn More