P_DrvtvInstrQtyCnsldtn

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_DrvtvInstrQtyCnsldtn.
-- 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: PVFINDCURQTY
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_DisplayView : cds_view_uom

CREATE VIEW P_DrvtvInstrQtyCnsldtn AS
SELECT
  vfind.CompanyCode AS CompanyCode,
  vfind.CommodityPriceExposure AS CommodityPriceExposure,
  vfind.CommodityExposureCategory AS CommodityExposureCategory,
  vfind.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  cast(max(vfind.CommodityPriceSubExposure) as cmm_vfind_exposure_subkey ) AS CommodityPriceSubExposure,
  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,
  cast(max( vfind.ExposureDueDate ) as ftr_exposure_date) AS ExposureDueDate,
  cast(max( vfind.ReportingDate ) as ftr_reporting_date) 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,
  cast(max( vfind.MaturityKeyDate ) as tba_keydate) 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.HasError AS HasError,
  vfind.TermStartDate AS TermStartDate,
  vfind.TermEndDate AS TermEndDate,
  cast (max( vfind.DeliveryDate ) as ftr_delivery_date) AS DeliveryDate,
  cast(sum( vfind.NumberOfCommodityContracts ) as tb_contracts_number) AS NumberOfCommodityContracts,
  vfind.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  vfind.CommodityPriceExposureBaseUnit AS CommodityPriceExposureBaseUnit,
  vfind.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  vfind.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  cast(sum( vfind.CommodityPriceExposureQuantity ) as ftr_exposure_qty) AS CommodityPriceExposureQuantity,
  cast(sum( vfind.CommodityPriceExposureBaseQty ) as ftr_exposure_base_qty) AS CommodityPriceExposureBaseQty,
  cast(sum( vfind.CmmdtyPriceExpsrQtyInMassUnit ) as ftr_exposure_mass_qty) AS CmmdtyPriceExpsrQtyInMassUnit,
  cast(sum( vfind.CmmdtyPriceExpsrQtyInVolUnit ) as ftr_exposure_volume_qty) 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,
  vfind.QuotationPriceType AS QuotationPriceType,
  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_DrvtvInstrAvgGrpg
;