VTVBARW_TR SAP (Treasury: For a Given Date) Structure details

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




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




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

VTVBARW_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 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_TR TYPE VTVBARW_TR.

The VTVBARW_TR table consists of various fields, each holding specific information or linking keys about Treasury: For a Given Date 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 VTVBARW_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
KBNEWENominal Value per Stock (Independent of Currency) VVBNEWEDEC15(6) VVKWKURS
KZAHLAKTPay-in rate KZAHLAKTDEC10(7) DEC3_7
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
RSTICHKey date reference RSTICHCHAR1RSTICH
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
RDPBANKDepository Bank RDEPOTBANKCHAR10Assigned to domainALPHABU_PARTNER
WVERB1Nominal currency borrowing/sale/outgoing side/short FTI_WHR_SHORTCUKY5TCURCWAERS
WFORD1Nominal currency investment/purchase incoming side/long FTI_WHR_LONGCUKY5TCURCWAERS
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
CALC_CCYEvaluation Currency AFW_EVAL_CURRENCYCUKY5TCURCWAERS
RLZTGRemaining Term in Days FTI_RLZTGNUMC5NUMC5
RLZMORemaining Term in Months FTI_RLZMONUMC4NUMC4
RLZJARemaining Term in Years FTI_RLZJANUMC3NUMC3
UEBTGOverdue Period in Days FTI_UEBTGNUMC5NUMC5
UEBMOOverdue Period in Months FTI_UEBMONUMC3NUMC3
UEBJAOverdue Period in Years FTI_UEBJANUMC2NUMC2
MPKONDInterest rate (characteristic in drill-down reporting) MPKONDNUMC3ALPHAFTI_NUMC3
PKONDInterest rate TV_PKONDDEC10(7) DECV3_7
PEFFZINSEffective Interest Rate FTI_EFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
MKKURSRate of FX transaction (drill-down reporting characteristic) MKKURSNUMC4NUMC4
VVRANLWXSecondary index class data VVRANLWXSCHAR20CHAR20S
STUECKENumber of units / Number of transactions FTI_STUECKEDEC15(5) ASTUECK
ASTUECK_SPNo. of Units Blocked for Unit-Quoted Securities ASTUECK_SPDEC15(5) ASTUECK
BVERB1Nominal value - short FTI_BVERB1CURR15(2) WERTV8
BFORD1Nominal value - long FTI_BFORD1CURR15(2) WERTV8
BNOMINA_SPLocked Nominal Amount in Position Currency BNOMINAL_SPCURR15(2) WERTV8_TR
BAKTAWBWAsset: Acquisition value in position/transaction currency FTI_AKTAWBWCURR15(2) WERTV8_TR
BAKTAWHWAsset: Acquisition value in local currency FTI_AKTAWHWCURR15(2) WERTV8_TR
BPASAWBWLiability: Acquisition value in position/transact. currency FTI_PASAWBWCURR15(2) WERTV8_TR
BPASAWHWLiability: Acquisition value in local currency FTI_PASAWHWCURR15(2) WERTV8_TR
BAKTBWBWAsset: Book value in position currency/transaction currency FTI_AKTBWBWCURR15(2) WERTV8_TR
BAKTBWHWAsset: Book value in local currency FTI_AKTBWHWCURR15(2) WERTV8_TR
BPASBWBWLiability: Book value in position/transaction currency FTI_PASBWBWCURR15(2) WERTV8_TR
BPASBWHWLiability: Book value in local currency FTI_PASBWHWCURR15(2) WERTV8_TR
BAKTPOSVALBWAsset: Current value in position currency FTI_AKTPOSVALBWCURR15(2) WERTV8_TR
BPASPOSVALBWLiability: Current value in position currency FTI_PASPOSVALBWCURR15(2) WERTV8_TR
BSUMABSCHRBWTotal depreciation in position/transaction currency FTI_SUMABSCHRBWCURR15(2) WERTV8_TR
BSUMABSCHRHWTotal depreciation in local currency FTI_SUMABSCHRHWCURR15(2) WERTV8_TR
BSUMRUECKHWTotal provisions in local currency FTI_SUMRUECKHWCURR15(2) WERTV8_TR
BKOSTWRCapitalized incid.costs acquisition value in pos. currency BKOSTWRCURR15(2) WERTV8_TR
BKOSTHWCapitalized incid.costs acquisition value in local currency BKOSTHWCURR15(2) WERTV8_TR
BKSTBWRBook value of capitalized incid. costs in position currency VVBKSTBWRCURR15(2) WERTV8_TR
BKSTBHWBook value of activated incid. costs in local currency VVBKSTBHWCURR15(2) WERTV8_TR
BAMORTWRTotal of amortization in position currency FTI_BAMORTWRCURR15(2) WERTV8_TR
BAMORTHWTotal of amortization in local currency FTI_BAMORTHWCURR15(2) WERTV8_TR
BAGIOWRRemaining premium/discount in position currency FTI_BAGIOWRCURR15(2) WERTV8_TR
BAGIOHWRemaining premium/discount in local currency FTI_BAGIOHWCURR15(2) WERTV8_TR
G_ANKUPRAcquisition Price for Percentage-Quoted Securities in % FTI_ANKUPRDEC15(6) VVPKTKUR
G_ANKSBWAcquisition Price f. Unit-Quoted Securities in Position Crcy FTI_ANKSBWDEC15(6) VVPKTKUR
G_KAKSBWPurchase Price for Unit-Quoted Securities in Position Crcy FTI_KAKSBWDEC15(6) VVPKTKUR
G_KAKUPRPurchase Price for Percentage-Quoted Securities in % FTI_KAKUPRDEC15(6) VVPKTKUR
G_BUKSBWBook Price for Unit-Quoted Securities in Position Currency FTI_BUKSBWDEC15(6) VVPKTKUR
G_BUKUPRBook Price for Percentage-Quoted Securities in % FTI_BUKUPRDEC15(6) VVPKTKUR
G_KURSPRMarket Price / % (Percentage-Quoted Securities) FTI_KURSPRDEC15(6) VVPKTKUR
G_KURSBWMarket Price/Unit in Position Crcy (Unit-Quoted Securities) FTI_KURSBWDEC15(6) VVPKTKUR
STUECKZINSAccrued Interest in Position Currency TB_STZINSCURR21(2) TPM_AMOUNT
NPV_PCRM Net Present Value in Position Currency TV_NPV_PCCURR15(2) WERTV8_TR
NPV_LONG_PCRM NPV of Incoming Side in Currency of Incoming Side TV_NPV_LONG_PCCURR15(2) WERTV8_TR
NPV_SHORT_PCRM NPV of Outgoing Side in Currency of Outgoing Side TV_NPV_SHORT_PCCURR15(2) WERTV8_TR
CLEAN_PRICE_PCClean Price in Position Currency TV_CLEAN_PRICE_PCCURR17(2) T_PRESVAL
BPVALUE_PCBasis Point Value in Position Currency TV_VALBP_PCCURR17(2) T_PRESVAL
NPV_CCRM NPV in Evaluation Currency TV_NPV_CCCURR15(2) WERTV8_TR
NPV_LONG_CCRM NPV of Incoming Side in Evaluation Currency TV_NPV_LONG_CCCURR15(2) WERTV8_TR
NPV_SHORT_CCRM NPV of Outgoing Side in Evaluation Currency TV_NPV_SHORT_CCCURR15(2) WERTV8_TR
CLEAN_PRICE_CCClean Price in Valuation Currency FTI_CLEAN_PRICE_CCCURR17(2) T_PRESVAL
BPVALUE_CCBasis Point Value in Evaluation Currency TV_VALBPCURR17(2) T_PRESVAL
MAC_DURATIONMacaulay Duration TV_MAC_DURATIONDEC12(3) DEC9_3SIGN
MOD_DURATIONFisher/Weil Duration TV_FISHER_WEIL_DURATIONDEC12(3) DEC9_3SIGN
ANZGWDisplay Currency FTI_ANZGWCUKY5TCURCWAERSFFZ
BVERB1_AWNominal value - short (display currency) BVERB1_AWCURR15(2) WERTV8
BFORD1_AWNominal value - long (display currency) BFORD1_AWCURR15(2) WERTV8
BNOMINA_SP_AWNominal amount blocked in display curr. from position curr. BNOMINAL_SP_AWCURR15(2) WERTV8
BAKTAWBW_AWAsset: Acquisition value in display currency FTI_AKTAWBW_AWCURR15(2) WERTV8_TR
BAKTAWHW_AWAsset: Acquisition value in display curr. from local curr. FTI_AKTAWHW_AWCURR15(2) WERTV8_TR
BPASAWBW_AWLiability: Acquisition value in display currency FTI_PASAWBW_AWCURR15(2) WERTV8_TR
BPASAWHW_AWLiability: Acquisition value in disp. curr. from local curr. FTI_PASAWHW_AWCURR15(2) WERTV8_TR
BAKTBWBW_AWAsset: Book value in display currency from position currency FTI_AKTBWBW_AWCURR15(2) WERTV8_TR
BAKTBWHW_AWAsset: Book value in display currency from local currency FTI_AKTBWHW_AWCURR15(2) WERTV8_TR
BPASBWBW_AWLiability: Book value in display currency FTI_PASBWBW_AWCURR15(2) WERTV8_TR
BPASBWHW_AWLiability: Book value in display curr. from local currency FTI_PASBWHW_AWCURR15(2) WERTV8_TR
BAKTPOSVALBW_AWAsset: Current value in display currency FTI_AKTPOSVALBW_AWCURR15(2) WERTV8_TR
BPASPOSVALBW_AWLiability: Current value in display currency FTI_PASPOSVALBW_AWCURR15(2) WERTV8_TR
BSUMABSCHRBW_AWTotal depreciation in display currency from position curr. FTI_SUMABSCHRBW_AWCURR15(2) WERTV8_TR
BSUMABSCHRHW_AWTotal depreciation in display currency from local currency FTI_SUMABSCHRHW_AWCURR15(2) WERTV8_TR
BSUMRUECKHW_AWTotal provisions in display currency from local currency FTI_SUMRUECKHW_AWCURR15(2) WERTV8_TR
BKOSTWR_AWCapitalized incidental costs acquisition value in DC from PC BKOSTWR_AWCURR15(2) WERTV8
BKOSTHW_AWCapitalized incidental costs acquisition value in DC from LC BKOSTHW_AWCURR15(2) WERTV8
BKSTBWR_AWCap.incid.costs book value in display currency from PC BKSTBWR_AWCURR15(2) WERTV8
BKSTBHW_AWCapitalized incid.costs book value in display curr. from LC BKSTBHW_AWCURR15(2) WERTV8
BAMORTWR_AWTotal of amortization in display curr. from position curr. FTI_BAMORTWR_AWCURR15(2) WERTV8_TR
BAMORTHW_AWTotal of amortization in display curr. from local currency FTI_BAMORTHW_AWCURR15(2) WERTV8_TR
BAGIOWR_AWRemaining premium/discount in display curr. from pos. curr. FTI_BAGIOWR_AWCURR15(2) WERTV8_TR
BAGIOHW_AWRemaining premium/discount in display curr. from local curr. FTI_BAGIOHW_AWCURR15(2) WERTV8_TR
STUECKZINS_AWAccumulated Accrued Interest in DC (PC) FTI_STZINSCURR21(2) TPM_AMOUNT
NPV_PC_AWRM NPV in Display Currency FTI_NPV_PCCURR23(2)
NPV_LONG_PC_AWRM NPV Incoming Side in Display Currency Incoming Side FTI_NPV_LONG_PCCURR23(2)
NPV_SHORT_PC_AWRM NPV Outgoing Side in Display Currency Outgoing Side FTI_NPV_SHORT_PCCURR23(2)
CLEAN_PRICE_PC_AWClean Price in Position Currency FTI_CLEAN_PRICE_PCCURR17(2) T_PRESVAL
BPVALUE_PC_AWBasis Point Value in Display Currency FTI_VALBP_PCCURR17(2) T_PRESVAL
RLZTG_KRemaining Term in Days (Key Figure) FTI_RLZTGKDEC7DEC7
UEBTG_KOverdue Period in Days (Key Figure) FTI_UEBTGKDEC7DEC7
VAL_TI_PCSecurity Valuation in Position Currency FTI_VAL_TI_PCCURR21(2) TPM_AMOUNT
VAL_TI_LCSecurity Valuation in Local Currency FTI_VAL_TI_LCCURR21(2) TPM_AMOUNT
VAL_TI_DCSecurity Valuation in Display Currency (from Position Crcy) FTI_VAL_TI_DCCURR21(2) TPM_AMOUNT
VAL_FX_LCForeign Currency Valuation in Local Currency FTI_VAL_FX_LCCURR21(2) TPM_AMOUNT
VAL_CH_TI_PCValuation of Cap. Costs, Security, in Position Currency FTI_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_LCValuation of Cap. Costs, Security, in Local Currency FTI_VAL_CH_TI_LCCURR21(2) TPM_AMOUNT
VAL_CH_TI_DCValuation of Cap. Costs, Security, in Display Crcy (from PC) FTI_VAL_CH_TI_DCCURR21(2) TPM_AMOUNT
VAL_CH_FX_LCValuation of Capitalized Costs, FX, in Local Currency FTI_VAL_CH_FX_LCCURR21(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
.INCLU--AP 0
TEST_MMTest Characteristic FTI_TEST_MMCHAR4
TEST_KZTest Key Figure in Display Currency FTI_TEST_KZCURR15(2)

Key field Non-key field



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

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

How to access SAP table VTVBARW_TR

Within an ECC or HANA version of SAP you can also view further information about VTVBARW_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!