SAP ABAP Table BAPIFVDEXP_VZZBEPP (Export Loan: Flow Data - Planned and Actual Items)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_EXPORT (Package) Export Interface for Loans

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIFVDEXP_VZZBEPP	Table Relationship Diagram
Short Description	Export Loan: Flow Data - Planned and Actual Items

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	FLOW_DATE_1	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
2	TIME_TRN_1	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
3	CONS_TR_1	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
4	DOC_NO_1	☐	RBELKPFD	RBELKPFD	CHAR	10	0	Document Number of Document Header (Loan)
5	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	CONTRACT_NO	☐	RANL	RANL	CHAR	13	0	Contract Number
7	SEC_ACCT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
8	ACTIV_DTE	☐	DVORGANG	DATUM	DATS	8	0	Activity date
9	ACTIVITY_1	☐	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
10	ACT_NO_1	☐	NVORGANG	CHAR3	CHAR	3	0	Activity number
11	FLOW_TYPE	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
12	REFFLWTYP	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
13	DEB_CRED	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
14	ACCTASSREF	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
15	STATUS	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
16	INT_LEVEL	☐	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	TDINTEB
17	REVER_IND	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
18	REVERSAL_DOC	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
19	ACTIVITY_2	☐	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
20	FCAT	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
21	CHANGEID	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
22	PLAN_ACT	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
23	FLOWSOURCE	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
24	ACC_DEF	☐	VVSABGRENZ	VVSABGRENZ	NUMC	1	0	Accrual/deferral method
25	PLANNING_LEVEL	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
26	CMF_FLAG	☐	JFDUPD	JANEI	CHAR	1	0	Record transferred to cash management and forecast
27	SIND	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
28	SEQUENCE	☐	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
29	INT_BASE	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
30	INT_DATE	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
31	FIXING	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
32	POSTFLAG	☐	JONLBUC	CHAR1	CHAR	1	0	Online posting flag indicator
33	POS_CURR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
34	POS_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
35	PC_AMOUNT_1	☐	BAPIBBWHR	BAPICURR	DEC	23	4	Amount in Position Currency
36	SETT_CURR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
37	SETT_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
38	STTMNTAMNT	☐	BAPIBCWHR	BAPICURR	DEC	23	4	Settlement Amount
39	LOC_CURR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	TCURC
40	LOC_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
41	LC_AMOUNT	☐	BAPIBHWHR	BAPICURR	DEC	23	4	Amount in Local Currency
42	NOM_CURR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
43	NOM_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
44	NOM_AMNT	☐	BAPIBNWHR	BAPICURR	DEC	23	4	Nominal Amount
45	BASE_AMNT	☐	BAPIBBASIS	BAPICURR	DEC	23	4	Calculation Base Amount
46	CALC_FROM	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
47	EXCL_ST	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
48	MONTH_END_1	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
49	CALC_TO	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
50	INCL_END	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
51	MONTH_END_2	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
52	DUE_DATE	☐	DFAELL	DATUM	DATS	8	0	Due date
53	DUE_MONTH_END	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
54	PMNT_DATE_1	☐	DDISPO	DATUM	DATS	8	0	Payment Date
55	CALC_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
56	INCLUSIVE_INDICATOR	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
57	MONTH_END_3	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
58	SETTL_DATE	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
59	INCL_STTL	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
60	MNTESTTL	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
61	NO_OF_DAYS	☐	VVATAGE	INT6	NUMC	6	0	Number of days
62	NO_BS_DY	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
63	NODYSPER	☐	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
64	DAYCALCMET	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
65	DAYS_IN_YR	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
66	INTEREST_CALC_METHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
67	CALENDAR	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
68	PERCENTAGE_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
69	PERCFDTE	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
70	PERSTRTDT	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
71	EXCL_STPER	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
72	MENDSTPER	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
73	PERENDDAT	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
74	INCL_ENDPE	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
75	MENDPEREND	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
76	CURRENCY_1	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
77	CURRENCY_1_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
78	COND_AMNT	☐	BAPIBKOND	BAPICURR	DEC	23	4	Condition Item Currency Amount
79	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
80	VAT	☐	BAPIBMWST	BAPICURR	DEC	23	4	Value-Added Tax Amount Included
81	CALC_BASE	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
82	IMM_STTLM	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
83	REM_BAL	☐	BAPIBSALDO	BAPICURR	DEC	23	4	Remaining Balance of a Contract (Account)
84	IMPANNREP_1	☐	BAPITFMBTIKALK	BAPICURR	DEC	23	4	Imputed Annuity Repayment Amount (FiMa Internal)
85	IMPANNREP_2	☐	BAPITFMBTIKALK	BAPICURR	DEC	23	4	Imputed Annuity Repayment Amount (FiMa Internal)
86	INTEREST	☐	BAPITFMBKAZINS	BAPICURR	DEC	23	4	Int.for Days Betw. Redemption Clear.and Pmnt (FiMa-Internal)
87	PC_AMOUNT_2	☐	BAPIBBWHR	BAPICURR	DEC	23	4	Amount in Position Currency
88	FREQUENCY_MONTH	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
89	FREQ_DAY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
90	NAME	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
91	INT_IND	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
92	NUMBER_OF_UNITS	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
93	SEC_PRICE_1	☐	BAPIBWKURS	BAPICURR	DEC	23	4	Security Price for Unit Quotation
94	PRICECURR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	*
95	PRICECURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
96	SEC_PRICE_2	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
97	MRKT_VAL	☐	BAPIVVBSWHR	BAPICURR	DEC	23	4	Market Value
98	PRICE_1	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
99	UNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	TZUNI
100	ACCINTMETH	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
101	DAYS_METH	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
102	ISSUE_YIELD_1	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
103	YIELD_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
104	EXCH_RATE_1	☐	VVKURS1	KURSF	DEC	9	5	Exchange rate into settlement currency
105	EXCH_RATE_2	☐	VVKURS2	KURSF	DEC	9	5	Exchange rate from settlement currency into local currency
106	POS_VL_DT	☐	DBESTAND	DATUM	DATS	8	0	Position value date
107	DTE_6B	☐	DBEST6B	DATUM	DATS	8	0	Date for §6b EstG relevant postings
108	ORDER_DATE	☐	DORDER	DATUM	DATS	8	0	Order day
109	ORDER_NO	☐	NORDER	NUM8	NUMC	8	0	Order Number
110	EXTORDNO	☐	NORDEXT	CHAR20	CHAR	20	0	External order number
111	EXPEN_KEY	☐	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
112	ORDER_NOT	☐	SLIMIT	SLIMIT	CHAR	1	0	Order notation
113	LIMITPRICE_1	☐	BAPIBLIMIT	BAPICURR	DEC	23	4	Limit Price for Unit Quotation
114	LIMITPRICE_2	☐	PLIMIT	PWKURS	DEC	10	7	Limit price for percentage quotation
115	DEBIT_ACCT	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	*
116	CREDIT_A_C	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	*
117	INT_BNK_AC	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
118	DEBITINTAC	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	*
119	CREDINTACT	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	*
120	CNTRPR_1	☐	RVERMIT_OLD	BP_PARTNR	CHAR	10	0	Business Partner ID for Agent	*
121	CNTRPR_2	☐	RVERMIT_OLD	BP_PARTNR	CHAR	10	0	Business Partner ID for Agent	*
122	ROLE_CAT	☐	BP_ROLETYP_OLD	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
123	ASSIGNMENT_1	☐	XZUSATZ	CHAR18	CHAR	18	0	Assignment
124	PARTNER_BK	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
125	PARTNER_1	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
126	INC_PMNT	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
127	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
128	REQUEST_1	☐	SREQUEST	JANEI	CHAR	1	0	Request
129	REQUEST_2	☐	SREQUEST	JANEI	CHAR	1	0	Request
130	REQUEST_3	☐	SREQUEST	JANEI	CHAR	1	0	Request
131	CURRENCY_2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
132	CURRENCY_2_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
133	CURRENCY_3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
134	CURRENCY_3_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
135	EXCH_RATE_3	☐	KURSF	KURSF	DEC	9	5	Exchange rate
136	POST_KEY_1	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
137	POST_KEY_2	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
138	POST_KEY_3	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
139	POST_KEY_4	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
140	POST_KEY_5	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
141	CURR_SWAP	☐	SWHRT	SWHRT	CHAR	1	0	Currency swap indicator
142	RESERDTE	☐	DANST	DATUM	DATS	8	0	Reservation date
143	ORD_TIME	☐	TANST	TIMES	TIMS	6	0	Order time of day
144	RES_REASON	☐	SANST	SANST	CHAR	2	0	Reservation reason	*
145	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
146	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
147	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
148	FLWHEADNO	☐	RBELKPF	RBELKPF	CHAR	10	0	Number of flow header	*
149	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
150	DUNN_AREA	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
151	PAY_BANK	☐	VVRZBANK_OLD	BP_PARTNR	CHAR	10	0	Paying Bank	*
152	DUMMY_FUNC	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
153	CHAR_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
154	DAYBK_NO	☐	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
155	WITHHOLD	☐	VVJEINBE	KENZX	CHAR	1	0	Indicator for withholding of amount during disbursement
156	HOUSEBANKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
157	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
158	POST_CONT	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key
159	PRF_DATE	☐	VVDSTOCK	DATUM	DATS	8	0	Premium reserve fund date
160	PSTNG_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
161	DRAWINGS	☐	JVERF	JVERF	CHAR	1	0	Indicator whether drawings exist for the disbursement
162	PYMT_BLOCK	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
163	CALC_CAT	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
164	A_D_POSTNG	☐	VVSBUCHA	CHAR1	CHAR	1	0	Indicator for postings to accruals/deferrals accounts
165	REFFLOWCAT_1	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
166	ADVANCE	☐	VVJVORAUS	KENZX	CHAR	1	0	ID for planned record reference to an advance payment
167	FIN_PROJ	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
168	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
169	COUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
170	COUPONDTE	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
171	TRAD_FLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
172	CONDITION_TYPE	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
173	CONDITION_VALID_FROM	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
174	CONS_NO	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
175	VALID_FROM	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
176	LEVEL_NO	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
177	STOCK_EXCHANGE	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
178	FIXED_RATE_1	☐	VVSFIXRATE	XFELD	CHAR	1	0	Fixed exchange rate
179	FIXED_RATE_2	☐	VVSFIXRATE	XFELD	CHAR	1	0	Fixed exchange rate
180	NUM4	☐	NUM4	NUM04	NUMC	4	0	Four-digit number
181	ACT_NO_2	☐	NVORGANG	CHAR3	CHAR	3	0	Activity number
182	PEC_RUN	☐	SEVALPOST	XFELD	CHAR	1	0	PEC for flow executed indicator yes/no
183	ORIGINID	☐	VVSHERK	VVSHERK	CHAR	1	0	Origin indicator: 'From planned record/actual record'
184	SP_GL_IND	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
185	ACTIVITYID	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
186	INT_BLOCK	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
187	CHAR_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
188	DUNN_BLOCK	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
189	QUOTA	☐	RKONT	RKONT	NUMC	6	0	Quota number
190	LEAD	☐	VVDAUSZ	DATUM	DATS	8	0	Lead date for withholding amounts for disbursement
191	FLOW_DATE_2	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
192	TIME_TRN_2	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
193	CONS_TR_2	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
194	ACTPRINC	☐	SSOLIST	CHAR1	CHAR	1	0	Calculation using actual principle (or debit)
195	BORROWER	☐	RDARNEHM_OLD	RPERS	CHAR	10	0	Borrower/Applicant Number
196	AMOUNT	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
197	DOC_NO_2	☐	RZEBEL	RBELKPFD	CHAR	10	0	Doc.no. of debit pos. doc.header (only for inc.pmnt records)
198	HOUSE_BANK	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
199	ACCOUNT	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
200	PARTN_BANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
201	PAYMENT	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
202	AC_DOC_NO_1	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
203	AC_DOC_NO_2	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
204	SEC_DOC_NO_1	☐	TRSEDOCNR	TRSEDOCNR	CHAR	10	0	Document number of security posting document	VWPOSTDOC
205	FISC_YEAR_1	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
206	SEC_DOC_NO_2	☐	TRSEDOCNR	TRSEDOCNR	CHAR	10	0	Document number of security posting document	VWPOSTDOC
207	FISC_YEAR_2	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
208	INT_FX_DTE	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
209	CLOSINGDTE	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
210	CLOS_TIME	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
211	PMNT_DATE_2	☐	DDISPO	DATUM	DATS	8	0	Payment Date
212	ISSUE_YIELD_2	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
213	REFSECACC	☐	VVREFRLDEP	RLDEPO	CHAR	10	0	Reference sec.acct for sec.acct transfer (inflow/outflow)	*
214	MBORRCUSNO	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	*
215	AC_DOC_NO_3	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
216	INV_YEAR	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
217	INV_REF	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
218	INV_ITEM	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
219	PARTNER_2	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
220	REFFLOWCAT_2	☐	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
221	PGL_STATUS	☐	TKGV	TKGV	CHAR	1	0	Manages status of the related price gains/losses flows
222	OBJECT_NO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
223	GRACE_INT	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
224	CA_NUMBER	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	*
225	RIGHT_NO	☐	TER_HEADNUMBER	TER_RIGHTNUMBER	CHAR	13	0	ID number of exercised right
226	PEC_DATE	☐	DEVALPOST	DATUM	DATS	8	0	Date of period-end closing
227	ASSIGNMENT_2	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
228	INTERNAL_REFERENCE	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
229	CHARACTERISTICS	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
230	PMNT_REQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
231	INDIV_PMNT_1	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
232	REQUESTID	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
233	INDIV_PMNT_2	☐	PRQ_XPORE	XFELD	CHAR	1	0	Indicator: Individual Payment?
234	HOUSEBANKACCTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
235	PARTNER_3	☐	TB_RPZAHL_OLD	BP_PARTNR	CHAR	10	0	Payer/Payee	*
236	FISC_YEAR_3	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
237	FIS_PERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
238	AC_DOC_NO_4	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
239	DTE_FIAC	☐	DANFIBU	DATUM	DATS	8	0	Date of transferal to FiAc
240	TMETOFIAC	☐	UANFIBU	TIMES	TIMS	6	0	Time of transfer to financial accounting
241	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
242	ACTIV_CAT	☐	VORGTYP_LO	VORGTYP_LO	CHAR	4	0	Activity Category (Posting Area)
243	SRCE_IN_PA	☐	ACENV_LO	ACENV_LO	NUMC	4	0	Source in TR-LO posting area
244	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
245	DIRECTION	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
246	PMTMTHSUPL	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
247	GROUP_DET	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
248	SAME_DIR	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
249	PAYMENT_METHODS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
250	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
251	EXPONENT	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
252	PG_EXCL	☐	VVSREVALEXCL	XFELD	CHAR	1	0	Price gains w/o proportionate gains from deferral write-back
253	TRANSACTN	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
254	PYMNTM_CM	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
255	PMNT_BLOCK	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
256	ROUNDING_TYPE	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
257	BO_NUMBER	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
258	ACC_DEFPRO	☐	RESABGVERF	RESABVEF	CHAR	1	0	Accrual/deferral procedure
259	PRICE_2	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
260	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
261	GROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
262	SEPA_MANDATE_ID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIFVDEXP_VZZBEPP	COMP_CODE	T001	BUKRS	KEY
2	BAPIFVDEXP_VZZBEPP	DUNN_AREA	T047M	MABER	KEY
3	BAPIFVDEXP_VZZBEPP	DUNN_BLOCK	T040S	MANSP	KEY
4	BAPIFVDEXP_VZZBEPP	FCAT	TZB03	SBEWZITI	KEY
5	BAPIFVDEXP_VZZBEPP	FLOW_TYPE	TZB0A	SBEWART
6	BAPIFVDEXP_VZZBEPP	INT_LEVEL	TDINTEB	INTEB	KEY
7	BAPIFVDEXP_VZZBEPP	LOC_CURR	TCURC	WAERS	KEY
8	BAPIFVDEXP_VZZBEPP	NOM_CURR	TCURC	WAERS	KEY
9	BAPIFVDEXP_VZZBEPP	PMTMTHSUPL	T042F	UZAWE	KEY
10	BAPIFVDEXP_VZZBEPP	POS_CURR	TCURC	WAERS	KEY
11	BAPIFVDEXP_VZZBEPP	PYMT_BLOCK	T008	ZAHLS	KEY
12	BAPIFVDEXP_VZZBEPP	SEC_DOC_NO_1	VWPOSTDOC	DOCNR	KEY
13	BAPIFVDEXP_VZZBEPP	SEC_DOC_NO_2	VWPOSTDOC	DOCNR	KEY
14	BAPIFVDEXP_VZZBEPP	SETT_CURR	TCURC	WAERS	KEY
15	BAPIFVDEXP_VZZBEPP	UNIT	TZUNI	SRUNIT	KEY

History

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