C_PositionValuesExpdLosses

Column Name Description
Column Name Description
💲 Nominal Currency (NominalCurrency):
NominalAmountInNominalCurrency Nominal Amount
OriglNominalAmtInNominalCrcy Original Nominal Amount
💲 Position Currency (PositionCurrency):
ClearingAmountInPositionCrcy Clearing Component in Position Currency
PurchaseValueInPositionCrcy Purchase Value in Position Currency
SecurityValuationAmtInPosCrcy Security Valuation in Position Currency
CostInPositionCurrency Costs in Position Currency
SecurityCostValnAmtInPosCrcy Valuation of Cap. Costs, Security, in Position Currency
AmortizationAmtInPositionCrcy Amortization in Position Currency
ClrdPremDiscDefrlTxCompnAmount Cleared PD Deferral/Tax Compensation in Position Currency
IndexValuationAmountInPosCrcy Index Valuation in Position Currency
PurValDeferralItmAmtInPosCrcy Deferral Item for Purchase Value in Position Currency
VariationMarginAmountInPosCrcy Variation Margin in Position Currency
OCISecurityValnAmountInPosCrcy Security Valuation, Not Affecting P/L, in Position Currency
OCIIndexValnAmountInPosCrcy Index Valuation, Not Affecting P/L, in Position Currency
OCIScrtyCostValnAmtInPosCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy
AccruedInterestInPositionCrcy Accrued Interest (Position Component) in Position Currency
NegttnSpreadAmtznAmtInPosCrcy Amortized Negotiation Spread in Position Currency
CumltvRepaymentAmountInPosCrcy Cumulative Repayment in Position Currency
SwapAccrualAmountInPosCurrency Swap/Margin Accrual/Deferral in Position Currency
ImpairmentAmountInPositionCrcy Impairment in Position Currency
HedgeAmortizationAmtInPosCrcy Hedge Amortization in Position Currency
GainValueAdjmtAmountInPosCrcy Value Adjustment of Gains in Position Currency
LossValueAdjmtAmountInPosCrcy Value Adjustment of Losses in Position Currency
OriginalValueAdjmtAmtInPosCrcy Original Value Adjustment in Position Currency
CapitalizationRsrvInPosCrcy Capitalization Reserve in Position Currency
CnsldtdScrtyGainAmtInPosCrcy Consolidated Security Gains in Position Currency
CnsldtdScrtyLossAmtInPosCrcy Consolidated Security Losses in Position Currency
InterestIncomeInPositionCrcy Interest Income in Position Currency
SecurityWriteUpAmountInPosCrcy Security Write-Up in Position Currency
SecurityWriteDownAmtInPosCrcy Security Write-Down in Position Currency
ScrtyCostWriteUpAmtInPosCrcy Write-Up of Capitalized Costs, Security Val. in Pos.Crcy
ScrtyCostWriteDownAmtInPosCrcy Write-Down of Capitalized Costs, Security Valn in Pos. Crcy
IndexWriteUpAmountInPosCrcy Index Write-Up in Position Currency
IndexWriteDownAmountInPosCrcy Index Write-Down in Position Currency
IndexCleanClearingAmtInPosCrcy Clearing Component, Index Clean, in Position Crcy
IndexCleanPurchaseValInPosCrcy Purchase Value, Index-Clean, in Position Currency
IdxCleanScrtyValnAmtInPosCrcy Security Valuation, Index-Clean, in Position Currency
IndexCleanCostInPositionCrcy Costs, Index-Clean, in Position Currency
IndexClnScrtyCostValuationAmt Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
IndexCleanAmtznAmountInPosCrcy Amortization, Index-Clean, in Position Currency
IdxClnClrdPremDiscDeferralAmt Cleared PD Deferral/Tax Compensation in PC: Index-Clean
IdxClnPurValDefrlAmtInPosCrcy Deferral Item for Purchase Value, Index-Clean, in Pos.Crcy
IdxClnOCIScrtyValnAmtInPosCrcy Security Valuation, Not Affecting P/L, Index-Clean, in PC
IdxClnOCIScrtyCostValuationAmt Val.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy
IndexCleanNegttnAmtznInPosCrcy Amort. Negotiation Spread, Index-Clean, in Position Currency
IndexCleanRpaytAmtInPosCrcy Cumulative Repayment, Index-Clean, in Position Currency
IndexCleanInterestIncInPosCrcy Interest Income, Index-Clean, in Position Currency
IdxCleanHedgeAmtznAmtInPosCrcy Hedge Amortization, Index-Clean, in Position Currency
IndexCleanImprmtAmtInPosCrcy Impairment, Index-Clean, in Position Currency
BookValueAmtInPositionCurrency Book Value in Position Currency
CostExcldBookValueAmtInPosCrcy Book Value Excluding Costs in Position Currency
AcquisitionAmtInPositionCrcy Acquisition Value in Position Currency
AmortizedAcqnAmountInPosCrcy Amortized Acquisition Value in Position Currency
IndexClnBookValueAmtInPosCrcy Book Value, Index-Clean, in Position Currency
IdxClnCostExcldBookValueAmount Book Value Excluding Costs, Index-Clean, in Position Crcy
IndexCleanAcqnAmountInPosCrcy Acquisition Value, Index-Clean, in Position Currency
IdxCleanAmtzdAcqnAmtInPosCrcy Amortized Acquisition Value, Index-Clean, in Position Crcy
LossAllowanceAmountInPosCrcy Loss Allowance in Position Currency
IdxCleanLossAllwncAmtInPosCrcy Loss Allowance in Position Currency: Index-Clean
OffstLossAllowanceAmtInPosCrcy Offset Loss Allowance in Position Currency
IdxCleanOffsetLossAllowanceAmt Offset Loss Allowance in Position Currency: Index-Clean
OCIOffstLossAllwncAmtInPosCrcy OCI Offset Loss Allowance in Position Currency
IdxClnOCIOffstLossAllwncAmtIn OCI Offset Loss Allowance in Position Currency: Index-Clean
AmtznAdjmtLossAllwncInPosCrcy Amortization Adjustm. of Loss Allowance in Position Currency
IdxClnAmtznAdjLossAllInPosCrcy Amort. Adj. of Loss Allowance in Position Crcy (Index-Clean)
ContractChangeAmtInPosCrcy Contractual Change in Position Currency
IdxClnContrChangeAmtInPosCrcy Contractual Change in Position Currency: Index-Clean
AmortizedCostInPositionCrcy OBSOLETE: Amortized Cost in Position Currency
IdxClnAmortizedCostInPosCrcy Amortized Cost in Position Currency: Index-Clean
💲 Valuation Currency (ValuationCurrency):
ClearingAmountInValuationCrcy Clearing Component in Valuation Currency
PurchaseValueInValuationCrcy Purchase Value in Valuation Currency
SecurityValuationAmtInValnCrcy Security Valuation in Valuation Currency
ForeignCrcyValnAmtInValnCrcy Foreign Currency Valuation in Valuation Currency
CostInValuationCurrency Costs in Valuation Currency
SecurityCostValnAmtInValnCrcy Valuation of Cap. Costs, Security, in Valuation Currency
FrgnExchCostValnAmtInValnCrcy Valuation of Capitalized Costs, FX, in Valuation Currency
AmortizationAmtInValuationCrcy Amortization in Valuation Currency
ClrdPremDiscDefrlAmtInValnCrcy Cleared PD Deferral/Tax Compensation in Valuation Currency
IndexValuationAmountInValnCrcy Index Valuation in Valuation Currency
PurValDeferralItmAmtInValnCrcy Deferral Item for Purchase Value in Valuation Currency
VariationMarginAmtInValnCrcy Variation Margin in Valuation Currency
OCIScrtyValnAmountInValnCrcy Security Valuation, Not Affecting P/L, in Valuation Currency
OCIFrgnExchValnAmtInValnCrcy Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy
OCIIndexValnAmountInValnCrcy Index Valuation, Not Affecting P/L, in Valuation Currency
OCIScrtyCostValnAmtInValnCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy
OCICostFXValnAmountInValnCrcy Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy
AccruedInterestInValuationCrcy Accrued Interest in Valuation Currency
NegttnSpreadAmtznAmtInValnCrcy Amortized Negotiation Spread in Valuation Currency
CumltvRepaymentAmtInValnCrcy Cumulative Repayment in Valuation Currency
PurCrcySpotValnAmtInValnCrcy Spot Valuation of Purchase Currency in Valuation Currency
SaleCrcySpotValnAmtInValnCrcy Spot Valuation of Sale Currency in Valuation Currency
SwapAccrualAmountInValnCrcy Swap or Margin Accrual/Deferral in Valuation Currency
SwapValuationAmountInValnCrcy Swap Valuation in Valuation Currency
ImpairmentAmtInValuationCrcy Impairment in Valuation Currency
HedgeAmortizationAmtInValnCrcy Hedge Amortization in Valuation Currency
FrgnExchValnDiffAmtInValnCrcy Foreign Exchange Valuation Differences
GainValueAdjmtAmountInValnCrcy Value Adjustment of Gains in Valuation Currency
LossValueAdjmtAmountInValnCrcy Value Adjustment of Losses in Valuation Currency
OriginalValAdjmtAmtInValnCrcy Original Value Adjustment in Valuation Currency
CapitalizationRsrvInValnCrcy Capitalization Reserve in Valuation Currency
FXValnAmtzdAcqnAmtInValnCrcy FX Valuation of Amort. Acquisition Value in Valuation Crcy
ForeignExchImprmtAmtInValnCrcy FX Impairment in Valuation Currency
CnsldtdScrtyGainAmtInValnCrcy Consolidated Security Gains in Valuation Currency
CnsldtdScrtyLossAmtInValnCrcy Consolidated Security Losses in Valuation Currency
CnsldtdForExGainAmtInValnCrcy Consolidated FX Gains in Valuation Currency
CnsldtdForExLossAmtInValnCrcy Consolidated FX Losses in Valuation Currency
InterestIncomeInValuationCrcy Interest Income in Valuation Currency
SecurityWriteUpAmtInValnCrcy Security Write-Up in Valuation Currency
ScrtyWriteDownAmtInValnCrcy Security Write-Down in Valuation Currency
FrgnExchWriteUpAmtInValnCrcy Forex Write-Up in Valuation Currency
FrgnExchWriteDownAmtInValnCrcy Forex Write-Down in Valuation Currency
ScrtyCostWriteUpAmtInValnCrcy Write-Up of Capitalized Costs, Security Val. in Val.Crcy
ScrtyCostWrtDownAmtInValnCrcy Write-Down of Capitalized Costs, Security Valn in Val.Crcy
FrgnExchCostWrtUpAmtInValnCrcy Write-Up of Capitalized Costs, FX Valuation in Val.Crcy
FXCostWriteDownAmtInValnCrcy Write-Down of Capitalized Costs, FX Valuation in Val.Crcy
IndexWriteUpAmountInValnCrcy Index Write-Up in Valuation Currency
IndexWriteDownAmtInValnCrcy Index Write-Down in Valuation Currency
BookValueAmountInValnCurrency Book Value in Valuation Currency
CostExcldBookValAmtInValnCrcy Book Value Excluding Costs in Valuation Currency
AcquisitionAmountInValnCrcy Acquisition Value in Valuation Currency
AmortizedAcqnAmountInValnCrcy Amortized Acquisition Value in Valuation Currency
LossAllowanceAmountInValnCrcy Loss Allowance in Valuation Currency
FXLossAllowanceAmtInValnCrcy Loss Allowance FX in Valuation Currency
OffsetLossAllwncAmtInValnCrcy Offset Loss Allowance in Valuation Currency
FXOffstLossAllwncAmtInValnCrcy Offset Loss Allowance FX in Valuation Currency
OCIOffstLossAllwncInValnCrcy OCI Offset Loss Allowance in Valuation Currency
FXOffstOCILossAllwncInValnCrcy OCI Offset Loss Allowance FX in Valuation Currency
AmtznAdjmtLossAllwncInValnCrcy Amortization Adj. of Loss Allowance in Valuation Currency
FXAmtznAdjLossAllwncInValnCrcy Amortization Adjust. of Loss Allowance FX in Valuation Crcy.
ContractChangeAmtInValnCrcy Contractual Change in Valuation Currency
FrgnExchContrChgAmtInValnCrcy Contractual Change FX in Valuation Currency
AmortizedCostInValuationCrcy OBSOLETE: Amortized Cost in Valuation Currency
💲 Designated Nominal Currency (DesignatedNominalCurrency):
DesignatedAmountInNominalCrcy Designated Nominal Amount
DesignatedOrigAmtInNominalCrcy Designated Original Nominal Amount
Column Name Description
Column Name Description
KeyDate null
TermStartDate Term Start
TrsyPositionLotCreationDate Lot Creation Date
TrsyPositionLotCreationTime Lot Creation Time
TermEndDate Term End
Column Name Description
FinInstrProductGroup Financial Instrument Product Group Show values
IsFreestanding Indicator: Freestanding Portion of the Position Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
TreasuryPositionIsNotZero Indicates whether Position is Zero at Key Date Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
TrsyDerivedBusTransacIsUpdated Status of Derived Business Transactions Show values
Column Name Description Domain name
FinancialInstrProdTypeName Name of the Product Type TEXT30
TreasuryValuationAreaName Name of the Valuation Area FTR_GEN_DESCRIPTION
TreasuryValuationClassName Name of the Valuation Class FTR_GEN_DESCRIPTION
TrsySubPosition Subposition SYSUUID
HedgedItem Hedged Item Number FTR_GEN_HITEM_NUMBER
HedgedItemFiscalYear Fiscal Year of Hedged Item GJAHR
HedgingInstr Hedging Instrument Number FTR_GEN_HINST_NUMBER
HedgingInstrumentFiscalYear Fiscal Year of Hedging Instrument GJAHR
CompanyCodeName Name of Company Code or Company TEXT25
SecurityAccountName Name of the Security Account XLDEPO
TreasuryPositionLot Identifier of the Lot SYSUUID
TrsyPositionLongShortCodeName Name of the Code: Long or Short Position TEXT20
CentralClearingAccount Central Clearing Account FTR_GEN_CNTRL_CLEARING_ACCOUNT
SecurityClassName Name of the Security Class XKBEZ
SecurityClassDescription Description of the Security Class XLBEZ
SecurityAccountGroupName Name of Securities Account Group FTR_GEN_DESCRIPTION
LoanContractName Name of the Loan Contract XTEXT50
FinancialInstrTransTypeName Name of Financial Instrument Transaction Type T_XTEXT30
FinancialInstrCharacteristic Financial Instrument Free Characteristic CHAR25
FinancialInstrumentAssignment Free Assignment of Financial Transaction TEXT18
FinancialInstrumentReference Financial Instrument Free Internal Reference CHAR16
LetterOfCredit Letter of Credit Number FTR_LC_NUMBER
CommitmentBusinessPartner Partner with Whom Commitment Exists BU_PARTNER
TrsyPosManagementProcedureName Name of the Position Management Procedure FTR_GEN_DESCRIPTION
TrsyPosValuationStepProcedure Procedure for a Step TPM_STEP_PROCEDURE
TrsyPosValnStepProcedureName Name of the Procedure for a Step FTR_GEN_DESCRIPTION
TreasuryGLAccountAssignRefName Name of the Account Assignment Reference FTR_GEN_DESCRIPTION
TrsyPosFreeDefinedAttribute7 Free Defined Attribute 7 CHAR30
TrsyPosFreeDefinedAttribute8 Free Defined Attribute 8 CHAR30
TrsyPosFreeDefinedAttribute9 Free Defined Attribute 9 CHAR30
TrsyPosFreeDfndAttribute1Name Name of the Free Defined Attribute 1 FTR_GEN_DESCRIPTION30
TrsyPosFreeDfndAttribute2Name Name of the Free Defined Attribute 2 FTR_GEN_DESCRIPTION30
TrsyPosFreeDfndAttribute3Name Name of the Free Defined Attribute 3 FTR_GEN_DESCRIPTION30
TrsyPosFreeDfndAttribute4Name Name of the Free Defined Attribute 4 FTR_GEN_DESCRIPTION30
TrsyPosFreeDfndAttribute5Name Name of the Free Defined Attribute 5 FTR_GEN_DESCRIPTION30
TrsyPosFreeDfndAttribute6Name Name of the Free Defined Attribute 6 FTR_GEN_DESCRIPTION30
TrsyPositionLotCreatedByUser Lot Entered By SYCHAR12
PosGenFinancialTransaction Lot-Generating Transaction Number (Listed Derivatives) T_RFHA
QuantityInPieces Quantity in Pieces FTR_GEN_UNITS
DesignatedQuantityInPieces Designated Quantity in Pieces FTR_GEN_UNITS
BusinessAreaName Business Area Description TEXT30
TreasuryFinanceProject Finance Project T_TFPROJ
Master Data Relations | to Other Relations ↓ Join Conditions
Business Area
  • Client
  • Business Area
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TGSB.MANDT
  • C_POSITIONVALUESEXPDLOSSES.BUSINESSAREA == TGSB.GSBER
