SAP ABAP Table VDBEVI (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | VDBEVI | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | RBELKPFD | RBELKPFD | RBELKPFD | CHAR | 10 | 0 | Document Number of Document Header (Loan) | ||
4 | RPOSNR | NVORGANG | CHAR3 | CHAR | 3 | 0 | Activity number | ||
5 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | ||
6 | SEFFMETH | SEFFMETH | SEFFMETH | NUMC | 1 | 0 | Effective Interest Method (Financial Mathematics) | ||
7 | PEFFZINS | PEFFZINS | DEC3_7 | DEC | 10 | 7 | Effective Interest Rate | ||
8 | SSTCKTG | SSTCKTG | SZBMETH | CHAR | 1 | 0 | Accrued interest: Daily method | ||
9 | SSTCKKZ | SSTCKKZ | SSTCKKZ | CHAR | 1 | 0 | Accrued interest method | ||
10 | NORDER | NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
11 | UANFIBU | UANFIBU | TIMES | TIMS | 6 | 0 | Time of transfer to financial accounting | ||
12 | DANFIBU | DANFIBU | DATUM | DATS | 8 | 0 | Date of transferal to FiAc | ||
13 | RANL | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
14 | DGUEL_KK | DGUEL | DATUM | DATS | 8 | 0 | Date Condition Effective from | ||
15 | NLFD_ANG | NLFD_ANG | LFNR3 | NUMC | 3 | 0 | Offer consecutive number | ||
16 | RKLAMMER | RKLAMMER | RANL | CHAR | 13 | 0 | Classification Number for Finance Projects | ||
17 | DVORGANG | DVORGANG | DATUM | DATS | 8 | 0 | Activity date | ||
18 | SVORGANG | SVORFALL | SVORFALL | CHAR | 4 | 0 | Business Operation (Activity) | ||
19 | NVORGANG | NVORGANG | CHAR3 | CHAR | 3 | 0 | Activity number | ||
20 | SSTATI | SSTATI | STATI | NUMC | 2 | 0 | Status of data record | ||
21 | RREFKONT | RREFKONT | USTRU | CHAR | 8 | 0 | Account Assignment Reference in Financial Assets Management | ||
22 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
23 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
24 | SBLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
25 | DBLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
26 | DBUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
27 | DGJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
28 | DMONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
29 | SSTORNO | SSTORNO | SSTORNO | CHAR | 1 | 0 | Reversal indicator | ||
30 | SSTOGRD | SSTOGRD | SSTOGRD | CHAR | 2 | 0 | Reason for Reversal | TZST | |
31 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
32 | RSTBLG | STBLG | BELNR | CHAR | 10 | 0 | Reverse Document Number | ||
33 | RZEBEL | RZEBEL | RBELKPFD | CHAR | 10 | 0 | Doc.no. of debit pos. doc.header (only for inc.pmnt records) | ||
34 | DORDER | DORDER | DATUM | DATS | 8 | 0 | Order day | ||
35 | DANJRNL | DANJRNL | DATUM | DATS | 8 | 0 | Date of transferal to journal | ||
36 | MWART | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
37 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | ||
38 | SBEWZITI | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | ||
39 | BNWHR | BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
40 | SNWHR | SNWHR | WAERS | CUKY | 5 | 0 | Currency of nominal amount | ||
41 | BBWHR | BBWHR | WERTV7 | CURR | 13 | 2 | Amount in position currency | ||
42 | SBWHR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | ||
43 | BCWHR | BCWHR | WERTV7 | CURR | 13 | 2 | Settlement Amount | ||
44 | SCWHR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | ||
45 | BHWHR | BHWHR | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
46 | PKKURS | PKKURS | PWKURS | DEC | 10 | 7 | Purchase Price of Borrower's Note | ||
47 | PRUCK | PRUCK | DEC3_7 | DEC | 10 | 7 | Repayment rate in percent | ||
48 | KURS1 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
49 | KURS2 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
50 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
51 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
52 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
53 | DBESTAND | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
54 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
55 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | ||
56 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
57 | SSPESEN | SSPESEN | SSPESEN | CHAR | 1 | 0 | Expenses key | ||
58 | VVSSOLHAB | VVSSOLHAB | VVSSOLHAB | CHAR | 1 | 0 | Debit/credit indicator | ||
59 | RSOLL | RSOLL | SAKNR | CHAR | 10 | 0 | Account for debit posting | SKA1 | |
60 | RHABEN | RHABEN | SAKNR | CHAR | 10 | 0 | Account for credit posting | SKA1 | |
61 | RZKSOLL | RZKSOLL | SAKNR | CHAR | 10 | 0 | Debit interim account | SKA1 | |
62 | RZKHABE | RZKHABE | SAKNR | CHAR | 10 | 0 | Credit interim account | SKA1 | |
63 | SBSLSOLL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
64 | SBSLZKSO | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
65 | SBSLZKHA | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
66 | SHSLHABEN | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
67 | BUCHTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
68 | RBANKK | RBANKK | SAKNR | CHAR | 10 | 0 | Bank account | SKB1 | |
69 | SFDLEV | FDLEV | FDLEV | CHAR | 2 | 0 | Planning Level | T036 | |
70 | JFDUPD | JFDUPD | JANEI | CHAR | 1 | 0 | Record transferred to cash management and forecast | ||
71 | JONLAEN | JONLAEN | VVSONLAEN | CHAR | 1 | 0 | Indicator for fixing a flow record | ||
72 | JZINSBAS | JZINSBAS | JANEI | CHAR | 1 | 0 | Flow in interest base | ||
73 | JZINSZPT | JZINSZPT | JANEI | CHAR | 1 | 0 | Interest date | ||
74 | PKOND | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
75 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
76 | SSORTZIT | SSORTZIT | CHAR1 | CHAR | 1 | 0 | Sort indicator for interest/repayment schedule calculations | ||
77 | SWOHER | SWOHER | CHAR1 | CHAR | 1 | 0 | Source of flow record | ||
78 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
79 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
80 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | ||
81 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
82 | RPARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
83 | SROLEXT | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
84 | JEINBEHALT | JEINBEHALT | KENZX | CHAR | 1 | 0 | Indicator for Withholding of Amount During Disbursement | ||
85 | JFIRUECK | JFIRUECK | JANEI | CHAR | 1 | 0 | Confirmation From FI Not Necessary | ||
86 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | T008 | |
87 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | ||
88 | SBUST | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | TZB09 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VDBEVI | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | VDBEVI | GSBER | TGSB | GSBER | KEY | 1 | CN |
3 | VDBEVI | HKONT | SKB1 | SAKNR | KEY | 1 | CN |
4 | VDBEVI | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
5 | VDBEVI | MABER | T047M | MABER | KEY | 1 | CN |
6 | VDBEVI | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | VDBEVI | RBANKK | SKB1 | SAKNR | KEY | 1 | CN |
8 | VDBEVI | RHABEN | SKA1 | SAKNR | KEY | 1 | 1 |
9 | VDBEVI | RPARTNR | BUT000 | PARTNER | |||
10 | VDBEVI | RSOLL | SKA1 | SAKNR | KEY | 1 | 1 |
11 | VDBEVI | RZKHABE | SKA1 | SAKNR | KEY | 1 | 1 |
12 | VDBEVI | RZKSOLL | SKA1 | SAKNR | KEY | 1 | 1 |
13 | VDBEVI | SBLART | T003 | BLART | KEY | 1 | CN |
14 | VDBEVI | SBSLSOLL | TBSL | BSCHL | KEY | 1 | CN |
15 | VDBEVI | SBSLZKHA | TBSL | BSCHL | KEY | 1 | CN |
16 | VDBEVI | SBSLZKSO | TBSL | BSCHL | KEY | 1 | CN |
17 | VDBEVI | SBUST | TZB09 | SBUST | KEY | 1 | CN |
18 | VDBEVI | SFDLEV | T036 | EBENE | KEY | 1 | CN |
19 | VDBEVI | SHSLHABEN | TBSL | BSCHL | KEY | 1 | CN |
20 | VDBEVI | SSTOGRD | TZST | SSTOGRD | KEY | 1 | 1 |
21 | VDBEVI | ZAHLS | T008 | ZAHLS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |