IDCFM_FRIM_DATA - Impairment Main Data
Impairment Main Data information is stored in SAP table IDCFM_FRIM_DATA.
It is part of development package ID-CFM-FR-IM in software component FI-LOC-TRM. This development package consists of objects that can be grouped under "Treasury Localization France: Impairment".
It is part of development package ID-CFM-FR-IM in software component FI-LOC-TRM. This development package consists of objects that can be grouped under "Treasury Localization France: Impairment".
Fields for table IDCFM_FRIM_DATA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
VALUATION_AREA | Treasury Valuation Area | X | TPM_VAL_AREA | CHAR | 6 | TRGC_VAL_AREA |
VALUATION_CLASS | Valuation Class | X | TPM_VAL_CLASS | NUMC | 8 | TRGC_VAL_CLASS |
COMPANY_CODE | Company Code | X | BUKRS | CHAR | 8 | T001 |
SECURITY_ACCOUNT | Securities Account | X | RLDEPO | CHAR | 20 | TWD01 |
SECURITY_ID | Security Class ID Number | X | VVRANLW | CHAR | 26 | VWPANLA |
PORTFOLIO | Portfolio | X | RPORTB | CHAR | 20 | TWPOB |
ACCOUNT_GROUP | Securities Account Group | X | TPM_SEC_ACCT_GRP | CHAR | 20 | TRGT_SECACCGRP |
LOANS_CONTRACT | Contract Number | X | RANL | CHAR | 26 | |
KEY_DATE | Key Date for Valuation | X | TPM_VAL_KEYDATE | DATS | 16 | |
PRICE_TYPE | Rate/Price Type - Treasury Instruments | X | TI_KURSART | CHAR | 4 | TW56 |
OKUART | Price/NPV Type for OTC Transactions | X | TV_OKUART | CHAR | 6 | ATVOK |
LOT_ID | Identifier of the Lot | X | TPM_LOT_ID | RAW | 16 | |
FUND | Fund | X | FM_FUND | CHAR | 20 | |
GRANT_NBR | Grant | X | GM_GRANT_NBR | CHAR | 40 | |
RUN_KEY | Technical Key for a Background Run | X | IDCFM_FRIM_RUN_KEY | CHAR | 2 | |
RUN_DATE | Date of Impairment Run | IDCFM_FRIM_RUN_DATE | DATS | 16 | ||
RUN_ID | Unique ID of Impairment Run on Date Specified | IDCFM_FRIM_RUN_ID | NUMC | 16 | ||
PFUND | Partner Fund | FM_PFUND | CHAR | 20 | ||
SP_VAL_SEC_CAT | Special Valuation Category | TPM_SP_VAL_SEC_CAT | CHAR | 2 | ||
PRICE_CURR | Quotation currency (which prices are in) | VVNOTWAERS | CUKY | 10 | TCURC | |
SECURITY_PRICE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 8 | ||
PRESENT_VALUE | NPV in Transaction Currency for Special Valuation | TPM_PRES_VAL_FOR_AMT | CURR | 8 | ||
PV_CURR | Transaction Currency | TPM_FOREIGN_CURR | CUKY | 10 | ||
PV_VAL_AMT | NPV in Valuation Currency for Special Valuation | TPM_PRES_VAL_VAL_AMT | CURR | 8 | ||
PV_VAL_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 10 | ||
.INCLUDE | IDCFM_FRIM_STR_DATA_NOKEYS | 0 | ||||
GSART | Product Type | VVSART | CHAR | 6 | TZPA | |
PERIOD_BEGIN | Date for Period Start of Selection Report Impairment | FTI_IMPAIR_PERIOD_BEGIN | DATS | 16 | ||
PERIOD_END | Date for Period End of Selection Report Impairment | FTI_IMPAIR_PERIOD_END | DATS | 16 | ||
KEY_DATE_REF | Key Date Reference for Parallel Books | FTI_RSTICH_PB | CHAR | 2 | ||
PC_CURRENCY | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 10 | TCURC | |
VC_CURRENCY | Valuation Currency | TPM_VALUATION_CURR | CUKY | 10 | TCURC | |
EXCHANGE_PC_VC | Rate Type Translation from Position Crcy to Valtn Crcy | FTI_IMPAIR_KURST_BEWW | CHAR | 8 | TCURV | |
UNITS | Number of units | FTI_UNITS | DEC | 12 | ||
NOMINAL_AMT_PC | Nominal Amount in Position Currency | FTI_NOMINAL_AMT_PC | CURR | 11 | ||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 11 | ||
AQU_VAL_VC | Acquisition Value in Valuation Currency | FTI_AQU_VAL_VC | CURR | 11 | ||
AQU_VAL_PC_RP | Acquisition Price for Percentage-Quoted Securities in % | FTI_ANKUPR | DEC | 8 | ||
AQU_VAL_PC_RU | Acquisition Price f. Unit-Quoted Securities in Position Crcy | FTI_ANKSBW | DEC | 8 | ||
AQU_VAL_VC_RU | Acquisition Price for Unit-Quoted SEC in Valuation Currency | FTI_IMPAIR_AQU_VC_RATE_UNITS | DEC | 8 | ||
RATE_MATURITY | Maximum Age of a Market Price for Impairment | FTI_IMPAIR_RATE_MATURITY | DEC | 2 | ||
RATE_INDICATOR | Price Type for Securities (Optional Entry) | FTI_KURSART | CHAR | 4 | TW56 | |
EXCHANGE_NC_PC | Rate Type for Translation from Quotation Currency to PC | FTI_IMPAIR_KURST_CURR | CHAR | 8 | TCURV | |
RATE_KEY_DATE | Rate/Price Date | DKURS | DATS | 16 | ||
MARKET_PLACE | Exchange | VVRHANDPL | CHAR | 20 | TWH01 | |
NPV_INDICATOR | Price/NPV Type for OTC Transactions | TV_OKUART | CHAR | 6 | ATVOK | |
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 11 | ||
MARKET_VC | Market Value (SE Only) in Valuation Currency | FTI_IMPAIR_MARKET_VC | CURR | 11 | ||
MARKET_PC_RP | Market Price / % (Percentage-Quoted Securities) | FTI_KURSPR | DEC | 8 | ||
MARKET_PC_RU | Market Price/Unit in Position Crcy (Unit-Quoted Securities) | FTI_KURSBW | DEC | 8 | ||
MARKET_VC_RU | Market Price / Unit in Valuation Currency | FTI_IMPAIR_MARKET_VC_RATE_UNIT | DEC | 8 | ||
MARKET_PC_MEAN | Mean Market Value (only SEC) in Postion Currency | FTI_IMPAIR_MARKET_PC_MEAN | CURR | 11 | ||
MARKET_PC_MEANP | Mean Market Price / % (for Percentage-Quoted SEC) | FTI_IMPAIR_KURSPR_MEAN | DEC | 8 | ||
MARKET_PC_MEANU | Mean Market Price/Unit in Postion Currency (Unit-Quoted SEC) | FTI_IMPAIR_KURSBW_MEAN | DEC | 8 | ||
KEY_DATE_FLAG | Flag Selection Criteria 1: Compare on Key Date | FTI_IMPAIR_KEY_DATE_FLAG | CHAR | 2 | ||
KEY_DATE_FLAGTXT | Flag Selection Criteria 1: Compare on Key Date | FTI_IMPAIR_KEY_DATE_FLAG_TEXT | CHAR | 32 | ||
KEY_DATE_BARRIER | Selection Criteria 1: Limit in % (Impairment) | FTI_IMPAIR_BARRIER | DEC | 4 | ||
KEY_DATE_RESULT | Selection Criteria 1: Relation in % | FTI_IMPAIR_BARRIER_RES | DEC | 4 | ||
KEY_DATE_FLAGM | Flag Selection Criteria 2: Compare Average Val.and Key Date | FTI_IMPAIR_KEY_DATE_FLAG_M | CHAR | 2 | ||
KEY_DATE_FLAGMTX | Flag Selection Criteria 2: Compare Average Val.and Key Date | FTI_IMPAIR_KEY_DATE_FLAG_M_TEX | CHAR | 32 | ||
KEY_DATE_BARR_M | Selection Criteria 2: Limit Averaged in % (Impairment) | FTI_IMPAIR_BARRIER_MEAN | DEC | 4 | ||
KEY_DATE_RESU_M | Selection Criteria 2: Relation Averaged Market Value in % | FTI_IMPAIR_BARRIER_RES_MEAN | DEC | 4 | ||
PERIOD_FLAG | Indicator Selection Criteria 3: Comparison for Period | FTI_IMPAIR_PERIOD_FLAG | CHAR | 2 | ||
PERIOD_FLAG_TEXT | Indicator Selection Criteria 3: Comparison for Period | FTI_IMPAIR_PERIOD_FLAG_TEXT | CHAR | 32 | ||
PERIOD_BARRIER | Selection Criteria 3: Limit Maximum in % (Impairment) | FTI_IMPAIR_BARRIER_MAX | DEC | 4 | ||
PERIOD_RESULT | Selection Criteria 3: Relation Maximum in % | FTI_IMPAIR_BARRIER_RES_MAX | DEC | 4 | ||
WARN | Result for Selection Report Impairment | FTI_IMPAIR_WARN | CHAR | 2 | ||
EXPORT | Flag for Exporting Positions for Impairment | FTI_IMPAIR_EXPORT | CHAR | 2 | ||
AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 11 | ||
AMAQU_VAL_LC | Amortized Acquisition Value in Local Currency | FTI_AMAQU_VAL_LC | CURR | 11 | ||
AMAQU_VAL_VC | Amortized Acquisition Value in Valuation Currency | FTI_AMAQU_VAL_VC | CURR | 11 | ||
AMAQU_VAL_DC | Amortized Acquisition Value in Display Currency (From PC) | FTI_AMAQU_VAL_DC | CURR | 11 | ||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 11 | ||
BOOK_VAL_LC | Book Value in Local Currency | FTI_BOOK_VAL_LC | CURR | 11 | ||
BOOK_VAL_VC | Book Value in Valuation Currency | FTI_BOOK_VAL_VC | CURR | 11 | ||
BOOK_VAL_DC | Book Value in Display Currency (From Position Currency) | FTI_BOOK_VAL_DC | CURR | 11 | ||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 11 | ||
IMPMNT_LC | Impairment in Local Currency | FTI_IMPMNT_LC | CURR | 11 | ||
IMPMNT_VC | Impairment in Valuation Currency | FTI_IMPMNT_VC | CURR | 11 | ||
IMPMNT_DC | Impairment in Display Currency | FTI_IMPMNT_DC | CURR | 11 | ||
IMPMNT_FX_LC | FX Impairment in Local Currency | FTI_IMPMNT_FX_LC | CURR | 11 | ||
IMPMNT_FX_VC | FX Impairment in Valuation Currency | FTI_IMPMNT_FX_VC | CURR | 11 | ||
XALKZ | Short Name | XALKZ | CHAR | 30 | ||
VVRANLWI | No. of the Secondary Index Description for Class Data | VVRANLWI | NUMC | 4 | TWX1 | |
VVRANLWX | Secondary index class data | VVRANLWX | CHAR | 40 | ||
MAX_RATE | Maximum Rate of Unit/Percentage-Quoted Security | VVPKTKUR_MAX | DEC | 8 | ||
MAX_RATE_DATE | Rate Date: Maximum Rate | DKURS_MAX | DATS | 16 | ||
MIN_RATE | Minimum Rate of Unit/Percentage-Quoted Security | VVPKTKUR_MIN | DEC | 8 | ||
MIN_RATE_DATE | Rate Date: Minimum Rate | DKURS_MIN | DATS | 16 | ||
MARKET_VC_MEAN | Average Market Value in Valuation Currency (Securities Only) | FTI_IMPAIR_MARKET_VC_MEAN | CURR | 11 | ||
MARKET_VC_MEANU | Average Market Price/Unit in VC (Unit-Quoted Securities) | FTI_MARKET_VC_RATE_UNIT_MEAN | DEC | 8 | ||
BUSTRANSCAT_INIT | Generating Business Transaction Category | FTI_GENERATING_BUSTRANSCAT | NUMC | 8 | * | |
TRLDATE_INIT | Creation Date of the Operative Business Transaction | TPM_BT_CREATE_DATE | DATS | 16 | ||
BUSTRANSCAT_INTT | Name of Business Transaction Category | TPM_BUSTRANSCAT_TEXT | CHAR | 120 | ||
.INCLUDE | IDCFM_FRIM_STR_IMPAIRMENT_VALS | 0 | ||||
PORTF_DIST_PC | Portfolio Distribution in Position Currency | IDCFM_FRIM_PORTFOLIO_DIST_PC | CURR | 11 | ||
PORTF_DIST_VC | Portfolio Distribution in Valuation Currency | IDCFM_FRIM_PORTFOLIO_DIST_VC | CURR | 11 | ||
MARKET_VAL_PC | Market Value in Position Currency | IDCFM_FRIM_MARKET_VAL_PC | CURR | 11 | ||
MARKET_VAL_LC | Market Value in Local Currency | IDCFM_FRIM_MARKET_VAL_LC | CURR | 11 | ||
MARKET_VAL_VC | Market Value in Valuation Currency | IDCFM_FRIM_MARKET_VAL_VC | CURR | 11 | ||
MARKET_VAL_DC | Market Value in Display Currency | IDCFM_FRIM_MARKET_VAL_DC | CURR | 11 | ||
EXPERT_VAL_PC | Expert Value in Position Currency | IDCFM_FRIM_EXPERT_VAL_PC | CURR | 11 | ||
EXPERT_VAL_LC | Expert Value in Local Currency | IDCFM_FRIM_EXPERT_VAL_LC | CURR | 11 | ||
EXPERT_VAL_VC | Expert Value in Valuation Currency | IDCFM_FRIM_EXPERT_VAL_VC | CURR | 11 | ||
EXPERT_VAL_DC | Expert Value in Display Currency | IDCFM_FRIM_EXPERT_VAL_DC | CURR | 11 | ||
EXPECTED_VAL_PC | Expected Value in Position Currency | IDCFM_FRIM_EXPECTED_VAL_PC | CURR | 11 | ||
EXPECTED_VAL_LC | Expected Value in Local Currency | IDCFM_FRIM_EXPECTED_VAL_LC | CURR | 11 | ||
EXPECTED_VAL_VC | Expected Value in Valuation Currency | IDCFM_FRIM_EXPECTED_VAL_VC | CURR | 11 | ||
EXPECTED_VAL_DC | Expected Value in Display Currency | IDCFM_FRIM_EXPECTED_VAL_DC | CURR | 11 | ||
DATA_STATUS | Status of Impairment Item | IDCFM_FRIM_DATA_STATUS | CHAR | 2 | ||
POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | CHAR | 8 | * |