Central Clearing Account Currency
  • Client
  • Central Clearing Account Currency
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TCURC.MANDT
  • C_POSITIONVALUESEXPDLOSSES.CENTRALCLEARINGACCOUNTCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • C_POSITIONVALUESEXPDLOSSES.MANDT == T001.MANDT
  • C_POSITIONVALUESEXPDLOSSES.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TKA01.MANDT
  • C_POSITIONVALUESEXPDLOSSES.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • C_POSITIONVALUESEXPDLOSSES.MANDT == CSKS.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "DATBI"] == CSKS.DATBI
  • C_POSITIONVALUESEXPDLOSSES.COSTCENTER == CSKS.KOSTL
Portfolio as Differentiation Characteristic
  • Client
  • Portfolio as Differentiation Characteristic
  • Company Code
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TWPOB.MANDT
  • C_POSITIONVALUESEXPDLOSSES.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • C_POSITIONVALUESEXPDLOSSES.COMPANYCODE == TWPOB.BUKRS
Financial Instrument Transaction Type
  • Client
  • Financial Instrument Transaction Type
  • ?
  • C_POSITIONVALUESEXPDLOSSES.MANDT == AT10.MANDT
  • C_POSITIONVALUESEXPDLOSSES.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "VVSART"] == AT10.SGSART
