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