I_DrvtvPosInterfaceLayer

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 I_DrvtvPosInterfaceLayer.
-- 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: IVFINDIL
-- Parameters: P_DisplayView : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date, P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_OptionDeltaMethod : cds_option_delta_method, P_OptionDeltaThreshold : cds_option_delta_threshold, P_CommodityViewSelectionType : cmm_view_type

CREATE VIEW I_DrvtvPosInterfaceLayer AS
SELECT
  CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  CommodityPriceExposureVersion,
  CommodityViewTypeText,
  CommodityViewSelectionType,
  ValidityStartDateTime,
  ValidityEndDateTime,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  MaximumVersion,
  RiskAnalyzerVersionUUID,
  ExposureDueDate,
  ReportingDate,
  Commodity,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  HasError,
  SystemMessageNumber,
  TermStartDate,
  TermEndDate,
  DeliveryDate,
  NumberOfCommodityContracts,
  CommodityPriceFixationStatus,
  TreasuryPositionAccount,
  DerivativeContract,
  OptionStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  OptionExerciseType,
  OptionDeltaFactorKeyFigure,
  ExternalKeyFigureValue,
  OptionDeltaFactor,
  EndOfDayBusinessEntityKey,
  ReportingMonth,
  ReportingYear,
  EvaluationDate,
  EndOfDaySnapshotDate,
  EndOfDaySnapshotDateTime,
  ConsumptionType AS MTMDataSelectionType,
  DisplayView,
  CommodityPriceExposureQuantity,
  CommodityPriceExposureUnit,
  PricedFinancialPositionQty,
  UnpricedFinancialPositionQty,
  DueInPastUnpricedFinPosQty,
  DueMktOnClsUnpricedFinPosQty,
  DueInFutureUnpricedFinPosQty,
  cast( ContractPriceExposure as cds_unpriced_cntrct_exp_qty) AS UnpricedContrPriceExposureQty,
  cast( MarketPriceExposure as cds_undlvrd_mkt_pr_exp_qty) AS UndeliveredMarketPrExposureQty,
  cast( OutrightExposureQty as cmm_outright_exposure_qty) AS OutrightPriceExposureQty,
  FinancialPositionQty,
  FinInstrExternalReference,
  TradedDrvtvContrSpecification,
  ParDrvtvContractSpecification,
  RiskViewIsNotRelevant,
  FinancialTransactionPortfolio,
  CmmdtyHdgPlanExposureHedgeBook,
  CommodityHedgePlanExposureID
FROM P_DerivativePosInterfaceLayer
LEFT OUTER JOIN E_FinancialInstrCharacteristic AS _Extension ON CompanyCode = _Extension.CompanyCode AND CommodityPriceExposure = _Extension.CommodityPriceExposure AND CommodityExposureCategory = _Extension.CommodityExposureCategory AND CommodityPriceSubExposure = _Extension.CommodityPriceSubExposure AND CommodityPriceExposureVersion = _Extension.CommodityPriceExposureVersion  -- association [1..1]
;