VTVDETA_TR SAP (Treasury: For a Given Period) Structure details

Dictionary Type: Structure
Description: Treasury: For a Given Period




ABAP Code to SELECT data from VTVDETA_TR
Related tables to VTVDETA_TR
Access table VTVDETA_TR




Structure field list including key, data, relationships and ABAP select examples

VTVDETA_TR 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 "Treasury: For a Given Period" 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_VTVDETA_TR TYPE VTVDETA_TR.

The VTVDETA_TR table consists of various fields, each holding specific information or linking keys about Treasury: For a Given Period data available in SAP. These include MANDT (Client), BUKRS (Company Code), RPORTB (Portfolio), WAERS (Currency Key).. 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 VTVDETA_TR 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
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
RANTYP_RContract type FTI_RANTYPCHAR1FTI_RANTYP
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
RANLSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLVDContract Number RANLCHAR13VDARLALPHARANLRAN
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
SAKTIVActive status of financial transaction (drilldown reporting) FTI_SAKTIVCHAR1FTI_SAKTIV
RREFKONT_RAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
SBILKBalance Sheet Indicator SBILKCHAR2TW11SBILK
FINPROJFinance Project TB_TFPROJCHAR13T_TFPROJ
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2AT02T_SFGZUTYC_AT02
RDEALERTrader RDEALERCHAR12TZDEARDEALER
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
RMAIDMaster Agreement TB_RMAIDCHAR10VTBMAALPHAT_RMAIDTMAVTMA
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
HKONTGeneral ledger account FTI_HKONTCHAR10SKB1ALPHASAKNR
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
DLOTGENERATIONDate On Which Lot Was Generated DLOTGENERATIONDATS8DATUM
TLOTGENERATIONLot Generation Time TLOTGENERATIONTIMS6UZEIT
LOTGENERATION_USERLot Entered By FTI_LOTGENERATIONUSERCHAR12SYCHAR12
LOTGENERATION_BUSTRANSCATBusiness Transaction Category Which Generated the Lot FTI_LOTGENERATION_BUSTRANSCATNUMC4TRDTS_BT_CATTPM_BUSTRANSCAT
PARTNRPartner with Whom Commitment Exists FTI_LDB_RISK_COUNTERPARTYCHAR10BUT000ALPHABU_PARTNERBUPA
TYPEBusiness Partner Category BP_TYPE_NEWCHAR1BU_TYPE
ISTYPEIndustry System BU_ISTYPECHAR4TB038BU_ISTYPE
IND_SECTORIndustry BU_IND_SECTORCHAR10TB038ABU_INDSECTOR
CNTRY_COMPCountry of Registered Office of Business Partner FTI_LANDBPCHAR3T005LAND1
LEGAL_ENTYLegal Form of Organization BP_LEG_ETY_NEWCHAR2TB019BU_LEGENTY
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORG_NEWCHAR2TB032BU_LEGAL_ORG
NATIONNationality BP_CNTR_NCHAR3T005LAND1
STATECitizenship BP_CNTR_STCHAR3T005LAND1
GROUP_IDBusiness Partner Grouping BU_GRP_ID_NEWCHAR4TB001BU_GROUPBPP
GROUP_DTarget Group BP_GROUP_DCHAR4TP13BP_GROUP_D
STAFF_GRPEmployee Group BP_STAFF_GCHAR4TP05BP_STAFF_G
COMP_REOrganization Relationship BP_COMP_RECHAR1BP_COMP_RE
GRADEValuation FTI_BP_GRADECHAR10TPZ22BP_GRADE
GRADE_METHODValuation Procedure FTI_BP_GRADE_METHODCHAR10TPZ21BP_GRADE_METHOD
SOLVNCYCredit Standing BP_SOLVNCYCHAR1BP_SOLVNCY
SOL_INFStatus of Credit Standing Information BP_SOL_INFCHAR1BP_SOL_INF
SOL_I_DDate of Credit Standing Information BP_SOL_I_DDATS8DATUM
RATINGRating FTI_BP_RATINGCHAR3TP06BP_RATING
SOL_INSInstitute providing credit standing information FTI_BP_SOL_INSCHAR4Assigned to domainBP_SOL_INS
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SWERTTYPSecurity Type ID SWERTTYPNUMC1TW20SAKTTYP
SWPKLASSClassification of bond SWPKLASSNUMC3TW01SWPKLASS
ALWPKLGeneral Security Classification ALWPKLCHAR3TW22ALWPKL
SARTBETType of shareholding SARTBETNUMC2TW02SARTBET
SAKARStock category SAKARNUMC1SAKAR
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
SNOTIQuotation Indicator SNOTINUMC1SNOTI
SBOERNOTIndicator: Listed on an Exchange SBOERNOTCHAR1JANEI
SFOTYFund type indicator SFOTYNUMC1TW21SFOTY
SOL_INS_RANLInstitut Supplying Credit Rating Information for Secur. ID FTI_SOL_INS_RANLCHAR4TP07BP_SOL_INS
RATING_RANLRating for Securities ID Number/OTC Transaction BP_RATING_RANLCHAR3TP06BP_RATING
KBNEWE_ENominal Value per Stock (Independent of Currency) FTI_VVBNEWE_EDEC15(6) VVKWKURS
KZAHLAKT_EPay-in rate FTI_KZAHLAKT_EDEC10(7) DEC3_7
VONDATStart Date of Evaluation DVONDATDATS8DATUM
BISDATDate of evaluation end DBISDATDATS8DATUM
RSTICHKey date reference RSTICHCHAR1RSTICH
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
DFAELLDue date DFAELLDATS8DATUM
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
JFDBUCRelevance to CM FTI_FDBUCCHAR1FTI_FDBUC
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
BANKK_HBBank key of house bank FTI_BANKKCHAR15BANKKBNK
BANKN_HBBank account number of house bank FTI_BANKNCHAR18BANKN
BANKK_BPBank key of business partner bank FTI_BANKKPCHAR15BANKKBNK
BANKN_BPBank account number of business partner FTI_BANKNPCHAR18BANKN
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
JAHRCalendar year TB_JAHRNUMC4GJAHRGJAHR
MONATCalendar month TB_MONATNUMC2TB_MONAT
WOCHECalendar Week FTI_WOCHENUMC2NUMC2
MONAT_JAHRCalendar Month/Year FTI_MONTH_YEARNUMC6PERIMCPERIOD
WOCHE_JAHRCalendar Week/Year FTI_WEEK_YEARNUMC6PERIMCPERIOD
SZARTPayment transaction TB_SZARTCHAR1XFELD
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
PRKEYKey Number for Payment Request PRQ_KEYNOCHAR10PAYRQALPHAPRQ_KEYNO
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
AWKEYReference Key AWKEYCHAR20AWKEY
GL_ACCOUNT_DNumber of G/L Account: Debit FTI_GLACC_DCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
GL_ACCOUNT_CNumber of G/L Account: Credit FTI_GLACC_CCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
DBESTANDPosition value date DBESTANDDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
BUCHST_TRPosting status of flow for Treasury BUCHST_TRCHAR1BUCHST_TR
SBEWART_RFlow Type SBEWARTCHAR4TZB0ASBEWART
SBFREIRelease Given for Flow to Be Posted? TB_SBFREICHAR1XFELD
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
RAHABKIShort key for own house bank TB_RHABKICHAR5T012HBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5T012KHKTID
PAYINDPayment Status of Flows TB_SPAYINDCHAR1T_SPAYIND
GSVGANGTR transaction activity for securities GSVGANGNUMC3GSVGANG
VVRANLWXSecondary index class data VVRANLWXSCHAR20CHAR20S
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
WVERB1Nominal currency borrowing/sale/outgoing side/short FTI_WHR_SHORTCUKY5TCURCWAERS
WFORD1Nominal currency investment/purchase incoming side/long FTI_WHR_LONGCUKY5TCURCWAERS
RLZTG_K_FRemaining Term in Days (Key Figure) FTI_RLZTGK_FDEC7DEC7
UEBTG_K_FOverdue Period in Days (Key Figure) FTI_UEBTGK_FDEC7DEC7
RLZTG_FRemaining Term in Days FTI_RLZTG_FNUMC5NUMC5
RLZMO_FRemaining Term in Months FTI_RLZMO_FNUMC4NUMC4
RLZJA_FRemaining Term in Years FTI_RLZJA_FNUMC3NUMC3
UEBTG_FOverdue Period in Days FTI_UEBTG_FNUMC5NUMC5
UEBMO_FOverdue Period in Months FTI_UEBMO_FNUMC3NUMC3
UEBJA_FOverdue Period in Years FTI_UEBJA_FNUMC2NUMC2
BZBETRPayment amount in payment currency D_CASHCWCURR15(2) WERTV8_TR
BHWBETRPayment amount in local currency D_CASHHWCURR15(2) WERTV8_TR
EHBETRProfit/loss amount in local currency EHBETRCURR13(2) WERTV7
EEBETRProfit/loss amount in profit/loss currency EEBETRCURR13(2) WERTV7
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
SPLWHRProfit/loss currency SPLWHRCUKY5TCURCWAERS
BBWHR_PAmount which changes position in curr. of position increase FTI_BBWHRPCURR13(2) WERTV7
SBWHR_PCurrency of position increase FTI_SBWPCUKY5TCURCWAERS
D_ASTUECKChange in no. of units (for unit-quoted securities) D_ASTUECKDEC15(5) ASTUECK
D_AKTNOMWBWAsset: Change in nominal value in purchase currency D_AKTNOMWBWCURR15(2) WERTV8_TR
D_PASNOMWBWLiability: Change in nominal value in sale currency D_PASNOMWBWCURR15(2) WERTV8_TR
D_AWBW_AChange in acquisition value in position currency (asset) D_AWBW_ACURR15(2) WERTV8_TR
D_AWBW_PChange in acquisition value in position currency (liability) D_AWBW_PCURR15(2) WERTV8_TR
D_AWHW_AChange in acquisition value in local currency (asset) D_AWHW_ACURR15(2) WERTV8_TR
D_AWHW_PChange in acquisition value in local currency (liability) D_AWHW_PCURR15(2) WERTV8_TR
D_AKTBWBWAsset: Change in book value in position/transaction curr. D_AKTBWBWCURR15(2) WERTV8_TR
D_AKTBWHWAsset: Change in book value in local currency D_AKTBWHWCURR15(2) WERTV8_TR
D_PASBWBWLiability: Change in book value in position/trans. curr. D_PASBWBWCURR15(2) WERTV8_TR
D_PASBWHWLiability: Change in book value in local currency D_PASBWHWCURR15(2) WERTV8_TR
D_NKBWBWDelta Incidental Costs for Book Value in Position Currency D_NKBWBWCURR15(2) WERTV8_TR
D_NKBWHWDelta Incidental Costs for Book Value in Local Currency D_NKBWHWCURR15(2) WERTV8_TR
PABGERFPLRevenue Accrued/Deferred in Profit/Loss Currency PABGERFPLWCURR15(2) WERTV8_TR
PABGERFHWRevenue Accrued/Deferred in Local Currency PABGERFHWCURR15(2) WERTV8_TR
D_VAL_TI_PCDelta Security Valuation in Position Currency FTI_D_VAL_TI_PCCURR21(2) TPM_AMOUNT
D_VAL_TI_LCDelta Security Valuation in Local Currency FTI_D_VAL_TI_LCCURR21(2) TPM_AMOUNT
D_VAL_FX_LCDelta Foreign Currency Valuation in Local Currency FTI_D_VAL_FX_LCCURR21(2) TPM_AMOUNT
D_VAL_CH_TI_PCDelta Valuation of Capitalized Costs, Security, in PC FTI_D_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
D_VAL_CH_TI_LCDelta Valuation of Capitalized Costs, Security, in LC FTI_D_VAL_CH_TI_LCCURR21(2) TPM_AMOUNT
D_VAL_CH_FX_LCDelta Valuation of Capitalized Costs, FX, in Local Currency FTI_D_VAL_CH_FX_LCCURR21(2) TPM_AMOUNT
CALC_CCYEvaluation Currency AFW_EVAL_CURRENCYCUKY5TCURCWAERS
MPKOND_AInterest rate - start (drilldown reporting characteristic) MPKOND_ANUMC3ALPHAFTI_NUMC3
MPKOND_EInterest rate - end (drilldown reporting characteristic) MPKOND_ENUMC3ALPHAFTI_NUMC3
PKOND_AInterest Rate: Start FTI_PKOND_ADEC10(7) DECV3_7
PKOND_EInterest Rate: End FTI_PKOND_EDEC10(7) DECV3_7
STUECKE_ANumber of units / Number of transactions - start FTI_STUECKE_ADEC15(5) ASTUECK
STUECKE_ENo. of units/No. of transactions - end FTI_STUECKE_EDEC15(5) ASTUECK
BVERA1Liability: Nominal value in sale currency - start FTI_PASNOMWBW_ACURR15(2) WERTV8_TR
BFORA1Asset: Nominal value in purchase currency - start FTI_AKTNOMWBW_ACURR15(2) WERTV8_TR
BVERE1Liability: Nominal Value in Currency of Sale - End FTI_PASNOMWBW_ECURR15(2) WERTV8_TR
BFORE1Asset: Nominal value in purchase currency - end FTI_AKTNOMWBW_ECURR15(2) WERTV8_TR
BKAUFWR_A_AAsset: Acquisition value in position currency - start FTI_BKAUFWR_A_ACURR15(2) WERTV8_TR
BKAUFWR_A_EAsset: Acquisition value in position currency - end FTI_BKAUFWR_A_ECURR15(2) WERTV8_TR
BKAUFHW_A_AAsset: Acquisition value in local currency - start FTI_BKAUFHW_A_ACURR15(2) WERTV8_TR
BKAUFHW_A_EAsset: Acquisition value in local currency - end FTI_BKAUFHW_A_ECURR15(2) WERTV8_TR
BKAUFWR_P_ALiability: Acquisition value in position currency - start FTI_BKAUFWR_P_ACURR15(2) WERTV8_TR
BKAUFWR_P_ELiability: Acquisition value in position currency - end FTI_BKAUFWR_P_ECURR15(2) WERTV8_TR
BKAUFHW_P_ALiability: Acquisition value in local currency - start FTI_BKAUFHW_P_ACURR15(2) WERTV8_TR
BKAUFHW_P_ELiability: Acquisition value in local currency - end FTI_BKAUFHW_P_ECURR15(2) WERTV8_TR
BKOSTWR_AAsset: Incidental costs acquisition value in pos.curr.-start FTI_BKOSTWR_ACURR15(2) WERTV8_TR
BKOSTWR_EAsset: Incidental costs acquisition value in pos.curr. - end FTI_BKOSTWR_ECURR15(2) WERTV8_TR
BKOSTHW_AAsset: Incidental costs acquis. value in local curr. -start FTI_BKOSTHW_ACURR15(2) WERTV8_TR
BKOSTHW_EAsset: Incidental costs acquisition value in local curr.-end FTI_BKOSTHW_ECURR15(2) WERTV8_TR
BKS_AWRBook value of cap. incidental costs in position curr.- start FTI_VVBKSTBWR_ACURR15(2) WERTV8_TR
BKS_EWRBook value of cap. incidental costs in position curr. - end FTI_VVBKSTBWR_ECURR15(2) WERTV8_TR
BKS_AHWBook value of cap. incidental costs in local curr. - start FTI_VVBKSTBHW_ACURR15(2) WERTV8_TR
BKS_EHWBook value of capitalized incidental costs in loc.curr.- end FTI_VVBKSTBHW_ECURR15(2) WERTV8_TR
AKTBWBW_AAsset: Book value in position currency - start FTI_AKTBWBW_ACURR15(2) WERTV8_TR
AKTBWHW_AAsset: Book value in local currency - start FTI_AKTBWHW_ACURR15(2) WERTV8_TR
PASBWBW_ALiability: Book value in position currency - start FTI_PASBWBW_ACURR15(2) WERTV8_TR
PASBWHW_ALiability: Book value in local currency - start FTI_PASBWHW_ACURR15(2) WERTV8_TR
AKTBWBW_EAsset: Book value in position currency - end FTI_AKTBWBW_ECURR15(2) WERTV8_TR
AKTBWHW_EAsset: Book value in local currency - end FTI_AKTBWHW_ECURR15(2) WERTV8_TR
PASBWBW_ELiability: Book value in position currency - end FTI_PASBWBW_ECURR15(2) WERTV8_TR
PASBWHW_ELiability: Book value in local currency - end FTI_PASBWHW_ECURR15(2) WERTV8_TR
BAKTPOSVALBW_AAsset: Current Value in Position Currency: Start FTI_AKTPOSVALBW_ACURR15(2) WERTV8_TR
BAKTPOSVALBW_EAsset: Current Value in Position Currency: End FTI_AKTPOSVALBW_ECURR15(2) WERTV8_TR
BPASPOSVALBW_ALiability: Current Value in Position Currency: Start FTI_PASPOSVALBW_ACURR15(2) WERTV8_TR
BPASPOSVALBW_ELiability: Current Value in Position Currency: End FTI_PASPOSVALBW_ECURR15(2) WERTV8_TR
ANKUPR_AAcq.Price for Percentage-Quoted Securities / Start of Period FTI_ANKUPR_ADEC15(6) VVPKTKUR
ANKUPR_EAcq.Price for Percentage-Quoted Securities / End of Period FTI_ANKUPR_EDEC15(6) VVPKTKUR
ANKSBW_AAcq. Price f. Unit-Quoted Securities in PC / Start of Period FTI_ANKSBW_ADEC15(6) VVPKTKUR
ANKSBW_EAcq. Price f. Unit-Quoted Securities in PC / End of Period FTI_ANKSBW_EDEC15(6) VVPKTKUR
BUKSBW_ABook Price f. Unit-Quoted Securities in PC / Start of Period FTI_BUKSBW_ADEC15(6) VVPKTKUR
BUKSBW_EBook Price f. Unit-Quoted Securities in PC / End of Period FTI_BUKSBW_EDEC15(6) VVPKTKUR
BUKUPR_ABook Price f. Perc.-Quoted Securities in % / Start of Period FTI_BUKUPR_ADEC15(6) VVPKTKUR
BUKUPR_EBook Price f. Perc.-Quoted Securities in % / End of Period FTI_BUKUPR_EDEC15(6) VVPKTKUR
KAKSBW_APurchase Price for Unit-Quoted Secs in PC / Start of Period FTI_KAKSBW_ADEC15(6) VVPKTKUR
KAKSBW_EPurchase Price for Unit-Quoted Secs in PC / End of Period FTI_KAKSBW_EDEC15(6) VVPKTKUR
KAKUPR_APurchase Price for Perc.-Quoted Secs in % / Start of Period FTI_KAKUPR_ADEC15(6) VVPKTKUR
KAKUPR_EPurchase Price for Perc.-Quoted Secs in % / End of Period FTI_KAKUPR_EDEC15(6) VVPKTKUR
KURSBW_AMarket Price for Unit-Quoted Secs in PC / Start of Period FTI_KURSBW_ADEC15(6) VVPKTKUR
KURSBW_EMarket Price for Unit-Quoted Secs in PC / End of Period FTI_KURSBW_EDEC15(6) VVPKTKUR
KURSPR_AMarket Price Percentage-Quoted Securities / Start of Period FTI_KURSPR_ADEC15(6) VVPKTKUR
KURSPR_EMarket Price Percentage-Quoted Securities / End of Period FTI_KURSPR_EDEC15(6) VVPKTKUR
NPV_PC_ARM NPV in Position Currency: Start FTI_NPV_PC_ACURR15(2) WERTV8_TR
NPV_PC_ERM NPV in Position Currency: End FTI_NPV_PC_ECURR15(2) WERTV8_TR
NPV_CC_ARM Net Present Value in Valuation Currency Start FTI_NPV_CC_ACURR15(2) WERTV8_TR
NPV_CC_ERM Net Present Value in Valuation Currency End FTI_NPV_CC_ECURR15(2) WERTV8_TR
NPV_LONG_PC_ARM NPV Incoming Side in Currency Incoming Side Start FTI_NPV_LONG_PC_ACURR15(2) WERTV8_TR
NPV_LONG_PC_ERM NPV Incoming Side in Currency Incoming Side End FTI_NPV_LONG_PC_ECURR15(2) WERTV8_TR
NPV_SHORT_PC_ARM NPV Outgoing Side in Currency Outgoing Side Start FTI_NPV_SHORT_PC_ACURR15(2) WERTV8_TR
NPV_SHORT_PC_ERM NPV Outgoing Side in Currency Outgoing Side End FTI_NPV_SHORT_PC_ECURR15(2) WERTV8_TR
NPV_LONG_CC_ARM Net Present Value Incoming Side in Val. Currency Start FTI_NPV_LONG_CC_ACURR15(2) WERTV8_TR
NPV_LONG_CC_ERM Net Present Value Incoming Side in Val. Currency End FTI_NPV_LONG_CC_ECURR15(2) WERTV8_TR
NPV_SHORT_CC_ARM NPV Outgoing Side in Valuation Currency Start FTI_NPV_SHORT_CC_ACURR15(2) WERTV8_TR
NPV_SHORT_CC_ERM NPV Outgoing Side in Valuation Currency End FTI_NPV_SHORT_CC_ECURR15(2) WERTV8_TR
CLEAN_PRICE_PC_AClean Price in Position Currency: Start FTI_CLEAN_PRICE_PC_ACURR15(2) WERTV8_TR
CLEAN_PRICE_PC_EClean Price in Position Currency: End FTI_CLEAN_PRICE_PC_ECURR15(2) WERTV8_TR
CLEAN_PRICE_CC_AClean Price in Valuation Currency - Start FTI_CLEAN_PRICE_CC_ACURR15(2) WERTV8_TR
CLEAN_PRICE_CC_EClean Price in Evaluation Currency End FTI_CLEAN_PRICE_CC_ECURR15(2) WERTV8_TR
BPVALUE_PC_ABasis Point Value in Position Currency: Start FTI_VALBP_PC_ACURR15(2) WERTV8_TR
BPVALUE_PC_EBasis Point Value in Position Currency: End FTI_VALBP_PC_ECURR15(2) WERTV8_TR
BPVALUE_CC_ABasis Point Value in Valuation Currency Start FTI_VALBP_CC_ACURR15(2) WERTV8_TR
BPVALUE_CC_EBasis Point Value in Valuation Currency End FTI_VALBP_CC_ECURR15(2) WERTV8_TR
MAC_DURATION_AMacaulay Duration: Start FTI_MAC_DURATION_ADEC12(3) DEC9_3
MAC_DURATION_EMacaulay Duration: End FTI_MAC_DURATION_EDEC12(3) DEC9_3
MOD_DURATION_AModified Duration: Start FTI_MOD_DURATION_ADEC12(3) DEC9_3
MOD_DURATION_EModified Duration: End FTI_MOD_DURATION_EDEC12(3) DEC9_3
BAMORTWR_AAmortization in Position Currency / Start of Period FTI_AMORT_PC_ACURR21(2) TPM_AMOUNT
BAMORTWR_EAmortization in Position Currency / End of Period FTI_AMORT_PC_ECURR21(2) TPM_AMOUNT
BAMORTHW_AAmortization in Local Currency / Start of Period FTI_AMORT_LC_ACURR21(2) TPM_AMOUNT
BAMORTHW_EAmortization in Local Currency / End of Period FTI_AMORT_LC_ECURR21(2) TPM_AMOUNT
BAGIOWR_ACleared PD Deferral/Tax Compensation in PC / Start of Period FTI_DISAGIO_PC_ACURR21(2) TPM_AMOUNT
BAGIOWR_ECleared PD Deferral/Tax Compensation in PC / End of Period FTI_DISAGIO_PC_ECURR21(2) TPM_AMOUNT
BAGIOHW_ACleared PD Deferral/Tax Compensation in LC / Start of Period FTI_DISAGIO_LC_ACURR21(2) TPM_AMOUNT
BAGIOHW_ECleared PD Deferral/Tax Compensation in LC / End of Period FTI_DISAGIO_LC_ECURR21(2) TPM_AMOUNT
VAL_TI_PC_ASecurity Valuation in Position Currency / Start of Period FTI_VAL_TI_PC_ACURR21(2) TPM_AMOUNT
VAL_TI_PC_ESecurity Valuation in Position Currency / End of Period FTI_VAL_TI_PC_ECURR21(2) TPM_AMOUNT
VAL_TI_LC_ASecurity Valuation in Local Currency / Start of Period FTI_VAL_TI_LC_ACURR21(2) TPM_AMOUNT
VAL_TI_LC_ESecurity Valuation in Local Currency / End of Period FTI_VAL_TI_LC_ECURR21(2) TPM_AMOUNT
VAL_FX_LC_AForeign Currency Valuation in Local Crcy / Start of Period FTI_VAL_FX_LC_ACURR21(2) TPM_AMOUNT
VAL_FX_LC_EForeign Currency Valuation in Local Crcy / End of Period FTI_VAL_FX_LC_ECURR21(2) TPM_AMOUNT
VAL_CH_TI_PC_AValuation of Cap. Costs, Security, in PC / Start of Period FTI_VAL_CH_TI_PC_ACURR21(2) TPM_AMOUNT
VAL_CH_TI_PC_EValuation of Cap. Costs, Security, in PC / End of Period FTI_VAL_CH_TI_PC_ECURR21(2) TPM_AMOUNT
VAL_CH_TI_LC_AValuation of Cap. Costs, Security, in LC / Start of Period FTI_VAL_CH_TI_LC_ACURR21(2) TPM_AMOUNT
VAL_CH_TI_LC_EValuation of Cap. Costs, Security, in LC / End of Period FTI_VAL_CH_TI_LC_ECURR21(2) TPM_AMOUNT
VAL_CH_FX_LC_AValuation of Cap. Costs, FX, in Local Crcy / Start of Period FTI_VAL_CH_FX_LC_ACURR21(2) TPM_AMOUNT
VAL_CH_FX_LC_EValuation of Cap. Costs, FX, in Local Crcy / End of Period FTI_VAL_CH_FX_LC_ECURR21(2) TPM_AMOUNT
ACC_INTEREST_PC_AAccrued Interest in Position Currency / Start of Period FTI_ACC_INTEREST_PC_ACURR21(2) TPM_AMOUNT
ACC_INTEREST_PC_EAccrued Interest in Position Currency / End of Period FTI_ACC_INTEREST_PC_ECURR21(2) TPM_AMOUNT
NOMINAL_AMT_LO_PC_ALocked Nominal Amount in Position Currency / Start of Period FTI_NOMINAL_AMT_LO_PC_ACURR21(2) TPM_AMOUNT
NOMINAL_AMT_LO_PC_ELocked Nominal Amount in Position Currency / End of Period FTI_NOMINAL_AMT_LO_PC_ECURR21(2) TPM_AMOUNT
BZBETR_AWPayment Amount of Flow in Display Crcy (from Pmnt Crcy) FTI_CASWCWCURR15(2) WERTV8
BHWBETR_AWPayment amount of flow in display currency from local curr. FTI_CASWHWCURR15(2) WERTV8
EHBETR_AWProfit/loss amount in display currency from local currency EHBETR_AWCURR15(2) WERTV8_TR
EEBETR_AWProfit/Loss Amount in DC (from P/L Currency) EEBETR_AWCURR15(2) WERTV8_TR
ANZGWDisplay Currency FTI_ANZGWCUKY5TCURCWAERSFFZ
BVERA1_AWLiability: Nominal value in display currency - start FTI_PASNOMWBW_A_AWCURR15(2) WERTV8_TR
BFORA1_AWAsset: Nominal value in display currency - start FTI_AKTNOMWBW_A_AWCURR15(2) WERTV8_TR
BVERE1_AWLiability: Nominal value in display currency - end FTI_PASNOMWBW_E_AWCURR15(2) WERTV8_TR
BFORE1_AWAsset: Nominal value in display currency - end FTI_AKTNOMWBW_E_AWCURR15(2) WERTV8_TR
AKTBWBW_A_AWAsset: Book value in display currency - start FTI_AKTBWBW_A_AWCURR15(2) WERTV8_TR
AKTBWHW_A_AWAsset: Book value in display currency (from LC) - start FTI_AKTBWHW_A_AWCURR15(2) WERTV8_TR
PASBWBW_A_AWLiability: Book value in display currency - start FTI_PASBWBW_A_AWCURR15(2) WERTV8_TR
PASBWHW_A_AWLiability: Book value in display currency (from LC) - start FTI_PASBWHW_A_AWCURR15(2) WERTV8_TR
AKTBWBW_E_AWAsset: Book value in display currency - end FTI_AKTBWBW_E_AWCURR15(2) WERTV8_TR
AKTBWHW_E_AWAsset: Book value in display currency (from LC) - end FTI_AKTBWHW_E_AWCURR15(2) WERTV8_TR
PASBWBW_E_AWLiability: Book value in display currency - end FTI_PASBWBW_E_AWCURR15(2) WERTV8_TR
PASBWHW_E_AWLiability: Book value in display currency (from LC) - end FTI_PASBWHW_E_AWCURR15(2) WERTV8_TR
BAKTPOSVALBW_A_AWAsset: Current Value in Display Currency: Start FTI_AKTPOSVALBW_A_AWCURR15(2) WERTV8_TR
BAKTPOSVALBW_E_AWAsset: Current Value in Display Currency: End FTI_AKTPOSVALBW_E_AWCURR15(2) WERTV8_TR
BPASPOSVALBW_A_AWLiability: Current Value in Display Currency: Start FTI_PASPOSVALBW_A_AWCURR15(2) WERTV8_TR
BPASPOSVALBW_E_AWLiability: Current Value in Display Currency: End FTI_PASPOSVALBW_E_AWCURR15(2) WERTV8_TR
D_AKTNOMWBW_AWAsset: Change in nominal value in disp.curr.from purch.curr. FTI_D_AKTNOMWBW_AWCURR15(2) WERTV8_TR
D_PASNOMWBW_AWLiability: Change in nom.value in displ.curr.from sale curr. FTI_D_PASNOMWBW_AWCURR15(2) WERTV8_TR
D_AWBW_A_AWAsset: Change in acquisition value in display currency FTI_D_AWBW_A_AWCURR15(2) WERTV8_TR
D_AWHW_A_AWAsset: Change in acquis.value in disp.curr. from local curr. FTI_D_AWHW_A_AWCURR15(2) WERTV8_TR
D_AWBW_P_AWChange in acquisition value in display currency (liability) FTI_D_AWBW_P_AWCURR15(2) WERTV8_TR
D_AWHW_P_AWLiability: Change in acquis.val.in disp.curr. from loc.curr. FTI_D_AWHW_P_AWCURR15(2) WERTV8_TR
D_AKTBWBW_AWAsset: Change in book value in display currency FTI_D_AKTBWBW_AWCURR15(2) WERTV8_TR
D_AKTBWHW_AWAsset: Change in book value in disp. curr. from local curr. FTI_D_AKTBWHW_AWCURR15(2) WERTV8_TR
D_PASBWBW_AWLiability: Change in book value in display currency FTI_D_PASBWBW_AWCURR15(2) WERTV8_TR
D_PASBWHW_AWLiability: Change in book val. in disp.curr.from local curr. FTI_D_PASBWHW_AWCURR15(2) WERTV8_TR
D_NKBWHW_AWChange in Book Value of Incidental Costs in DC (From PC) FTI_D_NKBWBW_AWCURR15(2) WERTV8_TR
D_NKBWBW_AWChange in Book Value of Incidental Costs in DC (From LC) FTI_D_NKBWHW_AWCURR15(2) WERTV8_TR
D_VAL_TI_DCDelta Security Valuation in Display Currency (From Pos.Crcy) FTI_D_VAL_TI_DCCURR21(2) TPM_AMOUNT
D_VAL_CH_TI_DCDelta Valuation of Capitalized Costs, Sec., in DC (from PC) FTI_D_VAL_CH_TI_DCCURR21(2) TPM_AMOUNT
PABGERFPL_AWRevenue Accrued/Deferred in DC (from P/L Currency) FTI_PABGERFPLW_AWCURR15(2) WERTV8_TR
PABGERFHW_AWRevenue accrued/deferred in display currency (local curr.) FTI_PABGERFHW_AWCURR15(2) WERTV8_TR
BKAUFWR_A_A_AWAsset: Acquis.value in display curr. from pos. curr. - start FTI_BKAUFWR_A_A_AWCURR15(2) WERTV8_TR
BKAUFWR_A_E_AWAsset: Acquisition value in display curr.from pos.curr.- end FTI_BKAUFWR_A_E_AWCURR15(2) WERTV8_TR
BKAUFHW_A_A_AWAsset: Acq. value in displ. curr. from local. curr. - start FTI_BKAUFHW_A_A_AWCURR15(2) WERTV8_TR
BKAUFHW_A_E_AWAsset: Acquis. value in displ. curr. from local. curr. - end FTI_BKAUFHW_A_E_AWCURR15(2) WERTV8_TR
BKAUFWR_P_A_AWLiability: Acquis. value in disp.curr. from pos.curr - start FTI_BKAUFWR_P_A_AWCURR15(2) WERTV8_TR
BKAUFWR_P_E_AWLiability: Acquis. value in disp. curr. from pos. curr - end FTI_BKAUFWR_P_E_AWCURR15(2) WERTV8_TR
BKAUFHW_P_A_AWLiability: Acquis.val.in displ.curr.from local curr. - start FTI_BKAUFHW_P_A_AWCURR15(2) WERTV8_TR
BKAUFHW_P_E_AWLiability: Acquis.value in displ.curr.from local curr. - end FTI_BKAUFHW_P_E_AWCURR15(2) WERTV8_TR
BKOSTHW_A_AWAsset: Incidental costs acquisition value in DC(LC) - start FTI_BKOSTHW_A_AWCURR15(2) WERTV8_TR
BKOSTHW_E_AWAsset: Incidental costs acquisition value in DC(LC) - end FTI_BKOSTHW_E_AWCURR15(2) WERTV8_TR
BKOSTWR_A_AWAsset: Incidental costs acquisition value in DC(PC) - start FTI_BKOSTWR_A_AWCURR15(2) WERTV8_TR
BKOSTWR_E_AWAsset: Incidental costs acquisition value in DC(PC) - end FTI_BKOSTWR_E_AWCURR15(2) WERTV8_TR
BKS_AWR_AWBook value of capitalized incidental costs in DC(PC) - start FTI_VVBKSTBWR_A_AWCURR15(2) WERTV8_TR
BKS_EWR_AWBook value of capitalized incidental costs in DC(PC) - end FTI_VVBKSTBWR_E_AWCURR15(2) WERTV8_TR
BKS_AHW_AWBook value of capitalized incidental costs in DC(LC) - start FTI_VVBKSTBHW_A_AWCURR15(2) WERTV8_TR
BKS_EHW_AWBook value of capitalized incidental costs in DC(LC) - end FTI_VVBKSTBHW_E_AWCURR15(2) WERTV8_TR
NPV_PC_A_AWRM NPV in Display Currency: Start FTI_NPV_PC_A_AWCURR15(2) WERTV8_TR
NPV_PC_E_AWRM NPV in Display Currency: End FTI_NPV_PC_E_AWCURR15(2) WERTV8_TR
CLEAN_PRICE_PC_A_AWClean Price in Display Currency: Start FTI_CLEAN_PRICE_AW_ACURR15(2) WERTV8_TR
CLEAN_PRICE_PC_E_AWClean Price in Display Currency: End FTI_CLEAN_PRICE_AW_ECURR15(2) WERTV8_TR
BPVALUE_PC_A_AWBasis Point Value in Display Currency: Start FTI_VALBP_AW_ACURR15(2) WERTV8_TR
BPVALUE_PC_E_AWBasis Point Value in Display Currency: End FTI_VALBP_AW_ECURR15(2) WERTV8_TR
BAMORTWR_A_AWAmortization in Display Currency / Start of Period FTI_AMORT_DC_ACURR21(2) TPM_AMOUNT
BAMORTWR_E_AWAmortization in Display Currency / End of Period FTI_AMORT_DC_ECURR21(2) TPM_AMOUNT
BAMORTHW_A_AWAmortization in Display Currency from LC: Start of Period FTI_AMORTHW_DC_ACURR21(2) TPM_AMOUNT
BAMORTHW_E_AWAmortization in Display Currency from LC: End of Period FTI_AMORTHW_DC_ECURR21(2) TPM_AMOUNT
BAGIOWR_A_AWCleared PD Deferral/Tax Compensation in DC / Start of Period FTI_DISAGIO_DC_ACURR21(2) TPM_AMOUNT
BAGIOWR_E_AWCleared PD Deferral/Tax Compensation in DC / End of Period FTI_DISAGIO_DC_ECURR21(2) TPM_AMOUNT
BAGIOHW_A_AWCleared PD Def./Tax Compensation in DC from LC: Start FTI_DISAGIOHW_DC_ACURR21(2) TPM_AMOUNT
BAGIOHW_E_AWCleared PD Def./Tax Compensation in DC from LC: End FTI_DISAGIOHW_DC_ECURR21(2) TPM_AMOUNT
VAL_TI_DC_ASecurity Valuation in Display Currency / Start of Period FTI_VAL_TI_DC_ACURR21(2) TPM_AMOUNT
VAL_TI_DC_ESecurity Valuation in Display Currency / End of Period FTI_VAL_TI_DC_ECURR21(2) TPM_AMOUNT
VAL_CH_TI_DC_AValuation of Cap. Costs, Security, in DC / Start of Period FTI_VAL_CH_TI_DC_ACURR21(2) TPM_AMOUNT
VAL_CH_TI_DC_EValuation of Cap. Costs, Security, in DC / End of Period FTI_VAL_CH_TI_DC_ECURR21(2) TPM_AMOUNT
ACC_INTEREST_DC_AAccrued Interest in Display Currency / Start of Period FTI_ACC_INTEREST_DC_ACURR21(2) TPM_AMOUNT
ACC_INTEREST_DC_EAccrued Interest in Display Currency / End of Period FTI_ACC_INTEREST_DC_ECURR21(2) TPM_AMOUNT
NOMINAL_AMT_LO_DC_ALocked Nominal Amount in Display Currency / Start of Period FTI_NOMINAL_AMT_LO_DC_ACURR21(2) TPM_AMOUNT
NOMINAL_AMT_LO_DC_ELocked Nominal Amount in Display Currency / End of Period FTI_NOMINAL_AMT_LO_DC_ECURR21(2) TPM_AMOUNT
NUMBRNumber of translation key in currency translation CFNUMBRNUMC3T242QCFNUMBRNBR
NUMBR_LCTranslation Type for Currency Translation into Local Crcy FTI_NUMBR_LCNUMC3T242QCFNUMBRNBR_LC
KURSAPrice type for evaluations VVKURSAUSWCHAR2TW56VVSKURSART
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VVRANLWINo. of the secondary index description for class data VVRANLWINUMC2TWX1VVRANLWI
CASHFIndicator for cash flow calculation up to end of term SCASHFLOWCHAR1XFELD
BILSTReference Date FTI_BILSTDATS8DATUM
BILST2Reference Date FTI_BILST2DATS8DATUM
BILST_REF_BPositions: Remaining Term/Overdue Period Based On FTI_BILST_REF_BCHAR1FTI_BILST_REF_BFTI_BILST_REF_POS
BILST_REF_FFlows: Remaining Term/Overdue Period Based On FTI_BILST_REF_FCHAR1FTI_BILST_REF_FFTI_BILST_REF_FLOWS
STORNOEvaluate Reversed Flows FTI_STORNOCHAR1XFELD
AUSWTEvaluation Type (Risk Management) FTI_EVALTYPECHAR4JBREVALJBREVALFTI_EVALTYPE
FLG_SEProduct Group Securities: Yes/No FTI_LDB_FLG_SECHAR1XFELDFTI_FLG_SE
FLG_LOProduct Group Loans: Yes/No FTI_LDB_FLG_LOCHAR1XFELDFTI_FLG_LO
FLG_OTCProduct Group OTC (MM, FX, DE): Yes/No FTI_LDB_FLG_OTCCHAR1XFELDFTI_FLG_OTC
FLG_LOFProduct Group Listed Derivatives (Futures): Yes/No FTI_LDB_FLG_LOFCHAR1XFELDFTI_FLG_LOF
FLG_COUPLING_SECACCGRPInterpret Assignment of Sec. Account to Sec. Account Group FTI_LDB_FLG_COUPLING_SECACCGRPCHAR1XFELDFTI_FLG_SECACCGRP
FLG_HISTORIC_ACCASSREFIndicator: Historical Account Assignment Reference FTI_LDB_FLG_HISTORIC_ACCASSREFCHAR1XFELDFTI_FLG_HISTKR
FLG_CONDENSESummarize Results (for Query) FTI_CONDENSECHAR1XFELDFTI_CONDENSE_ID
FLG_NO_NULLHide Zero Records FTI_NO_NULLCHAR1XFELDFTI_NO_NULL_ID
FLG_EXCLUDING_PLANExclude Plan Data (for Query) FTI_EXCL_PLANCHAR1XFELDFTI_CONDENSE_ID
FLG_REVERSED_FLOWSProcess Reversed Flows (for Query) FTI_REVERSED_FLOWSCHAR1XFELDFTI_CONDENSE_ID

Key field Non-key field



How do I retrieve data from SAP structure VTVDETA_TR using ABAP code?

As VTVDETA_TR 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 VTVDETA_TR as there is no data to select.

How to access SAP table VTVDETA_TR

Within an ECC or HANA version of SAP you can also view further information about VTVDETA_TR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!