VTVDETA_TR_CF SAP (Operative CFM: Payments) Structure details

Dictionary Type: Structure
Description: Operative CFM: Payments




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




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

VTVDETA_TR_CF 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 CFM: Payments" 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_TR_CF TYPE VTVDETA_TR_CF.

The VTVDETA_TR_CF table consists of various fields, each holding specific information or linking keys about Operative CFM: Payments data available in SAP. These include VONDAT (Start Date of Evaluation), BISDAT (Date of evaluation end), MANDT (Client), BUKRS (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_TR_CF 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
VONDATStart Date of Evaluation DVONDATDATS8DATUM
BISDATDate of evaluation end DBISDATDATS8DATUM
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
PORTFOLIOPortfolio as Differentiation Characteristic TPM_PORTFOLIO_DIFFCHAR10TWPOBRPORTB
SECURITY_IDSecurity ID Number VVRANLWCHAR13VWPANLAALPHAWP_RANLRANSECURITY_F4
LOANS_CONTRACTContract Number RANLCHAR13VDARLALPHARANLRAN
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
ACCOUNT_GROUPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10TRGT_SECACCGRPTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
SECURITY_ACCOUNTSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10TRFT_POS_ACCOUNTTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
EXTERNAL_ACCOUNTExternal Account (Position) TPM_EXT_ACCOUNT_POSCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
DIFF_CURRENCYCurrency as Differentiation Term TPM_DIFF_CURRENCYCUKY5Assigned to domainWAERSTPM_DIFF_CURR
EXTACC_DEALExternal Account (Transaction) TPM_EXT_ACCOUNT_DEALCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
FLAG_LONG_SHORTIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
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_BUSTRANSCATNUMC4Assigned to domainTPM_BUSTRANSCAT
LOTPOS_INIT_DATEPosition Acquisition Date of a Lot FTI_LOTPOSITION_INIT_DATEDATS8TPM_POSITION_DATE
LOTPOS_ORG_DATEOriginal Position Acquisition Date of a Lot FTI_LOTPOSITION_ORG_DATEDATS8TPM_POSITION_DATE
LOTGEN_BUKRSCompany Code of Lot-Generating Transaction FTI_LOTGENERATION_BUKRSCHAR4Assigned to domainBUKRSH_T001
LOTGEN_DEALNRLot-Generating Transaction Number (Listed Derivatives) FTI_LOTGENERATION_DEALNRCHAR13Assigned to domainALPHAT_RFHAF4_TRANS_NO
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
RANTYP_RContract Type RANTYPCHAR1RANTYP
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
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
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_SECTORCHAR10Assigned to domainBU_INDSECTOR
CNTRY_COMPCountry of Registered Office of Business Partner FTI_LANDBPCHAR3Assigned to domainLAND1
LEGAL_ENTYLegal Form of Organization BP_LEG_ETY_NEWCHAR2Assigned to domainBU_LEGENTY
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORG_NEWCHAR2Assigned to domainBU_LEGAL_ORG
NATIONNationality BP_CNTR_NCHAR3Assigned to domainLAND1
STATECitizenship BP_CNTR_STCHAR3Assigned to domainLAND1
GROUP_IDBusiness Partner Grouping BU_GRP_ID_NEWCHAR4Assigned to domainBU_GROUPBPP
GROUP_DTarget Group BP_GROUP_DCHAR4Assigned to domainBP_GROUP_D
STAFF_GRPEmployee Group BP_STAFF_GCHAR4Assigned to domainBP_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_RATINGCHAR3Assigned to domainBP_RATING
SOL_INSInstitute providing credit standing information FTI_BP_SOL_INSCHAR4Assigned to domainBP_SOL_INS
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
TYPE_KCounterparty Category FTI_BP_KONTR_TYPECHAR1BU_TYPE
ISTYPE_KIndustry System of Counterparty FTI_BP_KONTR_ISTYPECHAR4TB038BU_ISTYPE
IND_SECTOR_KIndustry Sector of Counterparty FTI_BP_KONTR_IND_SECTORCHAR10TB038ABU_INDSECTOR
CNTRY_COMP_KCountry of Registered Office of Counterparty FTI_BP_KONTR_LANDBPCHAR3T005LAND1
LEGAL_ENTY_KLegal Form of Organization of Counterparty FTI_BP_KONTR_LEG_ETYCHAR2TB019BU_LEGENTY
LEGAL_ORG_KLegal Entity of Organization of Counterparty FTI_BP_KONTR_LEGAL_ORGCHAR2TB032BU_LEGAL_ORG
NATION_KNationality of Counterparty FTI_BP_KONTR_CNTR_NCHAR3T005LAND1
STATE_KCitezenship of Counterparty FTI_BP_KONTR_CNTR_STCHAR3T005LAND1
GROUP_ID_KGrouping of Counterparty FTI_BP_KONTR_GRP_IDCHAR4TB001BU_GROUPBPP
GROUP_D_KTarget Group of Counterparty FTI_BP_KONTR_GROUP_DCHAR4TP13BP_GROUP_D
STAFF_GRP_KEmployee Group - Counterparty FTI_BP_KONTR_STAFF_GCHAR4TP05BP_STAFF_G
COMP_RE_KCompany Relationship of Counterparty FTI_BP_KONTR_COMP_RECHAR1BP_COMP_RE
SOLVNCY_KCredit Standing of Counterparty FTI_BP_KONTR_SOLVNCYCHAR1BP_SOLVNCY
RATING_KRating of Counterparty FTI_BP_KONTR_RATINGCHAR3TP06BP_RATING
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
FINPROJFinance Project TB_TFPROJCHAR13T_TFPROJ
RMAIDMaster Agreement TB_RMAIDCHAR10Assigned to domainALPHAT_RMAIDTMAVTMA
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
PORTFOLIO_TMPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
RDPBANKDepository Bank RDEPOTBANKCHAR10BUT000ALPHABU_PARTNER
SECACC_TYPESecurities Account Type TPM_SECACC_TYPECHAR3TRSC_SECACC_TYPETPM_SECACC_TYPE
SECACC_CATSecurities Account Category TPM_SECACC_CATCHAR1TPM_SECACC_CAT
SNOTIQuotation Indicator SNOTINUMC1SNOTI
ALWPKLGeneral Security Classification ALWPKLCHAR3Assigned to domainALWPKL
SWERTTYPSecurity Type ID SWERTTYPNUMC1Assigned to domainSAKTTYP
SOL_INS_RANLInstitut Supplying Credit Rating Information for Secur. ID FTI_SOL_INS_RANLCHAR4Assigned to domainBP_SOL_INS
RATING_RANLRating for Securities ID Number/OTC Transaction BP_RATING_RANLCHAR3Assigned to domainBP_RATING
SWPKLASSClassification of bond SWPKLASSNUMC3Assigned to domainSWPKLASS
SAKARStock category SAKARNUMC1SAKAR
SFOARTFund category indicator VVSFOARTCHAR2VVSFOART
SFOTYFund type indicator SFOTYNUMC1Assigned to domainSFOTY
SARTBETType of shareholding SARTBETNUMC2Assigned to domainSARTBET
SBOERNOTIndicator: Listed on an Exchange SBOERNOTCHAR1JANEI
VVRANLWXSecondary index class data VVRANLWXSCHAR20CHAR20S
AAAAKTIE_ENumber of Stocks Issued: End FTI_AAAKTIE_EDEC12DEC12
KZAHLAKT_EPay-in rate FTI_KZAHLAKT_EDEC10(7) DEC3_7
PKOND_EInterest Rate: End FTI_PKOND_EDEC10(7) DECV3_7
PEFFZINS_EEffective Interest Rate at End of Period FTI_PEFFZINS_EDEC10(7) DEC3_7
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
SHWHRLocal Currency TB_SHWHRCUKY5TCURCWAERS
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5Assigned to domainWAERS
ANZGWDisplay Currency FTI_ANZGWCUKY5TCURCWAERSFFZ
DBEWEGFlow Date DBEWEGDATS8DATUM
DBESTANDPosition value date DBESTANDDATS8DATUM
DORDEROrder day DORDERDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DSCHLUSSDate of business closing VVDSCHLUSSDATS8DATUM
DFAELLDue date DFAELLDATS8DATUM
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
SE_DEAL_NUMBERSecurities/Futures Transaction FTI_SE_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
RHANDPLExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
JFDBUCRelevance to CM FTI_FDBUCCHAR1FTI_FDBUC
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
SZARTPayment transaction TB_SZARTCHAR1XFELD
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
PRKEYKey Number for Payment Request PRQ_KEYNOCHAR10PAYRQALPHAPRQ_KEYNO
RREFKONT_RAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
ACC_ASS_REFAcct Assignment Ref. of Pos. Mgmt, Val. Area 001 FTI_AA_REF_001CHAR12TRACC_AA_REFTPM_AA_REFTRAC_AA_REF
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
AWKEYReference Key AWKEYCHAR20AWKEY
GL_ACCOUNT_DNumber of G/L Account: Debit FTI_GLACC_DCHAR10SKB1ALPHASAKNRSAKC_SAKNR
GL_ACCOUNT_CNumber of G/L Account: Credit FTI_GLACC_CCHAR10SKB1ALPHASAKNRSAKC_SAKNR
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
RAHABKISelling house bank TB_RAHABKICHAR5Assigned to domainHBKID
RAHKTIDSelling house bank account TB_RAHKTIDCHAR5Assigned to domainHKTID
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
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BUCHSTPosting status of flow for Treasury BUCHST_TRCHAR1BUCHST_TR
TRL_BOOKINGSTATEPosition Status of Flow for CFM (Parallel Only) BUCHST_CFM_PARCHAR1TRLBSTPM_TRL_BOOKINGSTATE
SBFREIRelease Given for Flow to Be Posted? TB_SBFREICHAR1XFELD
SBEWART_RFlow Type SBEWARTCHAR4Assigned to domainSBEWART
FLOW_TYPEUpdate Type TPM_DIS_FLOWTYPECHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
BUSTRANSCATBusiness Transaction Category TPM_BUSTRANSCATNUMC4TRDTS_BT_CATTPM_BUSTRANSCAT
SOURCETARGET_FLGIndicator: Source or Target of a Flow TPM_SOURCE_TARGET_FLGCHAR1TPM_SOURCE_TARGET_FLG
KMNRCorporate Action Number KMNRCHAR13VWKMKOALPHAVKMNRKMA
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
D_UNITSDelta Number of Units FTI_D_UNITSDEC22(6) TPM_UNITS
D_NOMINAL_AMT_PCDelta Nominal Amount in Position Currency FTI_D_NOMINAL_AMT_PCCURR21(2) TPM_AMOUNT
CF_CCPayment amount in payment currency FTI_PAYAMOUNT_PYCCURR21(2) TPM_AMOUNT
CF_LCPayment Amount in Local Currency FTI_PAYAMOUNT_LCCURR21(2) TPM_AMOUNT
CF_DCPayment Amount in Display Currency FTI_PAYAMOUNT_DCCURR21(2) TPM_AMOUNT
BUSTRANSIDIdentifier of the Distributor Business Transaction FTI_BUSTRANSIDRAW16SYSUUID
REFBUSTRANSIDID of Reference Business Transaction FTI_REFBUSTRANSIDRAW16SYSUUID
TRLFLOWNUMBERNumber of TRL Flow TPM_TRLFLOWNRINT410TPM_TRLFLOW_NR
RSTICHKey date reference RSTICHCHAR1RSTICH
PAYINDPayment Status of Flows TB_SPAYINDCHAR1T_SPAYIND
RLZTG_K_FRemaining Term in Days (Key Figure) FTI_RLZTGK_FDEC7DEC7
UEBTG_K_FOverdue Period in Days (Key Figure) FTI_UEBTGK_FDEC7DEC7
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
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_TR_CF using ABAP code?

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

How to access SAP table VTVDETA_TR_CF

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