VTVDETM_WP SAP (Securities: Characteristics for Cumulative Values) Structure details

Dictionary Type: Structure
Description: Securities: Characteristics for Cumulative Values




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




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

VTVDETM_WP 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 "Securities: Characteristics for 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_VTVDETM_WP TYPE VTVDETM_WP.

The VTVDETM_WP table consists of various fields, each holding specific information or linking keys about Securities: Characteristics for 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: Can be enhanced (character-type or numeric)


SAP VTVDETM_WP 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
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
RANLSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
SBILKBalance Sheet Indicator SBILKCHAR2TW11SBILK
BUCHST_BSEPosting status for position determination (securities) BUCHST_BSECHAR1BUCHST
HKONTGeneral ledger account FTI_HKONTCHAR10SKB1ALPHASAKNR
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
NORDEROrder Number NORDERNUMC8NUM8ORD
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
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
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
KBNEWE_ENominal Value per Stock (Independent of Currency) FTI_VVBNEWE_EDEC15(6) VVKWKURS
KZAHLAKT_EPay-in rate FTI_KZAHLAKT_EDEC10(7) DEC3_7
VONDATStart Date of Evaluation DVONDATDATS8DATUM
BISDATDate of evaluation end DBISDATDATS8DATUM
RSTICHKey date reference RSTICHCHAR1RSTICH
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
DFAELLDue date DFAELLDATS8DATUM
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
JFDBUCRelevance to CM FTI_FDBUCCHAR1FTI_FDBUC
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
BANKK_HBBank key of house bank FTI_BANKKCHAR15BANKKBNK
BANKN_HBBank account number of house bank FTI_BANKNCHAR18BANKN
BANKK_BPBank key of business partner bank FTI_BANKKPCHAR15BANKKBNK
BANKN_BPBank account number of business partner FTI_BANKNPCHAR18BANKN
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
JAHRCalendar year TB_JAHRNUMC4GJAHRGJAHR
MONATCalendar month TB_MONATNUMC2TB_MONAT
WOCHECalendar Week FTI_WOCHENUMC2NUMC2
MONAT_JAHRCalendar Month/Year FTI_MONTH_YEARNUMC6PERIMCPERIOD
WOCHE_JAHRCalendar Week/Year FTI_WEEK_YEARNUMC6PERIMCPERIOD
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
GL_ACCOUNT_DNumber of G/L Account: Debit FTI_GLACC_DCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
GL_ACCOUNT_CNumber of G/L Account: Credit FTI_GLACC_CCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
DBESTANDPosition value date DBESTANDDATS8DATUM
DORDEROrder day DORDERDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DSCHLUSSDate of business closing VVDSCHLUSSDATS8DATUM
BUCHSTPosting Status of Flow for CFM (Operative Only) BUCHST_CFMCHAR1BUCHST_CFM
SBEWARTFlow Type SBEWARTCHAR4TZB0ASBEWART
RDEALERTrader RDEALERCHAR12TZDEARDEALER
RHANDPLExchange VVRHANDPLCHAR10TWH01VVRHANDPLWHP
RAHABKIShort key for own house bank TB_RHABKICHAR5T012HBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5T012KHKTID
PAYINDPayment Status of Flows TB_SPAYINDCHAR1T_SPAYIND
GSVGANGTR transaction activity for securities GSVGANGNUMC3GSVGANG
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
KMNRCorporate Action Number KMNRCHAR13VWKMKOALPHAVKMNRKMA

Key field Non-key field



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

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

How to access SAP table VTVDETM_WP

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