TLVT_MANUAL_VAL

Book Values for Manual Valuation of Positions | #masterdata | Component: Transfer to Financial Accounting
Column Name Description
MANDT FK Client
KEY_DATE Key Date for Valuation
VALUATION_AREA FK Treasury Valuation Area
VALUATION_CLASS FK Valuation Class
COMPANY_CODE FK Company Code
SECURITY_ACCOUNT FK Securities Account
SECURITY_ID FK Security Class ID Number
PORTFOLIO FK Portfolio
ACCOUNT_GROUP FK Securities Account Group
LOANS_CONTRACT FK Contract Number
LOT_ID Identifier of the Lot
DEAL_NUMBER FK Financial Transaction
FUND Fund
GRANT_NBR Grant
SEMANTIC_KEY Hash Key
Column Name Description
💲 Position Currency (POSITION_CURR):
OBV_EC_CL New Book Value Exclusive of Costs - Clean - Position Crcy
OBV_EC_PC New Book Value Exclusive of Costs in Position Currency
💲 Valuation Currency (VALUATION_CURR):
OBV_EC_VC New Book Value Excluding Costs in Valuation Currency
Column Name Description
Column Name Description
KEY_DATE Key Date for Valuation
Column Name Description
Column Name Description Domain name
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • TLVT_MANUAL_VAL.MANDT == T001.MANDT
  • TLVT_MANUAL_VAL.COMPANY_CODE == T001.BUKRS
Cost Center
  • ?
  • Cost Center
  • ?
  • TLVT_MANUAL_VAL.MANDT == CSKS.MANDT
  • TLVT_MANUAL_VAL.[column in domain "DATBI"] == CSKS.DATBI
  • TLVT_MANUAL_VAL.COST_CENTER == CSKS.KOSTL
  • TLVT_MANUAL_VAL.[column in domain "KOKRS"] == CSKS.KOKRS
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • TLVT_MANUAL_VAL.COMPANY_CODE == VTBFHA.BUKRS
  • TLVT_MANUAL_VAL.MANDT == VTBFHA.MANDT
  • TLVT_MANUAL_VAL.DEAL_NUMBER == VTBFHA.RFHA
Functional Area
  • TLVT_MANUAL_VAL.MANDT == TFKB.MANDT
  • TLVT_MANUAL_VAL.FUNCTIONAL_AREA == TFKB.FKBER
Contract Number
  • ?
  • Client
  • Company Code
  • Contract Number
  • TLVT_MANUAL_VAL.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • TLVT_MANUAL_VAL.MANDT == VDARL.MANDT
  • TLVT_MANUAL_VAL.COMPANY_CODE == VDARL.BUKRS
  • TLVT_MANUAL_VAL.LOANS_CONTRACT == VDARL.RANL
Client TLVT_MANUAL_VAL.MANDT == T000.MANDT
Portfolio
  • Company Code
  • Portfolio
  • Client
  • TLVT_MANUAL_VAL.COMPANY_CODE == TWPOB.BUKRS
  • TLVT_MANUAL_VAL.PORTFOLIO == TWPOB.RPORTB
  • TLVT_MANUAL_VAL.MANDT == TWPOB.MANDT
Position Currency
  • TLVT_MANUAL_VAL.MANDT == TCURC.MANDT
  • TLVT_MANUAL_VAL.POSITION_CURR == TCURC.WAERS
Profit Center
  • ?
  • ?
  • Profit Center
  • TLVT_MANUAL_VAL.MANDT == CEPC.MANDT
  • TLVT_MANUAL_VAL.[column in domain "DATBI"] == CEPC.DATBI
  • TLVT_MANUAL_VAL.[column in domain "KOKRS"] == CEPC.KOKRS
  • TLVT_MANUAL_VAL.PROFIT_CENTER == CEPC.PRCTR
Securities Account
  • Securities Account
  • Company Code
  • TLVT_MANUAL_VAL.MANDT == TWD01.MANDT
  • TLVT_MANUAL_VAL.SECURITY_ACCOUNT == TWD01.RLDEPO
  • TLVT_MANUAL_VAL.COMPANY_CODE == TWD01.BUKRS
Security Class ID Number
  • TLVT_MANUAL_VAL.MANDT == VWPANLA.MANDT
  • TLVT_MANUAL_VAL.SECURITY_ID == VWPANLA.RANL
Valuation Class
  • Treasury Valuation Area
  • Valuation Class
Valuation Currency
  • TLVT_MANUAL_VAL.MANDT == TCURC.MANDT
  • TLVT_MANUAL_VAL.VALUATION_CURR == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client
Treasury Valuation Area