VTVDETA_FX SAP (Foreign Exchange: Cumulative Values) Structure details

Dictionary Type: Structure
Description: Foreign Exchange: Cumulative Values




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




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

VTVDETA_FX 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 "Foreign Exchange: Cumulative Values" 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_FX TYPE VTVDETA_FX.

The VTVDETA_FX table consists of various fields, each holding specific information or linking keys about Foreign Exchange: Cumulative Values 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: Cannot Be Enhanced


SAP VTVDETA_FX 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
RANTYPContract Type RANTYPCHAR1RANTYP
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
SAKTIVActive status of financial transaction (drilldown reporting) FTI_SAKTIVCHAR1FTI_SAKTIV
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
HKONTGeneral ledger account FTI_HKONTCHAR10SKB1ALPHASAKNR
FINPROJFinance Project TB_TFPROJCHAR13T_TFPROJ
DVTRABContract Conclusion Date TB_DVTRABDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
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
VONDATStart Date of Evaluation DVONDATDATS8DATUM
BISDATDate of evaluation end DBISDATDATS8DATUM
RSTICHKey date reference RSTICHCHAR1RSTICH
PARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SBEWARTFlow Type SBEWARTCHAR4TZB0ASBEWART
SBEWEBEPosting Status of Flow TB_SBEWEBECHAR1T_SBEWEBE
SBFREIRelease Given for Flow to Be Posted? TB_SBFREICHAR1XFELD
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
DFAELLDue date DFAELLDATS8DATUM
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
RAHABKIShort key for own house bank TB_RHABKICHAR5T012HBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5T012KHKTID
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
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
BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
WZBETRCurrency of payment amount FTI_SCWHRCUKY5TCURCWAERS
BHWBETRPayment Amount in Local Currency TB_HWBETRCURR13(2) WERTV7
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
SPLWHRProfit/loss currency SPLWHRCUKY5Assigned to domainWAERS
EHBETRProfit/loss amount in local currency EHBETRCURR13(2) WERTV7
D_ERFOLGPLWProfit/loss amount in currency of profit/loss FTI_ERFOLGPLWCURR15(2) WERTV8_TR
GVBETRDelta provisions/unrealized gains and losses LC GVBETRCURR13(2) WERTV7
KBBWHRChange in nominal purchase value KBBWHRCURR13(2) WERTV7
VKBBWHRChange in nominal value: Sale VKBBWHRCURR13(2) WERTV7
WGSCHFT1Currency Borrowing/Sale FTI_WGSCH1CUKY5Assigned to domainWAERS
WGSCHFT2Currency Investment/Purchase FTI_WGSCH2CUKY5Assigned to domainWAERS
D_ASTUECKChange in no. of units (for unit-quoted securities) D_ASTUECKDEC15(5) ASTUECK

Key field Non-key field



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

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

How to access SAP table VTVDETA_FX

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