I_TrsyPositionValueCube

DDL: I_TRSYPOSITIONVALUECUBE SQL: ITRSYPOSVALCUBE Type: view COMPOSITE
207 Fields 1 Data Sources 13 Associations

Treasury Position Values - Cube

I_TrsyPositionValueCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_TrsyPositionValueCube is a Composite CDS View (Cube) that provides data about "Treasury Position Values - Cube" in SAP S/4HANA. It reads from 1 data source (I_TrsyPosValuesCompatible) and exposes 207 fields. It has 13 associations to related views.

SAP Help Documentation

CategoryCDS Views for Transactional Data
Data CategoryCube
StatusReleased
Purpose
You can use this CDS view as basis for your own queries analyzing your Treasury positions by their attributes and position (component) values. Therefore, this CDS view provides the prerequisites for answering business questions for your Treasury positions, such as: What are the aggregated position values on the level of valuation areas, company codes, product types, or other dimensions like the account assignment reference? So you can, for example, answer the following specific questions: What is the overall nominal amount invested in the different product types? What is the current book value of your debts and investments? Note The amounts of the specific positions values of the single Treasury positions in the same currency are aggregated on the higher levels by summation. What are the specific position values of a single treasury position in position currency or valuation currency? Note SAP recommends that you use this cube view within a query, which calls this CDS view with specifc parameter values such as key date, exchange rate type, and display currency.

Prerequisites
The role must grant display authorization for the following authorization objects and fields: Assign Attributes to Positions ( T_POS_ASS ) Accounting Code Valuation Area Product Type Authorization for Product/Transaction Types ( T_DEAL_PD ) Company Code Product Type Transaction Type

Metadata Extension
The CDS view allows you to extend the view with fields available with the associations of this view: Valuation Area Valuation Class Company Code Securities Account Security Class Transaction Product Type Futures Account Acct Assignment Ref. Pos. Mgmt Procedure Central Clearing Account Currency (Position Currency) Currency (Valuation Currency) You can use the Custom Fields and Logic app available in the Extensibility group on the SAP Fiori launchpad to add fields. As result the selected fields are also available in the Treasury Position Values Cube CDS view.

Structure
Main CDS parameters and filters The CDS view does not have any parameters and filters. Measures and attributes Some important measures and attributes are: Attributes The attributes are the differentiation criteria of Treasury positions, such as Treasury valuation area, valuation class, product type, and other characteristics of Treasury positions. Client Treasury Valuation Area Valuation Class Company Code Security Account Security Class Loan Contract Number Code: Long or Short Position Financial Transaction Product Type Futures Account for Listed Options and Futures Account Assignment Reference of Position Management Identifier of the Lot Central Clearing Account Central Clearing Acount Currency Position Management Procedure Treasury Position UUID Exposure Item ID Exposure Subitem ID Financial Instrument Valuation Class Securities Account Group Fund Grant Treasury Ledger Date Business Transaction Category Update Type Accounting Code Indicator: Freestanding Portion of the Position Designated Nominal Currency Designated Quantity in Pieces Position Currency Valuation Currency Nominal Currency Risk Currency of Hedging Relationship Measures The available measures are the position component values of the Treasury positions. For each position component a specific measure for the amount in position currency and valuation currency is available. Designated Nominal Amount Designated Original Nominal Amount Book Value in Valuation Currency Book Value in Position Currency Nominal Amount Original Nominal Amount Purchase Value in Valuation Currency Purchase Value in Position Currency Security Valuation, Not Affecting P/L, in Valuation Currency Security Valuation, Not Affecting P/L, in Position Currency Security Valuation, Not Affecting P/L, Index-Clean, in PC Foreign Currency Valuation in Valuation Currency Book Value Excluding Costs in Valuation Currency Costs in Position Currency Valuation of Cap. Costs, Security, in Valuation Currency Valuation of Cap. Costs, Security, in Position Currency Valuat

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>You can use this CDS view as basis for your own queries analyzing your Treasury positions by their attributes and position (component) values. Therefore, this CDS view provides the prerequisites for answering business questions for your Treasury positions, such as:</p> <ul> <li><p>What are the aggregated position values on the level of valuation areas, company codes, product types, or other dimensions like the account assignment reference?</p><p>So you can, for example, answer the following specific questions:</p><ul> <li><p>What is the overall nominal amount invested in the different product types?</p></li> <li><p>What is the current book value of your debts and investments?</p></li> </ul></li> <li><p>What are the specific position values of a single treasury position in position currency or valuation currency?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_TrsyPosValuesCompatible I_Ftr_Position_Values from

Associations (13)

CardinalityTargetAliasCondition
[0..1] I_TreasuryValuationArea _TreasuryValuationArea $projection.TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_CentralClearingAccount _CentralClearingAccount $projection.CompanyCode = _CentralClearingAccount.CompanyCode and $projection.CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount
[0..1] I_SecurityAccount _SecurityAccount $projection.SecurityAccount = _SecurityAccount.SecurityAccount and $projection.CompanyCode = _SecurityAccount.CompanyCode
[0..1] I_FinancialinstrProductType _ProductType $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
[0..1] I_Currency _PositionCurrency $projection.PositionCurrency = _PositionCurrency.Currency
[0..1] I_Currency _ValuationCurrency $projection.ValuationCurrency = _ValuationCurrency.Currency
[0..1] I_SecurityClass _SecurityClass $projection.SecurityClass = _SecurityClass.SecurityClass
[0..1] I_TreasuryValuationClass _TreasuryValuationClass $projection.TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass and $projection.TreasuryValuationArea = _TreasuryValuationClass.TreasuryValuationArea
[0..1] I_FinancialTransaction _FinancialTransaction $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction and $projection.CompanyCode = _FinancialTransaction.CompanyCode
[0..1] I_TreasuryGLAccountAssignRef _TreasuryGLAccountAssignRef $projection.TreasuryGLAccountAssignmentRef = _TreasuryGLAccountAssignRef.TreasuryGLAccountAssignmentRef
[0..1] I_TreasuryPositionAccount _TreasuryPositionAccount $projection.TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount and $projection.CompanyCode = _TreasuryPositionAccount.CompanyCode
[0..1] I_TrsyPosManagementProcedure _TrsyPosManagementProcedure $projection.TrsyPosManagementProcedure = _TrsyPosManagementProcedure.TrsyPosManagementProcedure

