SAP ABAP Table VTVDETM_TR (Treasury: Cumulative Values: Characteristics Trans./Activity)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	VTVDETM_TR	Table Relationship Diagram
Short Description	Treasury: Cumulative Values: Characteristics Trans./Activity

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
2	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
3	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
4	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
5	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
7	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
8	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
9	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
10	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
11	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
12	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
13	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
14	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
15	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
16	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
17	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
18	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
19	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
20	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
21	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
22	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
23	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
24	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
25	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
26	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
27	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
28	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
29	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
30	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	*
31	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETM_TR	LAND1	T005	LAND1
2	VTVDETM_TR	PRKEY	PAYRQ	KEYNO		C	CN
3	VTVDETM_TR	RPZAHL	BUT000	PARTNER
4	VTVDETM_TR	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in