SAP ABAP View VDBEVI (Loan transaction record header and item)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
Basic Data
View Type | D | Database View |
Database View | VDBEVI | |
Short Description | Loan transaction record header and item | |
Root table | VDBEKI | Flow Data: Document Header for Actual Record |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VDBEKI | VDBEKI | ||
2 | VDBEPI |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | VDBEKI | MANDT | JL | EQ | 0 | 0 | ||||
2 | VDBEPI | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VDBEKI | BUKRS | JL | EQ | 0 | 0 | ||||
4 | VDBEPI | BUKRS | JR | EQ | AND | 0 | 0 | |||
5 | VDBEKI | RBELKPFD | JL | EQ | 0 | 0 | ||||
6 | VDBEPI | RBELKPFD | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VDBEKI | MANDT | MANDT | Client | |||
2 | BUKRS | VDBEKI | BUKRS | BUKRS | Company Code | |||
3 | RBELKPFD | VDBEKI | RBELKPFD | RBELKPFD | Document Number of Document Header (Loan) | |||
4 | RPOSNR | VDBEPI | RPOSNR | NVORGANG | Activity number | |||
5 | SANLF | VDBEKI | SANLF | SANLF | Product Category | |||
6 | SEFFMETH | VDBEKI | SEFFMETH | SEFFMETH | Effective Interest Method (Financial Mathematics) | |||
7 | PEFFZINS | VDBEKI | PEFFZINS | PEFFZINS | Effective Interest Rate | |||
8 | SSTCKTG | VDBEKI | SSTCKTG | SSTCKTG | Accrued interest: Daily method | |||
9 | SSTCKKZ | VDBEKI | SSTCKKZ | SSTCKKZ | Accrued interest method | |||
10 | NORDER | VDBEKI | NORDER | NORDER | Order Number | |||
11 | UANFIBU | VDBEKI | UANFIBU | UANFIBU | Time of transfer to financial accounting | |||
12 | DANFIBU | VDBEKI | DANFIBU | DANFIBU | Date of transferal to FiAc | |||
13 | RANL | VDBEKI | RANL | RANL | Contract Number | |||
14 | DGUEL_KK | VDBEKI | DGUEL_KK | DGUEL | Date Condition Effective from | |||
15 | NLFD_ANG | VDBEKI | NLFD_ANG | NLFD_ANG | Offer consecutive number | |||
16 | RKLAMMER | VDBEKI | RKLAMMER | RKLAMMER | Classification Number for Finance Projects | |||
17 | DVORGANG | VDBEKI | DVORGANG | DVORGANG | Activity date | |||
18 | SVORGANG | VDBEKI | SVORGANG | SVORFALL | Business Operation (Activity) | |||
19 | NVORGANG | VDBEKI | NVORGANG | NVORGANG | Activity number | |||
20 | SSTATI | VDBEKI | SSTATI | SSTATI | Status of data record | |||
21 | RREFKONT | VDBEKI | RREFKONT | RREFKONT | Account Assignment Reference in Financial Assets Management | |||
22 | HKONT | VDBEKI | HKONT | HKONT | General Ledger Account | |||
23 | GSBER | VDBEKI | GSBER | GSBER | Business Area | |||
24 | SBLART | VDBEKI | SBLART | BLART | Document type | |||
25 | DBLDAT | VDBEKI | DBLDAT | BLDAT | Document Date in Document | |||
26 | DBUDAT | VDBEKI | DBUDAT | BUDAT | Posting Date in the Document | |||
27 | DGJAHR | VDBEKI | DGJAHR | GJAHR | Fiscal Year | |||
28 | DMONAT | VDBEKI | DMONAT | MONAT | Fiscal period | |||
29 | SSTORNO | VDBEKI | SSTORNO | SSTORNO | Reversal indicator | |||
30 | SSTOGRD | VDBEKI | SSTOGRD | SSTOGRD | Reason for Reversal | |||
31 | ZUONR | VDBEKI | ZUONR | DZUONR | Assignment number | |||
32 | RSTBLG | VDBEKI | RSTBLG | STBLG | Reverse Document Number | |||
33 | RZEBEL | VDBEKI | RZEBEL | RZEBEL | Doc.no. of debit pos. doc.header (only for inc.pmnt records) | |||
34 | DORDER | VDBEKI | DORDER | DORDER | Order day | |||
35 | DANJRNL | VDBEKI | DANJRNL | DANJRNL | Date of transferal to journal | |||
36 | MWART | VDBEPI | MWART | MWART | Tax Type | |||
37 | SBEWART | VDBEPI | SBEWART | SBEWART | Flow Type | |||
38 | SBEWZITI | VDBEPI | SBEWZITI | SBEWZITI | Flow category | |||
39 | BNWHR | VDBEPI | BNWHR | BNWHR | Nominal amount | |||
40 | SNWHR | VDBEPI | SNWHR | SNWHR | Currency of nominal amount | |||
41 | BBWHR | VDBEPI | BBWHR | BBWHR | Amount in position currency | |||
42 | SBWHR | VDBEPI | SBWHR | SBWHR | Position Currency (Currency of Position Amount) | |||
43 | BCWHR | VDBEPI | BCWHR | BCWHR | Settlement Amount | |||
44 | SCWHR | VDBEPI | SCWHR | SCWHR | Settlement Currency | |||
45 | BHWHR | VDBEPI | BHWHR | BHWHR | Amount in local currency | |||
46 | PKKURS | VDBEPI | PKKURS | PKKURS | Purchase Price of Borrower's Note | |||
47 | PRUCK | VDBEPI | PRUCK | PRUCK | Repayment rate in percent | |||
48 | KURS1 | VDBEPI | KURS1 | VVKURSF | Exchange rate | |||
49 | KURS2 | VDBEPI | KURS2 | VVKURSF | Exchange rate | |||
50 | DVALUT | VDBEPI | DVALUT | DVALUT | Calculation Date | |||
51 | DFAELL | VDBEPI | DFAELL | DFAELL | Due date | |||
52 | DDISPO | VDBEPI | DDISPO | DDISPO | Payment Date | |||
53 | DBESTAND | VDBEPI | DBESTAND | DBESTAND | Position value date | |||
54 | DBERVON | VDBEPI | DBERVON | DBERVON | Start of Calculation Period | |||
55 | UMSKZ | VDBEPI | UMSKZ | UMSKZ | Special G/L Indicator | |||
56 | KOSTL | VDBEPI | KOSTL | KOSTL | Cost Center | |||
57 | SSPESEN | VDBEPI | SSPESEN | SSPESEN | Expenses key | |||
58 | VVSSOLHAB | VDBEPI | SSOLHAB | VVSSOLHAB | Debit/credit indicator | |||
59 | RSOLL | VDBEPI | RSOLL | RSOLL | Account for debit posting | |||
60 | RHABEN | VDBEPI | RHABEN | RHABEN | Account for credit posting | |||
61 | RZKSOLL | VDBEPI | RZKSOLL | RZKSOLL | Debit interim account | |||
62 | RZKHABE | VDBEPI | RZKHABE | RZKHABE | Credit interim account | |||
63 | SBSLSOLL | VDBEPI | SBSLSOLL | BSCHL | Posting Key | |||
64 | SBSLZKSO | VDBEPI | SBSLZKSO | BSCHL | Posting Key | |||
65 | SBSLZKHA | VDBEPI | SBSLZKHA | BSCHL | Posting Key | |||
66 | SHSLHABEN | VDBEPI | SHSLHABEN | BSCHL | Posting Key | |||
67 | BUCHTXT | VDBEPI | BUCHTXT | SGTXT | Item Text | |||
68 | RBANKK | VDBEPI | RBANKK | RBANKK | Bank account | |||
69 | SFDLEV | VDBEPI | SFDLEV | FDLEV | Planning Level | |||
70 | JFDUPD | VDBEPI | JFDUPD | JFDUPD | Record transferred to cash management and forecast | |||
71 | JONLAEN | VDBEPI | JONLAEN | JONLAEN | Indicator for fixing a flow record | |||
72 | JZINSBAS | VDBEPI | JZINSBAS | JZINSBAS | Flow in interest base | |||
73 | JZINSZPT | VDBEPI | JZINSZPT | JZINSZPT | Interest date | |||
74 | PKOND | VDBEPI | PKOND | PKOND | Percentage rate for condition items | |||
75 | BBASIS | VDBEPI | BBASIS | BBASIS | Calculation base amount | |||
76 | SSORTZIT | VDBEPI | SSORTZIT | SSORTZIT | Sort indicator for interest/repayment schedule calculations | |||
77 | SWOHER | VDBEPI | SWOHER | SWOHER | Source of flow record | |||
78 | KUNNR | VDBEPI | KUNNR | KUNNR | Customer Number | |||
79 | BVTYP | VDBEPI | BVTYP | BVTYP | Partner bank type | |||
80 | ZLSCH | VDBEPI | ZLSCH | DZLSCH | Payment method | |||
81 | MABER | VDBEPI | MABER | MABER | Dunning Area | |||
82 | RPARTNR | VDBEPI | RPARTNR | BP_PARTNR_NEW | Business Partner Number | |||
83 | SROLEXT | VDBEPI | SROLEXT | DUMMY_3 | Dummy function | |||
84 | JEINBEHALT | VDBEPI | JEINBEHALT | JEINBEHALT | Indicator for Withholding of Amount During Disbursement | |||
85 | JFIRUECK | VDBEPI | JFIRUECK | JFIRUECK | Confirmation From FI Not Necessary | |||
86 | ZAHLS | VDBEPI | ZAHLS | DZAHLS | Block Key for Payment | |||
87 | MWSKZ | VDBEPI | MWSKZ | MWSKZ | Tax on sales/purchases code | |||
88 | SBUST | VDBEPI | SBUST | VVSBUST | Posting control key | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |