VTVDETA_DL SAP (Operative Loans: For a Given Period) Structure details

Dictionary Type: Structure
Description: Operative Loans: For a Given Period




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




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

VTVDETA_DL 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 "Operative Loans: 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_DL TYPE VTVDETA_DL.

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


SAP VTVDETA_DL 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
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLVDLoan number RANLDCHAR13VDARLALPHARANLRAD
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DBFSZDate of start of fixed period VVDBFSZDATS8DATUM
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
XAKTFile Number XAKTCHAR32CHAR32
SDTYPLoans Class VVSDTYPNUMC3TD02VVSDTYP
STITELLoan Type Indicator STITELNUMC3TD03ASTITEL
SFRISTLoan Term SFRISTNUMC2TD09SFRIST
SSICHERPrimary collateral SSICHERCHAR4TD01SSICH
SVZWECKPurpose of Loan SVZWECKCHAR2TD07SVZWK
DBEWIApproval date VVDBEWIDATS8DATUM
SBEALoan Processing Indicator VVSBEANUMC2VVSBEA
SSOLISTPlan/Actual principle VVSSOLISTCHAR1VVSSOLIST
SSTATIStatus of data record SSTATINUMC2TZC37STATI
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
SDUNNCMPSummarization Level for Dunning Letter SDUNNCMPCHAR2SDUNNCMP
XNODUNNExclude Loan from Dunning Run XNODUNNCHAR1XFELD
MABERDunning Area MABERCHAR2T047MMABER
MAHNSDunning level MAHNS_DNUMC1MAHNS
MADATLast dunned on MADATDATS8DATUM
SMAHNMLoan Manual Dunning Level VVSMAHNMCHAR1TDMAHNS_MANVVSMAHNM
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SSONDERSpecial treatment of loan SSONDERNUMC2TD10SSONDER
SB_VERTRAGContract clerk SB_VERTRAG_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SB_BUCHHAccounting clerks SB_BUCHH_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SB_PROLORollover clerk SB_PROLO_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SFIWOIndicator: Type of Residential Object Financing SFIWOCHAR2TD15SFIWO
SOBJARTObject type SOBJARTNUMC2TIV5ASOBJART
RANLALT1Alternative Identification RANLALT1CHAR13CHAR13
RANLALT2Alternative identification 2 RANLALT2CHAR13CHAR13
SGR1Group Key 1 (Freely Available) SGRP1CHAR6TDDG1SGRP1
SGR2Group Key 2 (Freely Available) SGRP2CHAR6TDDG2SGRP2
SGRP3Group Key 3 (Freely Available) SGRP3CHAR6TDDG3SGRP3
SGRP4Group Key 4 (Freely Available) SGRP4CHAR6TDDG4SGRP4
SAKTPASIndicator: Asset/Liability Transaction VVSAKTPASCHAR1VVSAKTPAS
SBILKBalance Sheet Indicator SBILKCHAR2TW11SBILK
HKONTGeneral ledger account FTI_HKONTCHAR10SKB1ALPHASAKNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
DZUSAGELoan - Date of Commitment by Lender DZUSAGEDATS8DATUM
SNUTZARTMain usage type of object VVSNUTZNUMC4TIV01SNUNR
SREPAYMENTRepayment Status of Loan on Key Date SREPAYMENTCHAR1SREPAYMENT
SFIBGAsset Grouping Indicator SFIBGNUMC4TW08SFIBG
SREGIONSales Region VVSREGIONCHAR4TD18VVSREGION
SGESSTBranch Office VVSGESSTCHAR4TD17VVSGESST
SOBEZOrganizational District VVSOBEZCHAR2CHAR2
SBEZIRKAgent District VVSBEZIRKCHAR4CHAR4
LC_CAPITALSProcessing Characteristic: Status of Capital Amounts TB_LC_CHARAC_CAPITALSCHAR1Assigned to domainT_LC_CHARACVALUEH_VD_CHARAC_CAPITALS
LC_DISBURSEMENTProcessing Characteristic: Disbursement Status TB_LC_CHARAC_DISBURSEMENTCHAR1Assigned to domainT_LC_CHARACVALUEH_VD_CHARAC_DISBURSEMENT
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
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
BUCHST_DLPosting status of flow for loans BUCHST_DLCHAR1BUCHST_DL
SBEWZITIFlow category SBEWZITICHAR4Assigned to domainSBEWZITI
SBEWARTFlow Type SBEWARTCHAR4TZB0ASBEWART
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
DDISPOPayment Date DDISPODATS8DATUM
DVALUTCalculation Date DVALUTDATS8DATUM
DORDEROrder day DORDERDATS8DATUM
RAHABKIShort key for own house bank TB_RHABKICHAR5T012HBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5T012KHKTID
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
RLZTG_K_FRemaining Term in Days (Key Figure) FTI_RLZTGK_FDEC7DEC7
UEBTG_K_FOverdue Period in Days (Key Figure) FTI_UEBTGK_FDEC7DEC7
RLZTG_FRemaining Term in Days FTI_RLZTG_FNUMC5NUMC5
RLZMO_FRemaining Term in Months FTI_RLZMO_FNUMC4NUMC4
RLZJA_FRemaining Term in Years FTI_RLZJA_FNUMC3NUMC3
UEBTG_FOverdue Period in Days FTI_UEBTG_FNUMC5NUMC5
UEBMO_FOverdue Period in Months FTI_UEBMO_FNUMC3NUMC3
UEBJA_FOverdue Period in Years FTI_UEBJA_FNUMC2NUMC2
BZBETRPayment amount in payment currency D_CASHCWCURR15(2) WERTV8_TR
BHWBETRPayment amount in local currency D_CASHHWCURR15(2) WERTV8_TR
EHBETRProfit/loss amount in local currency EHBETRCURR13(2) WERTV7
EEBETRProfit/loss amount in profit/loss currency EEBETRCURR13(2) WERTV7
BBWHRFlow Amount in Position Currency TB_BBWR_ACURR15(2) WERTV8
BHWHRFlow Amount in Local Currency TB_BBHW_ACURR15(2) WERTV8
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
SPLWHRProfit/loss currency SPLWHRCUKY5TCURCWAERS
D_BNBW_AAsset: Change in nominal value in position currency D_BNOMBW_ACURR15(2) WERTV8_TR
D_BNBW_PLiability: Change in nominal value in position currency D_BNOMBW_PCURR15(2) WERTV8_TR
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
D_BWBW_AChange in book value in position currency (asset) D_BWBW_ACURR15(2) WERTV8_TR
D_BWHW_AChange in book value in local currency (asset) D_BWHW_ACURR15(2) WERTV8_TR
D_BWBW_PChange in book value in position currency (liability) D_BWBW_PCURR15(2) WERTV8_TR
D_BWHW_PChange in book value in local currency (liability) D_BWHW_PCURR15(2) WERTV8_TR
PABGERFHWRevenue Accrued/Deferred in Local Currency PABGERFHWCURR15(2) WERTV8_TR
PABGERFPLRevenue Accrued/Deferred in Profit/Loss Currency PABGERFPLWCURR15(2) WERTV8_TR
CALC_CCYEvaluation Currency AFW_EVAL_CURRENCYCUKY5TCURCWAERS
MPKOND_AInterest rate - start (drilldown reporting characteristic) MPKOND_ANUMC3ALPHAFTI_NUMC3
MPKOND_EInterest rate - end (drilldown reporting characteristic) MPKOND_ENUMC3ALPHAFTI_NUMC3
PKOND_AInterest Rate: Start FTI_PKOND_ADEC10(7) DECV3_7
PKOND_EInterest Rate: End FTI_PKOND_EDEC10(7) DECV3_7
BZUSA_AAsset: Current commitment capital - start FTI_BZUSAACURR13(2) WERTV7
BZUSA_EAsset: Current commitment capital - end FTI_BZUSAECURR13(2) WERTV7
BNBUE_AInitial capital not guaranteed (start) FTI_BNBUEACURR13(2) WERTV7
BNBUE_EInitial capital not guaranteeed end FTI_BNBUEECURR13(2) WERTV7
BRPWR_AAsset: Remaining capital acc. to debit position in PC- start FTI_BRPWR_A_ACURR15(2) WERTV8_TR
BRPWR_EAsset: Remaining capital acc. to debit position in PC - end FTI_BRPWR_A_ECURR15(2) WERTV8_TR
BRPWR_P_ALiability: Remaining cap. acc.to debit position in PC- start FTI_BRPWR_P_ACURR15(2) WERTV8_TR
BRPWR_P_ELiability: Remaining cap. acc. to debit position in PC - end FTI_BRPWR_P_ECURR15(2) WERTV8_TR
BRPHW_AAsset: Remaining capital acc. to debit position in LC- start FTI_BRPHW_A_ACURR15(2) WERTV8_TR
BRPHW_EAsset: Remaining capital acc. to debit position in LC - end FTI_BRPHW_A_ECURR15(2) WERTV8_TR
BRPHW_P_ALiability: Remaining cap. acc. to debit position LC - start FTI_BRPHW_P_ACURR15(2) WERTV8_TR
BRPHW_P_ELiability: Remaining capital acc.to debit position LC - end FTI_BRPHW_P_ECURR15(2) WERTV8_TR
BRIWR_AAsset: Effective cap. (rem.cap.acc.to IP) in PC - start FTI_BRIWRACURR15(2) WERTV8_TR
BRIWR_EAsset: Effective cap.(rem.cap.acc.to IP) in pos. curr.- end FTI_BRIWRECURR15(2) WERTV8_TR
BRIWR_P_ALiability: Effective capital(rem.cap.acc.to IP) in pos.curr. FTI_BRIWR_P_ACURR15(2) WERTV8_TR
BRIWR_P_ELiability: Effective cap.(rem.cap.acc.to IP) in PC - end FTI_BRIWR_P_ECURR15(2) WERTV8_TR
BRIHW_AAsset: Effective capital (rem.cap.acc.to IP) in LC - start FTI_BRIHW_A_ACURR15(2) WERTV8_TR
BRIHW_EAsset: Effective capital (rem.cap.acc.to IP) in LC - end FTI_BRIHW_A_ECURR15(2) WERTV8_TR
BRIHW_P_ALiability: Effective capital (rem.cap.acc.to IP) in LC-start FTI_BRIHW_P_ACURR15(2) WERTV8_TR
BRIHW_P_ELiability: Effective capital (rem.cap.acc.to IP) in LC - end FTI_BRIHW_P_ECURR15(2) WERTV8_TR
BVAWR_AAsset: Value-dated capital in position currency - start FTI_BVAWR_A_ACURR15(2) WERTV8_TR
BVAWR_EAsset: Value-dated capital in position currency - end FTI_BVAWR_A_ECURR15(2) WERTV8_TR
BVAWR_P_ALiability: Value-dated capital in position currency - start FTI_BVAWR_P_ACURR15(2) WERTV8_TR
BVAWR_P_ELiability: Value-dated capital in position currency - end FTI_BVAWR_P_ECURR15(2) WERTV8_TR
BAVWR_AAsset: Disbursement obligation in position currency - start FTI_BAVWR_A_ACURR15(2) WERTV8_TR
BAVWR_EAsset: Disbursement obligation in position currency - end FTI_BAVWR_A_ECURR15(2) WERTV8_TR
BAVWR_P_ALiability: Disbursement obligation in position curr. - start FTI_BAVWR_P_ACURR15(2) WERTV8_TR
BAVWR_P_ELiability: Disbursement obligation in position currency -end FTI_BAVWR_P_ECURR15(2) WERTV8_TR
BKAUFWR_A_AAsset: Acquisition value in position currency - start FTI_BKAUFWR_A_ACURR15(2) WERTV8_TR
BKAUFWR_A_EAsset: Acquisition value in position currency - end FTI_BKAUFWR_A_ECURR15(2) WERTV8_TR
BKAUFHW_A_AAsset: Acquisition value in local currency - start FTI_BKAUFHW_A_ACURR15(2) WERTV8_TR
BKAUFHW_A_EAsset: Acquisition value in local currency - end FTI_BKAUFHW_A_ECURR15(2) WERTV8_TR
BKAUFWR_P_ALiability: Acquisition value in position currency - start FTI_BKAUFWR_P_ACURR15(2) WERTV8_TR
BKAUFWR_P_ELiability: Acquisition value in position currency - end FTI_BKAUFWR_P_ECURR15(2) WERTV8_TR
BKAUFHW_P_ALiability: Acquisition value in local currency - start FTI_BKAUFHW_P_ACURR15(2) WERTV8_TR
BKAUFHW_P_ELiability: Acquisition value in local currency - end FTI_BKAUFHW_P_ECURR15(2) WERTV8_TR
BVZWR_AAsset: Current Contract Capital in Position Currency - Start FTI_BVZWR_A_ACURR15(2) WERTV8_TR
BVZWR_EAsset: Current Contract Capital in Position Currency - End FTI_BVZWR_A_ECURR15(2) WERTV8_TR
BVZWR_P_ALiability: Current Contract Capital in Position Curr.- Start FTI_BVZWR_P_ACURR15(2) WERTV8_TR
BVZWR_P_ELiability: Current Contract Capital in Position Currency-End FTI_BVZWR_P_ECURR15(2) WERTV8_TR
BKKWR_AAsset: Commitment capital in position currency - start FTI_BKKWR_A_ACURR15(2) WERTV8
BKKWR_EAsset: Commitment capital in position currency - end FTI_BKKWR_A_ECURR15(2) WERTV8
BKKWR_P_ALiability: Commitment capital in position currency - start FTI_BKKWR_P_ACURR15(2) WERTV8
BKKWR_P_ELiability: Commitment capital in position currency - end FTI_BKKWR_P_ECURR15(2) WERTV8
BNOMWR_A_AAsset: Nominal value in position currency - start FTI_BNOMWR_A_ACURR15(2) WERTV8_TR
BNOMWR_A_EAsset: Nominal value in position currency - end FTI_BNOMWR_A_ECURR15(2) WERTV8_TR
BNOMWR_P_ALiability: Nominal value in position currency - start FTI_BNOMWR_P_ACURR15(2) WERTV8_TR
BNOMWR_P_ELiability: Nominal value in position currency - end FTI_BNOMWR_P_ECURR15(2) WERTV8_TR
BRPNWR_AAsset: Nominal remaining capital in position currency -start FTI_BRPNWR_A_ACURR15(2) WERTV8_TR
BRPNWR_EAsset: Nominal remaining capital in position currency - end FTI_BRPNWR_A_ECURR15(2) WERTV8_TR
BRPNWR_P_ALiability: Nominal remaining cap.in position currency- start FTI_BRPNWR_P_ACURR15(2) WERTV8_TR
BRPNWR_P_ELiability: Nominal remaining cap.in position currency- end FTI_BRPNWR_P_ECURR15(2) WERTV8_TR
BRINWR_AAsset: Nominal effective capital in position currency -start FTI_BRINWR_A_ACURR15(2) WERTV8_TR
BRINWR_EAsset: Nominal effective capital in position currency - end FTI_BRINWR_A_ECURR15(2) WERTV8_TR
BRINWR_P_ALiability: Nominal effective capital in position curr.-start FTI_BRINWR_P_ACURR15(2) WERTV8_TR
BRINWR_P_ELiability: Nominal effective capital in position curr. - end FTI_BRINWR_P_ECURR15(2) WERTV8_TR
BBUCHWR_A_AAsset: Book value in position currency - start FTI_BBUCHWR_A_ACURR15(2) WERTV8_TR
BBUCHWR_A_EAsset: Book value in position currency - end FTI_BBUCHWR_A_ECURR15(2) WERTV8_TR
BBUCHWR_P_ALiability: Book value in position currency - start FTI_BBUCHWR_P_ACURR15(2) WERTV8_TR
BBUCHWR_P_ELiability: Book value in position currency - end FTI_BBUCHWR_P_ECURR15(2) WERTV8_TR
BBUCHHW_A_AAsset: Book value in local currency - start FTI_BBUCHHW_A_ACURR15(2) WERTV8_TR
BBUCHHW_A_EAsset: Book value in local currency - end FTI_BBUCHHW_A_ECURR15(2) WERTV8_TR
BBUCHHW_P_ALiability: Book value in local currency - start FTI_BBUCHHW_P_ACURR15(2) WERTV8_TR
BBUCHHW_P_ELiability: Book value in local currency - end FTI_BBUCHHW_P_ECURR15(2) WERTV8_TR
NPV_PC_ARM NPV in Position Currency: Start FTI_NPV_PC_ACURR15(2) WERTV8_TR
NPV_PC_ERM NPV in Position Currency: End FTI_NPV_PC_ECURR15(2) WERTV8_TR
NPV_CC_ARM Net Present Value in Valuation Currency Start FTI_NPV_CC_ACURR15(2) WERTV8_TR
NPV_CC_ERM Net Present Value in Valuation Currency End FTI_NPV_CC_ECURR15(2) WERTV8_TR
CLEAN_PRICE_PC_AClean Price in Position Currency: Start FTI_CLEAN_PRICE_PC_ACURR15(2) WERTV8_TR
CLEAN_PRICE_PC_EClean Price in Position Currency: End FTI_CLEAN_PRICE_PC_ECURR15(2) WERTV8_TR
CLEAN_PRICE_CC_AClean Price in Valuation Currency - Start FTI_CLEAN_PRICE_CC_ACURR15(2) WERTV8_TR
CLEAN_PRICE_CC_EClean Price in Evaluation Currency End FTI_CLEAN_PRICE_CC_ECURR15(2) WERTV8_TR
BPVALUE_PC_ABasis Point Value in Position Currency: Start FTI_VALBP_PC_ACURR15(2) WERTV8_TR
BPVALUE_PC_EBasis Point Value in Position Currency: End FTI_VALBP_PC_ECURR15(2) WERTV8_TR
BPVALUE_CC_ABasis Point Value in Valuation Currency Start FTI_VALBP_CC_ACURR15(2) WERTV8_TR
BPVALUE_CC_EBasis Point Value in Valuation Currency End FTI_VALBP_CC_ECURR15(2) WERTV8_TR
MAC_DURATION_AMacaulay Duration: Start FTI_MAC_DURATION_ADEC12(3) DEC9_3
MAC_DURATION_EMacaulay Duration: End FTI_MAC_DURATION_EDEC12(3) DEC9_3
MOD_DURATION_AModified Duration: Start FTI_MOD_DURATION_ADEC12(3) DEC9_3
MOD_DURATION_EModified Duration: End FTI_MOD_DURATION_EDEC12(3) DEC9_3
YTM_AYield to Maturity: Start FTI_YTM_ADEC12(5) FTI_DEC7_5SIGN
YTM_EYield-to-Maturity: End FTI_YTM_EDEC12(5) FTI_DEC7_5SIGN
PEFFZINS_AEffective Interest Rate at Start of Period FTI_PEFFZINS_ADEC10(7) DEC3_7
PEFFZINS_EEffective Interest Rate at End of Period FTI_PEFFZINS_EDEC10(7) DEC3_7
STUECKE_ANumber of units / Number of transactions - start FTI_STUECKE_ADEC15(5) ASTUECK
STUECKE_ENo. of units/No. of transactions - end FTI_STUECKE_EDEC15(5) ASTUECK
BZBETR_AWPayment Amount of Flow in Display Crcy (from Pmnt Crcy) FTI_CASWCWCURR15(2) WERTV8
BHWBETR_AWPayment amount of flow in display currency from local curr. FTI_CASWHWCURR15(2) WERTV8
EHBETR_AWProfit/loss amount in display currency from local currency EHBETR_AWCURR15(2) WERTV8_TR
EEBETR_AWProfit/Loss Amount in DC (from P/L Currency) EEBETR_AWCURR15(2) WERTV8_TR
BBWHR_AWFlow Amount in Display Currency (From Position Currency) FTI_BBWR_AWCURR15(2) WERTV8
BHWHR_AWFlow Amount in Display Currency from Local Currency FTI_BBHW_AWCURR15(2) WERTV8
D_BNBW_A_AWAsset: Change in nominal value in display currency FTI_D_BNOMBW_A_AWCURR15(2) WERTV8_TR
D_BNBW_P_AWLiability: Change in nominal value in display currency FTI_D_BNOMBW_P_AWCURR15(2) WERTV8_TR
D_AWBW_A_AWAsset: Change in acquisition value in display currency FTI_D_AWBW_A_AWCURR15(2) WERTV8_TR
D_AWHW_A_AWAsset: Change in acquis.value in disp.curr. from local curr. FTI_D_AWHW_A_AWCURR15(2) WERTV8_TR
D_AWBW_P_AWChange in acquisition value in display currency (liability) FTI_D_AWBW_P_AWCURR15(2) WERTV8_TR
D_AWHW_P_AWLiability: Change in acquis.val.in disp.curr. from loc.curr. FTI_D_AWHW_P_AWCURR15(2) WERTV8_TR
D_BWBW_A_AWAsset: Change in book value in display currency FTI_D_AKTBWBW_AWCURR15(2) WERTV8_TR
D_BWHW_A_AWAsset: Change in book value in disp. curr. from local curr. FTI_D_AKTBWHW_AWCURR15(2) WERTV8_TR
D_BWBW_P_AWLiability: Change in book value in display currency FTI_D_PASBWBW_AWCURR15(2) WERTV8_TR
D_BWHW_P_AWLiability: Change in book val. in disp.curr.from local curr. FTI_D_PASBWHW_AWCURR15(2) WERTV8_TR
PABGERFHW_AWRevenue accrued/deferred in display currency (local curr.) FTI_PABGERFHW_AWCURR15(2) WERTV8_TR
PABGERFPL_AWRevenue Accrued/Deferred in DC (from P/L Currency) FTI_PABGERFPLW_AWCURR15(2) WERTV8_TR
ANZGWDisplay Currency FTI_ANZGWCUKY5TCURCWAERSFFZ
BZUSA_A_AWAsset: Current commitment capital in display currency -start FTI_BZUSWACURR13(2) WERTV7
BZUSA_E_AWAsset: Current commitment capital in display currency -start FTI_BZUSWECURR13(2) WERTV7
BNBUE_A_AWInitial not guaranteed capital start in display currency FTI_BNBUWACURR13(2) WERTV7
BNBUE_E_AWInitial non-guaranteed capital end in display currency FTI_BNBUWECURR13(2) WERTV7
BRPWR_A_AWAsset: Remaining cap. acc. to debit position in DC(PC)-start FTI_BRPWR_A_A_AWCURR15(2) WERTV8_TR
BRPWR_E_AWAsset: Remaining capital acc. to debit pos. in DC(PC) - end FTI_BRPWR_A_E_AWCURR15(2) WERTV8_TR
BRPWR_P_A_AWLiability: Remaining cap. acc.to debit pos.in DC(PC) - start FTI_BRPWR_P_A_AWCURR15(2) WERTV8_TR
BRPWR_P_E_AWLiability: Remaining cap.acc.to debit position in DC(PC)-end FTI_BRPWR_P_E_AWCURR15(2) WERTV8_TR
BRPHW_A_AWAsset: Remaining cap. acc. to debit position in DC(LC)-start FTI_BRPHW_A_A_AWCURR15(2) WERTV8_TR
BRPHW_E_AWAsset: Remaining capital acc. to debit position DC(LC) - end FTI_BRPHW_A_E_AWCURR15(2) WERTV8_TR
BRPHW_P_A_AWLiability: Remaining cap.acc.to debit position DC(LC)- start FTI_BRPHW_P_A_AWCURR15(2) WERTV8_TR
BRPHW_P_E_AWLiability: Remaining cap. acc.to debit position DC(LC) - end FTI_BRPHW_P_E_AWCURR15(2) WERTV8_TR
BRIWR_A_AWAsset: Effective cap. (rem.cap.acc.to IP) in DC(PC) - start FTI_BRIWWACURR15(2) WERTV8_TR
BRIWR_E_AWAsset: Effective capital (rem.cap.acc.to IP) in DC(PC) - end FTI_BRIWWECURR15(2) WERTV8_TR
BRIWR_P_A_AWLiability: Effective cap.(rem.cap.acc.to IP) in DC(PC)-start FTI_BRIWR_P_A_AWCURR15(2) WERTV8_TR
BRIWR_P_E_AWLiability: Effective cap.(rem.cap.acc.to IP) in DC(PC) - end FTI_BRIWR_P_E_AWCURR15(2) WERTV8_TR
BRIHW_A_AWAsset: Effective capital (rem.cap.acc.to IP) in DC(LC)-start FTI_BRIHW_A_A_AWCURR15(2) WERTV8_TR
BRIHW_E_AWAsset: Effective capital (rem.cap.acc.to IP) in DC(LC) - end FTI_BRIHW_A_E_AWCURR15(2) WERTV8_TR
BRIHW_P_A_AWLiability: Effective capital(rem.cap.acc.to IP) DC(LC)-start FTI_BRIHW_P_A_AWCURR15(2) WERTV8_TR
BRIHW_P_E_AWLiability: Effective cap.(rem.cap.acc.to IP) in DC(LC) - end FTI_BRIHW_P_E_AWCURR15(2) WERTV8_TR
BVAWR_A_AWAsset: Value-dated capital in display currency - start FTI_BVAWR_A_A_AWCURR15(2) WERTV8_TR
BVAWR_E_AWAsset: Value-dated capital in display currency - end FTI_BVAWR_A_E_AWCURR15(2) WERTV8_TR
BVAWR_P_A_AWLiability: Value-dated capital in display currency - start FTI_BVAWR_P_A_AWCURR15(2) WERTV8_TR
BVAWR_P_E_AWLiability: Value-dated capital in display currency - end FTI_BVAWR_P_E_AWCURR15(2) WERTV8_TR
BAVWR_A_AWAsset: Disbursement obligation in display currency - start FTI_BAVWR_A_A_AWCURR15(2) WERTV8_TR
BAVWR_E_AWAsset: Disbursement obligation in display currency - end FTI_BAVWR_A_E_AWCURR15(2) WERTV8_TR
BAVWR_P_A_AWLiability: Disbursement obligation in display currency-start FTI_BAVWR_P_A_AWCURR15(2) WERTV8_TR
BAVWR_P_E_AWLiability: Disbursement obligation in display currency - end FTI_BAVWR_P_E_AWCURR15(2) WERTV8_TR
BKAUFWR_A_A_AWAsset: Acquis.value in display curr. from pos. curr. - start FTI_BKAUFWR_A_A_AWCURR15(2) WERTV8_TR
BKAUFWR_A_E_AWAsset: Acquisition value in display curr.from pos.curr.- end FTI_BKAUFWR_A_E_AWCURR15(2) WERTV8_TR
BKAUFHW_A_A_AWAsset: Acq. value in displ. curr. from local. curr. - start FTI_BKAUFHW_A_A_AWCURR15(2) WERTV8_TR
BKAUFHW_A_E_AWAsset: Acquis. value in displ. curr. from local. curr. - end FTI_BKAUFHW_A_E_AWCURR15(2) WERTV8_TR
BKAUFWR_P_A_AWLiability: Acquis. value in disp.curr. from pos.curr - start FTI_BKAUFWR_P_A_AWCURR15(2) WERTV8_TR
BKAUFWR_P_E_AWLiability: Acquis. value in disp. curr. from pos. curr - end FTI_BKAUFWR_P_E_AWCURR15(2) WERTV8_TR
BKAUFHW_P_A_AWLiability: Acquis.val.in displ.curr.from local curr. - start FTI_BKAUFHW_P_A_AWCURR15(2) WERTV8_TR
BKAUFHW_P_E_AWLiability: Acquis.value in displ.curr.from local curr. - end FTI_BKAUFHW_P_E_AWCURR15(2) WERTV8_TR
BVZWR_A_AWAsset: Current Contract Capital in Display Currency - Start FTI_BVZWR_A_A_AWCURR15(2) WERTV8_TR
BVZWR_E_AWAsset: Current Contract Capital in Display Currency - End FTI_BVZWR_A_E_AWCURR15(2) WERTV8_TR
BVZWR_P_A_AWLiability: Current Contract Capital in Display Curr.- Start FTI_BVZWR_P_A_AWCURR15(2) WERTV8_TR
BVZWR_P_E_AWLiability: Current Contract Capital in Display Currency-End FTI_BVZWR_P_E_AWCURR15(2) WERTV8_TR
BKKWR_A_AWAsset: Commitment capital in display currency - start FTI_BKKWR_A_A_AWCURR15(2) WERTV8
BKKWR_E_AWAsset: Commitment capital in display currency - end FTI_BKKWR_A_E_AWCURR15(2) WERTV8
BKKWR_P_A_AWLiability: Commitment capital in display currency - start FTI_BKKWR_P_A_AWCURR15(2) WERTV8
BKKWR_P_E_AWLiability: Commitment capital in display currency - end FTI_BKKWR_P_E_AWCURR15(2) WERTV8
BRPNWR_A_AWAsset: Nominal remaining capital in display currency -start FTI_BRPNWR_A_A_AWCURR15(2) WERTV8_TR
BRPNWR_E_AWAsset: Nominal remaining capital in display currency - end FTI_BRPNWR_A_E_AWCURR15(2) WERTV8_TR
BRPNWR_P_A_AWLiability: Nominal remaining cap.in display currency- start FTI_BRPNWR_P_A_AWCURR15(2) WERTV8_TR
BRPNWR_P_E_AWLiability: Nominal remaining cap.in display currency- end FTI_BRPNWR_P_E_AWCURR15(2) WERTV8_TR
BNOMWR_A_A_AWAsset: Nominal value in display currency - start FTI_BNOMWR_A_A_AWCURR15(2) WERTV8_TR
BNOMWR_A_E_AWAsset: Nominal value in display currency - end FTI_BNOMWR_A_E_AWCURR15(2) WERTV8_TR
BNOMWR_P_A_AWLiability: Nominal value in display currency - start FTI_BNOMWR_P_A_AWCURR15(2) WERTV8_TR
BNOMWR_P_E_AWLiability: Nominal value in display currency - end FTI_BNOMWR_P_E_AWCURR15(2) WERTV8_TR
BRINWR_A_AWAsset: Nominal effective capital in display currency - start FTI_BRINWR_A_A_AWCURR15(2) WERTV8_TR
BRINWR_E_AWAsset: Nominal effective capital in display currency - end FTI_BRINWR_A_E_AWCURR15(2) WERTV8_TR
BRINWR_P_A_AWLiability: Nominal effective capital in display curr.- start FTI_BRINWR_P_A_AWCURR15(2) WERTV8_TR
BRINWR_P_E_AWLiability: Nominal effective capital in display curr. - end FTI_BRINWR_P_E_AWCURR15(2) WERTV8_TR
BBUCHWR_A_A_AWAsset: Book value in display curr. from pos. curr. - start FTI_BBUCHWR_A_A_AWCURR15(2) WERTV8_TR
BBUCHWR_A_E_AWAsset: Book value in display curr. from position curr. - end FTI_BBUCHWR_A_E_AWCURR15(2) WERTV8_TR
BBUCHWR_P_A_AWLiability: Book value in display curr. from pos.curr.- start FTI_BBUCHWR_P_A_AWCURR15(2) WERTV8_TR
BBUCHWR_P_E_AWLiability: Book value in display curr. from pos. curr. - end FTI_BBUCHWR_P_E_AWCURR15(2) WERTV8_TR
BBUCHHW_A_A_AWAsset: Book value in display curr. from local curr. - start FTI_BBUCHHW_A_A_AWCURR15(2) WERTV8_TR
BBUCHHW_A_E_AWAsset: Book value in display curr. from local curr. - end FTI_BBUCHHW_A_E_AWCURR15(2) WERTV8_TR
BBUCHHW_P_A_AWLiability: Book value in displ.curr. from local curr.- start FTI_BBUCHHW_P_A_AWCURR15(2) WERTV8_TR
BBUCHHW_P_E_AWLiability: Book value in display curr. from local curr.- end FTI_BBUCHHW_P_E_AWCURR15(2) WERTV8_TR
NPV_PC_A_AWRM NPV in Display Currency: Start FTI_NPV_PC_A_AWCURR15(2) WERTV8_TR
NPV_PC_E_AWRM NPV in Display Currency: End FTI_NPV_PC_E_AWCURR15(2) WERTV8_TR
CLEAN_PRICE_PC_A_AWClean Price in Display Currency: Start FTI_CLEAN_PRICE_AW_ACURR15(2) WERTV8_TR
CLEAN_PRICE_PC_E_AWClean Price in Display Currency: End FTI_CLEAN_PRICE_AW_ECURR15(2) WERTV8_TR
BPVALUE_PC_A_AWBasis Point Value in Display Currency: Start FTI_VALBP_AW_ACURR15(2) WERTV8_TR
BPVALUE_PC_E_AWBasis Point Value in Display Currency: End FTI_VALBP_AW_ECURR15(2) WERTV8_TR
NUMBRNumber of translation key in currency translation CFNUMBRNUMC3T242QCFNUMBRNBR
NUMBR_LCTranslation Type for Currency Translation into Local Crcy FTI_NUMBR_LCNUMC3T242QCFNUMBRNBR_LC
KURSAPrice type for evaluations VVKURSAUSWCHAR2TW56VVSKURSART
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VVRANLWINo. of the secondary index description for class data VVRANLWINUMC2TWX1VVRANLWI
CASHFIndicator for cash flow calculation up to end of term SCASHFLOWCHAR1XFELD
BILSTReference Date FTI_BILSTDATS8DATUM
BILST2Reference Date FTI_BILST2DATS8DATUM
BILST_REF_BPositions: Remaining Term/Overdue Period Based On FTI_BILST_REF_BCHAR1FTI_BILST_REF_BFTI_BILST_REF_POS
BILST_REF_FFlows: Remaining Term/Overdue Period Based On FTI_BILST_REF_FCHAR1FTI_BILST_REF_FFTI_BILST_REF_FLOWS
STORNOEvaluate Reversed Flows FTI_STORNOCHAR1XFELD
AUSWTEvaluation Type (Risk Management) FTI_EVALTYPECHAR4JBREVALJBREVALFTI_EVALTYPE
FLG_SEProduct Group Securities: Yes/No FTI_LDB_FLG_SECHAR1XFELDFTI_FLG_SE
FLG_LOProduct Group Loans: Yes/No FTI_LDB_FLG_LOCHAR1XFELDFTI_FLG_LO
FLG_OTCProduct Group OTC (MM, FX, DE): Yes/No FTI_LDB_FLG_OTCCHAR1XFELDFTI_FLG_OTC
FLG_LOFProduct Group Listed Derivatives (Futures): Yes/No FTI_LDB_FLG_LOFCHAR1XFELDFTI_FLG_LOF
FLG_COUPLING_SECACCGRPInterpret Assignment of Sec. Account to Sec. Account Group FTI_LDB_FLG_COUPLING_SECACCGRPCHAR1XFELDFTI_FLG_SECACCGRP
FLG_HISTORIC_ACCASSREFIndicator: Historical Account Assignment Reference FTI_LDB_FLG_HISTORIC_ACCASSREFCHAR1XFELDFTI_FLG_HISTKR
FLG_CONDENSESummarize Results (for Query) FTI_CONDENSECHAR1XFELDFTI_CONDENSE_ID
FLG_NO_NULLHide Zero Records FTI_NO_NULLCHAR1XFELDFTI_NO_NULL_ID
FLG_EXCLUDING_PLANExclude Plan Data (for Query) FTI_EXCL_PLANCHAR1XFELDFTI_CONDENSE_ID
FLG_REVERSED_FLOWSProcess Reversed Flows (for Query) FTI_REVERSED_FLOWSCHAR1XFELDFTI_CONDENSE_ID

Key field Non-key field



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

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

How to access SAP table VTVDETA_DL

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