I_TreasuryPositionHistory

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_TreasuryPositionHistory.
-- 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: ITRLPOSHIST
-- Parameters: P_KeyDate : vdm_v_key_date, P_TreasuryPositionPeriod : ftr_pos_hist_period, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_TreasuryPositionHistory AS
SELECT
  I_Ftr_Position_Values.TreasuryValuationArea AS TreasuryValuationArea,
  I_Ftr_Position_Values.TreasuryValuationClass AS TreasuryValuationClass,
  I_Ftr_Position_Values.CompanyCode AS CompanyCode,
  I_Ftr_Position_Values.SecurityAccount AS SecurityAccount,
  I_Ftr_Position_Values.SecurityClass AS SecurityClass,
  I_Ftr_Position_Values.TreasuryPositionAccount AS TreasuryPositionAccount,
  I_Ftr_Position_Values.TreasuryPositionLot AS TreasuryPositionLot,
  I_Ftr_Position_Values.FinancialTransaction AS FinancialTransaction,
  I_Ftr_Position_Values.FinancialExposureItem AS FinancialExposureItem,
  I_Ftr_Position_Values.FinancialExposureSubItem AS FinancialExposureSubItem,
  I_Ftr_Position_Values.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  I_Ftr_Position_Values.DifferentiationPortfolio AS DifferentiationPortfolio,
  I_Ftr_Position_Values.SecurityAccountGroup AS SecurityAccountGroup,
  I_Ftr_Position_Values.LoanContract AS LoanContract,
  I_Ftr_Position_Values.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  I_Ftr_Position_Values.CentralClearingAccount AS CentralClearingAccount,
  I_Ftr_Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Position_Values.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  I_Ftr_Position_Values.Trader AS Trader,
  I_Ftr_Position_Values.Fund AS Fund,
  I_Ftr_Position_Values.GrantID AS GrantID,
  I_Ftr_Position_Values.TreasuryAccountingCode AS TreasuryAccountingCode,
  I_Ftr_Position_Values.TreasuryPositionZeroDate AS TreasuryPositionZeroDate,
  I_Ftr_Position_Values.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  I_Ftr_Position_Values.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  P_TreasuryHistPeriod.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  P_TreasuryHistPeriod.TreasuryPositionLedgerDateText AS TreasuryPositionLedgerDateText,
  I_Ftr_Position_Values.PostingDate AS PostingDate,
  I_Ftr_Position_Values.TreasuryPosition AS TreasuryPosition,
  I_Ftr_Position_Values.TrsySubPosition AS TrsySubPosition,
  I_Ftr_Position_Values.TrsyPosQuantityChangeCategory AS TrsyPosQuantityChangeCategory,
  I_Ftr_Position_Values.TrsyPosAmountChangeCategory AS TrsyPosAmountChangeCategory,
  I_Ftr_Position_Values.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
  I_Ftr_Position_Values.TrsyPosValuationStepProcedure AS TrsyPosValuationStepProcedure,
  I_Ftr_Position_Values.CommitmentBusinessPartner AS CommitmentBusinessPartner,
  I_Ftr_Position_Values.TrsyDerivedBusTransacIsUpdated AS TrsyDerivedBusTransacIsUpdated,
  I_Ftr_Position_Values.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Position_Values.TreasuryUpdateType AS TreasuryUpdateType,
  I_Ftr_Position_Values.PositionCurrency AS PositionCurrency,
  I_Ftr_Position_Values.ValuationCurrency AS ValuationCurrency,
  I_Ftr_Position_Values.WBSElementExternalID AS WBSElementExternalID,
  I_Ftr_Position_Values.FunctionalArea AS FunctionalArea,
  I_Ftr_Position_Values.CostCenter AS CostCenter,
  I_Ftr_Position_Values.ProfitCenter AS ProfitCenter,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  _TrsyPosCustomDiffntnTerm1._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm1Name AS TrsyPosCustomDiffntnTerm1Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  _TrsyPosCustomDiffntnTerm2._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm2Name AS TrsyPosCustomDiffntnTerm2Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  _TrsyPosCustomDiffntnTerm3._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm3Name AS TrsyPosCustomDiffntnTerm3Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  _TrsyPosCustomDiffntnTerm4._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm4Name AS TrsyPosCustomDiffntnTerm4Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  _TrsyPosCustomDiffntnTerm5._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm5Name AS TrsyPosCustomDiffntnTerm5Name,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency preserving type) AS DisplayCurrency,
  $parameters.P_ExchangeRateType AS ExchangeRateType,
  $parameters.P_TreasuryPositionPeriod AS TreasuryPositionPeriod,
  NominalCurrency,
  case when _TreasurySubPosition.DesignatedNominalCurrency is null then NominalCurrency else _TreasurySubPosition.DesignatedNominalCurrency end AS DesignatedNominalCurrency,
  QuantityInPieces,
  NominalAmountInNominalCurrency,
  OriglNominalAmtInNominalCrcy,
  PurchaseValueInPositionCrcy,
  PurchaseValueInValuationCrcy,
  SecurityValuationAmtInPosCrcy,
  SecurityValuationAmtInValnCrcy,
  ForeignCrcyValnAmtInValnCrcy,
  CostInPositionCurrency,
  CostInValuationCurrency,
  SecurityCostValnAmtInPosCrcy,
  SecurityCostValnAmtInValnCrcy,
  FrgnExchCostValnAmtInValnCrcy,
  AmortizationAmtInPositionCrcy,
  AmortizationAmtInValuationCrcy,
  ClrdPremDiscDefrlTxCompnAmount,
  ClrdPremDiscDefrlAmtInValnCrcy,
  PurValDeferralItmAmtInPosCrcy,
  PurValDeferralItmAmtInValnCrcy,
  FXValnAmtzdAcqnAmtInValnCrcy,
  VariationMarginAmountInPosCrcy,
  VariationMarginAmtInValnCrcy,
  OCISecurityValnAmountInPosCrcy,
  OCIScrtyValnAmountInValnCrcy,
  OCIFrgnExchValnAmtInValnCrcy,
  OCIScrtyCostValnAmtInPosCrcy,
  OCIScrtyCostValnAmtInValnCrcy,
  OCICostFXValnAmountInValnCrcy,
  InterestIncomeInPositionCrcy,
  InterestIncomeInValuationCrcy,
  AccruedInterestInPositionCrcy,
  AccruedInterestInValuationCrcy,
  NegttnSpreadAmtznAmtInPosCrcy,
  NegttnSpreadAmtznAmtInValnCrcy,
  CumltvRepaymentAmountInPosCrcy,
  CumltvRepaymentAmtInValnCrcy,
  PurCrcySpotValnAmtInValnCrcy,
  SaleCrcySpotValnAmtInValnCrcy,
  SwapAccrualAmountInPosCurrency,
  SwapAccrualAmountInValnCrcy,
  SwapValuationAmountInValnCrcy,
  ImpairmentAmountInPositionCrcy,
  ImpairmentAmtInValuationCrcy,
  ForeignExchImprmtAmtInValnCrcy,
  FrgnExchValnDiffAmtInValnCrcy,
  CapitalizationRsrvInPosCrcy,
  CapitalizationRsrvInValnCrcy,
  SecurityWriteUpAmountInPosCrcy,
  SecurityWriteUpAmtInValnCrcy,
  SecurityWriteDownAmtInPosCrcy,
  ScrtyWriteDownAmtInValnCrcy,
  FrgnExchWriteUpAmtInValnCrcy,
  FrgnExchWriteDownAmtInValnCrcy,
  ScrtyCostWriteUpAmtInPosCrcy,
  ScrtyCostWriteUpAmtInValnCrcy,
  ScrtyCostWriteDownAmtInPosCrcy,
  ScrtyCostWrtDownAmtInValnCrcy,
  FrgnExchCostWrtUpAmtInValnCrcy,
  FXCostWriteDownAmtInValnCrcy,
  DesignatedQuantityInPieces,
  DesignatedAmountInNominalCrcy,
  DesignatedOrigAmtInNominalCrcy,
  HedgeAmortizationAmtInPosCrcy,
  HedgeAmortizationAmtInValnCrcy,
  GainValueAdjmtAmountInPosCrcy,
  GainValueAdjmtAmountInValnCrcy,
  LossValueAdjmtAmountInPosCrcy,
  LossValueAdjmtAmountInValnCrcy,
  OriginalValueAdjmtAmtInPosCrcy,
  OriginalValAdjmtAmtInValnCrcy,
  TrsyClsfctnAmtInPosCrcy,
  TrsyClsfctnAmtInValnCrcy,
  EffctvAmtInPosCrcy,
  EffctvAmtInValnCrcy,
  IneffctvAmtInPosCrcy,
  IneffctvAmtInValnCrcy,
  EffctvCostHdggRsrvInPosCrcy,
  EffctvCostHdggRsrvInValnCrcy,
  IneffctvHdggRsrvPnLInPosCrcy,
  IneffctvHdggRsrvPnLInValnCrcy,
  EffctvHdggRsrvPnLInPosCrcy,
  EffctvHdggRsrvPnLInValnCrcy,
  IneffctvCostHdgRsrvPnLPosCrcy,
  IneffctvCostHdgRsrvPnLValnCrcy,
  EffctvCostHdgRsrvPnLInPosCrcy,
  EffctvCostHdgRsrvPnLInValnCrcy,
  PnLDesignatedAmtInPosCrcy,
  PnLDesignatedAmtInVC,
  PnLNonDesignatedAmtInPosCrcy,
  PnLNonDesignatedAmtInVC,
  AmtznNonDesignatedAmtInPosCrcy,
  AmtznNonDesignatedAmtInVC,
  CnsldtdScrtyGainAmtInPosCrcy,
  CnsldtdScrtyGainAmtInValnCrcy,
  CnsldtdScrtyLossAmtInPosCrcy,
  CnsldtdScrtyLossAmtInValnCrcy,
  CnsldtdForExGainAmtInValnCrcy,
  CnsldtdForExLossAmtInValnCrcy,
  LossAllowanceAmountInValnCrcy,
  FXLossAllowanceAmtInValnCrcy,
  OffstLossAllowanceAmtInPosCrcy,
  OffsetLossAllwncAmtInValnCrcy,
  OCIOffstLossAllwncAmtInPosCrcy,
  OCIOffstLossAllwncInValnCrcy,
  FXOffstLossAllwncAmtInValnCrcy,
  FXOffstOCILossAllwncInValnCrcy,
  AmtznAdjmtLossAllwncInPosCrcy,
  AmtznAdjmtLossAllwncInValnCrcy,
  ContractChangeAmtInPosCrcy,
  ContractChangeAmtInValnCrcy,
  FrgnExchContrChgAmtInValnCrcy,
  FXAmtznAdjLossAllwncInValnCrcy,
  BookValueAmtInPositionCurrency,
  BookValueAmountInValnCurrency,
  AcquisitionAmtInPositionCrcy,
  AcquisitionAmountInValnCrcy,
  AmortizedAcqnAmountInPosCrcy,
  AmortizedAcqnAmountInValnCrcy,
  AmortizedCostInPositionCrcy,
  AmortizedCostInValuationCrcy
FROM P_TreasuryHistPeriod
INNER JOIN I_Ftr_Position_Values ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateTypeVH ON ExchangeRateType = _ExchangeRateTypeVH.ExchangeRateType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPositionPeriodVH AS _TreasuryPositionPeriodVH ON TreasuryPositionPeriod = _TreasuryPositionPeriodVH.TreasuryPositionPeriod  -- association [1..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm1 AS _TrsyPosCustomDiffntnTerm1 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5  -- association [0..1]
;