VTVDETA_MM SAP (Money Market: Cumulative Values) Structure details

Dictionary Type: Structure
Description: Money Market: Cumulative Values




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




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

VTVDETA_MM 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 "Money Market: 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_MM TYPE VTVDETA_MM.

The VTVDETA_MM table consists of various fields, each holding specific information or linking keys about Money Market: 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_MM 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
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
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5Assigned to domainWAERS
SHWHRLocal Currency TB_SHWHRCUKY5Assigned to domainWAERS
BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
BHWBETRPayment Amount in Local Currency TB_HWBETRCURR13(2) WERTV7
EBBETR-->Profit/loss amount in position/transaction currency EBBETRCURR13(2) WERTV7
EHBETRProfit/loss amount in local currency EHBETRCURR13(2) WERTV7
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_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
PABGERFBWRevenue accrued/deferred in position currency (PC) PABGERFBWCURR15(2) WERTV8_TR
PABGERFHWRevenue Accrued/Deferred in Local Currency PABGERFHWCURR15(2) WERTV8_TR
D_ASTUECKChange in no. of units (for unit-quoted securities) D_ASTUECKDEC15(5) ASTUECK
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

Key field Non-key field



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

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

How to access SAP table VTVDETA_MM

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