SADL_V_AUnit_Currency

DDL: SADL_V_AUNIT_CURRENCY SQL: SADLVCUR Type: view

Currency for local unit tests

SADL_V_AUnit_Currency is a CDS View that provides data about "Currency for local unit tests" in SAP S/4HANA. It reads from 1 data source (tcurt) and exposes 5 fields with key fields waers, spras.

Data Sources (1)

SourceAliasJoin Type
tcurt tcurt from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADLVCUR view
EndUserText.label Currency for local unit tests view
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY waers tcurt waers Transaction Currency
KEY spras tcurt spras Off. Language
ltext tcurt ltext Text exists
ktext tcurt ktext Text
_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 SADL_V_AUnit_Currency.
-- 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: SADLVCUR

CREATE VIEW SADL_V_AUnit_Currency AS
SELECT
  tcurt.waers AS waers,
  tcurt.spras AS spras,
  tcurt.ltext AS ltext,
  tcurt.ktext AS ktext
FROM tcurt
;