VTVBARW_CFM_1 SAP (CFM Operative/Parallel: For a Given Date) Structure details
Description: CFM Operative/Parallel: For a Given Date
Related tables to VTVBARW_CFM_1
Access table VTVBARW_CFM_1
Structure field list including key, data, relationships and ABAP select examples
VTVBARW_CFM_1 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 "CFM Operative/Parallel: For a Given Date" 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_VTVBARW_CFM_1 TYPE VTVBARW_CFM_1.
The VTVBARW_CFM_1 table consists of various fields, each holding specific information or linking keys about CFM Operative/Parallel: For a Given Date data available in SAP. These include MANDT (Client), OS_GUID (Object Identity in Database Format), BUKRS (Company Code), LAND1 (Country key of company code).. 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 VTVBARW_CFM_1 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 | |||
OS_GUID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TPM_DB_OS_GUID | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
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 | |||
POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | CHAR | 4 | TRGC_PM_PROC | TPM_POS_MAN_PROC | |||
ACTIVE_PASSIVE | Assets/Liabilities Indicator | FTI_ASSLIAB_IND | CHAR | 1 | FTI_ASSLIAB_IND | ||||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | CHAR | 10 | TWPOB | RPORTB | |||
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
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 | |
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
EXTERNAL_ACCOUNT | External Account (Position) | TPM_EXT_ACCOUNT_POS | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | TPM_DIFF_CURR | ||
EXTACC_DEAL | External Account (Transaction) | TPM_EXT_ACCOUNT_DEAL | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_USER | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_BUSTRANSCAT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
LOTPOS_INIT_DATE | Position Acquisition Date of a Lot | FTI_LOTPOSITION_INIT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTPOS_ORG_DATE | Original Position Acquisition Date of a Lot | FTI_LOTPOSITION_ORG_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTGEN_BUKRS | Company Code of Lot-Generating Transaction | FTI_LOTGENERATION_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
LOTGEN_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 10 | ALPHA | TPM_HREL_NUMBER | |||
FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HITEM_NUMBER | Hedged Item Number | TPM_HITEM_NUMBER | CHAR | 10 | ALPHA | TPM_HITEM_NUMBER | |||
HINST_NUMBER | Hedging Instrument Number | TPM_HINST_NUMBER | CHAR | 10 | ALPHA | TPM_HINST_NUMBER | |||
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
STICHTAG | Key Date | FTI_STICHTAG | DATS | 8 | VVSTDAT | KEYDATE | |||
RANTYP_R | Contract type | FTI_RANTYP | CHAR | 1 | FTI_RANTYP | ||||
RREFKONT_R | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
ACC_ASS_REF | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | TRACC_AA_REF | TPM_AA_REF | TRAC_AA_REF | ||
HKONT | General ledger account | FTI_HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
RLZTG | Remaining Term in Days | FTI_RLZTG | NUMC | 5 | NUMC5 | ||||
RLZMO | Remaining Term in Months | FTI_RLZMO | NUMC | 4 | NUMC4 | ||||
RLZJA | Remaining Term in Years | FTI_RLZJA | NUMC | 3 | NUMC3 | ||||
UEBTG | Overdue Period in Days | FTI_UEBTG | NUMC | 5 | NUMC5 | ||||
UEBMO | Overdue Period in Months | FTI_UEBMO | NUMC | 3 | NUMC3 | ||||
UEBJA | Overdue Period in Years | FTI_UEBJA | NUMC | 2 | NUMC2 | ||||
PARTNR | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
TYPE | Business Partner Category | BP_TYPE_NEW | CHAR | 1 | BU_TYPE | ||||
ISTYPE | Industry System | BU_ISTYPE | CHAR | 4 | TB038 | BU_ISTYPE | |||
IND_SECTOR | Industry | BU_IND_SECTOR | CHAR | 10 | TB038A | BU_INDSECTOR | |||
CNTRY_COMP | Country of Registered Office of Business Partner | FTI_LANDBP | CHAR | 3 | T005 | LAND1 | |||
LEGAL_ENTY | Legal Form of Organization | BP_LEG_ETY_NEW | CHAR | 2 | TB019 | BU_LEGENTY | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG_NEW | CHAR | 2 | TB032 | BU_LEGAL_ORG | |||
NATION | Nationality | BP_CNTR_N | CHAR | 3 | T005 | LAND1 | |||
STATE | Citizenship | BP_CNTR_ST | CHAR | 3 | T005 | LAND1 | |||
GROUP_ID | Business Partner Grouping | BU_GRP_ID_NEW | CHAR | 4 | TB001 | BU_GROUP | BPP | ||
GROUP_D | Target Group | BP_GROUP_D | CHAR | 4 | TP13 | BP_GROUP_D | |||
STAFF_GRP | Employee Group | BP_STAFF_G | CHAR | 4 | TP05 | BP_STAFF_G | |||
COMP_RE | Organization Relationship | BP_COMP_RE | CHAR | 1 | BP_COMP_RE | ||||
GRADE | Valuation | FTI_BP_GRADE | CHAR | 10 | TPZ22 | BP_GRADE | |||
GRADE_METHOD | Valuation Procedure | FTI_BP_GRADE_METHOD | CHAR | 10 | TPZ21 | BP_GRADE_METHOD | |||
SOLVNCY | Credit Standing | BP_SOLVNCY | CHAR | 1 | BP_SOLVNCY | ||||
SOL_INF | Status of Credit Standing Information | BP_SOL_INF | CHAR | 1 | BP_SOL_INF | ||||
SOL_I_D | Date of Credit Standing Information | BP_SOL_I_D | DATS | 8 | DATUM | ||||
RATING | Rating | FTI_BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
SOL_INS | Institute providing credit standing information | FTI_BP_SOL_INS | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
FINPROJ | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
PORTFOLIO_TM | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
RDPBANK | Depository Bank | RDEPOTBANK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
SECACC_TYPE | Securities Account Type | TPM_SECACC_TYPE | CHAR | 3 | TRSC_SECACC_TYPE | TPM_SECACC_TYPE | |||
SECACC_CAT | Securities Account Category | TPM_SECACC_CAT | CHAR | 1 | TPM_SECACC_CAT | ||||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
ALWPKL | General Security Classification | ALWPKL | CHAR | 3 | TW22 | ALWPKL | |||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | TW20 | SAKTTYP | |||
SOL_INS_RANL | Institut Supplying Credit Rating Information for Secur. ID | FTI_SOL_INS_RANL | CHAR | 4 | TP07 | BP_SOL_INS | |||
RATING_RANL | Rating for Securities ID Number/OTC Transaction | BP_RATING_RANL | CHAR | 3 | TP06 | BP_RATING | |||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | TW01 | SWPKLASS | |||
SAKAR | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
SFOART | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | TW21 | SFOTY | |||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | TW02 | SARTBET | |||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
VVRANLWX | Secondary index class data | VVRANLWXS | CHAR | 20 | CHAR20S | ||||
RHANDPL | Exchange | FTI_RHANDPL_MW | CHAR | 10 | TWH01 | VVRHANDPL | WHP | ||
AAAAKTIE | Number of stocks issued | FTI_AAAKTIE | DEC | 12 | DEC12 | ||||
KBNEWE | Nominal Value per Stock (Independent of Currency) | VVBNEWE | DEC | 15(6) | VVKWKURS | ||||
KZAHLAKT | Pay-in/disbursement rate | FTI_PAYIN | DEC | 10(7) | DEC3_7 | ||||
INT_CAT | Interest Category | FTI_INTTYPE | CHAR | 1 | FTI_INTEREST_TYPE | ||||
PKOND | Interest rate | TV_PKOND | DEC | 10(7) | DECV3_7 | ||||
BKOND | Interest rate as amount | TB_BKOND | CURR | 13(2) | WERTV7 | ||||
PEFFZINS | Effective Interest Rate | FTI_EFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TRCOT_CTY_MASTER | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | |
UL_LOAN_ID | Underlying Loan Contract | FTR_UL_LOAN | CHAR | 13 | ALPHA | RANL | RAD | FTRH_UL_LOAN | |
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | TCURC | WAERS | |||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
CALC_CCY | Evaluation Currency | AFW_EVAL_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
WVERB1 | Nominal currency borrowing/sale/outgoing side/short | FTI_WHR_SHORT | CUKY | 5 | TCURC | WAERS | |||
WFORD1 | Nominal currency investment/purchase incoming side/long | FTI_WHR_LONG | CUKY | 5 | TCURC | WAERS | |||
SWHRKOND | Interest Currency | TB_WHRKOND | CUKY | 5 | TCURC | WAERS | |||
CTY_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UNITS | Number of units | FTI_UNITS | DEC | 22(6) | TPM_UNITS | ||||
UNITS_LOCKED | Number of Blocked Units | FTI_UNITS_LOCKED | DEC | 22(6) | TPM_UNITS | ||||
CTY_QUANTITY | Commodity Quantity to Be Delivered | FTI_CTY_QUAN_DELVRD | QUAN | 25(5) | FTI_CTY_QUAN | ||||
NOMINAL_AMT_PC | Nominal Amount in Position Currency | FTI_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_AMT_LO_PC | Locked Nominal Amount in Position Currency | FTI_NOMINAL_AMT_LO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT_PC | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_AMT_OUT_PC | Nominal Value, Outgoing Side, in Position Crcy (Outg. Side) | FTI_NOMINAL_OUT_PCOUT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_AMT_IN_PC | Nominal Value, Incoming Side, in Position Crcy (Inc. Side) | FTI_NOMINAL_IN_PCIN | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_LC | Purchase Value in Local Currency | FTI_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_LC | Acquisition Value in Local Currency | FTI_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_LC | Book Value in Local Currency | FTI_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_PC | Costs in position currency | FTI_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_LC | Costs in Local Currency | FTI_CHARGE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_PC | Book Value Excluding Costs in Position Currency | FTI_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_LC | Book Value Excluding Costs in Local Currency | FTI_BOOK_VAL_EX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_LC | Security Valuation in Local Currency | FTI_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_LC | Foreign Currency Valuation in Local Currency | FTI_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_AMAQU_VAL_LC | FX Valuation of Amort. Acquisition Value in Local Currency | FTI_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_LC | Valuation of Cap. Costs, Security, in Local Currency | FTI_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Currency | FTI_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_PC | Amortization in Position Currency | FTI_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_LC | Amortization in Local Currency | FTI_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_LC | Impairment in Local Currency | FTI_IMPMNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_LC | FX Impairment in Local Currency | FTI_IMPMNT_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_PC | Cumulative Repayment in Position Currency | TPM_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_LC | Cumulative Repayment in Local Currency | TPM_REPAYMENT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_LC | Amortized Acquisition Value in Local Currency | FTI_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_PC | Cleared PD Deferral/Tax Compensation in Position Currency | FTI_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_LC | Cleared PD Deferral/Tax Compensation in Local Currency | FTI_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in Local Currency | FTI_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_NPL_LC | Foreign Currency Valuation, Not Affecting P/L, in Local Crcy | FTI_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy | FTI_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Local Crcy | FTI_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_NPL_LC | Valuation of Cap. Costs, FX, Not Aff. P/L in Local Currency | FTI_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_PC | Variation Margin in Position Currency | FTI_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_LC | Variation Margin in Local Currency | FTI_VARMAR_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALP_LC | Spot Valuation of Purchase Currency in Local Currency | FTI_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALS_LC | Spot Valuation of Sale Currency in Local Currency | FTI_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Currency | FTI_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_LC | Swap or Margin Accrual/Deferral in Local Currency | FTI_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPVAL_LC | Swap Valuation in Local Currency | FTI_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_PC | Consolidated Security Gains in Position Currency | FTI_CONS_GAINS_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_LC | Consolidated Security Gains in Local Currency | FTI_CONS_GAINS_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_PC | Consolidated Security Losses in Position Currency | FTI_CONS_LOSSES_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_LC | Consolidated Security Losses in Local Currency | FTI_CONS_LOSSES_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_FX_LC | Consolidated FX Gains in Local Currency | FTI_CONS_GAINS_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_FX_LC | Consolidated FX Losses in Local Currency | FTI_CONS_LOSSES_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_LC | Value Adjustment of Gains in Local Currency | FTI_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_PC | Value Adjustment of Gains in Position Currency | FTI_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_LC | Value Adjustment of Losses in Local Currency | FTI_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_PC | Value Adjustment of Losses in Position Currency | FTI_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_LC | Original Value Adjustment in Local Currency | FTI_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_PC | Original Value Adjustment in Position Currency | FTI_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_LC | Hedge Adjustment in Local Currency | FTI_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_LC | Effective Amount in Local Currency | FTI_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_PC | Effective Amount in Position Currency | FTI_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_LC | Effective Dormant Amount in Local Currency | FTI_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
EFFECTIVE_DORMANT_PC | Effective Amount (Dormant) in Position Currency | FTI_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_LC | Ineffective Amount in Local Currency | FTI_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_PC | Ineffective Amount in Position Currency | FTI_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_LC | Ineffective Dormant Amount in Local Currency | FTI_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
INEFFECTIVE_DORMANT_PC | Ineffective Amount (Dormant) in Position Currency | FTI_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
KAKUPR | Purchase Price for Percentage-Quoted Securities in % | FTI_KAKUPR | DEC | 15(6) | VVPKTKUR | ||||
KAKSBW | Purchase Price for Unit-Quoted Securities in Position Crcy | FTI_KAKSBW | DEC | 15(6) | VVPKTKUR | ||||
ANKUPR | Acquisition Price for Percentage-Quoted Securities in % | FTI_ANKUPR | DEC | 15(6) | VVPKTKUR | ||||
ANKSBW | Acquisition Price f. Unit-Quoted Securities in Position Crcy | FTI_ANKSBW | DEC | 15(6) | VVPKTKUR | ||||
BUKUPR | Book Price for Percentage-Quoted Securities in % | FTI_BUKUPR | DEC | 15(6) | VVPKTKUR | ||||
BUKSBW | Book Price for Unit-Quoted Securities in Position Currency | FTI_BUKSBW | DEC | 15(6) | VVPKTKUR | ||||
KURSPR | Market Price / % (Percentage-Quoted Securities) | FTI_KURSPR | DEC | 15(6) | VVPKTKUR | ||||
KURSBW | Market Price/Unit in Position Crcy (Unit-Quoted Securities) | FTI_KURSBW | DEC | 15(6) | VVPKTKUR | ||||
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_DATE | Rate Date | FTI_MARKET_DATE | DATS | 8 | DATUM | ||||
ACC_INTEREST_PC | Accrued Interest in Position Currency | FTI_ACC_INTEREST_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_PC | Accrued Deferred Interest in Position Currency | FTI_ACC_DEF_INT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ACC_DEF_INT_LC | Accrued Deferred Interest in Local Currency | FTI_ACC_DEF_INT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_CC | RM NPV in Evaluation Currency | TV_NPV_CC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_PC | RM NPV of Incoming Side in Currency of Incoming Side | TV_NPV_LONG_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_PC | RM NPV of Outgoing Side in Currency of Outgoing Side | TV_NPV_SHORT_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_CC | RM NPV of Incoming Side in Evaluation Currency | TV_NPV_LONG_CC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_CC | RM NPV of Outgoing Side in Evaluation Currency | TV_NPV_SHORT_CC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
CLEAN_PRICE_CC | Clean Price in Valuation Currency | FTI_CLEAN_PRICE_CC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_CC | Basis Point Value in Evaluation Currency | TV_VALBP | CURR | 17(2) | T_PRESVAL | ||||
YTM | Yield to Maturity | TV_YTM | DEC | 12(5) | DEC7_5SIGN | ||||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
MOD_DURATION | Modified Duration | TV_MOD_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
FW_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
CONVEXITY | Convexity with 5 Decimal Places | TV_CONVEXITY_MORE_ACCURATE | DEC | 11(5) | DEC6_5SIGN | ||||
DELTA | Delta, 1st derivation of premium based on underlying rate | TV_DELTA | DEC | 15(10) | T_SENSI | ||||
GAMMA | Gamma, 2nd derivation of premium based on underlying rate | TV_GAMMA | DEC | 14(8) | T_GAMMA | ||||
THETA | Theta, 1st derivation of premium according to time | TV_THETA | DEC | 15(10) | T_SENSI | ||||
VEGA | Vega, 1st Volatility Derivative | TV_VEGA | DEC | 15(10) | T_SENSI | ||||
S_VAL_TI_PC | Security Valuation in Position Currency (Simulation) | FTI_S_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_LC | Security Valuation in Local Currency (Simulation) | FTI_S_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_LC | Foreign Currency Valuation in Local Currency (Simulation) | FTI_S_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_AMAQU_VAL_LC | FX Valuation of Amort. Acquisition Val. in LC (Simulation) | FTI_S_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_PC | Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) | FTI_S_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_LC | Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.) | FTI_S_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Crcy (Simul.) | FTI_S_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_PC | Amortization in Position Currency (Simulation) | FTI_S_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_AMORT_LC | Amortization in Local Currency (Simulation) | FTI_S_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_PC | Cleared PD Def./Tax Compensation in Pos. Crcy: Simulation | FTI_S_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_DISAGIO_LC | Cleared PD Def./Tax Compensation in Local Crcy: Simulation | FTI_S_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in PC (Simulation) | FTI_S_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in LC (Simulation) | FTI_S_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_FX_NPL_LC | Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation) | FTI_S_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) | FTI_S_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_TI_NPL_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) | FTI_S_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAL_CH_FX_NPL_LC | Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) | FTI_S_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALP_LC | Spot Valuation, Purchase Currency, in Local Crcy: Simulation | FTI_S_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SPOTVALS_LC | Spot Valuation, Sale Currency, in Local Crcy: Simulation | FTI_S_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Crcy (Simulation) | FTI_S_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPACC_LC | Swap/Margin Accrual/Deferral in Local Currency: Simulation | FTI_S_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_SWAPVAL_LC | Swap Valuation in Local Currency: Simulation | FTI_S_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VALID_DATE | Date of Found Rate or Present Value | TPM_VALID_DATE | DATS | 8 | DATS | ||||
S_VALID_RATE_DATE | Date of Exchange Rate Found | TPM_VALID_RATE_DATE | DATS | 8 | DATS | ||||
S_MAP | Valuation Price | FTI_LDB_MAP | DEC | 15(6) | VVPKTKUR | ||||
S_MAV | Current Value for Valuation (Market Value, NPV) | FTI_LDB_MAV | CURR | 21(2) | TPM_AMOUNT | ||||
S_MAR_FE | Exchange Rate - Position/Valuation Currency on Market | FTI_LDB_MAR_FE | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_P | Spot Rate Purchase Currency/Valuation Currency in the Market | FTI_LDB_SPOT_RATE_P | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_S | Spot Rate Sales Currency/Valuation Currency in the Market | FTI_LDB_SPOT_RATE_S | DEC | 9(5) | EXCRT | UKURS | |||
S_SWAP_RATE_P | Swap Rate Purchase Currency/Valuation Currency in the Market | FTI_LDB_SWAP_RATE_P | DEC | 9(5) | TB_DEVSWSA | ||||
S_SWAP_RATE_S | Swap Rate Sales Currency/Valuation Currency in the Market | FTI_LDB_SWAP_RATE_S | DEC | 9(5) | TB_DEVSWSA | ||||
S_VAD_GAIN_LC | Simulated Value Adjustment of Gains in Local Currency | FTI_S_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_GAIN_PC | Simulated Value Adjustment of Gains in Position Currency | FTI_S_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_LOSS_LC | Simulated Value Adjustment of Losses in Local Currency | FTI_S_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_VAD_LOSS_PC | Simulated Value Adjustment of Losses in Position Currency | FTI_S_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_ORIG_VAD_LC | Simulated Original Value Adjustment in Local Currency | FTI_S_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_ORIG_VAD_PC | Simulated Original Value Adjustment in Position Currency | FTI_S_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_HADJ_LC | Simulated Hedge Adjustment in Local Currency | FTI_S_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_HADJ_PC | Simulated Hedge Adjustment in Position Currency | FTI_S_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_LC | Simulated Effective Amount in Local Currency | FTI_S_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_PC | Simulated Effective Amount in Position Currency | FTI_S_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_DORMANT_LC | Simulated: Effective Dormant Amount in Local Currency | FTI_S_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_EFFECTIVE_DORMANT_PC | Simulated Effective Dormant Amount in Position Currency | FTI_S_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_LC | Simulated Ineffective Amount in Local Currency | FTI_S_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_PC | Simulated Ineffective Amount in Position Currency | FTI_S_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_DORMANT_LC | Simulated Ineffective Dormant Amount in Local Currency | FTI_S_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
S_INEFFECTIVE_DORMANT_PC | Simulated Ineffective Dormant Amount in Position Currency | FTI_S_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ZERO_POSITION | Zero Position on Key Date | FTI_ZERO_POSITION | DEC | 1 | FTI_ZERO_POSITION | ||||
MPKOND | Interest rate (characteristic in drill-down reporting) | MPKOND | NUMC | 3 | ALPHA | FTI_NUMC3 | |||
RLZTG_K | Remaining Term in Days (Key Figure) | FTI_RLZTGK | DEC | 7 | DEC7 | ||||
UEBTG_K | Overdue Period in Days (Key Figure) | FTI_UEBTGK | DEC | 7 | DEC7 | ||||
RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
RSTICH_PB | Key Date Reference for Parallel Books | FTI_RSTICH_PB | CHAR | 1 | RSTICH_PB | ||||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | T242Q | CFNUMBR | NBR | ||
NUMBR_LC | Translation Type for Currency Translation into Local Crcy | FTI_NUMBR_LC | NUMC | 3 | T242Q | CFNUMBR | NBR_LC | ||
KURSA | Price type for evaluations | VVKURSAUSW | CHAR | 2 | TW56 | VVSKURSART | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
VVRANLWI | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | TWX1 | VVRANLWI | |||
CASHF | Indicator for cash flow calculation up to end of term | SCASHFLOW | CHAR | 1 | XFELD | ||||
BILST | Reference Date | FTI_BILST | DATS | 8 | DATUM | ||||
BILST2 | Reference Date | FTI_BILST2 | DATS | 8 | DATUM | ||||
BILST_REF_B | Positions: Remaining Term/Overdue Period Based On | FTI_BILST_REF_B | CHAR | 1 | FTI_BILST_REF_B | FTI_BILST_REF_POS | |||
BILST_REF_F | Flows: Remaining Term/Overdue Period Based On | FTI_BILST_REF_F | CHAR | 1 | FTI_BILST_REF_F | FTI_BILST_REF_FLOWS | |||
STORNO | Evaluate Reversed Flows | FTI_STORNO | CHAR | 1 | XFELD | ||||
AUSWT | Evaluation Type (Risk Management) | FTI_EVALTYPE | CHAR | 4 | JBREVAL | JBREVAL | FTI_EVALTYPE | ||
FLG_SE | Product Group Securities: Yes/No | FTI_LDB_FLG_SE | CHAR | 1 | XFELD | FTI_FLG_SE | |||
FLG_LO | Product Group Loans: Yes/No | FTI_LDB_FLG_LO | CHAR | 1 | XFELD | FTI_FLG_LO | |||
FLG_OTC | Product Group OTC (MM, FX, DE): Yes/No | FTI_LDB_FLG_OTC | CHAR | 1 | XFELD | FTI_FLG_OTC | |||
FLG_LOF | Product Group Listed Derivatives (Futures): Yes/No | FTI_LDB_FLG_LOF | CHAR | 1 | XFELD | FTI_FLG_LOF | |||
FLG_COUPLING_SECACCGRP | Interpret Assignment of Sec. Account to Sec. Account Group | FTI_LDB_FLG_COUPLING_SECACCGRP | CHAR | 1 | XFELD | FTI_FLG_SECACCGRP | |||
FLG_HISTORIC_ACCASSREF | Indicator: Historical Account Assignment Reference | FTI_LDB_FLG_HISTORIC_ACCASSREF | CHAR | 1 | XFELD | FTI_FLG_HISTKR | |||
FLG_CONDENSE | Summarize Results (for Query) | FTI_CONDENSE | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_NO_NULL | Hide Zero Records | FTI_NO_NULL | CHAR | 1 | XFELD | FTI_NO_NULL_ID | |||
FLG_EXCLUDING_PLAN | Exclude Plan Data (for Query) | FTI_EXCL_PLAN | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_REVERSED_FLOWS | Process Reversed Flows (for Query) | FTI_REVERSED_FLOWS | CHAR | 1 | XFELD | FTI_CONDENSE_ID |
Key field | Non-key field |
How do I retrieve data from SAP structure VTVBARW_CFM_1 using ABAP code?
As VTVBARW_CFM_1 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 VTVBARW_CFM_1 as there is no data to select.How to access SAP table VTVBARW_CFM_1
Within an ECC or HANA version of SAP you can also view further information about VTVBARW_CFM_1 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