I_Ftr_Atpv_Logic

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_Atpv_Logic.
-- 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: IFTRPOSVALLOG
-- Parameters: P_KeyDate : vdm_v_key_date, P_TrsyPosPlndDataIsInclusive : ftr_atpv_planned_data

CREATE VIEW I_Ftr_Atpv_Logic AS
SELECT
  I_Ftr_Position_Values.TreasuryPosition AS TreasuryPosition,
  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.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.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  I_FinInstrProductGroup.FinInstrProductGroup AS FinInstrProductGroup,
  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.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  I_Ftr_Position_Values.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  I_Ftr_Position_Values.TrsyPosValuationStepProcedure AS TrsyPosValuationStepProcedure,
  I_Ftr_Position_Values.TrsyDerivedBusTransacIsUpdated AS TrsyDerivedBusTransacIsUpdated,
  _TrsyLdgrGLAcctAssgmtRef.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  I_Ftr_Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Position_Values.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  I_Ftr_Position_Values.TreasuryPositionLedgerDate AS KeyDate,
  I_Ftr_Position_Values.PostingDate AS PostingDate,
  I_Ftr_Position_Values.TrsyPosQuantityChangeCategory AS TrsyPosQuantityChangeCategory,
  I_Ftr_Position_Values.TrsyPosAmountChangeCategory AS TrsyPosAmountChangeCategory,
  I_Ftr_Position_Values.PositionCurrency AS PositionCurrency,
  I_Ftr_Position_Values.ValuationCurrency AS ValuationCurrency,
  I_Ftr_Position_Values.NominalCurrency AS NominalCurrency,
  I_Ftr_Position_Values.TreasuryPositionZeroDate AS TreasuryPositionZeroDate,
  I_Ftr_Position_Values.QuantityInPieces AS QuantityInPieces,
  I_Ftr_Position_Values.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  I_Ftr_Position_Values.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  I_Ftr_Position_Values.ClearingAmountInPositionCrcy AS ClearingAmountInPositionCrcy,
  I_Ftr_Position_Values.ClearingAmountInValuationCrcy AS ClearingAmountInValuationCrcy,
  I_Ftr_Position_Values.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  I_Ftr_Position_Values.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  I_Ftr_Position_Values.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  I_Ftr_Position_Values.CostInPositionCurrency AS CostInPositionCurrency,
  I_Ftr_Position_Values.CostInValuationCurrency AS CostInValuationCurrency,
  I_Ftr_Position_Values.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  I_Ftr_Position_Values.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  I_Ftr_Position_Values.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  I_Ftr_Position_Values.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  I_Ftr_Position_Values.IndexValuationAmountInPosCrcy AS IndexValuationAmountInPosCrcy,
  I_Ftr_Position_Values.IndexValuationAmountInValnCrcy AS IndexValuationAmountInValnCrcy,
  I_Ftr_Position_Values.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  I_Ftr_Position_Values.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  I_Ftr_Position_Values.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  I_Ftr_Position_Values.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  I_Ftr_Position_Values.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  I_Ftr_Position_Values.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  I_Ftr_Position_Values.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCIIndexValnAmountInPosCrcy AS OCIIndexValnAmountInPosCrcy,
  I_Ftr_Position_Values.OCIIndexValnAmountInValnCrcy AS OCIIndexValnAmountInValnCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  I_Ftr_Position_Values.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  I_Ftr_Position_Values.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  I_Ftr_Position_Values.NegttnSpreadAmtznAmtInPosCrcy AS NegttnSpreadAmtznAmtInPosCrcy,
  I_Ftr_Position_Values.NegttnSpreadAmtznAmtInValnCrcy AS NegttnSpreadAmtznAmtInValnCrcy,
  I_Ftr_Position_Values.CumltvRepaymentAmountInPosCrcy AS CumltvRepaymentAmountInPosCrcy,
  I_Ftr_Position_Values.CumltvRepaymentAmtInValnCrcy AS CumltvRepaymentAmtInValnCrcy,
  I_Ftr_Position_Values.PurCrcySpotValnAmtInValnCrcy AS PurCrcySpotValnAmtInValnCrcy,
  I_Ftr_Position_Values.SaleCrcySpotValnAmtInValnCrcy AS SaleCrcySpotValnAmtInValnCrcy,
  I_Ftr_Position_Values.SwapAccrualAmountInPosCurrency AS SwapAccrualAmountInPosCurrency,
  I_Ftr_Position_Values.SwapAccrualAmountInValnCrcy AS SwapAccrualAmountInValnCrcy,
  I_Ftr_Position_Values.SwapValuationAmountInValnCrcy AS SwapValuationAmountInValnCrcy,
  I_Ftr_Position_Values.ImpairmentAmountInPositionCrcy AS ImpairmentAmountInPositionCrcy,
  I_Ftr_Position_Values.ImpairmentAmtInValuationCrcy AS ImpairmentAmtInValuationCrcy,
  I_Ftr_Position_Values.HedgeAmortizationAmtInPosCrcy AS HedgeAmortizationAmtInPosCrcy,
  I_Ftr_Position_Values.HedgeAmortizationAmtInValnCrcy AS HedgeAmortizationAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchValnDiffAmtInValnCrcy AS FrgnExchValnDiffAmtInValnCrcy,
  I_Ftr_Position_Values.GainValueAdjmtAmountInPosCrcy AS GainValueAdjmtAmountInPosCrcy,
  I_Ftr_Position_Values.GainValueAdjmtAmountInValnCrcy AS GainValueAdjmtAmountInValnCrcy,
  I_Ftr_Position_Values.LossValueAdjmtAmountInPosCrcy AS LossValueAdjmtAmountInPosCrcy,
  I_Ftr_Position_Values.LossValueAdjmtAmountInValnCrcy AS LossValueAdjmtAmountInValnCrcy,
  I_Ftr_Position_Values.OriginalValueAdjmtAmtInPosCrcy AS OriginalValueAdjmtAmtInPosCrcy,
  I_Ftr_Position_Values.OriginalValAdjmtAmtInValnCrcy AS OriginalValAdjmtAmtInValnCrcy,
  I_Ftr_Position_Values.CapitalizationRsrvInPosCrcy AS CapitalizationRsrvInPosCrcy,
  I_Ftr_Position_Values.CapitalizationRsrvInValnCrcy AS CapitalizationRsrvInValnCrcy,
  I_Ftr_Position_Values.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  I_Ftr_Position_Values.ForeignExchImprmtAmtInValnCrcy AS ForeignExchImprmtAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyGainAmtInPosCrcy AS CnsldtdScrtyGainAmtInPosCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyGainAmtInValnCrcy AS CnsldtdScrtyGainAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyLossAmtInPosCrcy AS CnsldtdScrtyLossAmtInPosCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyLossAmtInValnCrcy AS CnsldtdScrtyLossAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdForExGainAmtInValnCrcy AS CnsldtdForExGainAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdForExLossAmtInValnCrcy AS CnsldtdForExLossAmtInValnCrcy,
  I_Ftr_Position_Values.InterestIncomeInPositionCrcy AS InterestIncomeInPositionCrcy,
  I_Ftr_Position_Values.InterestIncomeInValuationCrcy AS InterestIncomeInValuationCrcy,
  I_Ftr_Position_Values.SecurityWriteUpAmountInPosCrcy AS SecurityWriteUpAmountInPosCrcy,
  I_Ftr_Position_Values.SecurityWriteDownAmtInPosCrcy AS SecurityWriteDownAmtInPosCrcy,
  I_Ftr_Position_Values.SecurityWriteUpAmtInValnCrcy AS SecurityWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.ScrtyWriteDownAmtInValnCrcy AS ScrtyWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchWriteUpAmtInValnCrcy AS FrgnExchWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchWriteDownAmtInValnCrcy AS FrgnExchWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteUpAmtInPosCrcy AS ScrtyCostWriteUpAmtInPosCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteDownAmtInPosCrcy AS ScrtyCostWriteDownAmtInPosCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteUpAmtInValnCrcy AS ScrtyCostWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.ScrtyCostWrtDownAmtInValnCrcy AS ScrtyCostWrtDownAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchCostWrtUpAmtInValnCrcy AS FrgnExchCostWrtUpAmtInValnCrcy,
  I_Ftr_Position_Values.FXCostWriteDownAmtInValnCrcy AS FXCostWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.IndexWriteUpAmountInPosCrcy AS IndexWriteUpAmountInPosCrcy,
  I_Ftr_Position_Values.IndexWriteDownAmountInPosCrcy AS IndexWriteDownAmountInPosCrcy,
  I_Ftr_Position_Values.IndexWriteUpAmountInValnCrcy AS IndexWriteUpAmountInValnCrcy,
  I_Ftr_Position_Values.IndexWriteDownAmtInValnCrcy AS IndexWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.IndexCleanClearingAmtInPosCrcy AS IndexCleanClearingAmtInPosCrcy,
  I_Ftr_Position_Values.IndexCleanPurchaseValInPosCrcy AS IndexCleanPurchaseValInPosCrcy,
  I_Ftr_Position_Values.IdxCleanScrtyValnAmtInPosCrcy AS IdxCleanScrtyValnAmtInPosCrcy,
  I_Ftr_Position_Values.IndexCleanCostInPositionCrcy AS IndexCleanCostInPositionCrcy,
  I_Ftr_Position_Values.IndexClnScrtyCostValuationAmt AS IndexClnScrtyCostValuationAmt,
  I_Ftr_Position_Values.IndexCleanAmtznAmountInPosCrcy AS IndexCleanAmtznAmountInPosCrcy,
  I_Ftr_Position_Values.IdxClnClrdPremDiscDeferralAmt AS IdxClnClrdPremDiscDeferralAmt,
  I_Ftr_Position_Values.IdxClnPurValDefrlAmtInPosCrcy AS IdxClnPurValDefrlAmtInPosCrcy,
  I_Ftr_Position_Values.IdxClnOCIScrtyValnAmtInPosCrcy AS IdxClnOCIScrtyValnAmtInPosCrcy,
  I_Ftr_Position_Values.IdxClnOCIScrtyCostValuationAmt AS IdxClnOCIScrtyCostValuationAmt,
  I_Ftr_Position_Values.IndexCleanNegttnAmtznInPosCrcy AS IndexCleanNegttnAmtznInPosCrcy,
  I_Ftr_Position_Values.IndexCleanRpaytAmtInPosCrcy AS IndexCleanRpaytAmtInPosCrcy,
  I_Ftr_Position_Values.IndexCleanInterestIncInPosCrcy AS IndexCleanInterestIncInPosCrcy,
  I_Ftr_Position_Values.IdxCleanHedgeAmtznAmtInPosCrcy AS IdxCleanHedgeAmtznAmtInPosCrcy,
  I_Ftr_Position_Values.IndexCleanImprmtAmtInPosCrcy AS IndexCleanImprmtAmtInPosCrcy,
  I_Ftr_Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  I_Ftr_Position_Values.CostExcldBookValueAmtInPosCrcy AS CostExcldBookValueAmtInPosCrcy,
  I_Ftr_Position_Values.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  I_Ftr_Position_Values.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  I_Ftr_Position_Values.CostExcldBookValAmtInValnCrcy AS CostExcldBookValAmtInValnCrcy,
  I_Ftr_Position_Values.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  I_Ftr_Position_Values.IndexClnBookValueAmtInPosCrcy AS IndexClnBookValueAmtInPosCrcy,
  I_Ftr_Position_Values.IdxClnCostExcldBookValueAmount AS IdxClnCostExcldBookValueAmount,
  I_Ftr_Position_Values.IndexCleanAcqnAmountInPosCrcy AS IndexCleanAcqnAmountInPosCrcy,
  I_Ftr_Position_Values.IdxCleanAmtzdAcqnAmtInPosCrcy AS IdxCleanAmtzdAcqnAmtInPosCrcy,
  I_Ftr_Position_Values.TreasuryUpdateType AS TreasuryUpdateType,
  I_Ftr_Position_Values.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Position_Values.TreasuryAccountingCode AS TreasuryAccountingCode,
  TrsySubPosition,
  case when _TreasurySubPosition.DesignatedNominalCurrency is null then NominalCurrency else _TreasurySubPosition.DesignatedNominalCurrency end AS DesignatedNominalCurrency,
  DesignatedQuantityInPieces,
  DesignatedAmountInNominalCrcy,
  DesignatedOrigAmtInNominalCrcy,
  I_Ftr_Position_Values.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus
FROM I_Ftr_Position_Values
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
;