SAP ABAP Table VTVDETA_TR_CF (Operative CFM: Payments)

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	VTVDETA_TR_CF	Table Relationship Diagram
Short Description	Operative CFM: Payments

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	.INCLUDE	☐				0	0	Treasury: Payment Information for Several Time Intervals
2	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
3	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
4	.INCLUDE	☐				0	0	Treasury: Payment Information
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
8	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
9	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
10	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
11	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
12	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	VTBFHA
13	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
14	SECURITY_ACCOUNT	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
15	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
16	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
17	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
18	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
19	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
20	LOTGENERATION_USER	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
21	LOTGENERATION_BUSTRANSCAT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
22	LOTPOS_INIT_DATE	☐	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
23	LOTPOS_ORG_DATE	☐	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
24	LOTGEN_BUKRS	☐	FTI_LOTGENERATION_BUKRS	BUKRS	CHAR	4	0	Company Code of Lot-Generating Transaction	*
25	LOTGEN_DEALNR	☐	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
26	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
27	RANTYP_R	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
28	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
29	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
30	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
31	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
32	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
33	UEBTG_F	☐	FTI_UEBTG_F	NUMC5	NUMC	5	0	Overdue Period in Days
34	UEBMO_F	☐	FTI_UEBMO_F	NUMC3	NUMC	3	0	Overdue Period in Months
35	UEBJA_F	☐	FTI_UEBJA_F	NUMC2	NUMC	2	0	Overdue Period in Years
36	.INCLUDE	☐				0	0	Include for Data of Commitment Partner (->LDBs)
37	.INCLUDE	☐				0	0	Treasury: Commitment Partner
38	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
39	.INCLUDE	☐				0	0	Treasury: Partner Attributes
40	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
41	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
42	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
43	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	*
44	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	*
45	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
46	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
47	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	*
48	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
49	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	*
50	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	*
51	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
52	.INCLUDE	☐				0	0	Business partner credit standing data
53	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
54	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
55	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	*
56	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
57	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
58	.INCLUDE	☐				0	0	Include for Counterparty Data
59	.INCLUDE	☐				0	0	Treasury: Commitment Partner
60	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
61	.INCLUDE	☐				0	0	Treasury: Partner Attributes (Counterparty)
62	TYPE_K	☐	FTI_BP_KONTR_TYPE	BU_TYPE	CHAR	1	0	Counterparty Category
63	ISTYPE_K	☐	FTI_BP_KONTR_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System of Counterparty	TB038
64	IND_SECTOR_K	☐	FTI_BP_KONTR_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry Sector of Counterparty	TB038A
65	CNTRY_COMP_K	☐	FTI_BP_KONTR_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Counterparty	T005
66	LEGAL_ENTY_K	☐	FTI_BP_KONTR_LEG_ETY	BU_LEGENTY	CHAR	2	0	Legal Form of Organization of Counterparty	TB019
67	LEGAL_ORG_K	☐	FTI_BP_KONTR_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization of Counterparty	TB032
68	NATION_K	☐	FTI_BP_KONTR_CNTR_N	LAND1	CHAR	3	0	Nationality of Counterparty	T005
69	STATE_K	☐	FTI_BP_KONTR_CNTR_ST	LAND1	CHAR	3	0	Citezenship of Counterparty	T005
70	GROUP_ID_K	☐	FTI_BP_KONTR_GRP_ID	BU_GROUP	CHAR	4	0	Grouping of Counterparty	TB001
71	GROUP_D_K	☐	FTI_BP_KONTR_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group of Counterparty	TP13
72	STAFF_GRP_K	☐	FTI_BP_KONTR_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group - Counterparty	TP05
73	COMP_RE_K	☐	FTI_BP_KONTR_COMP_RE	BP_COMP_RE	CHAR	1	0	Company Relationship of Counterparty
74	.INCLUDE	☐				0	0	Business Partner Credit Standing Data (Counterparty)
75	SOLVNCY_K	☐	FTI_BP_KONTR_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing of Counterparty
76	RATING_K	☐	FTI_BP_KONTR_RATING	BP_RATING	CHAR	3	0	Rating of Counterparty	TP06
77	.INCLUDE	☐				0	0	Include for Transaction Attributes Rel. for Position (->LDB)
78	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
79	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
80	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
81	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
82	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
83	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
84	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
85	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
86	PORTFOLIO_TM	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
87	RDPBANK	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	BUT000
88	SECACC_TYPE	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
89	SECACC_CAT	☐	TPM_SECACC_CAT	TPM_SECACC_CAT	CHAR	1	0	Securities Account Category
90	.INCLUDE	☐				0	0	Include for Time-Dependent Class Data (-> LDBs)
91	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
92	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	*
93	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	*
94	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	*
95	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	*
96	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	*
97	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
98	SFOART	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
99	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	*
100	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	*
101	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
102	VVRANLWX	☐	VVRANLWXS	CHAR20S	CHAR	20	0	Secondary index class data
103	AAAAKTIE_E	☐	FTI_AAAKTIE_E	DEC12	DEC	12	0	Number of Stocks Issued: End
104	KZAHLAKT_E	☐	FTI_KZAHLAKT_E	DEC3_7	DEC	10	7	Pay-in rate
105	PKOND_E	☐	FTI_PKOND_E	DECV3_7	DEC	10	7	Interest rate - end
106	PEFFZINS_E	☐	FTI_PEFFZINS_E	DEC3_7	DEC	10	7	Effective Interest Rate at End of Period
107	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
108	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	*
109	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
110	DBEWEG	☐	DBEWEG	DATUM	DATS	8	0	Flow Date
111	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
112	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
113	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
114	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
115	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
116	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
117	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
118	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
119	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
120	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
121	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
122	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
123	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
124	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
125	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
126	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
127	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
128	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
129	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
130	ACC_ASS_REF	☐	TPM_AA_REF_001	TPM_AA_REF	CHAR	12	0	Acct Assignment Ref. in Pos. Mgmt for Val. Area 001	TRACC_AA_REF
131	.INCLUDE	☐				0	0	Include for FI Document Data/Filling FI Document Data ->LDB
132	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
133	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
134	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	SKB1
135	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	SKB1
136	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
137	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
138	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
139	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
140	RAHABKI	☐	TB_RAHABKI	HBKID	CHAR	5	0	Selling house bank	*
141	RAHKTID	☐	TB_RAHKTID	HKTID	CHAR	5	0	Selling house bank account	*
142	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
143	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
144	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
145	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
146	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
147	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
148	BUCHST	☐	BUCHST_TR	BUCHST_TR	CHAR	1	0	Posting status of flow for Treasury
149	TRL_BOOKINGSTATE	☐	BUCHST_CFM_PAR	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Position Status of Flow for CFM (Parallel Only)
150	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
151	SBEWART_R	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
152	FLOW_TYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
153	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
154	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
155	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	VWKMKO
156	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
157	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
158	D_UNITS	☐	FTI_D_UNITS	TPM_UNITS	DEC	22	6	Delta Number of Units
159	D_NOMINAL_AMT_PC	☐	FTI_D_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Delta Nominal Amount in Position Currency
160	CF_CC	☐	FTI_PAYAMOUNT_PYC	TPM_AMOUNT	CURR	21	2	Payment amount in payment currency
161	CF_LC	☐	FTI_PAYAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Payment Amount in Local Currency
162	CF_DC	☐	FTI_PAYAMOUNT_DC	TPM_AMOUNT	CURR	21	2	Payment Amount in Display Currency
163	BUSTRANSID	☐	FTI_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
164	TRLFLOWNUMBER	☐	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
165	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
166	PAYIND	☐	TB_SPAYIND	T_SPAYIND	CHAR	1	0	Payment Status of Flows
167	.INCLUDE	☐				0	0	Actual Key Figures Occurring in Position and Flow Lists
168	RLZTG_K_F	☐	FTI_RLZTGK_F	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
169	UEBTG_K_F	☐	FTI_UEBTGK_F	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
170	SARCHIV	☐	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
171	.INCLUDE	☐				0	0	Additional Treasury Selections
172	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
173	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
174	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
175	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
176	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
177	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
178	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
179	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
180	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
181	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
182	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
183	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
184	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
185	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
186	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
187	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
188	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
189	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
190	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
191	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
192	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
193	FLG_REVERSED_FLOWS	☐	FTI_REVERSED_FLOWS	XFELD	CHAR	1	0	Process Reversed Flows (for Query)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETA_TR_CF	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	VTVDETA_TR_CF	ACC_ASS_REF	TRACC_AA_REF	AA_REF
3	VTVDETA_TR_CF	ANZGW	TCURC	WAERS
4	VTVDETA_TR_CF	AUSWT	JBREVAL	AUSWERTUNG
5	VTVDETA_TR_CF	BUKRS	T001	BUKRS		1	CN
6	VTVDETA_TR_CF	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
7	VTVDETA_TR_CF	CNTRY_COMP_K	T005	LAND1
8	VTVDETA_TR_CF	DEAL_NUMBER	VTBFHA	RFHA
9	VTVDETA_TR_CF	FLOW_TYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE
10	VTVDETA_TR_CF	GL_ACCOUNT_C	SKB1	SAKNR
11	VTVDETA_TR_CF	GL_ACCOUNT_D	SKB1	SAKNR
12	VTVDETA_TR_CF	GROUP_D_K	TP13	GROUP_D
13	VTVDETA_TR_CF	GROUP_ID_K	TB001	BU_GROUP
14	VTVDETA_TR_CF	GSART	TZPA	GSART
15	VTVDETA_TR_CF	IND_SECTOR_K	TB038A	IND_SECTOR
16	VTVDETA_TR_CF	ISTYPE	TB038	ISTYPE
17	VTVDETA_TR_CF	ISTYPE_K	TB038	ISTYPE
18	VTVDETA_TR_CF	KMNR	VWKMKO	KMNR
19	VTVDETA_TR_CF	KURSA	TW56	SKURSART
20	VTVDETA_TR_CF	LAND1	T005	LAND1
21	VTVDETA_TR_CF	LEGAL_ENTY_K	TB019	LEGAL_ENTY
22	VTVDETA_TR_CF	LEGAL_ORG_K	TB032	LEGAL_ORG
23	VTVDETA_TR_CF	LOANS_CONTRACT	VDARL	RANL
24	VTVDETA_TR_CF	MANDT	T000	MANDT		1	CN
25	VTVDETA_TR_CF	NATION_K	T005	LAND1
26	VTVDETA_TR_CF	NUMBR	T242Q	NUMBR
27	VTVDETA_TR_CF	NUMBR_LC	T242Q	NUMBR
28	VTVDETA_TR_CF	PARTNR	BUT000	PARTNER
29	VTVDETA_TR_CF	PERIV	T009	PERIV
30	VTVDETA_TR_CF	PORTFOLIO	TWPOB	RPORTB		1	CN
31	VTVDETA_TR_CF	PORTFOLIO_TM	TWPOB	RPORTB
32	VTVDETA_TR_CF	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT
33	VTVDETA_TR_CF	PRKEY	PAYRQ	KEYNO		C	CN
34	VTVDETA_TR_CF	RATING_K	TP06	RATING
35	VTVDETA_TR_CF	RDPBANK	BUT000	PARTNER
36	VTVDETA_TR_CF	RREFKONT_R	T037S	RREFKONT
37	VTVDETA_TR_CF	SANLF	TZAF	SANLF
38	VTVDETA_TR_CF	SECACC_TYPE	TRSC_SECACC_TYPE	SECACC_TYPE
39	VTVDETA_TR_CF	SECURITY_ACCOUNT	TWD01	RLDEPO
40	VTVDETA_TR_CF	SECURITY_ID	VWPANLA	RANL
41	VTVDETA_TR_CF	SHWHR	TCURC	WAERS
42	VTVDETA_TR_CF	STAFF_GRP_K	TP05	STAFF_GRP		C	CN
43	VTVDETA_TR_CF	STATE_K	T005	LAND1
44	VTVDETA_TR_CF	VVRANLWI	TWX1	VVRANLWI
45	VTVDETA_TR_CF	WZBETR	TCURC	WAERS
46	VTVDETA_TR_CF	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in	200