SAP ABAP Table VDBEPI (Posted line items for document header)
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
Table Category | TRANSP | Transparent table |
Transparent table | VDBEPI | Table Relationship Diagram |
Short Description | Posted line items for document header |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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) | VDBEKI | |
4 | RPOSNR | NVORGANG | CHAR3 | CHAR | 3 | 0 | Activity number | ||
5 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
6 | SREFBEW | SREFBEW | SBEWART | CHAR | 4 | 0 | Reference flow type | * | |
7 | SBEWZITI | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | * | |
8 | BNWHR | BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
9 | SNWHR | SNWHR | WAERS | CUKY | 5 | 0 | Currency of nominal amount | * | |
10 | BBWHR | BBWHR | WERTV7 | CURR | 13 | 2 | Amount in position currency | ||
11 | SBWHR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
12 | BCWHR | BCWHR | WERTV7 | CURR | 13 | 2 | Settlement Amount | ||
13 | SCWHR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | * | |
14 | BHWHR | BHWHR | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
15 | PKKURS | PKKURS | PWKURS | DEC | 10 | 7 | Purchase Price of Borrower's Note | ||
16 | PRUCK | PRUCK | DEC3_7 | DEC | 10 | 7 | Repayment rate in percent | ||
17 | KURS1 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
18 | KURS2 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
19 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
20 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
21 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
22 | DBESTAND | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
23 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
24 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
25 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
26 | SSPESEN | SSPESEN | SSPESEN | CHAR | 1 | 0 | Expenses key | ||
27 | SSOLHAB | VVSSOLHAB | VVSSOLHAB | CHAR | 1 | 0 | Debit/credit indicator | ||
28 | RSOLL | RSOLL | SAKNR | CHAR | 10 | 0 | Account for debit posting | SKA1 | |
29 | RHABEN | RHABEN | SAKNR | CHAR | 10 | 0 | Account for credit posting | SKA1 | |
30 | RZKSOLL | RZKSOLL | SAKNR | CHAR | 10 | 0 | Debit interim account | SKA1 | |
31 | RZKHABE | RZKHABE | SAKNR | CHAR | 10 | 0 | Credit interim account | SKA1 | |
32 | SBSLSOLL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
33 | SBSLZKSO | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
34 | SBSLZKHA | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
35 | SHSLHABEN | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
36 | BUCHTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
37 | RBANKK | RBANKK | SAKNR | CHAR | 10 | 0 | Bank account | SKB1 | |
38 | SFDLEV | FDLEV | FDLEV | CHAR | 2 | 0 | Planning Level | T036 | |
39 | JFDUPD | JFDUPD | JANEI | CHAR | 1 | 0 | Record transferred to cash management and forecast | ||
40 | JONLAEN | JONLAEN | VVSONLAEN | CHAR | 1 | 0 | Indicator for fixing a flow record | ||
41 | JZINSBAS | JZINSBAS | JANEI | CHAR | 1 | 0 | Flow in interest base | ||
42 | JZINSZPT | JZINSZPT | JANEI | CHAR | 1 | 0 | Interest date | ||
43 | PKOND | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
44 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
45 | SSORTZIT | SSORTZIT | CHAR1 | CHAR | 1 | 0 | Sort indicator for interest/repayment schedule calculations | ||
46 | SWOHER | SWOHER | CHAR1 | CHAR | 1 | 0 | Source of flow record | ||
47 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
48 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
49 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
50 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
51 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | T008 | |
52 | RPARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
53 | SROLEXT | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
54 | JEINBEHALT | JEINBEHALT | KENZX | CHAR | 1 | 0 | Indicator for Withholding of Amount During Disbursement | ||
55 | JFIRUECK | JFIRUECK | JANEI | CHAR | 1 | 0 | Confirmation From FI Not Necessary | ||
56 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
57 | MWART | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
58 | DBERBIS | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
59 | ATAGE | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
60 | ABASTAGE | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
61 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
62 | JSTOCK | VVJSTOCK | JANEI | CHAR | 1 | 0 | Premium reserve fund-relevant indicator | ||
63 | SBUST | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | TZB09 | |
64 | DTRANS | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
65 | TTRANS | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
66 | NTRANS | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
67 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
68 | SKOART | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | TZK01 | |
69 | SEXCLVON | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
70 | SULTVON | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
71 | SINCLBIS | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
72 | SULTBIS | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
73 | SINCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
74 | DVERRECH | VVDVERRECH | DATUM | DATS | 8 | 0 | Settlement date | ||
75 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
76 | SBUCHA | VVSBUCHA | CHAR1 | CHAR | 1 | 0 | Indicator for postings to accruals/deferrals accounts | ||
77 | ZINKZ | DZINKZ | ZINKZ | CHAR | 2 | 0 | Exempted from Interest Calculation | ||
78 | SVULT | VVSVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Value Date | ||
79 | JSOFVERR | JSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Immediate settlement | ||
80 | SINCLVERR | VVSINCLVER | VVSINCLVER | NUMC | 1 | 0 | Inclusive Indicator for Clearing Date | ||
81 | SULTVERR | VVSULTVERR | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Clearing Date | ||
82 | SREFZITI | VVSREFZITI | SBEWZITI | CHAR | 4 | 0 | Refer.flow category in accrual/deferral flow records | * | |
83 | STGBASIS | VVSTGBASIS | VVSTGBASIS | CHAR | 1 | 0 | Base Days Method | ||
84 | STGMETH | VVSTGMETH | VVSTGMETH | NUMC | 1 | 0 | Daily Method | ||
85 | SBASIS | VVSBASIS | VVSBASIS | CHAR | 4 | 0 | Calculation base reference | * | |
86 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
87 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | AT40 | |
88 | SVORGKZ | VVSVORGKZ | VVSVORGKZ | NUMC | 2 | 0 | Activity indicator for debit/credit control | ||
89 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
90 | DGUEL_KP | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
91 | NSTUFE | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
92 | DBPERIOD | VVDBPERIOD | DATUM | DATS | 8 | 0 | Period start | ||
93 | SPAEXCL | TFMSPAEXCL | TFMSPAEXCL | NUMC | 1 | 0 | Exclusive Indicator for Start Date of a Period | ||
94 | SPAULT | TFMSPAULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start Date of a Period | ||
95 | DEPERIOD | VVDEPERIOD | DATUM | DATS | 8 | 0 | Period End | ||
96 | SPEINCL | TFMSPEINCL | TFMSPEINCL | NUMC | 1 | 0 | Inclusive Indicator for End Date of a Period | ||
97 | SPEULT | TFMSPEULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for End of a Period | ||
98 | SSTCKKZ | SSTCKKZ | SSTCKKZ | CHAR | 1 | 0 | Accrued interest method | ||
99 | NORDER | NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
100 | RKONT | RKONT | RKONT | NUMC | 6 | 0 | Quota number | ||
101 | DAUSZ | VVDAUSZ | DATUM | DATS | 8 | 0 | Lead date for withholding amounts for disbursement | ||
102 | SSOLIST | SSOLIST | CHAR1 | CHAR | 1 | 0 | Calculation using actual principle (or debit) | ||
103 | RDARNEHM | RDARNEHM_NEW | BU_PARTNER | CHAR | 10 | 0 | Borrower/Applicant Number | * | |
104 | BKOND | BKOND | WERTV7 | CURR | 13 | 2 | Condition item currency amount | ||
105 | SBERECH | SBERECH | XFELD | CHAR | 1 | 0 | Grace Period Interest Method | ||
106 | BKARZINS | TFMBKAZINS | TFM_WRTV7 | CURR | 13 | 2 | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | ||
107 | BTITALK | TFMBTIKALK | TFM_WRTV7 | CURR | 13 | 2 | Imputed annuity repayment amount (FiMa internal) | ||
108 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
109 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
110 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
111 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
112 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
113 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
114 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
115 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
116 | HDN_KUNNR | HDN_KUNNR | KUNNR | CHAR | 10 | 0 | Main Borrower Customer Number | * | |
117 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
118 | RUZBEL | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
119 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
120 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
121 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
122 | S_SSDREF | VVS_SSDREF | SBEWZITI | CHAR | 4 | 0 | Reference flow category in borrower's note loan flow records | * | |
123 | PWKURS | PWKURS | PWKURS | DEC | 10 | 7 | Security price for percentage quotation | ||
124 | DZFEST | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
125 | XPORE | PRQ_XPORE | XFELD | CHAR | 1 | 0 | Indicator: Individual Payment? | ||
126 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
127 | PRKEY | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
128 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
129 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
130 | VORGTYP | VORGTYP_LO | VORGTYP_LO | CHAR | 4 | 0 | Activity Category (Posting Area) | ||
131 | ACENV | ACENV_LO | ACENV_LO | NUMC | 4 | 0 | Source in TR-LO posting area | ||
132 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
133 | SPRSNG | TB_SPRSNGK | XFELD | CHAR | 1 | 0 | Individual payment | ||
134 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
135 | SPRGRD | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
136 | SCSPAY | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
137 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
138 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
139 | JEXPOZINS | TB_JZINSRE | XFELD | CHAR | 1 | 0 | Exponential Interest Calculation | ||
140 | SREVALEXCL | VVSREVALEXCL | XFELD | CHAR | 1 | 0 | Price gains w/o proportionate gains from deferral write-back | ||
141 | SROUND | TFM_SROUND | TFM_SROUND | CHAR | 1 | 0 | Rounding Category | ||
142 | SKALIDWT | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | * | |
143 | JVERF | JVERF | JVERF | CHAR | 1 | 0 | Indicator whether drawings exist for the disbursement | ||
144 | PPAYMENT | TFM_PPAYMENT | TFM_PPAYMENT | DEC | 11 | 7 | Payment Rate | ||
145 | AMMRHYZV | TFM_AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | 0 | Interest Settlement Frequency for Exponential Interest Calc. | ||
146 | LC_CAPITALS | TB_LC_CAPITALS | T_LC_CASH_FLOW | CHAR | 2 | 0 | Effect of the Flow on Capital Amounts Status | ||
147 | LC_DISBURSE | TB_LC_DISBURSE | T_LC_CASH_FLOW | CHAR | 2 | 0 | Effect of the Flow on the Disbursement Status | ||
148 | DFAELL_OLD_EXT | TB_EXTENS_DFAELL_OLD | DATUM | DATS | 8 | 0 | Old Due Date | ||
149 | DDISPO_OLD_EXT | TB_EXTENS_DDISPO_OLD | DATUM | DATS | 8 | 0 | Old Payment Date | ||
150 | RBO_EXT | RBO | RBO | CHAR | 15 | 0 | Business Operation Number (Loans) | ||
151 | SBEWEGRP2 | TB_FLOW_REC_GRP | SBEWEGRP2 | NUMC | 6 | 0 | Flow Record Group in Cash Flow Calculator (Incoming Payment) | ||
152 | SUSP_REASON_TYPE | TB_SUSPREASON | T_SUSPREASON | NUMC | 3 | 0 | Key for Overpayment Reason | * | |
153 | BILL_NUMBER | TB_BILL_NUMBER | T_BILL_NUMBER | CHAR | 15 | 0 | Bill Number | ||
154 | BILL_DUE_DATE | TB_BILL_DUE_DATE | DATUM | DATS | 8 | 0 | Due Date for Bill | ||
155 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
156 | .INCLUDE | 0 | 0 | SEPA Remittance Information | |||||
157 | REMIT_INFO | TB_REMIT_INFO | T_REMIT_INFO | CHAR | 140 | 0 | SEPA Payment Notes Information | ||
158 | .INCLU--AP | 0 | 0 | Extension for Localization | |||||
159 | BROUNDUNIT | TB_BROUNDUNIT_A | TFMSRUNIT | DEC | 13 | 7 | Rounding Unit for Amounts |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VDBEPI | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | VDBEPI | GSBER | TGSB | GSBER | KEY | 1 | CN |
3 | VDBEPI | HBKID | T012 | HBKID | |||
4 | VDBEPI | HKTID | T012K | HKTID | |||
5 | VDBEPI | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
6 | VDBEPI | MABER | T047M | MABER | KEY | 1 | CN |
7 | VDBEPI | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | VDBEPI | MANSP | T040S | MANSP | |||
9 | VDBEPI | RBANKK | SKB1 | SAKNR | KEY | 1 | CN |
10 | VDBEPI | RBELKPFD | VDBEKI | RBELKPFD | KEY | 1 | CN |
11 | VDBEPI | RHABEN | SKA1 | SAKNR | KEY | 1 | 1 |
12 | VDBEPI | RPARTNR | BUT000 | PARTNER | |||
13 | VDBEPI | RSOLL | SKA1 | SAKNR | KEY | 1 | 1 |
14 | VDBEPI | RZKHABE | SKA1 | SAKNR | KEY | 1 | 1 |
15 | VDBEPI | RZKSOLL | SKA1 | SAKNR | KEY | 1 | 1 |
16 | VDBEPI | SBERFIMA | AT40 | SBERFIMA | |||
17 | VDBEPI | SBSLSOLL | TBSL | BSCHL | KEY | 1 | CN |
18 | VDBEPI | SBSLZKHA | TBSL | BSCHL | KEY | 1 | CN |
19 | VDBEPI | SBSLZKSO | TBSL | BSCHL | KEY | 1 | CN |
20 | VDBEPI | SBUST | TZB09 | SBUST | KEY | 1 | CN |
21 | VDBEPI | SFDLEV | T036 | EBENE | KEY | 1 | CN |
22 | VDBEPI | SHSLHABEN | TBSL | BSCHL | KEY | 1 | CN |
23 | VDBEPI | SKOART | TZK01 | SKOART | KEY | 1 | CN |
24 | VDBEPI | UZAWE | T042F | UZAWE | |||
25 | VDBEPI | ZAHLS | T008 | ZAHLS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141121 |
SAP Release Created in |