SAP ABAP Table BAPIFVDEXP_VDBEPP (Export Loan: Flow Data - Planned Item)

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_VDBEPP	Table Relationship Diagram
Short Description	Export Loan: Flow Data - Planned Item

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	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	CONTRACT_NO	☐	RANL	RANL	CHAR	13	0	Contract Number
3	FLOW_DATE_1	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
4	TIME_TRN_1	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
5	CONS_TR_1	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
6	ACTIV_DTE	☐	DVORGANG	DATUM	DATS	8	0	Activity date
7	ACTIVITY	☐	SVORFALL	SVORFALL	CHAR	4	0	Business Operation (Activity)
8	ACT_NO	☐	NVORGANG	CHAR3	CHAR	3	0	Activity number
9	FLOW_TYPE	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
10	REFFLWTYP	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
11	FCAT	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
12	PLAN_ACT	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
13	DEB_CRED	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
14	REVER_IND	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
15	REV_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
16	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
17	REVERSAL_DOC	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
18	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
19	PRODUCT_CATEGORY	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
20	CONDITION_VALID_FROM	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
21	CONS_NO	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
22	STATUS	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
23	PROD_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPAB
24	ACCTASSREF	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
25	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	ORDER_DATE	☐	DORDER	DATUM	DATS	8	0	Order day
27	ORDER_NO	☐	NORDER	NUM8	NUMC	8	0	Order Number
28	NOM_AMNT	☐	BAPIBNWHR	BAPICURR	DEC	23	4	Nominal Amount
29	NOM_CURR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
30	NOM_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
31	PC_AMOUNT	☐	BAPIBBWHR	BAPICURR	DEC	23	4	Amount in Position Currency
32	POS_CURR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
33	POS_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
34	STTMNTAMNT	☐	BAPIBCWHR	BAPICURR	DEC	23	4	Settlement Amount
35	SETT_CURR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
36	SETT_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
37	LC_AMOUNT	☐	BAPIBHWHR	BAPICURR	DEC	23	4	Amount in Local Currency
38	LOC_CURR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	TCURC
39	LOC_CURR_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
40	EXCH_RATE_1	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
41	EXCH_RATE_2	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
42	CALC_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
43	DUE_ON	☐	DFAELLIG	DATUM	DATS	8	0	Due date/calculation date
44	PMNT_DATE_1	☐	DDISPO	DATUM	DATS	8	0	Payment Date
45	POS_VL_DT	☐	DBESTAND	DATUM	DATS	8	0	Position value date
46	CALC_FROM	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
47	CALC_TO	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
48	NO_OF_DAYS	☐	VVATAGE	INT6	NUMC	6	0	Number of days
49	NO_BS_DY	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
50	INTEREST_CALC_METHOD	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
51	SP_GL_IND	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
52	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
53	EXPEN_KEY	☐	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
54	DEBIT_ACCT	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
55	CREDIT_A_C	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
56	DEBITINTAC	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	SKA1
57	CREDINTACT	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	SKA1
58	POST_KEY_1	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
59	POST_KEY_2	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
60	POST_KEY_3	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
61	POST_KEY_4	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
62	INT_BNK_AC	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	SKB1
63	PLANNING_LEVEL	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
64	CMF_FLAG	☐	JFDUPD	JANEI	CHAR	1	0	Record transferred to cash management and forecast
65	FIXING	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
66	INT_BASE	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
67	INT_DATE	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
68	PERCENTAGE_RATE	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
69	BASE_AMNT	☐	BAPIBBASIS	BAPICURR	DEC	23	4	Calculation Base Amount
70	SIND	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
71	FLOWSOURCE	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
72	ACCINTMETH	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
73	DAYS_METH	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
74	ISSUE_YIELD	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
75	YIELD_METHOD	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
76	DRAWINGS	☐	JVERF	JVERF	CHAR	1	0	Indicator whether drawings exist for the disbursement
77	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
78	PARTNER_BK	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
79	PYMT_METH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
80	DUNN_AREA	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
81	PYMT_BLOCK	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
82	PARTNER_1	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
83	DUMMY	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
84	FIN_PROJ	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
85	WITHHOLD	☐	VVJEINBE	KENZX	CHAR	1	0	Indicator for withholding of amount during disbursement
86	INC_PMNT	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
87	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
88	FLOW_DATE_2	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
89	TIME_TRN_2	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
90	CONS_TR_2	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
91	DAYBK_NO	☐	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
92	HOUSEBANKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
93	POST_CONT	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
94	SEC_PRICE	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
95	PRF_DATE	☐	VVDSTOCK	DATUM	DATS	8	0	Premium reserve fund date
96	ADVANCE	☐	VVJVORAUS	KENZX	CHAR	1	0	ID for planned record reference to an advance payment
97	FREQUENCY_MONTH	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
98	CONDITION_TYPE	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
99	EXCL_ST	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
100	MONTH_END_1	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
101	INCL_END	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
102	MONTH_END_2	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
103	INCLUSIVE_INDICATOR	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
104	SETTL_DATE	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
105	PERCFDTE	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
106	REFTRNDOC	☐	UMBLG	BELNR	CHAR	10	0	Reference transfer document number
107	INT_BLOCK	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
108	MONTH_END_3	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
109	IMM_STTLM	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
110	INCL_STTL	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
111	MNTESTTL	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
112	REFFLOWCAT_1	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
113	DAYS_IN_YR	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
114	DAYCALCMET	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
115	BASE_REF	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
116	CALC_CAT	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
117	ACTIVITYID	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
118	DUNN_BLOCK	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
119	VALID_FROM	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
120	LEVEL_NO	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
121	PERSTRTDT	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
122	EXCL_STPER	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
123	MENDSTPER	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
124	PERENDDAT	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
125	INCL_ENDPE	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
126	MENDPEREND	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
127	QUOTA	☐	RKONT	RKONT	NUMC	6	0	Quota number
128	LEAD	☐	VVDAUSZ	DATUM	DATS	8	0	Lead date for withholding amounts for disbursement
129	ACTPRINC	☐	SSOLIST	CHAR1	CHAR	1	0	Calculation using actual principle (or debit)
130	PARTNER_2	☐	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
131	CONDITION	☐	BAPIBKOND	BAPICURR	DEC	23	4	Condition Item Currency Amount
132	WAIVER	☐	VEBLGNR	BELNR	CHAR	10	0	Document number of waiver/write-off document
133	PMNT_DATE_2	☐	DDISPO	DATUM	DATS	8	0	Payment Date
134	INT_FX_DTE	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
135	GRACE_INT	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
136	INTEREST	☐	BAPIBKARZINS	BAPICURR	DEC	23	4	Int.for Days Betw. Redemption Clear.and Pmnt (FiMa-Internal)
137	IMPANNREP	☐	BAPIBTITALK	BAPICURR	DEC	23	4	Imputed Annuity Repayment Amount (FiMa Internal)
138	MBORRCUSNO	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	KNA1
139	PAYMENT	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
140	AC_DOC_NO	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
141	INV_YEAR	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
142	INV_REF	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
143	INV_ITEM	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
144	REFFLOWCAT_2	☐	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
145	CHANGEID	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
146	INDIV_PMNT_1	☐	PRQ_XPORE	XFELD	CHAR	1	0	Indicator: Individual Payment?
147	PMNT_REQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
148	REQUESTID	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
149	HOUSEBANKACCTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
150	ACTIV_CAT	☐	VORGTYP_LO	VORGTYP_LO	CHAR	4	0	Activity Category (Posting Area)
151	SRCE_IN_PA	☐	ACENV_LO	ACENV_LO	NUMC	4	0	Source in TR-LO posting area
152	DIRECTION	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
153	INDIV_PMNT_2	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
154	PMTMTHSUPL	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
155	GROUP_DET	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
156	SAME_DIR	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
157	PAYMENT_METHOD	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
158	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
159	EXPONENT	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
160	PG_EXCL	☐	VVSREVALEXCL	XFELD	CHAR	1	0	Price gains w/o proportionate gains from deferral write-back
161	BO_NUMBER	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
162	ROUNDING_TYPE	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
163	CALENDAR	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
164	PAYMENT_RATE	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
165	INTSTFRQ	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
166	EF_CATSTAT	☐	TB_LC_CAPITALS	T_LC_CASH_FLOW	CHAR	2	0	Effect of the Flow on Capital Amounts Status
167	EFF_D_STAT	☐	TB_LC_DISBURSE	T_LC_CASH_FLOW	CHAR	2	0	Effect of the Flow on the Disbursement Status
168	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_VDBEPP	ACCTASSREF	T037S	RREFKONT
2	BAPIFVDEXP_VDBEPP	BASE_REF	TZFB	SBASIS
3	BAPIFVDEXP_VDBEPP	BUS_AREA	TGSB	GSBER
4	BAPIFVDEXP_VDBEPP	CALC_CAT	AT40	SBERFIMA
5	BAPIFVDEXP_VDBEPP	COMP_CODE	T001	BUKRS	KEY	1	CN
6	BAPIFVDEXP_VDBEPP	CONDITION_TYPE	TZK01	SKOART	KEY	1	CN
7	BAPIFVDEXP_VDBEPP	CREDINTACT	SKA1	SAKNR	KEY	1	1
8	BAPIFVDEXP_VDBEPP	CREDIT_A_C	SKA1	SAKNR	KEY	1	1
9	BAPIFVDEXP_VDBEPP	CUSTOMER	KNA1	KUNNR	REF	C	CN
10	BAPIFVDEXP_VDBEPP	DEBITINTAC	SKA1	SAKNR	KEY	1	1
11	BAPIFVDEXP_VDBEPP	DEBIT_ACCT	SKA1	SAKNR	KEY	1	1
12	BAPIFVDEXP_VDBEPP	DUNN_AREA	T047M	MABER	KEY	1	CN
13	BAPIFVDEXP_VDBEPP	DUNN_BLOCK	T040S	MANSP
14	BAPIFVDEXP_VDBEPP	HOUSEBANKACCTID	T012K	HKTID
15	BAPIFVDEXP_VDBEPP	HOUSEBANKID	T012	HBKID	KEY	1	CN
16	BAPIFVDEXP_VDBEPP	INT_BNK_AC	SKB1	SAKNR	KEY	1	CN
17	BAPIFVDEXP_VDBEPP	LOC_CURR	TCURC	WAERS	KEY	1	CN
18	BAPIFVDEXP_VDBEPP	MBORRCUSNO	KNA1	KUNNR	REF	C	CN
19	BAPIFVDEXP_VDBEPP	NOM_CURR	TCURC	WAERS	KEY	1	CN
20	BAPIFVDEXP_VDBEPP	PARTNER_1	BUT000	PARTNER	KEY	1	CN
21	BAPIFVDEXP_VDBEPP	PLANNING_LEVEL	T036	EBENE	KEY	1	CN
22	BAPIFVDEXP_VDBEPP	PMTMTHSUPL	T042F	UZAWE
23	BAPIFVDEXP_VDBEPP	POST_CONT	TZB09	SBUST	KEY	1	CN
24	BAPIFVDEXP_VDBEPP	POST_KEY_1	TBSL	BSCHL	KEY	1	CN
25	BAPIFVDEXP_VDBEPP	POST_KEY_2	TBSL	BSCHL	KEY	1	CN
26	BAPIFVDEXP_VDBEPP	POST_KEY_3	TBSL	BSCHL	KEY	1	CN
27	BAPIFVDEXP_VDBEPP	POST_KEY_4	TBSL	BSCHL	KEY	1	CN
28	BAPIFVDEXP_VDBEPP	POS_CURR	TCURC	WAERS	KEY	1	CN
29	BAPIFVDEXP_VDBEPP	PROD_TYPE	TZPAB	GSART	KEY	1	CN
30	BAPIFVDEXP_VDBEPP	PYMT_BLOCK	T008	ZAHLS	KEY	1	CN
31	BAPIFVDEXP_VDBEPP	PYMT_METH	T042Z	ZLSCH
32	BAPIFVDEXP_VDBEPP	REV_REASON	TZST	SSTOGRD	KEY	1	CN
33	BAPIFVDEXP_VDBEPP	SETT_CURR	TCURC	WAERS	KEY	1	CN
34	BAPIFVDEXP_VDBEPP	TAX_CODE	T007A	MWSKZ

History

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