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
⤷ 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
History
Last changed by/on | SAP | 20141121 |
SAP Release Created in | 200 |