VTVDETA SAP (Market Risk: For a Given Period) Structure details

Dictionary Type: Structure
Description: Market Risk: For a Given Period




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




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

VTVDETA 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 "Market Risk: 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 TYPE VTVDETA.

The VTVDETA table consists of various fields, each holding specific information or linking keys about Market Risk: 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: Cannot Be Enhanced


SAP VTVDETA 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
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
AUSWTEvaluation type in Risk Management TV_AUSWTCHAR4JBREVALJBREVAL
WBARWERDisplay Currency FTI_AZGWMRCUKY5TCURCWAERS
SZENARIScenario TV_SZENARICHAR10VTVSZKOT_SZENARIOSZES_VTVSZKO_SZENARIO
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
RANLSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLVDContract Number RANLCHAR13VDARLALPHARANLRAN
PARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
DELFZEnd of Term DELFZDATS8DATUM
HORIZONTCalculation horizon TV_HORIZONDATS8DATUM
AKTUDATEvaluation Date TV_AKTUDATDATS8DATUM
RANTYP_RContract type FTI_RANTYPCHAR1FTI_RANTYP
RREFKONT_RAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
SPUTCALLPut/call indicator TI_SPUTCALNUMC1T_SPUTCAL
DDISPOPayment Date DDISPODATS8DATUM
GLIEDGrouping GLIEDCHAR10T038PGLIEDFGL
BARWERTNet present value in display currency TV_BARWECURR17(2) T_PRESVAL
CASHFLPayment amount TV_CASHFLCURR15(2) WERTV8
VALBPBasis Point Value in Evaluation Currency TV_VALBPCURR17(2) T_PRESVAL
FXEXPOSURECurrency exposure TV_EXPOSUCURR15(2) WERTV8
CFWAERSCurrency for cash flow and FX exposure TV_CFWAERSCUKY5TCURCWAERS
PKONDInterest rate TV_PKONDDEC10(7) DECV3_7
CASHFL_AWPayment amount in display currency from payment currency BZBETR_AWCURR13(2) WERTV7
FXEXPOSURE_AWForeign Currency Exposure in Display Currency FTI_EXPOSU_AWCURR15(2) WERTV8
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 BP_LEG_ORG_NEWCHAR2TB032BU_LEGAL_ORG
NATIONNationality BP_CNTR_NCHAR3T005LAND1
STATECitizenship BP_CNTR_STCHAR3T005LAND1
GROUP_IDBusiness Partner Grouping BP_GRP_ID_NEWCHAR4TB001BU_GROUP
GROUP_DTarget Group BP_GROUP_DCHAR4TP13BP_GROUP_D
STAFF_GRPEmployee Group BP_STAFF_GCHAR4TP05BP_STAFF_G
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

Key field Non-key field



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

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

How to access SAP table VTVDETA

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