C_Ftr_Atpv_Productquery

DDL: C_FTR_ATPV_PRODUCTQUERY SQL: CPOSPRODQ Type: view CONSUMPTION
154 Fields 1 Data Sources

Treasury Position Analysis

C_Ftr_Atpv_Productquery is a Consumption CDS View that provides data about "Treasury Position Analysis" in SAP S/4HANA. It reads from 1 data source (I_Ftr_Atpv_Cube) and exposes 154 fields.

Data Sources (1)

SourceAliasJoin Type
I_Ftr_Atpv_Cube I_Ftr_Atpv_Cube from

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_TrsyPosPlndDataIsInclusive ftr_atpv_planned_data

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPOSPRODQ view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
OData.publish true view
EndUserText.label Treasury Position Analysis view
Analytics.query true view

Fields (154)

KeyFieldSource TableSource FieldDescription
CompanyCode I_Ftr_Atpv_Cube CompanyCode Receiver Company Code
FinancialInstrumentProductType I_Ftr_Atpv_Cube FinancialInstrumentProductType
Portfolio I_Ftr_Atpv_Cube Portfolio Portfolio
TreasuryValuationArea I_Ftr_Atpv_Cube TreasuryValuationArea
TreasuryValuationClass I_Ftr_Atpv_Cube TreasuryValuationClass
SecurityAccount I_Ftr_Atpv_Cube SecurityAccount
SecurityClass I_Ftr_Atpv_Cube SecurityClass
TreasuryPositionLongShortCode I_Ftr_Atpv_Cube TreasuryPositionLongShortCode
FinancialTransaction I_Ftr_Atpv_Cube FinancialTransaction Transaction
FinInstrProductGroup I_Ftr_Atpv_Cube FinInstrProductGroup
TreasuryGLAccountAssignmentRef I_Ftr_Atpv_Cube TreasuryGLAccountAssignmentRef
TreasuryPositionLot I_Ftr_Atpv_Cube TreasuryPositionLot
TrsyPosManagementProcedure I_Ftr_Atpv_Cube TrsyPosManagementProcedure
TreasuryPosition I_Ftr_Atpv_Cube TreasuryPosition
Fund I_Ftr_Atpv_Cube Fund Sender Fund
GrantID I_Ftr_Atpv_Cube GrantID Sender Grant
WBSElementInternalID I_Ftr_Atpv_Cube WBSElementInternalID WBS Internal ID
ProfitCenter I_Ftr_Atpv_Cube ProfitCenter Profit Center
CostCenter I_Ftr_Atpv_Cube CostCenter Cost Center
FunctionalArea I_Ftr_Atpv_Cube FunctionalArea Sendr Fctl Area
TrsyPosCustomDiffntnTerm1 I_Ftr_Atpv_Cube TrsyPosCustomDiffntnTerm1
TrsyPosCustomDiffntnTerm2 I_Ftr_Atpv_Cube TrsyPosCustomDiffntnTerm2
TrsyPosCustomDiffntnTerm3 I_Ftr_Atpv_Cube TrsyPosCustomDiffntnTerm3
TrsyPosCustomDiffntnTerm4 I_Ftr_Atpv_Cube TrsyPosCustomDiffntnTerm4
TrsyPosCustomDiffntnTerm5 I_Ftr_Atpv_Cube TrsyPosCustomDiffntnTerm5
Issuer I_Ftr_Atpv_Cube Issuer User Name
Counterparty I_Ftr_Atpv_Cube Counterparty Supplier
FinancialInstrTransactionType I_Ftr_Atpv_Cube FinancialInstrTransactionType
TreasuryPositionLedgerDate I_Ftr_Atpv_Cube TreasuryPositionLedgerDate
TreasuryBusinessTransCategory I_Ftr_Atpv_Cube TreasuryBusinessTransCategory
TreasuryUpdateType I_Ftr_Atpv_Cube TreasuryUpdateType
PositionCurrency I_Ftr_Atpv_Cube PositionCurrency
QuantityInPieces I_Ftr_Atpv_Cube QuantityInPieces Units
NominalAmountInNominalCurrency I_Ftr_Atpv_Cube NominalAmountInNominalCurrency
BookValueAmountInValnCurrency I_Ftr_Atpv_Cube BookValueAmountInValnCurrency
BookValueAmtInPositionCurrency I_Ftr_Atpv_Cube BookValueAmtInPositionCurrency
AmortizedAcqnAmountInValnCrcy I_Ftr_Atpv_Cube AmortizedAcqnAmountInValnCrcy
AmortizedAcqnAmountInPosCrcy I_Ftr_Atpv_Cube AmortizedAcqnAmountInPosCrcy
NominalCurrency I_Ftr_Atpv_Cube NominalCurrency
ValuationCurrency I_Ftr_Atpv_Cube ValuationCurrency
OriglNominalAmtInNominalCrcy I_Ftr_Atpv_Cube OriglNominalAmtInNominalCrcy
PurchaseValueInValuationCrcy I_Ftr_Atpv_Cube PurchaseValueInValuationCrcy
PurchaseValueInPositionCrcy I_Ftr_Atpv_Cube PurchaseValueInPositionCrcy
OCIScrtyValnAmountInValnCrcy I_Ftr_Atpv_Cube OCIScrtyValnAmountInValnCrcy
OCISecurityValnAmountInPosCrcy I_Ftr_Atpv_Cube OCISecurityValnAmountInPosCrcy
IdxClnOCIScrtyValnAmtInPosCrcy I_Ftr_Atpv_Cube IdxClnOCIScrtyValnAmtInPosCrcy
ForeignCrcyValnAmtInValnCrcy I_Ftr_Atpv_Cube ForeignCrcyValnAmtInValnCrcy
CostExcldBookValAmtInValnCrcy I_Ftr_Atpv_Cube CostExcldBookValAmtInValnCrcy
CostInPositionCurrency I_Ftr_Atpv_Cube CostInPositionCurrency
SecurityCostValnAmtInValnCrcy I_Ftr_Atpv_Cube SecurityCostValnAmtInValnCrcy
SecurityCostValnAmtInPosCrcy I_Ftr_Atpv_Cube SecurityCostValnAmtInPosCrcy
FrgnExchCostValnAmtInValnCrcy I_Ftr_Atpv_Cube FrgnExchCostValnAmtInValnCrcy
AmortizationAmtInValuationCrcy I_Ftr_Atpv_Cube AmortizationAmtInValuationCrcy
AmortizationAmtInPositionCrcy I_Ftr_Atpv_Cube AmortizationAmtInPositionCrcy
ClrdPremDiscDefrlAmtInValnCrcy I_Ftr_Atpv_Cube ClrdPremDiscDefrlAmtInValnCrcy
ClrdPremDiscDefrlTxCompnAmount I_Ftr_Atpv_Cube ClrdPremDiscDefrlTxCompnAmount
IndexValuationAmountInValnCrcy I_Ftr_Atpv_Cube IndexValuationAmountInValnCrcy
IndexValuationAmountInPosCrcy I_Ftr_Atpv_Cube IndexValuationAmountInPosCrcy
FXValnAmtzdAcqnAmtInValnCrcy I_Ftr_Atpv_Cube FXValnAmtzdAcqnAmtInValnCrcy
VariationMarginAmtInValnCrcy I_Ftr_Atpv_Cube VariationMarginAmtInValnCrcy
VariationMarginAmountInPosCrcy I_Ftr_Atpv_Cube VariationMarginAmountInPosCrcy
OCIFrgnExchValnAmtInValnCrcy I_Ftr_Atpv_Cube OCIFrgnExchValnAmtInValnCrcy
OCIIndexValnAmountInValnCrcy I_Ftr_Atpv_Cube OCIIndexValnAmountInValnCrcy
OCIIndexValnAmountInPosCrcy I_Ftr_Atpv_Cube OCIIndexValnAmountInPosCrcy
OCIScrtyCostValnAmtInValnCrcy I_Ftr_Atpv_Cube OCIScrtyCostValnAmtInValnCrcy
OCIScrtyCostValnAmtInPosCrcy I_Ftr_Atpv_Cube OCIScrtyCostValnAmtInPosCrcy
OCICostFXValnAmountInValnCrcy I_Ftr_Atpv_Cube OCICostFXValnAmountInValnCrcy
AccruedInterestInValuationCrcy I_Ftr_Atpv_Cube AccruedInterestInValuationCrcy
AccruedInterestInPositionCrcy I_Ftr_Atpv_Cube AccruedInterestInPositionCrcy
CostExcldBookValueAmtInPosCrcy I_Ftr_Atpv_Cube CostExcldBookValueAmtInPosCrcy
AcquisitionAmountInValnCrcy I_Ftr_Atpv_Cube AcquisitionAmountInValnCrcy
AcquisitionAmtInPositionCrcy I_Ftr_Atpv_Cube AcquisitionAmtInPositionCrcy
SecurityValuationAmtInValnCrcy I_Ftr_Atpv_Cube SecurityValuationAmtInValnCrcy
SecurityValuationAmtInPosCrcy I_Ftr_Atpv_Cube SecurityValuationAmtInPosCrcy
ClearingAmountInPositionCrcy I_Ftr_Atpv_Cube ClearingAmountInPositionCrcy
ClearingAmountInValuationCrcy I_Ftr_Atpv_Cube ClearingAmountInValuationCrcy
CostInValuationCurrency I_Ftr_Atpv_Cube CostInValuationCurrency
PurValDeferralItmAmtInPosCrcy I_Ftr_Atpv_Cube PurValDeferralItmAmtInPosCrcy
PurValDeferralItmAmtInValnCrcy I_Ftr_Atpv_Cube PurValDeferralItmAmtInValnCrcy
NegttnSpreadAmtznAmtInPosCrcy I_Ftr_Atpv_Cube NegttnSpreadAmtznAmtInPosCrcy
NegttnSpreadAmtznAmtInValnCrcy I_Ftr_Atpv_Cube NegttnSpreadAmtznAmtInValnCrcy
CumltvRepaymentAmountInPosCrcy I_Ftr_Atpv_Cube CumltvRepaymentAmountInPosCrcy
CumltvRepaymentAmtInValnCrcy I_Ftr_Atpv_Cube CumltvRepaymentAmtInValnCrcy
PurCrcySpotValnAmtInValnCrcy I_Ftr_Atpv_Cube PurCrcySpotValnAmtInValnCrcy
SaleCrcySpotValnAmtInValnCrcy I_Ftr_Atpv_Cube SaleCrcySpotValnAmtInValnCrcy
SwapAccrualAmountInPosCurrency I_Ftr_Atpv_Cube SwapAccrualAmountInPosCurrency
SwapAccrualAmountInValnCrcy I_Ftr_Atpv_Cube SwapAccrualAmountInValnCrcy
SwapValuationAmountInValnCrcy I_Ftr_Atpv_Cube SwapValuationAmountInValnCrcy
ImpairmentAmountInPositionCrcy I_Ftr_Atpv_Cube ImpairmentAmountInPositionCrcy
ImpairmentAmtInValuationCrcy I_Ftr_Atpv_Cube ImpairmentAmtInValuationCrcy
HedgeAmortizationAmtInPosCrcy I_Ftr_Atpv_Cube HedgeAmortizationAmtInPosCrcy
HedgeAmortizationAmtInValnCrcy I_Ftr_Atpv_Cube HedgeAmortizationAmtInValnCrcy
FrgnExchValnDiffAmtInValnCrcy I_Ftr_Atpv_Cube FrgnExchValnDiffAmtInValnCrcy
GainValueAdjmtAmountInPosCrcy I_Ftr_Atpv_Cube GainValueAdjmtAmountInPosCrcy
GainValueAdjmtAmountInValnCrcy I_Ftr_Atpv_Cube GainValueAdjmtAmountInValnCrcy
LossValueAdjmtAmountInPosCrcy I_Ftr_Atpv_Cube LossValueAdjmtAmountInPosCrcy
LossValueAdjmtAmountInValnCrcy I_Ftr_Atpv_Cube LossValueAdjmtAmountInValnCrcy
OriginalValueAdjmtAmtInPosCrcy I_Ftr_Atpv_Cube OriginalValueAdjmtAmtInPosCrcy
OriginalValAdjmtAmtInValnCrcy I_Ftr_Atpv_Cube OriginalValAdjmtAmtInValnCrcy
CapitalizationRsrvInPosCrcy I_Ftr_Atpv_Cube CapitalizationRsrvInPosCrcy
CapitalizationRsrvInValnCrcy I_Ftr_Atpv_Cube CapitalizationRsrvInValnCrcy
ForeignExchImprmtAmtInValnCrcy I_Ftr_Atpv_Cube ForeignExchImprmtAmtInValnCrcy
CnsldtdScrtyGainAmtInPosCrcy I_Ftr_Atpv_Cube CnsldtdScrtyGainAmtInPosCrcy
CnsldtdScrtyGainAmtInValnCrcy I_Ftr_Atpv_Cube CnsldtdScrtyGainAmtInValnCrcy
CnsldtdScrtyLossAmtInPosCrcy I_Ftr_Atpv_Cube CnsldtdScrtyLossAmtInPosCrcy
CnsldtdScrtyLossAmtInValnCrcy I_Ftr_Atpv_Cube CnsldtdScrtyLossAmtInValnCrcy
CnsldtdForExGainAmtInValnCrcy I_Ftr_Atpv_Cube CnsldtdForExGainAmtInValnCrcy
CnsldtdForExLossAmtInValnCrcy I_Ftr_Atpv_Cube CnsldtdForExLossAmtInValnCrcy
InterestIncomeInPositionCrcy I_Ftr_Atpv_Cube InterestIncomeInPositionCrcy
InterestIncomeInValuationCrcy I_Ftr_Atpv_Cube InterestIncomeInValuationCrcy
SecurityWriteUpAmountInPosCrcy I_Ftr_Atpv_Cube SecurityWriteUpAmountInPosCrcy
SecurityWriteDownAmtInPosCrcy I_Ftr_Atpv_Cube SecurityWriteDownAmtInPosCrcy
SecurityWriteUpAmtInValnCrcy I_Ftr_Atpv_Cube SecurityWriteUpAmtInValnCrcy
ScrtyWriteDownAmtInValnCrcy I_Ftr_Atpv_Cube ScrtyWriteDownAmtInValnCrcy
FrgnExchWriteUpAmtInValnCrcy I_Ftr_Atpv_Cube FrgnExchWriteUpAmtInValnCrcy
FrgnExchWriteDownAmtInValnCrcy I_Ftr_Atpv_Cube FrgnExchWriteDownAmtInValnCrcy
ScrtyCostWriteUpAmtInPosCrcy I_Ftr_Atpv_Cube ScrtyCostWriteUpAmtInPosCrcy
ScrtyCostWriteDownAmtInPosCrcy I_Ftr_Atpv_Cube ScrtyCostWriteDownAmtInPosCrcy
ScrtyCostWriteUpAmtInValnCrcy I_Ftr_Atpv_Cube ScrtyCostWriteUpAmtInValnCrcy
ScrtyCostWrtDownAmtInValnCrcy I_Ftr_Atpv_Cube ScrtyCostWrtDownAmtInValnCrcy
FrgnExchCostWrtUpAmtInValnCrcy I_Ftr_Atpv_Cube FrgnExchCostWrtUpAmtInValnCrcy
FXCostWriteDownAmtInValnCrcy I_Ftr_Atpv_Cube FXCostWriteDownAmtInValnCrcy
IndexWriteUpAmountInPosCrcy I_Ftr_Atpv_Cube IndexWriteUpAmountInPosCrcy
IndexWriteDownAmountInPosCrcy I_Ftr_Atpv_Cube IndexWriteDownAmountInPosCrcy
IndexWriteUpAmountInValnCrcy I_Ftr_Atpv_Cube IndexWriteUpAmountInValnCrcy
IndexWriteDownAmtInValnCrcy I_Ftr_Atpv_Cube IndexWriteDownAmtInValnCrcy
IndexCleanClearingAmtInPosCrcy I_Ftr_Atpv_Cube IndexCleanClearingAmtInPosCrcy
IndexCleanPurchaseValInPosCrcy I_Ftr_Atpv_Cube IndexCleanPurchaseValInPosCrcy
IdxCleanScrtyValnAmtInPosCrcy I_Ftr_Atpv_Cube IdxCleanScrtyValnAmtInPosCrcy
IndexCleanCostInPositionCrcy I_Ftr_Atpv_Cube IndexCleanCostInPositionCrcy
IndexClnScrtyCostValuationAmt I_Ftr_Atpv_Cube IndexClnScrtyCostValuationAmt
IndexCleanAmtznAmountInPosCrcy I_Ftr_Atpv_Cube IndexCleanAmtznAmountInPosCrcy
IdxClnClrdPremDiscDeferralAmt I_Ftr_Atpv_Cube IdxClnClrdPremDiscDeferralAmt
IdxClnPurValDefrlAmtInPosCrcy I_Ftr_Atpv_Cube IdxClnPurValDefrlAmtInPosCrcy
IdxClnOCIScrtyCostValuationAmt I_Ftr_Atpv_Cube IdxClnOCIScrtyCostValuationAmt
IndexCleanNegttnAmtznInPosCrcy I_Ftr_Atpv_Cube IndexCleanNegttnAmtznInPosCrcy
IndexCleanRpaytAmtInPosCrcy I_Ftr_Atpv_Cube IndexCleanRpaytAmtInPosCrcy
IndexCleanInterestIncInPosCrcy I_Ftr_Atpv_Cube IndexCleanInterestIncInPosCrcy
IdxCleanHedgeAmtznAmtInPosCrcy I_Ftr_Atpv_Cube IdxCleanHedgeAmtznAmtInPosCrcy
IndexCleanImprmtAmtInPosCrcy I_Ftr_Atpv_Cube IndexCleanImprmtAmtInPosCrcy
IndexClnBookValueAmtInPosCrcy I_Ftr_Atpv_Cube IndexClnBookValueAmtInPosCrcy
IdxClnCostExcldBookValueAmount I_Ftr_Atpv_Cube IdxClnCostExcldBookValueAmount
IndexCleanAcqnAmountInPosCrcy I_Ftr_Atpv_Cube IndexCleanAcqnAmountInPosCrcy
IdxCleanAmtzdAcqnAmtInPosCrcy I_Ftr_Atpv_Cube IdxCleanAmtzdAcqnAmtInPosCrcy
TrsySubPosition TrsySubPosition
HedgingInstr HedgingInstr
HedgingInstrumentFiscalYear HedgingInstrumentFiscalYear
HedgedItem HedgedItem
HedgedItemFiscalYear HedgedItemFiscalYear
IsFreestanding IsFreestanding
DesignatedNominalCurrency DesignatedNominalCurrency
DesignatedQuantityInPieces DesignatedQuantityInPieces
DesignatedAmountInNominalCrcy DesignatedAmountInNominalCrcy
DesignatedOrigAmtInNominalCrcy DesignatedOrigAmtInNominalCrcy

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

