I_Ftr_Pos_Val_Parm_St

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_Ftr_Pos_Val_Parm_St.
-- 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: IFTRPOSVALPARM
-- Parameters: P_SelectionByPostingDateIsUsed : ftr_gen_use_sel_by_pstng_date, P_TrsyPosPlndDataIsInclusive : ftr_gen_pos_planned_data_incl

CREATE VIEW I_Ftr_Pos_Val_Parm_St AS
SELECT
  Position_Values.TreasuryPosition AS TreasuryPosition,
  Position_Values.TrsySubPosition AS TrsySubPosition,
  Position_Values.TreasuryValuationArea AS TreasuryValuationArea,
  Position_Values.TreasuryValuationClass AS TreasuryValuationClass,
  Position_Values.CompanyCode AS CompanyCode,
  Position_Values.SecurityAccount AS SecurityAccount,
  Position_Values.SecurityClass AS SecurityClass,
  Position_Values.TreasuryPositionAccount AS TreasuryPositionAccount,
  Position_Values.TreasuryPositionLot AS TreasuryPositionLot,
  Position_Values.FinancialTransaction AS FinancialTransaction,
  Position_Values.FinancialExposureItem AS FinancialExposureItem,
  Position_Values.FinancialExposureSubItem AS FinancialExposureSubItem,
  Position_Values.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  Position_Values.DifferentiationPortfolio AS DifferentiationPortfolio,
  Position_Values.SecurityAccountGroup AS SecurityAccountGroup,
  Position_Values.LoanContract AS LoanContract,
  Position_Values.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  Position_Values.CentralClearingAccount AS CentralClearingAccount,
  Position_Values.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  Position_Values.Trader AS Trader,
  Position_Values.Fund AS Fund,
  Position_Values.GrantID AS GrantID,
  Position_Values.FunctionalArea AS FunctionalArea,
  Position_Values.WBSElementExternalID AS WBSElementExternalID,
  Position_Values.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  Position_Values.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  Position_Values.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  Position_Values.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  Position_Values.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  Position_Values.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  Position_Values.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  Position_Values.TrsyPosValuationStepProcedure AS TrsyPosValuationStepProcedure,
  Position_Values.TrsyDerivedBusTransacIsUpdated AS TrsyDerivedBusTransacIsUpdated,
  _TrsyLdgrGLAcctAssgmtRef.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  Position_Values.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  Position_Values.PostingDate AS PostingDate,
  Position_Values.TrsyPosQuantityChangeCategory AS TrsyPosQuantityChangeCategory,
  Position_Values.TrsyPosAmountChangeCategory AS TrsyPosAmountChangeCategory,
  Position_Values.PositionCurrency AS PositionCurrency,
  Position_Values.ValuationCurrency AS ValuationCurrency,
  Position_Values.NominalCurrency AS NominalCurrency,
  Position_Values.TreasuryPositionZeroDate AS TreasuryPositionZeroDate,
  _TreasurySubPosition.HedgedItemUUID AS HedgedItemUUID,
  _TreasurySubPosition.HedgingInstrumentUUID AS HedgingInstrumentUUID,
  _TreasurySubPosition.IsFreestanding AS IsFreestanding,
  Position_Values.QuantityInPieces AS QuantityInPieces,
  _TreasurySubPosition.DesignatedNominalCurrency AS DesignatedNominalCurrency,
  NominalAmountInNominalCurrency,
  OriglNominalAmtInNominalCrcy,
  DesignatedQuantityInPieces,
  DesignatedAmountInNominalCrcy,
  DesignatedOrigAmtInNominalCrcy,
  Position_Values.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  Position_Values.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  Position_Values.ClearingAmountInPositionCrcy AS ClearingAmountInPositionCrcy,
  Position_Values.ClearingAmountInValuationCrcy AS ClearingAmountInValuationCrcy,
  Position_Values.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  Position_Values.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  Position_Values.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  Position_Values.CostInPositionCurrency AS CostInPositionCurrency,
  Position_Values.CostInValuationCurrency AS CostInValuationCurrency,
  Position_Values.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  Position_Values.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  Position_Values.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  Position_Values.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  Position_Values.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  Position_Values.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  Position_Values.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  Position_Values.IndexValuationAmountInPosCrcy AS IndexValuationAmountInPosCrcy,
  Position_Values.IndexValuationAmountInValnCrcy AS IndexValuationAmountInValnCrcy,
  Position_Values.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  Position_Values.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  Position_Values.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  Position_Values.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  Position_Values.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  Position_Values.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  Position_Values.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  Position_Values.OCIIndexValnAmountInPosCrcy AS OCIIndexValnAmountInPosCrcy,
  Position_Values.OCIIndexValnAmountInValnCrcy AS OCIIndexValnAmountInValnCrcy,
  Position_Values.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  Position_Values.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  Position_Values.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  Position_Values.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  Position_Values.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  Position_Values.NegttnSpreadAmtznAmtInPosCrcy AS NegttnSpreadAmtznAmtInPosCrcy,
  Position_Values.NegttnSpreadAmtznAmtInValnCrcy AS NegttnSpreadAmtznAmtInValnCrcy,
  Position_Values.CumltvRepaymentAmountInPosCrcy AS CumltvRepaymentAmountInPosCrcy,
  Position_Values.CumltvRepaymentAmtInValnCrcy AS CumltvRepaymentAmtInValnCrcy,
  Position_Values.PurCrcySpotValnAmtInValnCrcy AS PurCrcySpotValnAmtInValnCrcy,
  Position_Values.SaleCrcySpotValnAmtInValnCrcy AS SaleCrcySpotValnAmtInValnCrcy,
  Position_Values.SwapAccrualAmountInPosCurrency AS SwapAccrualAmountInPosCurrency,
  Position_Values.SwapAccrualAmountInValnCrcy AS SwapAccrualAmountInValnCrcy,
  Position_Values.SwapValuationAmountInValnCrcy AS SwapValuationAmountInValnCrcy,
  Position_Values.ImpairmentAmountInPositionCrcy AS ImpairmentAmountInPositionCrcy,
  Position_Values.ImpairmentAmtInValuationCrcy AS ImpairmentAmtInValuationCrcy,
  Position_Values.HedgeAmortizationAmtInPosCrcy AS HedgeAmortizationAmtInPosCrcy,
  Position_Values.HedgeAmortizationAmtInValnCrcy AS HedgeAmortizationAmtInValnCrcy,
  Position_Values.FrgnExchValnDiffAmtInValnCrcy AS FrgnExchValnDiffAmtInValnCrcy,
  Position_Values.GainValueAdjmtAmountInPosCrcy AS GainValueAdjmtAmountInPosCrcy,
  Position_Values.GainValueAdjmtAmountInValnCrcy AS GainValueAdjmtAmountInValnCrcy,
  Position_Values.LossValueAdjmtAmountInPosCrcy AS LossValueAdjmtAmountInPosCrcy,
  Position_Values.LossValueAdjmtAmountInValnCrcy AS LossValueAdjmtAmountInValnCrcy,
  Position_Values.OriginalValueAdjmtAmtInPosCrcy AS OriginalValueAdjmtAmtInPosCrcy,
  Position_Values.OriginalValAdjmtAmtInValnCrcy AS OriginalValAdjmtAmtInValnCrcy,
  Position_Values.CapitalizationRsrvInPosCrcy AS CapitalizationRsrvInPosCrcy,
  Position_Values.CapitalizationRsrvInValnCrcy AS CapitalizationRsrvInValnCrcy,
  Position_Values.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  Position_Values.ForeignExchImprmtAmtInValnCrcy AS ForeignExchImprmtAmtInValnCrcy,
  Position_Values.CnsldtdScrtyGainAmtInPosCrcy AS CnsldtdScrtyGainAmtInPosCrcy,
  Position_Values.CnsldtdScrtyGainAmtInValnCrcy AS CnsldtdScrtyGainAmtInValnCrcy,
  Position_Values.CnsldtdScrtyLossAmtInPosCrcy AS CnsldtdScrtyLossAmtInPosCrcy,
  Position_Values.CnsldtdScrtyLossAmtInValnCrcy AS CnsldtdScrtyLossAmtInValnCrcy,
  Position_Values.CnsldtdForExGainAmtInValnCrcy AS CnsldtdForExGainAmtInValnCrcy,
  Position_Values.CnsldtdForExLossAmtInValnCrcy AS CnsldtdForExLossAmtInValnCrcy,
  Position_Values.InterestIncomeInPositionCrcy AS InterestIncomeInPositionCrcy,
  Position_Values.InterestIncomeInValuationCrcy AS InterestIncomeInValuationCrcy,
  Position_Values.TrsyClsfctnAmtInPosCrcy AS TrsyClsfctnAmtInPosCrcy,
  Position_Values.TrsyClsfctnAmtInValnCrcy AS TrsyClsfctnAmtInValnCrcy,
  Position_Values.EffctvAmtInPosCrcy AS EffctvAmtInPosCrcy,
  Position_Values.EffctvAmtInValnCrcy AS EffctvAmtInValnCrcy,
  Position_Values.IneffctvAmtInPosCrcy AS IneffctvAmtInPosCrcy,
  Position_Values.IneffctvAmtInValnCrcy AS IneffctvAmtInValnCrcy,
  Position_Values.EffctvCostHdggRsrvInPosCrcy AS EffctvCostHdggRsrvInPosCrcy,
  Position_Values.EffctvCostHdggRsrvInValnCrcy AS EffctvCostHdggRsrvInValnCrcy,
  Position_Values.IneffctvHdggRsrvPnLInPosCrcy AS IneffctvHdggRsrvPnLInPosCrcy,
  Position_Values.IneffctvHdggRsrvPnLInValnCrcy AS IneffctvHdggRsrvPnLInValnCrcy,
  Position_Values.EffctvHdggRsrvPnLInPosCrcy AS EffctvHdggRsrvPnLInPosCrcy,
  Position_Values.EffctvHdggRsrvPnLInValnCrcy AS EffctvHdggRsrvPnLInValnCrcy,
  Position_Values.IneffctvCostHdgRsrvPnLPosCrcy AS IneffctvCostHdgRsrvPnLPosCrcy,
  Position_Values.IneffctvCostHdgRsrvPnLValnCrcy AS IneffctvCostHdgRsrvPnLValnCrcy,
  Position_Values.EffctvCostHdgRsrvPnLInPosCrcy AS EffctvCostHdgRsrvPnLInPosCrcy,
  Position_Values.EffctvCostHdgRsrvPnLInValnCrcy AS EffctvCostHdgRsrvPnLInValnCrcy,
  Position_Values.PnLDesignatedAmtInPosCrcy AS PnLDesignatedAmtInPosCrcy,
  Position_Values.PnLDesignatedAmtInVC AS PnLDesignatedAmtInVC,
  Position_Values.PnLNonDesignatedAmtInPosCrcy AS PnLNonDesignatedAmtInPosCrcy,
  Position_Values.PnLNonDesignatedAmtInVC AS PnLNonDesignatedAmtInVC,
  Position_Values.AmtznNonDesignatedAmtInPosCrcy AS AmtznNonDesignatedAmtInPosCrcy,
  Position_Values.AmtznNonDesignatedAmtInVC AS AmtznNonDesignatedAmtInVC,
  Position_Values.SecurityWriteUpAmountInPosCrcy AS SecurityWriteUpAmountInPosCrcy,
  Position_Values.SecurityWriteDownAmtInPosCrcy AS SecurityWriteDownAmtInPosCrcy,
  Position_Values.SecurityWriteUpAmtInValnCrcy AS SecurityWriteUpAmtInValnCrcy,
  Position_Values.ScrtyWriteDownAmtInValnCrcy AS ScrtyWriteDownAmtInValnCrcy,
  Position_Values.FrgnExchWriteUpAmtInValnCrcy AS FrgnExchWriteUpAmtInValnCrcy,
  Position_Values.FrgnExchWriteDownAmtInValnCrcy AS FrgnExchWriteDownAmtInValnCrcy,
  Position_Values.ScrtyCostWriteUpAmtInPosCrcy AS ScrtyCostWriteUpAmtInPosCrcy,
  Position_Values.ScrtyCostWriteDownAmtInPosCrcy AS ScrtyCostWriteDownAmtInPosCrcy,
  Position_Values.ScrtyCostWriteUpAmtInValnCrcy AS ScrtyCostWriteUpAmtInValnCrcy,
  Position_Values.ScrtyCostWrtDownAmtInValnCrcy AS ScrtyCostWrtDownAmtInValnCrcy,
  Position_Values.FrgnExchCostWrtUpAmtInValnCrcy AS FrgnExchCostWrtUpAmtInValnCrcy,
  Position_Values.FXCostWriteDownAmtInValnCrcy AS FXCostWriteDownAmtInValnCrcy,
  Position_Values.IndexWriteUpAmountInPosCrcy AS IndexWriteUpAmountInPosCrcy,
  Position_Values.IndexWriteDownAmountInPosCrcy AS IndexWriteDownAmountInPosCrcy,
  Position_Values.IndexWriteUpAmountInValnCrcy AS IndexWriteUpAmountInValnCrcy,
  Position_Values.IndexWriteDownAmtInValnCrcy AS IndexWriteDownAmtInValnCrcy,
  Position_Values.IndexCleanClearingAmtInPosCrcy AS IndexCleanClearingAmtInPosCrcy,
  Position_Values.IndexCleanPurchaseValInPosCrcy AS IndexCleanPurchaseValInPosCrcy,
  Position_Values.IdxCleanScrtyValnAmtInPosCrcy AS IdxCleanScrtyValnAmtInPosCrcy,
  Position_Values.IndexCleanCostInPositionCrcy AS IndexCleanCostInPositionCrcy,
  Position_Values.IndexClnScrtyCostValuationAmt AS IndexClnScrtyCostValuationAmt,
  Position_Values.IndexCleanAmtznAmountInPosCrcy AS IndexCleanAmtznAmountInPosCrcy,
  Position_Values.IdxClnClrdPremDiscDeferralAmt AS IdxClnClrdPremDiscDeferralAmt,
  Position_Values.IdxClnPurValDefrlAmtInPosCrcy AS IdxClnPurValDefrlAmtInPosCrcy,
  Position_Values.IdxClnOCIScrtyValnAmtInPosCrcy AS IdxClnOCIScrtyValnAmtInPosCrcy,
  Position_Values.IdxClnOCIScrtyCostValuationAmt AS IdxClnOCIScrtyCostValuationAmt,
  Position_Values.IndexCleanNegttnAmtznInPosCrcy AS IndexCleanNegttnAmtznInPosCrcy,
  Position_Values.IndexCleanRpaytAmtInPosCrcy AS IndexCleanRpaytAmtInPosCrcy,
  Position_Values.IndexCleanInterestIncInPosCrcy AS IndexCleanInterestIncInPosCrcy,
  Position_Values.IdxCleanHedgeAmtznAmtInPosCrcy AS IdxCleanHedgeAmtznAmtInPosCrcy,
  Position_Values.IndexCleanImprmtAmtInPosCrcy AS IndexCleanImprmtAmtInPosCrcy,
  Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  Position_Values.CostExcldBookValueAmtInPosCrcy AS CostExcldBookValueAmtInPosCrcy,
  Position_Values.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  Position_Values.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  Position_Values.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  Position_Values.CostExcldBookValAmtInValnCrcy AS CostExcldBookValAmtInValnCrcy,
  Position_Values.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  Position_Values.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  Position_Values.IndexClnBookValueAmtInPosCrcy AS IndexClnBookValueAmtInPosCrcy,
  Position_Values.IdxClnCostExcldBookValueAmount AS IdxClnCostExcldBookValueAmount,
  Position_Values.IndexCleanAcqnAmountInPosCrcy AS IndexCleanAcqnAmountInPosCrcy,
  Position_Values.IdxCleanAmtzdAcqnAmtInPosCrcy AS IdxCleanAmtzdAcqnAmtInPosCrcy,
  Position_Values.LossAllowanceAmountInPosCrcy AS LossAllowanceAmountInPosCrcy,
  Position_Values.LossAllowanceAmountInValnCrcy AS LossAllowanceAmountInValnCrcy,
  Position_Values.FXLossAllowanceAmtInValnCrcy AS FXLossAllowanceAmtInValnCrcy,
  Position_Values.OffsetLossAllwncAmtInValnCrcy AS OffsetLossAllwncAmtInValnCrcy,
  Position_Values.OffstLossAllowanceAmtInPosCrcy AS OffstLossAllowanceAmtInPosCrcy,
  Position_Values.FXOffstLossAllwncAmtInValnCrcy AS FXOffstLossAllwncAmtInValnCrcy,
  Position_Values.OCIOffstLossAllwncInValnCrcy AS OCIOffstLossAllwncInValnCrcy,
  Position_Values.OCIOffstLossAllwncAmtInPosCrcy AS OCIOffstLossAllwncAmtInPosCrcy,
  Position_Values.FXOffstOCILossAllwncInValnCrcy AS FXOffstOCILossAllwncInValnCrcy,
  Position_Values.AmtznAdjmtLossAllwncInPosCrcy AS AmtznAdjmtLossAllwncInPosCrcy,
  Position_Values.AmtznAdjmtLossAllwncInValnCrcy AS AmtznAdjmtLossAllwncInValnCrcy,
  Position_Values.FXAmtznAdjLossAllwncInValnCrcy AS FXAmtznAdjLossAllwncInValnCrcy,
  Position_Values.ContractChangeAmtInPosCrcy AS ContractChangeAmtInPosCrcy,
  Position_Values.ContractChangeAmtInValnCrcy AS ContractChangeAmtInValnCrcy,
  Position_Values.FrgnExchContrChgAmtInValnCrcy AS FrgnExchContrChgAmtInValnCrcy,
  Position_Values.IdxCleanLossAllwncAmtInPosCrcy AS IdxCleanLossAllwncAmtInPosCrcy,
  Position_Values.IdxCleanOffsetLossAllowanceAmt AS IdxCleanOffsetLossAllowanceAmt,
  Position_Values.IdxClnOCIOffstLossAllwncAmtIn AS IdxClnOCIOffstLossAllwncAmtIn,
  Position_Values.IdxClnAmtznAdjLossAllInPosCrcy AS IdxClnAmtznAdjLossAllInPosCrcy,
  Position_Values.IdxClnContrChangeAmtInPosCrcy AS IdxClnContrChangeAmtInPosCrcy,
  Position_Values.AmortizedCostInPositionCrcy AS AmortizedCostInPositionCrcy,
  Position_Values.IdxClnAmortizedCostInPosCrcy AS IdxClnAmortizedCostInPosCrcy,
  Position_Values.AmortizedCostInValuationCrcy AS AmortizedCostInValuationCrcy,
  Position_Values.BookValueAmtInPositionCurrency AS BookValPosCrcyScrtyClassValue,
  Position_Values.AmortizedAcqnAmountInPosCrcy AS BookValValnCrcyScrtyClassValue,
  Position_Values.AcquisitionAmtInPositionCrcy AS AcqnValPosCrcyScrtyClassValue,
  Position_Values.AcquisitionAmountInValnCrcy AS AcqnValValnCrcyScrtyClassValue
FROM I_TrsyPosCompVal AS Position_Values
;