SADL_V_AUnit_Viewbld

DDL: SADL_V_CURRENCY_VIEWBLD SQL: SADLVCUVB Type: view
7 Fields 1 Data Sources 1 Associations

Currency for local unit tests

SADL_V_AUnit_Viewbld is a CDS View that provides data about "Currency for local unit tests" in SAP S/4HANA. It reads from 1 data source (tcurr) and exposes 7 fields with key fields kurst, fcurr, tcurr, gdatu. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tcurr tcurr from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _From_Currency $projection.fcurr = _From_Currency.Currency

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName SADLVCUVB view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Currency for local unit tests view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY kurst tcurr kurst Fix.rate type (EMU)
KEY fcurr tcurr fcurr From currency
KEY tcurr tcurr tcurr Trans. Currency
KEY gdatu tcurr gdatu Valid until
ukurs tcurr ukurs Rate
ffact tcurr ffact Ratio (from)
tfact tcurr tfact Ratio (to)

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_Viewbld.
-- 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: SADLVCUVB

CREATE VIEW SADL_V_AUnit_Viewbld AS
SELECT
  tcurr.kurst AS kurst,
  tcurr.fcurr AS fcurr,
  tcurr.tcurr AS tcurr,
  tcurr.gdatu AS gdatu,
  tcurr.ukurs AS ukurs,
  tcurr.ffact AS ffact,
  tcurr.tfact AS tfact
FROM tcurr
LEFT OUTER JOIN I_Currency AS _From_Currency ON fcurr = _From_Currency.Currency  -- association [0..1]
;

Learn More