VTVDETA_DE SAP (Derivatives: Cumulative Values) Structure details

Dictionary Type: Structure
Description: Derivatives: Cumulative Values




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




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

VTVDETA_DE 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 "Derivatives: 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_DE TYPE VTVDETA_DE.

The VTVDETA_DE table consists of various fields, each holding specific information or linking keys about Derivatives: Cumulative Values data available in SAP. These include BUKRS (Company Code), RPORTB (Portfolio), WAERS (Currency Key), 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 VTVDETA_DE 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RPORTBPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
RANTYPContract Type RANTYPCHAR1RANTYP
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SFGTYPTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
SAKTIVActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8Assigned to domainUSTRU
FINPROJFinance Project TB_TFPROJCHAR13T_TFPROJ
DBLFZTerm Start TB_DBLFZDATS8DATUM
DELFZTerm End TB_DELFZDATS8DATUM
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
RDEALERTrader RDEALERCHAR12Assigned to domainRDEALER
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
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
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5Assigned to domainWAERS
SUWHRUnderlying currency SUWHRCUKY5Assigned to domainWAERS
WGSCHFT1Currency of Outgoing Side TB_WGSCHF1CUKY5Assigned to domainWAERS
WGSCHFT2Currency of Incoming Side TB_WGSCHF2CUKY5Assigned to domainWAERS
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
D_ZBETRPayment amount in payment currency D_CASHCWCURR15(2) WERTV8_TR
D_ZBETRHWPayment amount in local currency D_CASHHWCURR15(2) WERTV8_TR
D_WZBETRPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
D_EBETR-->Profit/loss amount in position currency D_ERFOLGBWCURR15(2) WERTV8_TR
D_EBETRHWProfit/Loss Amount in Local Currency D_ERFOLGHWCURR15(2) WERTV8_TR
D_BNOMBWChange in nominal value in position currency D_BNOMBWCURR15(2) WERTV8_TR
D_BNOMBW1Change in nominal value in position currency D_BNOMBWCURR15(2) WERTV8_TR
D_BNOMBW2Change in nominal value in position currency D_BNOMBWCURR15(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_BEW_PAS_OPRLiability: Delta Eval. Option Premium (Borrow/Sale) in PC/TC FTI_D_BEW_PAS_OPRCURR15(2) WERTV8_TR
D_BEW_PAS_OPR_HWLiability: Delta Eval. Option Premium (Borrowing/Sale) in LC FTI_D_BEW_PAS_OPR_HWCURR15(2) WERTV8_TR
D_FXBEW_PAS_OPR_HWDelta Evaluation Forex Liability Option Premium in LC FTI_D_FXBEW_PAS_OPR_HWCURR15(2) WERTV8_TR
D_BEW_AKT_OPRAsset: Delta Eval. Option Premium (Borrowing/Sale in PC/TC FTI_D_BEW_AKT_OPRCURR15(2) WERTV8_TR
D_BEW_AKT_OPR_HWAsset: Delta Eval. Option Premium (Borrowing/Sale) in LC FTI_D_BEW_AKT_OPR_HWCURR15(2) WERTV8_TR
D_FXBEW_AKT_OPR_HWDelta Evaluation Forex Capitalized Option Premium in LC FTI_D_FXBEW_AKT_OPR_HWCURR15(2) WERTV8_TR
PABGERFBWRevenue accrued/deferred in position currency (PC) PABGERFBWCURR15(2) WERTV8_TR
PABGERFHWRevenue Accrued/Deferred in Local Currency PABGERFHWCURR15(2) WERTV8_TR

Key field Non-key field



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

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

How to access SAP table VTVDETA_DE

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