Product Type
  • Client
  • Product Type
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TZPA.MANDT
  • C_POSITIONVALUESEXPDLOSSES.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Instrument Valuation Class
  • Financial Instrument Valuation Class
  • Client
  • C_POSITIONVALUESEXPDLOSSES.FINANCIALINSTRVALUATIONCLASS == TRGC_COM_VALCL.COM_VAL_CLASS
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRGC_COM_VALCL.MANDT
Transaction Number
  • Client
  • Company Code
  • Financial Transaction
  • C_POSITIONVALUESEXPDLOSSES.MANDT == VTBFHA.MANDT
  • C_POSITIONVALUESEXPDLOSSES.COMPANYCODE == VTBFHA.BUKRS
  • C_POSITIONVALUESEXPDLOSSES.FINANCIALTRANSACTION == VTBFHA.RFHA
Hedging Classification
  • Client
  • Hedging Classification
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TOEC_CLASS.CLIENT
  • C_POSITIONVALUESEXPDLOSSES.HEDGINGCLASSIFICATION == TOEC_CLASS.HEDGING_CLASSIFICATION
Loan Contract Number
  • Client
  • Company Code
  • Loan Contract Number
  • ?
  • C_POSITIONVALUESEXPDLOSSES.MANDT == VDARL.MANDT
  • C_POSITIONVALUESEXPDLOSSES.COMPANYCODE == VDARL.BUKRS
  • C_POSITIONVALUESEXPDLOSSES.LOANCONTRACT == VDARL.RANL
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "SARCHIV"] == VDARL.SARCHIV
Portfolio
  • Client
  • ?
  • Portfolio
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TWPOB.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "BUKRS"] == TWPOB.BUKRS
  • C_POSITIONVALUESEXPDLOSSES.PORTFOLIO == TWPOB.RPORTB
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • C_POSITIONVALUESEXPDLOSSES.MANDT == CEPC.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "DATBI"] == CEPC.DATBI
  • C_POSITIONVALUESEXPDLOSSES.PROFITCENTER == CEPC.PRCTR
