FTI_S_REP_CHECK_IMPAIRMENT SAP (Data Structure for Selection Report for Impairment) Structure details
Description: Data Structure for Selection Report for Impairment
Related tables to FTI_S_REP_CHECK_IMPAIRMENT
Access table FTI_S_REP_CHECK_IMPAIRMENT
Structure field list including key, data, relationships and ABAP select examples
FTI_S_REP_CHECK_IMPAIRMENT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data Structure for Selection Report for Impairment" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FTI_S_REP_CHECK_IMPAIRMENT TYPE FTI_S_REP_CHECK_IMPAIRMENT.
The FTI_S_REP_CHECK_IMPAIRMENT table consists of various fields, each holding specific information or linking keys about Data Structure for Selection Report for Impairment data available in SAP. These include BUKRS (Company Code), VALUATION_AREA (Valuation Area), VALUATION_CLASS (Valuation Class), GSART (Product Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FTI_S_REP_CHECK_IMPAIRMENT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
PERIOD_BEGIN | Date for Period Start of Selection Report Impairment | FTI_IMPAIR_PERIOD_BEGIN | DATS | 8 | DATUM | ||||
PERIOD_END | Date for Period End of Selection Report Impairment | FTI_IMPAIR_PERIOD_END | DATS | 8 | DATUM | ||||
KEY_DATE_REF | Key Date Reference for Parallel Books | FTI_RSTICH_PB | CHAR | 1 | RSTICH_PB | ||||
PC_CURRENCY | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
VC_CURRENCY | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | TCURC | WAERS | |||
EXCHANGE_PC_VC | Rate Type Translation from Position Crcy to Valtn Crcy | FTI_IMPAIR_KURST_BEWW | CHAR | 4 | TCURV | KURST | |||
UNITS | Number of units | FTI_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT_PC | Nominal Amount in Position Currency | FTI_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_VC | Acquisition Value in Valuation Currency | FTI_AQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC_RATE_PERCENT | Acquisition Price for Percentage-Quoted Securities in % | FTI_ANKUPR | DEC | 15(6) | VVPKTKUR | ||||
AQU_VAL_PC_RATE_UNITS | Acquisition Price f. Unit-Quoted Securities in Position Crcy | FTI_ANKSBW | DEC | 15(6) | VVPKTKUR | ||||
AQU_VAL_VC_RATE_UNITS | Acquisition Price for Unit-Quoted SEC in Valuation Currency | FTI_IMPAIR_AQU_VC_RATE_UNITS | DEC | 15(6) | VVPKTKUR | ||||
RATE_MATURITY | Maximum Age of a Market Price for Impairment | FTI_IMPAIR_RATE_MATURITY | DEC | 3 | |||||
RATE_INDICATOR | Price Type for Securities (Optional Entry) | FTI_KURSART | CHAR | 2 | TW56 | VVSKURSART | H_KURSART | ||
EXCHANGE_NC_PC | Rate Type for Translation from Quotation Currency to PC | FTI_IMPAIR_KURST_CURR | CHAR | 4 | TCURV | KURST | H_KURST | ||
RATE_KEY_DATE | Rate/Price Date | DKURS | DATS | 8 | DATUM | ||||
MARKET_PLACE | Exchange | VVRHANDPL | CHAR | 10 | TWH01 | VVRHANDPL | WHP | ||
NPV_INDICATOR | Price/NPV Type for OTC Transactions | TV_OKUART | CHAR | 3 | ATVOK | T_OKUART | |||
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_VC | Market Value (SE Only) in Valuation Currency | FTI_IMPAIR_MARKET_VC | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_PC_RATE_PERCENT | Market Price / % (Percentage-Quoted Securities) | FTI_KURSPR | DEC | 15(6) | VVPKTKUR | ||||
MARKET_PC_RATE_UNITS | Market Price/Unit in Position Crcy (Unit-Quoted Securities) | FTI_KURSBW | DEC | 15(6) | VVPKTKUR | ||||
MARKET_VC_RATE_UNITS | Market Price / Unit in Valuation Currency | FTI_IMPAIR_MARKET_VC_RATE_UNIT | DEC | 15(6) | VVPKTKUR | ||||
MARKET_PC_MEAN | Mean Market Value (only SEC) in Postion Currency | FTI_IMPAIR_MARKET_PC_MEAN | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_PC_MEAN_PERCENT | Mean Market Price / % (for Percentage-Quoted SEC) | FTI_IMPAIR_KURSPR_MEAN | DEC | 15(6) | VVPKTKUR | ||||
MARKET_PC_MEAN_UNITS | Mean Market Price/Unit in Postion Currency (Unit-Quoted SEC) | FTI_IMPAIR_KURSBW_MEAN | DEC | 15(6) | VVPKTKUR | ||||
KEY_DATE_FLAG | Flag Selection Criteria 1: Compare on Key Date | FTI_IMPAIR_KEY_DATE_FLAG | CHAR | 1 | XFELD | ||||
KEY_DATE_FLAG_TEXT | Flag Selection Criteria 1: Compare on Key Date | FTI_IMPAIR_KEY_DATE_FLAG_TEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
KEY_DATE_BARRIER | Selection Criteria 1: Limit in % (Impairment) | FTI_IMPAIR_BARRIER | DEC | 6(2) | |||||
KEY_DATE_RESULT | Selection Criteria 1: Relation in % | FTI_IMPAIR_BARRIER_RES | DEC | 6(2) | |||||
KEY_DATE_FLAG_M | Flag Selection Criteria 2: Compare Average Val.and Key Date | FTI_IMPAIR_KEY_DATE_FLAG_M | CHAR | 1 | XFELD | ||||
KEY_DATE_FLAG_M_TEXT | Flag Selection Criteria 2: Compare Average Val.and Key Date | FTI_IMPAIR_KEY_DATE_FLAG_M_TEX | CHAR | 16 | FTI_CHAR16LOW | ||||
KEY_DATE_BARRIER_M | Selection Criteria 2: Limit Averaged in % (Impairment) | FTI_IMPAIR_BARRIER_MEAN | DEC | 6(2) | |||||
KEY_DATE_RESULT_M | Selection Criteria 2: Relation Averaged Market Value in % | FTI_IMPAIR_BARRIER_RES_MEAN | DEC | 6(2) | |||||
PERIOD_FLAG | Indicator Selection Criteria 3: Comparison for Period | FTI_IMPAIR_PERIOD_FLAG | CHAR | 1 | XFELD | ||||
PERIOD_FLAG_TEXT | Indicator Selection Criteria 3: Comparison for Period | FTI_IMPAIR_PERIOD_FLAG_TEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
PERIOD_BARRIER | Selection Criteria 3: Limit Maximum in % (Impairment) | FTI_IMPAIR_BARRIER_MAX | DEC | 6(2) | |||||
PERIOD_RESULT | Selection Criteria 3: Relation Maximum in % | FTI_IMPAIR_BARRIER_RES_MAX | DEC | 6(2) | |||||
WARN | Result for Selection Report Impairment | FTI_IMPAIR_WARN | CHAR | 1 | CHAR1 | ||||
EXPORT | Flag for Exporting Positions for Impairment | FTI_IMPAIR_EXPORT | CHAR | 1 | XFELD | ||||
AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_VC | Amortized Acquisition Value in Valuation Currency | FTI_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_VC | Book Value in Valuation Currency | FTI_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_VC | Impairment in Valuation Currency | FTI_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_VC | FX Impairment in Valuation Currency | FTI_IMPMNT_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
VVRANLWI | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | Assigned to domain | VVRANLWI | |||
VVRANLWX | Secondary index class data | VVRANLWX | CHAR | 20 | CHAR20 | ||||
MAX_RATE | Maximum Rate of Unit/Percentage-Quoted Security | VVPKTKUR_MAX | DEC | 15(6) | VVPKTKUR | ||||
MAX_RATE_DATE | Rate Date: Maximum Rate | DKURS_MAX | DATS | 8 | DATUM | ||||
MIN_RATE | Minimum Rate of Unit/Percentage-Quoted Security | VVPKTKUR_MIN | DEC | 15(6) | VVPKTKUR | ||||
MIN_RATE_DATE | Rate Date: Minimum Rate | DKURS_MIN | DATS | 8 | DATUM | ||||
MARKET_VC_MEAN | Average Market Value in Valuation Currency (Securities Only) | FTI_IMPAIR_MARKET_VC_MEAN | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_VC_MEAN_UNITS | Average Market Price/Unit in VC (Unit-Quoted Securities) | FTI_MARKET_VC_RATE_UNIT_MEAN | DEC | 15(6) | VVPKTKUR | ||||
BUSTRANSCAT_INIT | Generating Business Transaction Category | FTI_GENERATING_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
TRLDATE_INIT | Creation Date of the Operative Business Transaction | TPM_BT_CREATE_DATE | DATS | 8 | DATUM | ||||
BUSTRANSCAT_INIT_T | Name of Business Transaction Category | TPM_BUSTRANSCAT_TEXT | CHAR | 60 | TPM_DESCRIPTION |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_S_REP_CHECK_IMPAIRMENT using ABAP code?
As FTI_S_REP_CHECK_IMPAIRMENT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTI_S_REP_CHECK_IMPAIRMENT as there is no data to select.How to access SAP table FTI_S_REP_CHECK_IMPAIRMENT
Within an ECC or HANA version of SAP you can also view further information about FTI_S_REP_CHECK_IMPAIRMENT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects