IDCFM_FRIM_DATA

Impairment Main Data | #transactional | Component: Localization for Treasury
Column Name Description
MANDT FK Client
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 Contract Number
KEY_DATE Key Date for Valuation
PRICE_TYPE FK Rate/Price Type - Treasury Instruments
OKUART FK Price/NPV Type for OTC Transactions
LOT_ID Identifier of the Lot
FUND Fund
GRANT_NBR Grant
RUN_KEY Technical Key for a Background Run
Column Name Description
💲 Transaction Currency (PV_CURR):
PRESENT_VALUE NPV in Transaction Currency for Special Valuation
💲 Valuation Currency (PV_VAL_CURR):
PV_VAL_AMT NPV in Valuation Currency for Special Valuation
💲 Position Currency (Currency of Position Amount) (PC_CURRENCY):
NOMINAL_AMT_PC Nominal Amount in Position Currency
AQU_VAL_PC Acquisition Value in Position Currency
MARKET_PC Market Value in Position Currency
MARKET_PC_MEAN Mean Market Value (only SEC) in Postion Currency
💲 Valuation Currency (VC_CURRENCY):
AQU_VAL_VC Acquisition Value in Valuation Currency
MARKET_VC Market Value (SE Only) in Valuation Currency
MARKET_VC_MEAN Average Market Value in Valuation Currency (Securities Only)
AMAQU_VAL_PC Amortized Acquisition Value in Position Currency
AMAQU_VAL_LC Amortized Acquisition Value in Local Currency
AMAQU_VAL_VC Amortized Acquisition Value in Valuation Currency
AMAQU_VAL_DC Amortized Acquisition Value in Display Currency (From PC)
BOOK_VAL_PC Book Value in Position Currency
BOOK_VAL_LC Book Value in Local Currency
BOOK_VAL_VC Book Value in Valuation Currency
BOOK_VAL_DC Book Value in Display Currency (From Position Currency)
IMPMNT_PC Impairment in Position Currency
IMPMNT_LC Impairment in Local Currency
IMPMNT_VC Impairment in Valuation Currency
IMPMNT_DC Impairment in Display Currency
IMPMNT_FX_LC FX Impairment in Local Currency
IMPMNT_FX_VC FX Impairment in Valuation Currency
PORTF_DIST_PC Portfolio Distribution in Position Currency
PORTF_DIST_VC Portfolio Distribution in Valuation Currency
MARKET_VAL_PC Market Value in Position Currency
MARKET_VAL_LC Market Value in Local Currency
MARKET_VAL_VC Market Value in Valuation Currency
MARKET_VAL_DC Market Value in Display Currency
EXPERT_VAL_PC Expert Value in Position Currency
EXPERT_VAL_LC Expert Value in Local Currency
EXPERT_VAL_VC Expert Value in Valuation Currency
EXPERT_VAL_DC Expert Value in Display Currency
EXPECTED_VAL_PC Expected Value in Position Currency
EXPECTED_VAL_LC Expected Value in Local Currency
EXPECTED_VAL_VC Expected Value in Valuation Currency
EXPECTED_VAL_DC Expected Value in Display Currency
Column Name Description
Column Name Description
KEY_DATE Key Date for Valuation
RUN_DATE Date of Impairment Run
PERIOD_BEGIN Date for Period Start of Selection Report Impairment
PERIOD_END Date for Period End of Selection Report Impairment
RATE_KEY_DATE Rate/Price Date
MAX_RATE_DATE Rate Date: Maximum Rate
MIN_RATE_DATE Rate Date: Minimum Rate
TRLDATE_INIT Creation Date of the Operative Business Transaction
Column Name Description
SP_VAL_SEC_CAT Special Valuation Category Show values
KEY_DATE_REF Key Date Reference for Parallel Books Show values
KEY_DATE_FLAG Flag Selection Criteria 1: Compare on Key Date Show values
KEY_DATE_FLAGM Flag Selection Criteria 2: Compare Average Val.and Key Date Show values
PERIOD_FLAG Indicator Selection Criteria 3: Comparison for Period Show values
EXPORT Flag for Exporting Positions for Impairment Show values
DATA_STATUS Status of Impairment Item Show values
Column Name Description Domain name
RUN_ID Unique ID of Impairment Run on Date Specified IDCFM_FRIM_RUN_ID
PFUND Partner Fund BP_GEBER
SECURITY_PRICE Price of Unit- or Percentage-Quoted Security VVPKTKUR
UNITS Number of units TPM_UNITS
AQU_VAL_PC_RP Acquisition Price for Percentage-Quoted Securities in % VVPKTKUR
AQU_VAL_PC_RU Acquisition Price f. Unit-Quoted Securities in Position Crcy VVPKTKUR
AQU_VAL_VC_RU Acquisition Price for Unit-Quoted SEC in Valuation Currency VVPKTKUR
RATE_MATURITY Maximum Age of a Market Price for Impairment
MARKET_PC_RP Market Price / % (Percentage-Quoted Securities) VVPKTKUR
MARKET_PC_RU Market Price/Unit in Position Crcy (Unit-Quoted Securities) VVPKTKUR
MARKET_VC_RU Market Price / Unit in Valuation Currency VVPKTKUR
MARKET_PC_MEANP Mean Market Price / % (for Percentage-Quoted SEC) VVPKTKUR
MARKET_PC_MEANU Mean Market Price/Unit in Postion Currency (Unit-Quoted SEC) VVPKTKUR
KEY_DATE_FLAGTXT Flag Selection Criteria 1: Compare on Key Date FTI_CHAR16LOW
KEY_DATE_BARRIER Selection Criteria 1: Limit in % (Impairment)
KEY_DATE_RESULT Selection Criteria 1: Relation in %
KEY_DATE_FLAGMTX Flag Selection Criteria 2: Compare Average Val.and Key Date FTI_CHAR16LOW
KEY_DATE_BARR_M Selection Criteria 2: Limit Averaged in % (Impairment)
KEY_DATE_RESU_M Selection Criteria 2: Relation Averaged Market Value in %
PERIOD_FLAG_TEXT Indicator Selection Criteria 3: Comparison for Period FTI_CHAR16LOW
PERIOD_BARRIER Selection Criteria 3: Limit Maximum in % (Impairment)
PERIOD_RESULT Selection Criteria 3: Relation Maximum in %
WARN Result for Selection Report Impairment CHAR1
XALKZ Short Name XKBEZ
VVRANLWX Secondary index class data CHAR20
MAX_RATE Maximum Rate of Unit/Percentage-Quoted Security VVPKTKUR
MIN_RATE Minimum Rate of Unit/Percentage-Quoted Security VVPKTKUR
MARKET_VC_MEANU Average Market Price/Unit in VC (Unit-Quoted Securities) VVPKTKUR
BUSTRANSCAT_INIT Generating Business Transaction Category TPM_BUSTRANSCAT
BUSTRANSCAT_INTT Name of Business Transaction Category TPM_DESCRIPTION
POS_MAN_PROC Position Management Procedure TPM_POS_MAN_PROC
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • IDCFM_FRIM_DATA.MANDT == T001.MANDT
  • IDCFM_FRIM_DATA.COMPANY_CODE == T001.BUKRS