CREATE VIEW C_Ftr_Atpv_Productquery AS
SELECT
  I_Ftr_Atpv_Cube.CompanyCode AS CompanyCode,
  I_Ftr_Atpv_Cube.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Atpv_Cube.Portfolio AS Portfolio,
  I_Ftr_Atpv_Cube.TreasuryValuationArea AS TreasuryValuationArea,
  I_Ftr_Atpv_Cube.TreasuryValuationClass AS TreasuryValuationClass,
  I_Ftr_Atpv_Cube.SecurityAccount AS SecurityAccount,
  I_Ftr_Atpv_Cube.SecurityClass AS SecurityClass,
  I_Ftr_Atpv_Cube.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  I_Ftr_Atpv_Cube.FinancialTransaction AS FinancialTransaction,
  I_Ftr_Atpv_Cube.FinInstrProductGroup AS FinInstrProductGroup,
  I_Ftr_Atpv_Cube.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  I_Ftr_Atpv_Cube.TreasuryPositionLot AS TreasuryPositionLot,
  I_Ftr_Atpv_Cube.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  I_Ftr_Atpv_Cube.TreasuryPosition AS TreasuryPosition,
  I_Ftr_Atpv_Cube.Fund AS Fund,
  I_Ftr_Atpv_Cube.GrantID AS GrantID,
  I_Ftr_Atpv_Cube.WBSElementInternalID AS WBSElementInternalID,
  I_Ftr_Atpv_Cube.ProfitCenter AS ProfitCenter,
  I_Ftr_Atpv_Cube.CostCenter AS CostCenter,
  I_Ftr_Atpv_Cube.FunctionalArea AS FunctionalArea,
  I_Ftr_Atpv_Cube.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  I_Ftr_Atpv_Cube.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  I_Ftr_Atpv_Cube.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  I_Ftr_Atpv_Cube.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  I_Ftr_Atpv_Cube.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  I_Ftr_Atpv_Cube.Issuer AS Issuer,
  I_Ftr_Atpv_Cube.Counterparty AS Counterparty,
  I_Ftr_Atpv_Cube.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  I_Ftr_Atpv_Cube.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  I_Ftr_Atpv_Cube.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Atpv_Cube.TreasuryUpdateType AS TreasuryUpdateType,
  I_Ftr_Atpv_Cube.PositionCurrency AS PositionCurrency,
  I_Ftr_Atpv_Cube.QuantityInPieces AS QuantityInPieces,
  I_Ftr_Atpv_Cube.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  I_Ftr_Atpv_Cube.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  I_Ftr_Atpv_Cube.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  I_Ftr_Atpv_Cube.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  I_Ftr_Atpv_Cube.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  I_Ftr_Atpv_Cube.NominalCurrency AS NominalCurrency,
  I_Ftr_Atpv_Cube.ValuationCurrency AS ValuationCurrency,
  I_Ftr_Atpv_Cube.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  I_Ftr_Atpv_Cube.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  I_Ftr_Atpv_Cube.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  I_Ftr_Atpv_Cube.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  I_Ftr_Atpv_Cube.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  I_Ftr_Atpv_Cube.IdxClnOCIScrtyValnAmtInPosCrcy AS IdxClnOCIScrtyValnAmtInPosCrcy,
  I_Ftr_Atpv_Cube.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CostExcldBookValAmtInValnCrcy AS CostExcldBookValAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CostInPositionCurrency AS CostInPositionCurrency,
  I_Ftr_Atpv_Cube.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  I_Ftr_Atpv_Cube.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  I_Ftr_Atpv_Cube.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  I_Ftr_Atpv_Cube.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  I_Ftr_Atpv_Cube.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  I_Ftr_Atpv_Cube.IndexValuationAmountInValnCrcy AS IndexValuationAmountInValnCrcy,
  I_Ftr_Atpv_Cube.IndexValuationAmountInPosCrcy AS IndexValuationAmountInPosCrcy,
  I_Ftr_Atpv_Cube.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  I_Ftr_Atpv_Cube.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  I_Ftr_Atpv_Cube.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.OCIIndexValnAmountInValnCrcy AS OCIIndexValnAmountInValnCrcy,
  I_Ftr_Atpv_Cube.OCIIndexValnAmountInPosCrcy AS OCIIndexValnAmountInPosCrcy,
  I_Ftr_Atpv_Cube.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  I_Ftr_Atpv_Cube.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  I_Ftr_Atpv_Cube.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  I_Ftr_Atpv_Cube.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  I_Ftr_Atpv_Cube.CostExcldBookValueAmtInPosCrcy AS CostExcldBookValueAmtInPosCrcy,
  I_Ftr_Atpv_Cube.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  I_Ftr_Atpv_Cube.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  I_Ftr_Atpv_Cube.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  I_Ftr_Atpv_Cube.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  I_Ftr_Atpv_Cube.ClearingAmountInPositionCrcy AS ClearingAmountInPositionCrcy,
  I_Ftr_Atpv_Cube.ClearingAmountInValuationCrcy AS ClearingAmountInValuationCrcy,
  I_Ftr_Atpv_Cube.CostInValuationCurrency AS CostInValuationCurrency,
  I_Ftr_Atpv_Cube.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  I_Ftr_Atpv_Cube.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  I_Ftr_Atpv_Cube.NegttnSpreadAmtznAmtInPosCrcy AS NegttnSpreadAmtznAmtInPosCrcy,
  I_Ftr_Atpv_Cube.NegttnSpreadAmtznAmtInValnCrcy AS NegttnSpreadAmtznAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CumltvRepaymentAmountInPosCrcy AS CumltvRepaymentAmountInPosCrcy,
  I_Ftr_Atpv_Cube.CumltvRepaymentAmtInValnCrcy AS CumltvRepaymentAmtInValnCrcy,
  I_Ftr_Atpv_Cube.PurCrcySpotValnAmtInValnCrcy AS PurCrcySpotValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.SaleCrcySpotValnAmtInValnCrcy AS SaleCrcySpotValnAmtInValnCrcy,
  I_Ftr_Atpv_Cube.SwapAccrualAmountInPosCurrency AS SwapAccrualAmountInPosCurrency,
  I_Ftr_Atpv_Cube.SwapAccrualAmountInValnCrcy AS SwapAccrualAmountInValnCrcy,
  I_Ftr_Atpv_Cube.SwapValuationAmountInValnCrcy AS SwapValuationAmountInValnCrcy,
  I_Ftr_Atpv_Cube.ImpairmentAmountInPositionCrcy AS ImpairmentAmountInPositionCrcy,
  I_Ftr_Atpv_Cube.ImpairmentAmtInValuationCrcy AS ImpairmentAmtInValuationCrcy,
  I_Ftr_Atpv_Cube.HedgeAmortizationAmtInPosCrcy AS HedgeAmortizationAmtInPosCrcy,
  I_Ftr_Atpv_Cube.HedgeAmortizationAmtInValnCrcy AS HedgeAmortizationAmtInValnCrcy,
  I_Ftr_Atpv_Cube.FrgnExchValnDiffAmtInValnCrcy AS FrgnExchValnDiffAmtInValnCrcy,
  I_Ftr_Atpv_Cube.GainValueAdjmtAmountInPosCrcy AS GainValueAdjmtAmountInPosCrcy,
  I_Ftr_Atpv_Cube.GainValueAdjmtAmountInValnCrcy AS GainValueAdjmtAmountInValnCrcy,
  I_Ftr_Atpv_Cube.LossValueAdjmtAmountInPosCrcy AS LossValueAdjmtAmountInPosCrcy,
  I_Ftr_Atpv_Cube.LossValueAdjmtAmountInValnCrcy AS LossValueAdjmtAmountInValnCrcy,
  I_Ftr_Atpv_Cube.OriginalValueAdjmtAmtInPosCrcy AS OriginalValueAdjmtAmtInPosCrcy,
  I_Ftr_Atpv_Cube.OriginalValAdjmtAmtInValnCrcy AS OriginalValAdjmtAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CapitalizationRsrvInPosCrcy AS CapitalizationRsrvInPosCrcy,
  I_Ftr_Atpv_Cube.CapitalizationRsrvInValnCrcy AS CapitalizationRsrvInValnCrcy,
  I_Ftr_Atpv_Cube.ForeignExchImprmtAmtInValnCrcy AS ForeignExchImprmtAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CnsldtdScrtyGainAmtInPosCrcy AS CnsldtdScrtyGainAmtInPosCrcy,
  I_Ftr_Atpv_Cube.CnsldtdScrtyGainAmtInValnCrcy AS CnsldtdScrtyGainAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CnsldtdScrtyLossAmtInPosCrcy AS CnsldtdScrtyLossAmtInPosCrcy,
  I_Ftr_Atpv_Cube.CnsldtdScrtyLossAmtInValnCrcy AS CnsldtdScrtyLossAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CnsldtdForExGainAmtInValnCrcy AS CnsldtdForExGainAmtInValnCrcy,
  I_Ftr_Atpv_Cube.CnsldtdForExLossAmtInValnCrcy AS CnsldtdForExLossAmtInValnCrcy,
  I_Ftr_Atpv_Cube.InterestIncomeInPositionCrcy AS InterestIncomeInPositionCrcy,
  I_Ftr_Atpv_Cube.InterestIncomeInValuationCrcy AS InterestIncomeInValuationCrcy,
  I_Ftr_Atpv_Cube.SecurityWriteUpAmountInPosCrcy AS SecurityWriteUpAmountInPosCrcy,
  I_Ftr_Atpv_Cube.SecurityWriteDownAmtInPosCrcy AS SecurityWriteDownAmtInPosCrcy,
  I_Ftr_Atpv_Cube.SecurityWriteUpAmtInValnCrcy AS SecurityWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Cube.ScrtyWriteDownAmtInValnCrcy AS ScrtyWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Cube.FrgnExchWriteUpAmtInValnCrcy AS FrgnExchWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Cube.FrgnExchWriteDownAmtInValnCrcy AS FrgnExchWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Cube.ScrtyCostWriteUpAmtInPosCrcy AS ScrtyCostWriteUpAmtInPosCrcy,
  I_Ftr_Atpv_Cube.ScrtyCostWriteDownAmtInPosCrcy AS ScrtyCostWriteDownAmtInPosCrcy,
  I_Ftr_Atpv_Cube.ScrtyCostWriteUpAmtInValnCrcy AS ScrtyCostWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Cube.ScrtyCostWrtDownAmtInValnCrcy AS ScrtyCostWrtDownAmtInValnCrcy,
  I_Ftr_Atpv_Cube.FrgnExchCostWrtUpAmtInValnCrcy AS FrgnExchCostWrtUpAmtInValnCrcy,
  I_Ftr_Atpv_Cube.FXCostWriteDownAmtInValnCrcy AS FXCostWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Cube.IndexWriteUpAmountInPosCrcy AS IndexWriteUpAmountInPosCrcy,
  I_Ftr_Atpv_Cube.IndexWriteDownAmountInPosCrcy AS IndexWriteDownAmountInPosCrcy,
  I_Ftr_Atpv_Cube.IndexWriteUpAmountInValnCrcy AS IndexWriteUpAmountInValnCrcy,
  I_Ftr_Atpv_Cube.IndexWriteDownAmtInValnCrcy AS IndexWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Cube.IndexCleanClearingAmtInPosCrcy AS IndexCleanClearingAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IndexCleanPurchaseValInPosCrcy AS IndexCleanPurchaseValInPosCrcy,
  I_Ftr_Atpv_Cube.IdxCleanScrtyValnAmtInPosCrcy AS IdxCleanScrtyValnAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IndexCleanCostInPositionCrcy AS IndexCleanCostInPositionCrcy,
  I_Ftr_Atpv_Cube.IndexClnScrtyCostValuationAmt AS IndexClnScrtyCostValuationAmt,
  I_Ftr_Atpv_Cube.IndexCleanAmtznAmountInPosCrcy AS IndexCleanAmtznAmountInPosCrcy,
  I_Ftr_Atpv_Cube.IdxClnClrdPremDiscDeferralAmt AS IdxClnClrdPremDiscDeferralAmt,
  I_Ftr_Atpv_Cube.IdxClnPurValDefrlAmtInPosCrcy AS IdxClnPurValDefrlAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IdxClnOCIScrtyCostValuationAmt AS IdxClnOCIScrtyCostValuationAmt,
  I_Ftr_Atpv_Cube.IndexCleanNegttnAmtznInPosCrcy AS IndexCleanNegttnAmtznInPosCrcy,
  I_Ftr_Atpv_Cube.IndexCleanRpaytAmtInPosCrcy AS IndexCleanRpaytAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IndexCleanInterestIncInPosCrcy AS IndexCleanInterestIncInPosCrcy,
  I_Ftr_Atpv_Cube.IdxCleanHedgeAmtznAmtInPosCrcy AS IdxCleanHedgeAmtznAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IndexCleanImprmtAmtInPosCrcy AS IndexCleanImprmtAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IndexClnBookValueAmtInPosCrcy AS IndexClnBookValueAmtInPosCrcy,
  I_Ftr_Atpv_Cube.IdxClnCostExcldBookValueAmount AS IdxClnCostExcldBookValueAmount,
  I_Ftr_Atpv_Cube.IndexCleanAcqnAmountInPosCrcy AS IndexCleanAcqnAmountInPosCrcy,
  I_Ftr_Atpv_Cube.IdxCleanAmtzdAcqnAmtInPosCrcy AS IdxCleanAmtzdAcqnAmtInPosCrcy,
  TrsySubPosition,
  HedgingInstr,
  HedgingInstrumentFiscalYear,
  HedgedItem,
  HedgedItemFiscalYear,
  IsFreestanding,
  DesignatedNominalCurrency,
  DesignatedQuantityInPieces,
  DesignatedAmountInNominalCrcy,
  DesignatedOrigAmtInNominalCrcy
FROM I_Ftr_Atpv_Cube
;

Learn More