Annotations (16)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITRSYPOSVALCUBE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Treasury Position Values - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
OData.publish true view

Fields (207)

KeyFieldSource TableSource FieldDescription
FinInstrProductGroup
IsFreestanding
DesignatedNominalCurrency Designated Nominal Currency
DesignatedQuantityInPieces Designated Quantity in Pieces
TrsyHedgingRelshpRiskCurrency Risk Currency of Hedging Relationship
QuantityInPieces Quantity in Pieces
_CompanyCode _CompanyCode
_SecurityAccount _SecurityAccount
_TreasuryValuationArea _TreasuryValuationArea
_ProductType _ProductType
_PositionCurrency _PositionCurrency
_ValuationCurrency _ValuationCurrency
_SecurityClass _SecurityClass
_TreasuryValuationClass _TreasuryValuationClass
_FinancialTransaction _FinancialTransaction
_TreasuryPositionAccount _TreasuryPositionAccount
_TreasuryGLAccountAssignRef _TreasuryGLAccountAssignRef
_TrsyPosManagementProcedure _TrsyPosManagementProcedure
_CentralClearingAccount _CentralClearingAccount
_CommitmentBusinessPartner _CommitmentBusinessPartner
_Portfolio _Portfolio
TreasuryValuationArea I_TrsyPosValuesCompatible TreasuryValuationArea Treasury Valuation Area
TreasuryValuationClass I_TrsyPosValuesCompatible TreasuryValuationClass Valuation Class
CompanyCode I_TrsyPosValuesCompatible CompanyCode Receiver Company Code
SecurityAccount I_TrsyPosValuesCompatible SecurityAccount Security Account
SecurityClass I_TrsyPosValuesCompatible SecurityClass Security Class
LoanContract I_TrsyPosValuesCompatible LoanContract Loan Contract Number
TreasuryPositionLongShortCode I_TrsyPosValuesCompatible TreasuryPositionLongShortCode Code: Long or Short Position
FinancialTransaction I_TrsyPosValuesCompatible FinancialTransaction Financial Transaction
FinancialInstrumentProductType I_TrsyPosValuesCompatible FinancialInstrumentProductType Product Type
TreasuryPositionAccount I_TrsyPosValuesCompatible TreasuryPositionAccount Futures Account for Listed Options and Futures
TreasuryGLAccountAssignmentRef I_TrsyPosValuesCompatible TreasuryGLAccountAssignmentRef Account Assignment Reference of Position Management
TreasuryPositionLot I_TrsyPosValuesCompatible TreasuryPositionLot Identifier of the Lot
CentralClearingAccount I_TrsyPosValuesCompatible CentralClearingAccount Central Clearing Account
CentralClearingAccountCurrency I_TrsyPosValuesCompatible CentralClearingAccountCurrency Central Clearing Account Currency
TrsyPosManagementProcedure I_TrsyPosValuesCompatible TrsyPosManagementProcedure Position Management Procedure
TreasuryPosition I_TrsyPosValuesCompatible TreasuryPosition Treasury Position UUID
FinancialExposureItem I_TrsyPosValuesCompatible FinancialExposureItem Exposure Item ID
FinancialExposureSubItem I_TrsyPosValuesCompatible FinancialExposureSubItem Exposure Subitem ID
FinancialInstrValuationClass I_TrsyPosValuesCompatible FinancialInstrValuationClass General Valuation Class
SecurityAccountGroup I_TrsyPosValuesCompatible SecurityAccountGroup Securities Account Group
Fund I_TrsyPosValuesCompatible Fund Sender Fund
GrantID I_TrsyPosValuesCompatible GrantID Sender Grant
WBSElementInternalID I_TrsyPosValuesCompatible WBSElementInternalID WBS Internal ID
ProfitCenter I_TrsyPosValuesCompatible ProfitCenter Profit Center
CostCenter I_TrsyPosValuesCompatible CostCenter Cost Center
FunctionalArea I_TrsyPosValuesCompatible FunctionalArea Sendr Fctl Area
TrsyPosCustomDiffntnTerm1 I_TrsyPosValuesCompatible TrsyPosCustomDiffntnTerm1 Custom Differentiation Term 1 (Value)
TrsyPosCustomDiffntnTerm2 I_TrsyPosValuesCompatible TrsyPosCustomDiffntnTerm2 Custom Differentiation Term 2 (Value)
TrsyPosCustomDiffntnTerm3 I_TrsyPosValuesCompatible TrsyPosCustomDiffntnTerm3 Custom Differentiation Term 3 (Value)
TrsyPosCustomDiffntnTerm4 I_TrsyPosValuesCompatible TrsyPosCustomDiffntnTerm4 Custom Differentiation Term 4 (Value)
TrsyPosCustomDiffntnTerm5 I_TrsyPosValuesCompatible TrsyPosCustomDiffntnTerm5 Custom Differentiation Term 5 (Value)
Portfolio I_TrsyPosValuesCompatible Portfolio Portfolio
CommitmentBusinessPartner I_TrsyPosValuesCompatible CommitmentBusinessPartner Partner with Whom Commitment Exists
TreasuryPositionLedgerDate I_TrsyPosValuesCompatible TreasuryPositionLedgerDate Treasury Ledger Date
TreasuryBusinessTransCategory I_TrsyPosValuesCompatible TreasuryBusinessTransCategory Business Transaction Category
TreasuryUpdateType I_TrsyPosValuesCompatible TreasuryUpdateType Update Type
TreasuryPosAssetLiabilityCode I_TrsyPosValuesCompatible TreasuryPosAssetLiabilityCode Asset / Liability Position
TreasuryAccountingCode I_TrsyPosValuesCompatible TreasuryAccountingCode Accounting Code
DesignatedAmountInNominalCrcy I_TrsyPosValuesCompatible DesignatedAmountInNominalCrcy Designated Nominal Amount
DesignatedOrigAmtInNominalCrcy I_TrsyPosValuesCompatible DesignatedOrigAmtInNominalCrcy Designated Original Nominal Amount
PositionCurrency I_TrsyPosValuesCompatible PositionCurrency Position Currency
ValuationCurrency I_TrsyPosValuesCompatible ValuationCurrency Valuation Currency
NominalCurrency I_TrsyPosValuesCompatible NominalCurrency Nominal Currency
BookValueAmountInValnCurrency I_TrsyPosValuesCompatible BookValueAmountInValnCurrency Book Value in Valuation Currency
BookValueAmtInPositionCurrency I_TrsyPosValuesCompatible BookValueAmtInPositionCurrency Book Value in Position Currency
NominalAmountInNominalCurrency I_TrsyPosValuesCompatible NominalAmountInNominalCurrency Nominal Amount
OriglNominalAmtInNominalCrcy I_TrsyPosValuesCompatible OriglNominalAmtInNominalCrcy Original Nominal Amount
PurchaseValueInValuationCrcy I_TrsyPosValuesCompatible PurchaseValueInValuationCrcy Purchase Value in Valuation Currency
PurchaseValueInPositionCrcy I_TrsyPosValuesCompatible PurchaseValueInPositionCrcy Purchase Value in Position Currency
OCIScrtyValnAmountInValnCrcy I_TrsyPosValuesCompatible OCIScrtyValnAmountInValnCrcy Security Valuation, Not Affecting P/L, in Valuation Currency
OCISecurityValnAmountInPosCrcy I_TrsyPosValuesCompatible OCISecurityValnAmountInPosCrcy Security Valuation, Not Affecting P/L, in Position Currency
IdxClnOCIScrtyValnAmtInPosCrcy I_TrsyPosValuesCompatible IdxClnOCIScrtyValnAmtInPosCrcy Security Valuation, Not Affecting P/L, Index-Clean, in PC
ForeignCrcyValnAmtInValnCrcy I_TrsyPosValuesCompatible ForeignCrcyValnAmtInValnCrcy Foreign Currency Valuation in Valuation Currency
CostExcldBookValAmtInValnCrcy I_TrsyPosValuesCompatible CostExcldBookValAmtInValnCrcy Book Value Excluding Costs in Valuation Currency
CostInPositionCurrency I_TrsyPosValuesCompatible CostInPositionCurrency Costs in Position Currency
SecurityCostValnAmtInValnCrcy I_TrsyPosValuesCompatible SecurityCostValnAmtInValnCrcy Valuation of Cap. Costs, Security, in Valuation Currency
SecurityCostValnAmtInPosCrcy I_TrsyPosValuesCompatible SecurityCostValnAmtInPosCrcy Valuation of Cap. Costs, Security, in Position Currency
FrgnExchCostValnAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchCostValnAmtInValnCrcy Valuation of Capitalized Costs, FX, in Valuation Currency
AmortizationAmtInValuationCrcy I_TrsyPosValuesCompatible AmortizationAmtInValuationCrcy Amortization in Valuation Currency
AmortizationAmtInPositionCrcy I_TrsyPosValuesCompatible AmortizationAmtInPositionCrcy Amortization in Position Currency
ClrdPremDiscDefrlAmtInValnCrcy I_TrsyPosValuesCompatible ClrdPremDiscDefrlAmtInValnCrcy Cleared PD Deferral/Tax Compensation in Valuation Currency
ClrdPremDiscDefrlTxCompnAmount I_TrsyPosValuesCompatible ClrdPremDiscDefrlTxCompnAmount Cleared PD Deferral/Tax Compensation in Position Currency
IndexValuationAmountInValnCrcy I_TrsyPosValuesCompatible IndexValuationAmountInValnCrcy Index Valuation in Valuation Currency
IndexValuationAmountInPosCrcy I_TrsyPosValuesCompatible IndexValuationAmountInPosCrcy Index Valuation in Position Currency
FXValnAmtzdAcqnAmtInValnCrcy I_TrsyPosValuesCompatible FXValnAmtzdAcqnAmtInValnCrcy FX Valuation of Amort. Acquisition Value in Valuation Crcy
VariationMarginAmtInValnCrcy I_TrsyPosValuesCompatible VariationMarginAmtInValnCrcy Variation Margin in Valuation Currency
VariationMarginAmountInPosCrcy I_TrsyPosValuesCompatible VariationMarginAmountInPosCrcy Variation Margin in Position Currency
OCIFrgnExchValnAmtInValnCrcy I_TrsyPosValuesCompatible OCIFrgnExchValnAmtInValnCrcy Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy
OCIIndexValnAmountInValnCrcy I_TrsyPosValuesCompatible OCIIndexValnAmountInValnCrcy Index Valuation, Not Affecting P/L, in Valuation Currency
OCIIndexValnAmountInPosCrcy I_TrsyPosValuesCompatible OCIIndexValnAmountInPosCrcy Index Valuation, Not Affecting P/L, in Position Currency
OCIScrtyCostValnAmtInValnCrcy I_TrsyPosValuesCompatible OCIScrtyCostValnAmtInValnCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy
OCIScrtyCostValnAmtInPosCrcy I_TrsyPosValuesCompatible OCIScrtyCostValnAmtInPosCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy
OCICostFXValnAmountInValnCrcy I_TrsyPosValuesCompatible OCICostFXValnAmountInValnCrcy Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy
AccruedInterestInValuationCrcy I_TrsyPosValuesCompatible AccruedInterestInValuationCrcy Accrued Interest (Position Component) in Valuation Currency
AccruedInterestInPositionCrcy I_TrsyPosValuesCompatible AccruedInterestInPositionCrcy Accrued Interest (Position Component) in Position Currency
CostExcldBookValueAmtInPosCrcy I_TrsyPosValuesCompatible CostExcldBookValueAmtInPosCrcy Book Value Excluding Costs in Position Currency
AcquisitionAmountInValnCrcy I_TrsyPosValuesCompatible AcquisitionAmountInValnCrcy Acquisition Value in Valuation Currency
AcquisitionAmtInPositionCrcy I_TrsyPosValuesCompatible AcquisitionAmtInPositionCrcy Acquisition Value in Position Currency
AmortizedAcqnAmountInValnCrcy I_TrsyPosValuesCompatible AmortizedAcqnAmountInValnCrcy Amortized Acquisition Value in Valuation Currency
AmortizedAcqnAmountInPosCrcy I_TrsyPosValuesCompatible AmortizedAcqnAmountInPosCrcy Amortized Acquisition Value in Position Currency
SecurityValuationAmtInValnCrcy I_TrsyPosValuesCompatible SecurityValuationAmtInValnCrcy Security Valuation in Valuation Currency
SecurityValuationAmtInPosCrcy I_TrsyPosValuesCompatible SecurityValuationAmtInPosCrcy Security Valuation in Position Currency
ClearingAmountInPositionCrcy I_TrsyPosValuesCompatible ClearingAmountInPositionCrcy Clearing Component in Position Currency
ClearingAmountInValuationCrcy I_TrsyPosValuesCompatible ClearingAmountInValuationCrcy Clearing Component in Valuation Currency
CostInValuationCurrency I_TrsyPosValuesCompatible CostInValuationCurrency Costs in Valuation Currency
PurValDeferralItmAmtInPosCrcy I_TrsyPosValuesCompatible PurValDeferralItmAmtInPosCrcy Deferral Item for Purchase Value in Position Currency
PurValDeferralItmAmtInValnCrcy I_TrsyPosValuesCompatible PurValDeferralItmAmtInValnCrcy Deferral Item for Purchase Value in Valuation Currency
NegttnSpreadAmtznAmtInPosCrcy I_TrsyPosValuesCompatible NegttnSpreadAmtznAmtInPosCrcy Amortized Negotiation Spread in Position Currency
NegttnSpreadAmtznAmtInValnCrcy I_TrsyPosValuesCompatible NegttnSpreadAmtznAmtInValnCrcy Amortized Negotiation Spread in Valuation Currency
CumltvRepaymentAmountInPosCrcy I_TrsyPosValuesCompatible CumltvRepaymentAmountInPosCrcy Cumulative Repayment in Position Currency
CumltvRepaymentAmtInValnCrcy I_TrsyPosValuesCompatible CumltvRepaymentAmtInValnCrcy Cumulative Repayment in Valuation Currency
PurCrcySpotValnAmtInValnCrcy I_TrsyPosValuesCompatible PurCrcySpotValnAmtInValnCrcy Spot Valuation of Purchase Currency in Valuation Currency
SaleCrcySpotValnAmtInValnCrcy I_TrsyPosValuesCompatible SaleCrcySpotValnAmtInValnCrcy Spot Valuation of Sale Currency in Valuation Currency
SwapAccrualAmountInPosCurrency I_TrsyPosValuesCompatible SwapAccrualAmountInPosCurrency Swap/Margin Accrual/Deferral in Position Currency
SwapAccrualAmountInValnCrcy I_TrsyPosValuesCompatible SwapAccrualAmountInValnCrcy Swap or Margin Accrual/Deferral in Valuation Currency
SwapValuationAmountInValnCrcy I_TrsyPosValuesCompatible SwapValuationAmountInValnCrcy Swap Valuation in Valuation Currency
ImpairmentAmountInPositionCrcy I_TrsyPosValuesCompatible ImpairmentAmountInPositionCrcy Impairment in Position Currency
ImpairmentAmtInValuationCrcy I_TrsyPosValuesCompatible ImpairmentAmtInValuationCrcy Impairment in Valuation Currency
HedgeAmortizationAmtInPosCrcy I_TrsyPosValuesCompatible HedgeAmortizationAmtInPosCrcy Hedge Amortization in Position Currency
HedgeAmortizationAmtInValnCrcy I_TrsyPosValuesCompatible HedgeAmortizationAmtInValnCrcy Hedge Amortization in Valuation Currency
FrgnExchValnDiffAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchValnDiffAmtInValnCrcy Foreign Exchange Valuation Differences
GainValueAdjmtAmountInPosCrcy I_TrsyPosValuesCompatible GainValueAdjmtAmountInPosCrcy Value Adjustment of Gains in Position Currency
GainValueAdjmtAmountInValnCrcy I_TrsyPosValuesCompatible GainValueAdjmtAmountInValnCrcy Value Adjustment of Gains in Valuation Currency
LossValueAdjmtAmountInPosCrcy I_TrsyPosValuesCompatible LossValueAdjmtAmountInPosCrcy Value Adjustment of Losses in Position Currency
LossValueAdjmtAmountInValnCrcy I_TrsyPosValuesCompatible LossValueAdjmtAmountInValnCrcy Value Adjustment of Losses in Valuation Currency
OriginalValueAdjmtAmtInPosCrcy I_TrsyPosValuesCompatible OriginalValueAdjmtAmtInPosCrcy Original Value Adjustment in Position Currency
OriginalValAdjmtAmtInValnCrcy I_TrsyPosValuesCompatible OriginalValAdjmtAmtInValnCrcy Original Value Adjustment in Valuation Currency
CapitalizationRsrvInPosCrcy I_TrsyPosValuesCompatible CapitalizationRsrvInPosCrcy Capitalization Reserve in Position Currency
CapitalizationRsrvInValnCrcy I_TrsyPosValuesCompatible CapitalizationRsrvInValnCrcy Capitalization Reserve in Valuation Currency
ForeignExchImprmtAmtInValnCrcy I_TrsyPosValuesCompatible ForeignExchImprmtAmtInValnCrcy FX Impairment in Valuation Currency
CnsldtdScrtyGainAmtInPosCrcy I_TrsyPosValuesCompatible CnsldtdScrtyGainAmtInPosCrcy Consolidated Security Gains in Position Currency
CnsldtdScrtyGainAmtInValnCrcy I_TrsyPosValuesCompatible CnsldtdScrtyGainAmtInValnCrcy Consolidated Security Gains in Valuation Currency
CnsldtdScrtyLossAmtInPosCrcy I_TrsyPosValuesCompatible CnsldtdScrtyLossAmtInPosCrcy Consolidated Security Losses in Position Currency
CnsldtdScrtyLossAmtInValnCrcy I_TrsyPosValuesCompatible CnsldtdScrtyLossAmtInValnCrcy Consolidated Security Losses in Valuation Currency
CnsldtdForExGainAmtInValnCrcy I_TrsyPosValuesCompatible CnsldtdForExGainAmtInValnCrcy Consolidated FX Gains in Valuation Currency
CnsldtdForExLossAmtInValnCrcy I_TrsyPosValuesCompatible CnsldtdForExLossAmtInValnCrcy Consolidated FX Losses in Valuation Currency
InterestIncomeInPositionCrcy I_TrsyPosValuesCompatible InterestIncomeInPositionCrcy Interest Income in Position Currency
InterestIncomeInValuationCrcy I_TrsyPosValuesCompatible InterestIncomeInValuationCrcy Interest Income in Valuation Currency
SecurityWriteUpAmountInPosCrcy I_TrsyPosValuesCompatible SecurityWriteUpAmountInPosCrcy Security Write-Up in Position Currency
SecurityWriteDownAmtInPosCrcy I_TrsyPosValuesCompatible SecurityWriteDownAmtInPosCrcy Security Write-Down in Position Currency
SecurityWriteUpAmtInValnCrcy I_TrsyPosValuesCompatible SecurityWriteUpAmtInValnCrcy Security Write-Up in Valuation Currency
ScrtyWriteDownAmtInValnCrcy I_TrsyPosValuesCompatible ScrtyWriteDownAmtInValnCrcy Security Write-Down in Valuation Currency
FrgnExchWriteUpAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchWriteUpAmtInValnCrcy Forex Write-Up in Valuation Currency
FrgnExchWriteDownAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchWriteDownAmtInValnCrcy Forex Write-Down in Valuation Currency
ScrtyCostWriteUpAmtInPosCrcy I_TrsyPosValuesCompatible ScrtyCostWriteUpAmtInPosCrcy Write-Up of Capitalized Costs, Security Val. in Pos.Crcy
ScrtyCostWriteDownAmtInPosCrcy I_TrsyPosValuesCompatible ScrtyCostWriteDownAmtInPosCrcy Write-Down of Capitalized Costs, Security Valn in Pos. Crcy
ScrtyCostWriteUpAmtInValnCrcy I_TrsyPosValuesCompatible ScrtyCostWriteUpAmtInValnCrcy Write-Up of Capitalized Costs, Security Val. in Val.Crcy
ScrtyCostWrtDownAmtInValnCrcy I_TrsyPosValuesCompatible ScrtyCostWrtDownAmtInValnCrcy Write-Down of Capitalized Costs, Security Valn in Val.Crcy
FrgnExchCostWrtUpAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchCostWrtUpAmtInValnCrcy Write-Up of Capitalized Costs, FX Valuation in Val.Crcy
FXCostWriteDownAmtInValnCrcy I_TrsyPosValuesCompatible FXCostWriteDownAmtInValnCrcy Write-Down of Capitalized Costs, FX Valuation in Val.Crcy
IndexWriteUpAmountInPosCrcy I_TrsyPosValuesCompatible IndexWriteUpAmountInPosCrcy Index Write-Up in Position Currency
IndexWriteDownAmountInPosCrcy I_TrsyPosValuesCompatible IndexWriteDownAmountInPosCrcy Index Write-Down in Position Currency
IndexWriteUpAmountInValnCrcy I_TrsyPosValuesCompatible IndexWriteUpAmountInValnCrcy Index Write-Up in Valuation Currency
IndexWriteDownAmtInValnCrcy I_TrsyPosValuesCompatible IndexWriteDownAmtInValnCrcy Index Write-Down in Valuation Currency
IndexCleanClearingAmtInPosCrcy I_TrsyPosValuesCompatible IndexCleanClearingAmtInPosCrcy Clearing Component, Index Clean, in Position Crcy
IndexCleanPurchaseValInPosCrcy I_TrsyPosValuesCompatible IndexCleanPurchaseValInPosCrcy Purchase Value, Index-Clean, in Position Currency
IdxCleanScrtyValnAmtInPosCrcy I_TrsyPosValuesCompatible IdxCleanScrtyValnAmtInPosCrcy Security Valuation, Index-Clean, in Position Currency
IndexCleanCostInPositionCrcy I_TrsyPosValuesCompatible IndexCleanCostInPositionCrcy Costs, Index-Clean, in Position Currency
IndexClnScrtyCostValuationAmt I_TrsyPosValuesCompatible IndexClnScrtyCostValuationAmt Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
IndexCleanAmtznAmountInPosCrcy I_TrsyPosValuesCompatible IndexCleanAmtznAmountInPosCrcy Amortization, Index-Clean, in Position Currency
IdxClnClrdPremDiscDeferralAmt I_TrsyPosValuesCompatible IdxClnClrdPremDiscDeferralAmt Cleared PD Deferral/Tax Compensation in PC: Index-Clean
IdxClnPurValDefrlAmtInPosCrcy I_TrsyPosValuesCompatible IdxClnPurValDefrlAmtInPosCrcy Deferral Item for Purchase Value, Index-Clean, in Pos.Crcy
IdxClnOCIScrtyCostValuationAmt I_TrsyPosValuesCompatible IdxClnOCIScrtyCostValuationAmt Val.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy
IndexCleanNegttnAmtznInPosCrcy I_TrsyPosValuesCompatible IndexCleanNegttnAmtznInPosCrcy Amort. Negotiation Spread, Index-Clean, in Position Currency
IndexCleanRpaytAmtInPosCrcy I_TrsyPosValuesCompatible IndexCleanRpaytAmtInPosCrcy Cumulative Repayment, Index-Clean, in Position Currency
IndexCleanInterestIncInPosCrcy I_TrsyPosValuesCompatible IndexCleanInterestIncInPosCrcy Interest Income, Index-Clean, in Position Currency
IdxCleanHedgeAmtznAmtInPosCrcy I_TrsyPosValuesCompatible IdxCleanHedgeAmtznAmtInPosCrcy Hedge Amortization, Index-Clean, in Position Currency
IndexCleanImprmtAmtInPosCrcy I_TrsyPosValuesCompatible IndexCleanImprmtAmtInPosCrcy Impairment, Index-Clean, in Position Currency
IndexClnBookValueAmtInPosCrcy I_TrsyPosValuesCompatible IndexClnBookValueAmtInPosCrcy Book Value, Index-Clean, in Position Currency
IdxClnCostExcldBookValueAmount I_TrsyPosValuesCompatible IdxClnCostExcldBookValueAmount Book Value Excluding Costs, Index-Clean, in Position Crcy
IndexCleanAcqnAmountInPosCrcy I_TrsyPosValuesCompatible IndexCleanAcqnAmountInPosCrcy Acquisition Value, Index-Clean, in Position Currency
IdxCleanAmtzdAcqnAmtInPosCrcy I_TrsyPosValuesCompatible IdxCleanAmtzdAcqnAmtInPosCrcy Amortized Acquisition Value, Index-Clean, in Position Crcy
EffctvAmtInValnCrcy I_TrsyPosValuesCompatible EffctvAmtInValnCrcy Effective Amount in Valuation Currency
EffctvAmtInPosCrcy I_TrsyPosValuesCompatible EffctvAmtInPosCrcy Effective Amount in Position Currency
IneffctvAmtInPosCrcy I_TrsyPosValuesCompatible IneffctvAmtInPosCrcy Ineffective Amount in Position Currency
IneffctvAmtInValnCrcy I_TrsyPosValuesCompatible IneffctvAmtInValnCrcy Ineffective Amount in Valuation Currency
EffctvCostHdggRsrvInPosCrcy I_TrsyPosValuesCompatible EffctvCostHdggRsrvInPosCrcy Effective/Cost of Hedging Reserve in Position Currency
EffctvCostHdggRsrvInValnCrcy I_TrsyPosValuesCompatible EffctvCostHdggRsrvInValnCrcy Effective/Cost of Hedging Reserve in Valuation Currency
IneffctvHdggRsrvPnLInPosCrcy I_TrsyPosValuesCompatible IneffctvHdggRsrvPnLInPosCrcy Ineffective/Hedging Rsrv Through Profit & Loss in Pos Crcy
IneffctvHdggRsrvPnLInValnCrcy I_TrsyPosValuesCompatible IneffctvHdggRsrvPnLInValnCrcy Ineffective/Hedging Rsrv Through Profit & Loss in Vln Crcy
EffctvHdggRsrvPnLInPosCrcy I_TrsyPosValuesCompatible EffctvHdggRsrvPnLInPosCrcy Effective/Hedging Rsrv Through Profit & Loss in Pos. Crcy
IneffctvCostHdgRsrvPnLPosCrcy I_TrsyPosValuesCompatible IneffctvCostHdgRsrvPnLPosCrcy Ineffective/Cost of Hdg Rsrv Through Profit & Loss in PC
IneffctvCostHdgRsrvPnLValnCrcy I_TrsyPosValuesCompatible IneffctvCostHdgRsrvPnLValnCrcy Ineffective/Cost of Hdg Rsrv Through Profit & Loss in VC
EffctvCostHdgRsrvPnLInPosCrcy I_TrsyPosValuesCompatible EffctvCostHdgRsrvPnLInPosCrcy Effective/Cost of Hdg Rsrv Thr. Profit & Loss in Pos. Crcy
EffctvCostHdgRsrvPnLInValnCrcy I_TrsyPosValuesCompatible EffctvCostHdgRsrvPnLInValnCrcy Effective/Cost of Hdg Rsrv Thr. Profit & Loss in Vln Crcy
LossAllowanceAmountInPosCrcy I_TrsyPosValuesCompatible LossAllowanceAmountInPosCrcy Loss Allowance in Position Currency
LossAllowanceAmountInValnCrcy I_TrsyPosValuesCompatible LossAllowanceAmountInValnCrcy Loss Allowance in Valuation Currency
FXLossAllowanceAmtInValnCrcy I_TrsyPosValuesCompatible FXLossAllowanceAmtInValnCrcy Loss Allowance FX in Valuation Currency
OffstLossAllowanceAmtInPosCrcy I_TrsyPosValuesCompatible OffstLossAllowanceAmtInPosCrcy Offset Loss Allowance in Position Currency
OffsetLossAllwncAmtInValnCrcy I_TrsyPosValuesCompatible OffsetLossAllwncAmtInValnCrcy Offset Loss Allowance in Valuation Currency
OCIOffstLossAllwncAmtInPosCrcy I_TrsyPosValuesCompatible OCIOffstLossAllwncAmtInPosCrcy OCI Offset Loss Allowance in Position Currency
FXOffstLossAllwncAmtInValnCrcy I_TrsyPosValuesCompatible FXOffstLossAllwncAmtInValnCrcy Offset Loss Allowance FX in Valuation Currency
FXOffstOCILossAllwncInValnCrcy I_TrsyPosValuesCompatible FXOffstOCILossAllwncInValnCrcy OCI Offset Loss Allowance FX in Valuation Currency
AmtznAdjmtLossAllwncInPosCrcy I_TrsyPosValuesCompatible AmtznAdjmtLossAllwncInPosCrcy Amortization Adjustm. of Loss Allowance in Position Currency
AmtznAdjmtLossAllwncInValnCrcy I_TrsyPosValuesCompatible AmtznAdjmtLossAllwncInValnCrcy Amortization Adj. of Loss Allowance in Valuation Currency
ContractChangeAmtInPosCrcy I_TrsyPosValuesCompatible ContractChangeAmtInPosCrcy Contractual Change in Position Currency
ContractChangeAmtInValnCrcy I_TrsyPosValuesCompatible ContractChangeAmtInValnCrcy Contractual Change in Valuation Currency
FrgnExchContrChgAmtInValnCrcy I_TrsyPosValuesCompatible FrgnExchContrChgAmtInValnCrcy Contractual Change FX in Valuation Currency
AmortizedCostInPositionCrcy I_TrsyPosValuesCompatible AmortizedCostInPositionCrcy OBSOLETE: Amortized Cost in Position Currency
AmortizedCostInValuationCrcy I_TrsyPosValuesCompatible AmortizedCostInValuationCrcy OBSOLETE: Amortized Cost in Valuation Currency
PnLDesignatedAmtInPosCrcy I_TrsyPosValuesCompatible PnLDesignatedAmtInPosCrcy Profit/Loss Effective / Designated Comp. in Position Crcy
PnLDesignatedAmtInVC I_TrsyPosValuesCompatible PnLDesignatedAmtInVC Profit/Loss Effective / Designated Comp. in Valuation Crcy
PnLNonDesignatedAmtInPosCrcy I_TrsyPosValuesCompatible PnLNonDesignatedAmtInPosCrcy Profit/Loss Effective / Non-Designated Component in PC
PnLNonDesignatedAmtInVC I_TrsyPosValuesCompatible PnLNonDesignatedAmtInVC Profit/Loss Effective / Non-Designated Component in VC
AmtznNonDesignatedAmtInPosCrcy I_TrsyPosValuesCompatible AmtznNonDesignatedAmtInPosCrcy Amortization / Non-Designated Component in Position Currency
AmtznNonDesignatedAmtInVC I_TrsyPosValuesCompatible AmtznNonDesignatedAmtInVC Amortization / Non-Designated Comp. in Valuation Currency

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_TrsyPositionValueCube.
-- 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: ITRSYPOSVALCUBE

