P_Vlogp_Gmdafx

DDL: P_VLOGP_GMDAFX SQL: PVLOGPGMDAFX Type: view BASIC
11 Fields 2 Data Sources

P_Vlogp_Gmdafx is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_GmdaFx, P_Vlogp_Fx) and exposes 11 fields with key fields bukrs, SourceCurrency, TargetCurrency, ExchangeRateType, maturity.

Data Sources (2)

SourceAliasJoin Type
I_GmdaFx gmdafx left_outer
P_Vlogp_Fx P_Vlogp_Fx from

Parameters (2)

NameTypeDefault
P_valuation_date cmm_eval_keydate
P_snapshot_date cmm_dend_cutdate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVLOGPGMDAFX view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY bukrs vlogpfx bukrs Value
KEY SourceCurrency vlogpfx SourceCurrency Source Currency
KEY TargetCurrency vlogpfx TargetCurrency Target Currency
KEY ExchangeRateType vlogpfx ExchangeRateType Exch. Rate Type
KEY maturity vlogpfx maturity Maturity Date
eval_date_to I_GmdaFx ExchangeRateValidTo To Date of FX Rate
fwd_rate I_GmdaFx ForwardExchangeRate Exchange Rate
spot_rate I_GmdaFx SpotExchangeRate Spot Exchange Rate
swap_rate I_GmdaFx SwapExchangeRate Swap Exchange Rate
interpolated I_GmdaFx SwapExchangeRateIsInterpolated Interpolated
read_back I_GmdaFx ExchangeRateIsOutdated Read Back

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 P_Vlogp_Gmdafx.
-- 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: PVLOGPGMDAFX
-- Parameters: P_valuation_date : cmm_eval_keydate, P_snapshot_date : cmm_dend_cutdate

CREATE VIEW P_Vlogp_Gmdafx AS
SELECT
  vlogpfx.bukrs AS bukrs,
  vlogpfx.SourceCurrency AS SourceCurrency,
  vlogpfx.TargetCurrency AS TargetCurrency,
  vlogpfx.ExchangeRateType AS ExchangeRateType,
  vlogpfx.maturity AS maturity,
  gmdafx.ExchangeRateValidTo AS eval_date_to,
  gmdafx.ForwardExchangeRate AS fwd_rate,
  gmdafx.SpotExchangeRate AS spot_rate,
  gmdafx.SwapExchangeRate AS swap_rate,
  gmdafx.SwapExchangeRateIsInterpolated AS interpolated,
  gmdafx.ExchangeRateIsOutdated AS read_back
FROM P_Vlogp_Fx
LEFT OUTER JOIN I_GmdaFx AS gmdafx ON /* join condition not captured in parsed metadata */
;

Learn More