SAP ABAP Table BAPIFVDEXP_VDBEPI (Export Loan: Posted Line Items for Document Header)
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_VDBEPI | Table Relationship Diagram |
Short Description | Export Loan: Posted Line Items for Document Header |
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 | DOC_NO | RBELKPFD | RBELKPFD | CHAR | 10 | 0 | Document Number of Document Header (Loan) | VDBEKI | |
3 | ACT_NO | NVORGANG | CHAR3 | CHAR | 3 | 0 | Activity number | ||
4 | FLOW_TYPE | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
5 | REFFLWTYP | SREFBEW | SBEWART | CHAR | 4 | 0 | Reference flow type | * | |
6 | FCAT | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | * | |
7 | NOM_AMNT | BAPIBNWHR | BAPICURR | DEC | 23 | 4 | Nominal Amount | ||
8 | NOM_CURR | SNWHR | WAERS | CUKY | 5 | 0 | Currency of nominal amount | * | |
9 | NOM_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
10 | PC_AMOUNT | BAPIBBWHR | BAPICURR | DEC | 23 | 4 | Amount in Position Currency | ||
11 | POS_CURR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
12 | POS_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
13 | STTMNTAMNT | BAPIBCWHR | BAPICURR | DEC | 23 | 4 | Settlement Amount | ||
14 | SETT_CURR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | * | |
15 | SETT_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
16 | LC_AMOUNT | BAPIBHWHR | BAPICURR | DEC | 23 | 4 | Amount in Local Currency | ||
17 | LOC_CURR | SHWHR | WAERS | CUKY | 5 | 0 | Local currency | * | |
18 | LOC_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
19 | PURCH_PR | PKKURS | PWKURS | DEC | 10 | 7 | Purchase Price of Borrower's Note | ||
20 | REPMNT_RTE | PRUCK | DEC3_7 | DEC | 10 | 7 | Repayment rate in percent | ||
21 | EXCH_RATE_1 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
22 | EXCH_RATE_2 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
23 | CALC_DATE | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
24 | DUE_DATE | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
25 | PMNT_DATE | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
26 | POS_VL_DT | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
27 | CALC_FROM | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
28 | SP_GL_IND | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
29 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
30 | EXPEN_KEY | SSPESEN | SSPESEN | CHAR | 1 | 0 | Expenses key | ||
31 | DEB_CRED | VVSSOLHAB | VVSSOLHAB | CHAR | 1 | 0 | Debit/credit indicator | ||
32 | DEBIT_ACCT | RSOLL | SAKNR | CHAR | 10 | 0 | Account for debit posting | SKA1 | |
33 | CREDIT_A_C | RHABEN | SAKNR | CHAR | 10 | 0 | Account for credit posting | SKA1 | |
34 | DEBITINTAC | RZKSOLL | SAKNR | CHAR | 10 | 0 | Debit interim account | SKA1 | |
35 | CREDINTACT | RZKHABE | SAKNR | CHAR | 10 | 0 | Credit interim account | SKA1 | |
36 | POST_KEY_1 | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
37 | POST_KEY_2 | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
38 | POST_KEY_3 | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
39 | POST_KEY_4 | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
40 | ITEM_TEXT_1 | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
41 | INT_BNK_AC | RBANKK | SAKNR | CHAR | 10 | 0 | Bank account | SKB1 | |
42 | PLANNING_LEVEL | FDLEV | FDLEV | CHAR | 2 | 0 | Planning Level | T036 | |
43 | CMF_FLAG | JFDUPD | JANEI | CHAR | 1 | 0 | Record transferred to cash management and forecast | ||
44 | FIXING | JONLAEN | VVSONLAEN | CHAR | 1 | 0 | Indicator for fixing a flow record | ||
45 | INT_BASE | JZINSBAS | JANEI | CHAR | 1 | 0 | Flow in interest base | ||
46 | INT_DATE | JZINSZPT | JANEI | CHAR | 1 | 0 | Interest date | ||
47 | PERCENTAGE_RATE | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
48 | BASE_AMNT | BAPIBBASIS | BAPICURR | DEC | 23 | 4 | Calculation Base Amount | ||
49 | SIND | SSORTZIT | CHAR1 | CHAR | 1 | 0 | Sort indicator for interest/repayment schedule calculations | ||
50 | FLOWSOURCE | SWOHER | CHAR1 | CHAR | 1 | 0 | Source of flow record | ||
51 | CUSTOMER | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
52 | PARTNER_BK | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
53 | PYMT_METH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
54 | DUNN_AREA | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
55 | PYMT_BLOCK | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | T008 | |
56 | PARTNER_1 | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
57 | DUMMY | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
58 | WITHHOLD | JEINBEHALT | KENZX | CHAR | 1 | 0 | Indicator for Withholding of Amount During Disbursement | ||
59 | FI_CONFIR | JFIRUECK | JANEI | CHAR | 1 | 0 | Confirmation From FI Not Necessary | ||
60 | TAX_CODE | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
61 | TAX_TYPE | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
62 | CALC_TO | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
63 | NO_OF_DAYS | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
64 | NO_BS_DY | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
65 | INTEREST_CALC_METHOD | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
66 | REL_PRF | VVJSTOCK | JANEI | CHAR | 1 | 0 | Premium reserve fund-relevant indicator | ||
67 | POST_CONT | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | TZB09 | |
68 | FLOW_DATE | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
69 | TIME_TRN | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
70 | CONS_TR | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
71 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
72 | CONDITION_TYPE | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | TZK01 | |
73 | EXCL_ST | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
74 | MONTH_END_1 | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
75 | INCL_END | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
76 | MONTH_END_2 | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
77 | INCLUSIVE_INDICATOR | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
78 | SETTL_DATE | VVDVERRECH | DATUM | DATS | 8 | 0 | Settlement date | ||
79 | PERCFDTE | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
80 | A_D_POSTNG | VVSBUCHA | CHAR1 | CHAR | 1 | 0 | Indicator for postings to accruals/deferrals accounts | ||
81 | INT_BLOCK | DZINKZ | ZINKZ | CHAR | 2 | 0 | Exempted from Interest Calculation | ||
82 | MONTH_END_3 | VVSVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Value Date | ||
83 | IMM_STTLM | JSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Immediate settlement | ||
84 | INCL_STTL | VVSINCLVER | VVSINCLVER | NUMC | 1 | 0 | Inclusive Indicator for Clearing Date | ||
85 | MNTESTTL | VVSULTVERR | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Clearing Date | ||
86 | REFFLOWCAT_1 | VVSREFZITI | SBEWZITI | CHAR | 4 | 0 | Refer.flow category in accrual/deferral flow records | * | |
87 | DAYS_IN_YR | VVSTGBASIS | VVSTGBASIS | CHAR | 1 | 0 | Base Days Method | ||
88 | DAYCALCMET | VVSTGMETH | VVSTGMETH | NUMC | 1 | 0 | Daily Method | ||
89 | BASE_REF | VVSBASIS | VVSBASIS | CHAR | 4 | 0 | Calculation base reference | * | |
90 | ITEM_TEXT_2 | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
91 | CALC_CAT | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | AT40 | |
92 | ACTIVITYID | VVSVORGKZ | VVSVORGKZ | NUMC | 2 | 0 | Activity indicator for debit/credit control | ||
93 | DUNN_BLOCK | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
94 | VALID_FROM | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
95 | LEVEL_NO | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
96 | PERSTRTDT | VVDBPERIOD | DATUM | DATS | 8 | 0 | Period start | ||
97 | EXCL_STPER | TFMSPAEXCL | TFMSPAEXCL | NUMC | 1 | 0 | Exclusive Indicator for Start Date of a Period | ||
98 | MENDSTPER | TFMSPAULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start Date of a Period | ||
99 | PERENDDAT | VVDEPERIOD | DATUM | DATS | 8 | 0 | Period End | ||
100 | INCL_ENDPE | TFMSPEINCL | TFMSPEINCL | NUMC | 1 | 0 | Inclusive Indicator for End Date of a Period | ||
101 | MENDPEREND | TFMSPEULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for End of a Period | ||
102 | ACCINTMETH | SSTCKKZ | SSTCKKZ | CHAR | 1 | 0 | Accrued interest method | ||
103 | ORDER_NO | NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
104 | QUOTA | RKONT | RKONT | NUMC | 6 | 0 | Quota number | ||
105 | LEAD | VVDAUSZ | DATUM | DATS | 8 | 0 | Lead date for withholding amounts for disbursement | ||
106 | ACTPRINC | SSOLIST | CHAR1 | CHAR | 1 | 0 | Calculation using actual principle (or debit) | ||
107 | PARTNER_2 | RDARNEHM_NEW | BU_PARTNER | CHAR | 10 | 0 | Borrower/Applicant Number | * | |
108 | CONDITION | BAPIBKOND | BAPICURR | DEC | 23 | 4 | Condition Item Currency Amount | ||
109 | GRACE_INT | SBERECH | XFELD | CHAR | 1 | 0 | Grace Period Interest Method | ||
110 | INTEREST | BAPIBKARZINS | BAPICURR | DEC | 23 | 4 | Int.for Days Betw. Redemption Clear.and Pmnt (FiMa-Internal) | ||
111 | IMPANNREP | BAPIBTITALK | BAPICURR | DEC | 23 | 4 | Imputed Annuity Repayment Amount (FiMa Internal) | ||
112 | MBORRCUSNO | HDN_KUNNR | KUNNR | CHAR | 10 | 0 | Main Borrower Customer Number | * | |
113 | PAYMENT | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
114 | AC_DOC_NO | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
115 | INV_YEAR | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
116 | INV_REF | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
117 | INV_ITEM | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
118 | REFFLOWCAT_2 | VVS_SSDREF | SBEWZITI | CHAR | 4 | 0 | Reference flow category in borrower's note loan flow records | * | |
119 | SEC_PRICE | PWKURS | PWKURS | DEC | 10 | 7 | Security price for percentage quotation | ||
120 | INT_FX_DTE | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
121 | INDIV_PMNT_1 | PRQ_XPORE | XFELD | CHAR | 1 | 0 | Indicator: Individual Payment? | ||
122 | PMNT_REQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
123 | REQUESTID | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
124 | HOUSEBANKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
125 | HOUSEBANKACCTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
126 | ACTIV_CAT | VORGTYP_LO | VORGTYP_LO | CHAR | 4 | 0 | Activity Category (Posting Area) | ||
127 | SRCE_IN_PA | ACENV_LO | ACENV_LO | NUMC | 4 | 0 | Source in TR-LO posting area | ||
128 | DIRECTION | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
129 | INDIV_PMNT_2 | TB_SPRSNGK | XFELD | CHAR | 1 | 0 | Individual payment | ||
130 | PMTMTHSUPL | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
131 | GROUP_DET | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
132 | SAME_DIR | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
133 | PAYMENT_METHODS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
134 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
135 | EXPONENT | TB_JZINSRE | XFELD | CHAR | 1 | 0 | Exponential Interest Calculation | ||
136 | PG_EXCL | VVSREVALEXCL | XFELD | CHAR | 1 | 0 | Price gains w/o proportionate gains from deferral write-back | ||
137 | ROUNDING_TYPE | TFM_SROUND | TFM_SROUND | CHAR | 1 | 0 | Rounding Category | ||
138 | CALENDAR | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | * | |
139 | DRAWINGS | JVERF | JVERF | CHAR | 1 | 0 | Indicator whether drawings exist for the disbursement | ||
140 | PAYMENT_RATE | TFM_PPAYMENT | TFM_PPAYMENT | DEC | 11 | 7 | Payment Rate | ||
141 | INTSTFRQ | TFM_AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | 0 | Interest Settlement Frequency for Exponential Interest Calc. | ||
142 | EF_CATSTAT | TB_LC_CAPITALS | T_LC_CASH_FLOW | CHAR | 2 | 0 | Effect of the Flow on Capital Amounts Status | ||
143 | EFF_D_STAT | TB_LC_DISBURSE | T_LC_CASH_FLOW | CHAR | 2 | 0 | Effect of the Flow on the Disbursement Status | ||
144 | 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 |