CREATE VIEW I_TrsyPositionValueCube AS
SELECT
  case when _TreasurySubPosition.IsFreestanding is null then 'X' else ' ' end AS IsFreestanding,
  case when _TreasurySubPosition.DesignatedNominalCurrency is null then NominalCurrency else _TreasurySubPosition.DesignatedNominalCurrency end AS DesignatedNominalCurrency,
  cast(I_Ftr_Position_Values.DesignatedQuantityInPieces as ftr_gen_des_quant_in_units_l) AS DesignatedQuantityInPieces,
  cast( case when _TreasurySubPosition.DesignatedNominalCurrency is null then I_Ftr_Position_Values.NominalCurrency else _TreasurySubPosition.DesignatedNominalCurrency end as ftr_gen_hrel_risk_currency preserving type) AS TrsyHedgingRelshpRiskCurrency,
  cast(I_Ftr_Position_Values.QuantityInPieces as ftr_gen_quantity_in_units_l) AS QuantityInPieces,
  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.LoanContract AS LoanContract,
  I_Ftr_Position_Values.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  I_Ftr_Position_Values.FinancialTransaction AS FinancialTransaction,
  I_Ftr_Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Position_Values.TreasuryPositionAccount AS TreasuryPositionAccount,
  I_Ftr_Position_Values.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  I_Ftr_Position_Values.TreasuryPositionLot AS TreasuryPositionLot,
  I_Ftr_Position_Values.CentralClearingAccount AS CentralClearingAccount,
  I_Ftr_Position_Values.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  I_Ftr_Position_Values.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  I_Ftr_Position_Values.TreasuryPosition AS TreasuryPosition,
  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.SecurityAccountGroup AS SecurityAccountGroup,
  I_Ftr_Position_Values.Fund AS Fund,
  I_Ftr_Position_Values.GrantID AS GrantID,
  I_Ftr_Position_Values.WBSElementInternalID AS WBSElementInternalID,
  I_Ftr_Position_Values.ProfitCenter AS ProfitCenter,
  I_Ftr_Position_Values.CostCenter AS CostCenter,
  I_Ftr_Position_Values.FunctionalArea AS FunctionalArea,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  I_Ftr_Position_Values.Portfolio AS Portfolio,
  I_Ftr_Position_Values.CommitmentBusinessPartner AS CommitmentBusinessPartner,
  I_Ftr_Position_Values.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  I_Ftr_Position_Values.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Position_Values.TreasuryUpdateType AS TreasuryUpdateType,
  I_Ftr_Position_Values.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  I_Ftr_Position_Values.TreasuryAccountingCode AS TreasuryAccountingCode,
  I_Ftr_Position_Values.DesignatedAmountInNominalCrcy AS DesignatedAmountInNominalCrcy,
  I_Ftr_Position_Values.DesignatedOrigAmtInNominalCrcy AS DesignatedOrigAmtInNominalCrcy,
  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.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  I_Ftr_Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  I_Ftr_Position_Values.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  I_Ftr_Position_Values.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  I_Ftr_Position_Values.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  I_Ftr_Position_Values.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  I_Ftr_Position_Values.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  I_Ftr_Position_Values.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  I_Ftr_Position_Values.IdxClnOCIScrtyValnAmtInPosCrcy AS IdxClnOCIScrtyValnAmtInPosCrcy,
  I_Ftr_Position_Values.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  I_Ftr_Position_Values.CostExcldBookValAmtInValnCrcy AS CostExcldBookValAmtInValnCrcy,
  I_Ftr_Position_Values.CostInPositionCurrency AS CostInPositionCurrency,
  I_Ftr_Position_Values.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  I_Ftr_Position_Values.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  I_Ftr_Position_Values.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  I_Ftr_Position_Values.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  I_Ftr_Position_Values.IndexValuationAmountInValnCrcy AS IndexValuationAmountInValnCrcy,
  I_Ftr_Position_Values.IndexValuationAmountInPosCrcy AS IndexValuationAmountInPosCrcy,
  I_Ftr_Position_Values.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  I_Ftr_Position_Values.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  I_Ftr_Position_Values.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  I_Ftr_Position_Values.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCIIndexValnAmountInValnCrcy AS OCIIndexValnAmountInValnCrcy,
  I_Ftr_Position_Values.OCIIndexValnAmountInPosCrcy AS OCIIndexValnAmountInPosCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  I_Ftr_Position_Values.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  I_Ftr_Position_Values.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  I_Ftr_Position_Values.CostExcldBookValueAmtInPosCrcy AS CostExcldBookValueAmtInPosCrcy,
  I_Ftr_Position_Values.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  I_Ftr_Position_Values.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  I_Ftr_Position_Values.ClearingAmountInPositionCrcy AS ClearingAmountInPositionCrcy,
  I_Ftr_Position_Values.ClearingAmountInValuationCrcy AS ClearingAmountInValuationCrcy,
  I_Ftr_Position_Values.CostInValuationCurrency AS CostInValuationCurrency,
  I_Ftr_Position_Values.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  I_Ftr_Position_Values.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  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.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.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.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.EffctvAmtInValnCrcy AS EffctvAmtInValnCrcy,
  I_Ftr_Position_Values.EffctvAmtInPosCrcy AS EffctvAmtInPosCrcy,
  I_Ftr_Position_Values.IneffctvAmtInPosCrcy AS IneffctvAmtInPosCrcy,
  I_Ftr_Position_Values.IneffctvAmtInValnCrcy AS IneffctvAmtInValnCrcy,
  I_Ftr_Position_Values.EffctvCostHdggRsrvInPosCrcy AS EffctvCostHdggRsrvInPosCrcy,
  I_Ftr_Position_Values.EffctvCostHdggRsrvInValnCrcy AS EffctvCostHdggRsrvInValnCrcy,
  I_Ftr_Position_Values.IneffctvHdggRsrvPnLInPosCrcy AS IneffctvHdggRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.IneffctvHdggRsrvPnLInValnCrcy AS IneffctvHdggRsrvPnLInValnCrcy,
  I_Ftr_Position_Values.EffctvHdggRsrvPnLInPosCrcy AS EffctvHdggRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.IneffctvCostHdgRsrvPnLPosCrcy AS IneffctvCostHdgRsrvPnLPosCrcy,
  I_Ftr_Position_Values.IneffctvCostHdgRsrvPnLValnCrcy AS IneffctvCostHdgRsrvPnLValnCrcy,
  I_Ftr_Position_Values.EffctvCostHdgRsrvPnLInPosCrcy AS EffctvCostHdgRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.EffctvCostHdgRsrvPnLInValnCrcy AS EffctvCostHdgRsrvPnLInValnCrcy,
  I_Ftr_Position_Values.LossAllowanceAmountInPosCrcy AS LossAllowanceAmountInPosCrcy,
  I_Ftr_Position_Values.LossAllowanceAmountInValnCrcy AS LossAllowanceAmountInValnCrcy,
  I_Ftr_Position_Values.FXLossAllowanceAmtInValnCrcy AS FXLossAllowanceAmtInValnCrcy,
  I_Ftr_Position_Values.OffstLossAllowanceAmtInPosCrcy AS OffstLossAllowanceAmtInPosCrcy,
  I_Ftr_Position_Values.OffsetLossAllwncAmtInValnCrcy AS OffsetLossAllwncAmtInValnCrcy,
  I_Ftr_Position_Values.OCIOffstLossAllwncAmtInPosCrcy AS OCIOffstLossAllwncAmtInPosCrcy,
  I_Ftr_Position_Values.FXOffstLossAllwncAmtInValnCrcy AS FXOffstLossAllwncAmtInValnCrcy,
  I_Ftr_Position_Values.FXOffstOCILossAllwncInValnCrcy AS FXOffstOCILossAllwncInValnCrcy,
  I_Ftr_Position_Values.AmtznAdjmtLossAllwncInPosCrcy AS AmtznAdjmtLossAllwncInPosCrcy,
  I_Ftr_Position_Values.AmtznAdjmtLossAllwncInValnCrcy AS AmtznAdjmtLossAllwncInValnCrcy,
  I_Ftr_Position_Values.ContractChangeAmtInPosCrcy AS ContractChangeAmtInPosCrcy,
  I_Ftr_Position_Values.ContractChangeAmtInValnCrcy AS ContractChangeAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchContrChgAmtInValnCrcy AS FrgnExchContrChgAmtInValnCrcy,
  I_Ftr_Position_Values.AmortizedCostInPositionCrcy AS AmortizedCostInPositionCrcy,
  I_Ftr_Position_Values.AmortizedCostInValuationCrcy AS AmortizedCostInValuationCrcy,
  I_Ftr_Position_Values.PnLDesignatedAmtInPosCrcy AS PnLDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.PnLDesignatedAmtInVC AS PnLDesignatedAmtInVC,
  I_Ftr_Position_Values.PnLNonDesignatedAmtInPosCrcy AS PnLNonDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.PnLNonDesignatedAmtInVC AS PnLNonDesignatedAmtInVC,
  I_Ftr_Position_Values.AmtznNonDesignatedAmtInPosCrcy AS AmtznNonDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.AmtznNonDesignatedAmtInVC AS AmtznNonDesignatedAmtInVC
FROM I_TrsyPosValuesCompatible AS I_Ftr_Position_Values
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccount AS _CentralClearingAccount ON CompanyCode = _CentralClearingAccount.CompanyCode AND CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON PositionCurrency = _PositionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ValuationCurrency ON ValuationCurrency = _ValuationCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClass AS _TreasuryValuationClass ON TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClass.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON FinancialTransaction = _FinancialTransaction.FinancialTransaction AND CompanyCode = _FinancialTransaction.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TreasuryGLAccountAssignRef AS _TreasuryGLAccountAssignRef ON TreasuryGLAccountAssignmentRef = _TreasuryGLAccountAssignRef.TreasuryGLAccountAssignmentRef  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount AND CompanyCode = _TreasuryPositionAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosManagementProcedure AS _TrsyPosManagementProcedure ON TrsyPosManagementProcedure = _TrsyPosManagementProcedure.TrsyPosManagementProcedure  -- association [0..1]
;

Learn More