P_Vlogp_Fx_Quotdt

DDL: P_VLOGP_FX_QUOTDT SQL: PVLOGPFXQUOTDT Type: view BASIC Package: LOG_CMM_RUNTIME_VALUATION

fx quot

P_Vlogp_Fx_Quotdt is a Basic CDS View that provides data about "fx quot" in SAP S/4HANA. It reads from 3 data sources (I_QuotTimeSeries, I_VersionedLogisticDocument, I_VlogpConvCurr) and exposes 5 fields. Part of development package LOG_CMM_RUNTIME_VALUATION.

Data Sources (3)

SourceAliasJoin Type
I_QuotTimeSeries tser inner
I_VersionedLogisticDocument vlogp from
I_VlogpConvCurr vlogp_c inner

Parameters (1)

NameTypeDefault
P_snapshot_date cmm_dend_cutdate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVLOGPFXQUOTDT 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 (5)

KeyFieldSource TableSource FieldDescription
bukrs I_VersionedLogisticDocument CompanyCode Receiver Company Code
SourceCurrency I_VlogpConvCurr SourceCurrency LowrBndry Crcy
TargetCurrency I_VlogpConvCurr TargetCurrency UprBndry Crcy
ExchangeRateType I_VlogpConvCurr ExchangeRateType Exch. Rate Type
maturity I_QuotTimeSeries PriceQuotationDate Quotation date

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_Fx_Quotdt.
-- 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: PVLOGPFXQUOTDT
-- Parameters: P_snapshot_date : cmm_dend_cutdate

CREATE VIEW P_Vlogp_Fx_Quotdt AS
SELECT
  vlogp.CompanyCode AS bukrs,
  vlogp_c.SourceCurrency AS SourceCurrency,
  vlogp_c.TargetCurrency AS TargetCurrency,
  vlogp_c.ExchangeRateType AS ExchangeRateType,
  tser.PriceQuotationDate AS maturity
FROM I_VersionedLogisticDocument AS vlogp
INNER JOIN I_QuotTimeSeries AS tser ON /* join condition not captured in parsed metadata */
INNER JOIN I_VlogpConvCurr AS vlogp_c ON /* join condition not captured in parsed metadata */
;