Rate Type for Translation from Quotation Currency to PC
  • IDCFM_FRIM_DATA.MANDT == TCURV.MANDT
  • IDCFM_FRIM_DATA.EXCHANGE_NC_PC == TCURV.KURST
Rate Type Translation from Position Crcy to Valtn Crcy
  • IDCFM_FRIM_DATA.MANDT == TCURV.MANDT
  • IDCFM_FRIM_DATA.EXCHANGE_PC_VC == TCURV.KURST
Product Type
  • Product Type
  • Client
  • IDCFM_FRIM_DATA.GSART == TZPA.GSART
  • IDCFM_FRIM_DATA.MANDT == TZPA.MANDT
Client IDCFM_FRIM_DATA.MANDT == T000.MANDT
Price/NPV Type for OTC Transactions
  • IDCFM_FRIM_DATA.MANDT == ATVOK.MANDT
  • IDCFM_FRIM_DATA.NPV_INDICATOR == ATVOK.OKUART
Price/NPV Type for OTC Transactions
  • IDCFM_FRIM_DATA.MANDT == ATVOK.MANDT
  • IDCFM_FRIM_DATA.OKUART == ATVOK.OKUART
Position Currency (Currency of Position Amount)
  • IDCFM_FRIM_DATA.MANDT == TCURC.MANDT
  • IDCFM_FRIM_DATA.PC_CURRENCY == TCURC.WAERS
Portfolio
  • Company Code
  • Portfolio
  • Client
  • IDCFM_FRIM_DATA.COMPANY_CODE == TWPOB.BUKRS
  • IDCFM_FRIM_DATA.PORTFOLIO == TWPOB.RPORTB
  • IDCFM_FRIM_DATA.MANDT == TWPOB.MANDT
Quotation currency (which prices are in)
  • IDCFM_FRIM_DATA.MANDT == TCURC.MANDT
  • IDCFM_FRIM_DATA.PRICE_CURR == TCURC.WAERS
Rate/Price Type - Treasury Instruments
  • IDCFM_FRIM_DATA.MANDT == TW56.MANDT
  • IDCFM_FRIM_DATA.PRICE_TYPE == TW56.SKURSART
Price Type for Securities (Optional Entry)
  • IDCFM_FRIM_DATA.MANDT == TW56.MANDT
  • IDCFM_FRIM_DATA.RATE_INDICATOR == TW56.SKURSART
Securities Account
  • Securities Account
  • Company Code
  • IDCFM_FRIM_DATA.MANDT == TWD01.MANDT
  • IDCFM_FRIM_DATA.SECURITY_ACCOUNT == TWD01.RLDEPO
  • IDCFM_FRIM_DATA.COMPANY_CODE == TWD01.BUKRS
Security Class ID Number
  • IDCFM_FRIM_DATA.MANDT == VWPANLA.MANDT
  • IDCFM_FRIM_DATA.SECURITY_ID == VWPANLA.RANL
Valuation Class
  • Treasury Valuation Area
  • Valuation Class
Valuation Currency
  • IDCFM_FRIM_DATA.MANDT == TCURC.MANDT
  • IDCFM_FRIM_DATA.VC_CURRENCY == TCURC.WAERS
No. of the Secondary Index Description for Class Data
  • No. of the Secondary Index Description for Class Data
  • Client
  • IDCFM_FRIM_DATA.VVRANLWI == TWX1.VVRANLWI
  • IDCFM_FRIM_DATA.MANDT == TWX1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client
Exchange
  • Exchange
  • Client
  • IDCFM_FRIM_DATA.MARKET_PLACE == TWH01.RHANDPL
  • IDCFM_FRIM_DATA.MANDT == TWH01.MANDT
Treasury Valuation Area