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