P_EvalRsltsEndOfDayPnL

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_EvalRsltsEndOfDayPnL.
-- 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: PEVALRSLTSEODPNL
-- Parameters: P_EvaluationDate : cds_evaluation_date, p_EvaluationDateVFINR : cds_evaluation_date, P_DisplayCurrency : cds_view_currency, P_DisplayView : cds_view_uom

CREATE VIEW P_EvalRsltsEndOfDayPnL AS
SELECT
  VFIND.CompanyCode AS CompanyCode,
  VFIND.CommodityPriceExposure AS CommodityPriceExposure,
  VFIND.CommodityExposureCategory AS CommodityExposureCategory,
  VFIND.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  VFIND.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  VFIND.ValidityStartDateTime AS ValidityStartDateTime,
  VFIND.ValidityEndDateTime AS ValidityEndDateTime,
  VFIND.ValidityStartDate AS ValidityStartDate,
  VFIND.ValidityStartTime AS ValidityStartTime,
  VFIND.ValidityEndDate AS ValidityEndDate,
  VFIND.ValidityEndTime AS ValidityEndTime,
  VFIND.ValidityStartCharTimestamp AS ValidityStartCharTimestamp,
  VFIND.ValidityEndCharTimestamp AS ValidityEndCharTimestamp,
  VFIND.MaximumVersion AS MaximumVersion,
  VFIND.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  VFIND.ExposureDueDate AS ExposureDueDate,
  VFIND.ReportingDate AS ReportingDate,
  VFIND.Commodity AS Commodity,
  VFIND.CashFlowDirection AS CashFlowDirection,
  VFIND.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  VFIND.DerivativeContrSpecification AS DerivativeContrSpecification,
  VFIND.MarketIdentifierCode AS MarketIdentifierCode,
  VFIND.TimeToMaturity AS TimeToMaturity,
  VFIND.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  VFIND.MaturityKeyDate AS MaturityKeyDate,
  VFIND.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  VFIND.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  VFIND.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  VFIND.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  VFIND.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  VFIND.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  VFIND.FinancialObject AS FinancialObject,
  VFIND.PnLEventType AS PnLEventType,
  VFIND.TermStartDate AS TermStartDate,
  VFIND.TermEndDate AS TermEndDate,
  VFIND.DeliveryDate AS DeliveryDate,
  VFIND.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  VFIND.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  VFIND.CommodityPriceExposureBaseUnit AS CommodityPriceExposureBaseUnit,
  VFIND.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  VFIND.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  VFIND.CommodityPriceExposureQuantity AS CommodityPriceExposureQuantity,
  VFIND.CommodityPriceExposureBaseQty AS CommodityPriceExposureBaseQty,
  VFIND.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  VFIND.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  VFIND.TreasuryPositionAccount AS TreasuryPositionAccount,
  VFIND.DerivativeContract AS DerivativeContract,
  VFIND.OptionStrikePrice AS OptionStrikePrice,
  VFIND.OptionStrikeCurrency AS OptionStrikeCurrency,
  VFIND.OptionPutCallCode AS OptionPutCallCode,
  VFIND.OptionExerciseType AS OptionExerciseType,
  VFIND.EvaluationDate AS EvaluationDate,
  VFIND.ConsumptionType AS ConsumptionType,
  VFIND.FinInstrExternalReference AS FinInstrExternalReference,
  VFIND.DisplayView AS DisplayView,
  cast($parameters.P_DisplayCurrency as cds_view_currency) AS DisplayCurrency,
  cast ( case when VFIND.HasError = 'X' then 'VFIND' when STATE.HasError = 'X' then 'SAVES' when VFINR.HasError = 'X' then 'VFINR' when VFINR.CommodityPriceExposure is null then 'NO_VFINR' else ' ' end as abap.char(20) ) as SourceError AS char20asSourceError,
  VFINR.UndiscountedMTMVaInQtanCrcy AS UndiscountedMTMVaInQtanCrcy,
  VFINR.ContractValueInQtanCurrency AS ContractValueInQtanCurrency,
  VFINR.MarketValueInQtanCurrency AS MarketValueInQtanCurrency,
  VFINR.QuotationCurrency AS QuotationCurrency,
  VFINR.UndiscountedMTMValInPaytCrcy AS UndiscountedMTMValInPaytCrcy,
  VFINR.ContractValueInPaytCurrency AS ContractValueInPaytCurrency,
  VFINR.MarketValInPaytCurrency AS MarketValInPaytCurrency,
  VFINR.PaymentCurrency AS PaymentCurrency,
  VFINR.UndiscountedMTMValInStstcCrcy AS UndiscountedMTMValInStstcCrcy,
  VFINR.ContractValueInStstcCurrency AS ContractValueInStstcCurrency,
  VFINR.MarketValueInStstcCurrency AS MarketValueInStstcCurrency,
  VFINR.StatisticsCurrency AS StatisticsCurrency,
  VFINR.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  VFIND._CompanyCode AS _CompanyCode,
  VFIND._DerivativeContrSpecification AS _DerivativeContrSpecification,
  VFIND._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  VFIND._MarketIdentifierCode AS _MarketIdentifierCode,
  VFIND._PhysicalCommodity AS _PhysicalCommodity,
  VFIND._UnitOfMeasure AS _UnitOfMeasure
FROM P_DrvtvInstrEndOfDayQtyCnsldtn
INNER JOIN I_VersionedRiskAdminData AS STATE ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EvalRsltsEndOfDayVals ON /* join condition not captured in parsed metadata */
;