Security Account
  • Client
  • Company Code
  • Security Account
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TWD01.MANDT
  • C_POSITIONVALUESEXPDLOSSES.COMPANYCODE == TWD01.BUKRS
  • C_POSITIONVALUESEXPDLOSSES.SECURITYACCOUNT == TWD01.RLDEPO
Security Class
  • Client
  • Security Class
  • C_POSITIONVALUESEXPDLOSSES.MANDT == VWPANLA.MANDT
  • C_POSITIONVALUESEXPDLOSSES.SECURITYCLASS == VWPANLA.RANL
Account Assignment Reference of Position Management
  • Client
  • Account Assignment Reference of Position Management
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRACC_AA_REF.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TREASURYGLACCOUNTASSIGNMENTREF == TRACC_AA_REF.AA_REF
Foreign Key Futures Account
  • Client
  • Company Code
  • Futures Account for Listed Options and Futures
Valuation Class
  • Client
  • Treasury Valuation Area
  • Valuation Class
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRGC_VAL_CLASS.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TREASURYVALUATIONAREA == TRGC_VAL_CLASS.VALUATION_AREA
  • C_POSITIONVALUESEXPDLOSSES.TREASURYVALUATIONCLASS == TRGC_VAL_CLASS.VALUATION_CLASS
Free Defined Attribute 1
  • Client
  • ?
  • Free Defined Attribute 1
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_S.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_S.ATTRIB
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE1 == TRLTC_ATTRVAL_S.VALUE
Free Defined Attribute 2
  • Client
  • ?
  • Free Defined Attribute 2
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_S.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_S.ATTRIB
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE2 == TRLTC_ATTRVAL_S.VALUE
Free Defined Attribute 3
  • Client
  • Free Defined Attribute 3
  • ?
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_S.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE3 == TRLTC_ATTRVAL_S.VALUE
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_S.ATTRIB
Free Defined Attribute 4
  • Client
  • ?
  • Free Defined Attribute 4
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_M.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_M.ATTRIB
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE4 == TRLTC_ATTRVAL_M.VALUE
Free Defined Attribute 5
  • Client
  • ?
  • Free Defined Attribute 5
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_M.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_M.ATTRIB
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE5 == TRLTC_ATTRVAL_M.VALUE
Free Defined Attribute 6
  • Client
  • ?
  • Free Defined Attribute 6
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRLTC_ATTRVAL_M.MANDT
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "TPM_POS_ATTRIB"] == TRLTC_ATTRVAL_M.ATTRIB
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSFREEDEFINEDATTRIBUTE6 == TRLTC_ATTRVAL_M.VALUE
Position Management Procedure
  • Client
  • Position Management Procedure
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRGC_PM_PROC.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TRSYPOSMANAGEMENTPROCEDURE == TRGC_PM_PROC.POS_MAN_PROC
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Client
  • Company Code
  • Securities Account Group
Trader / Back office clerk
  • Client
  • Trader
  • ?
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TZDEA.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TRADER == TZDEA.RDEALER
  • C_POSITIONVALUESEXPDLOSSES.[column in domain "BUKRS"] == TZDEA.BUKRS
Accounting Code
  • Client
  • Accounting Code
Treasury Valuation Area
  • Client
  • Treasury Valuation Area
  • C_POSITIONVALUESEXPDLOSSES.MANDT == TRGC_VAL_AREA.MANDT
  • C_POSITIONVALUESEXPDLOSSES.TREASURYVALUATIONAREA == TRGC_VAL_AREA.VALUATION_AREA