VDBEPI_SHADOW is a standard SAP Table which is used to store Shadow Table for VDBEPI (Restrictions) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VDBEPI_SHADOW Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
MANDT | MANDT | CLNT | 3 |
* | Client | |
.INCLUDE | VDBEPI_KEY | Flow Data (Key Fields VDBEPI) | ||||
BUKRS | BUKRS | CHAR | 4 |
* | Company Code | |
RBELKPFD | RBELKPFD | CHAR | 10 | Document Number of Document Header (Loan) | ALPHA | |
RPOSNR | NVORGANG | CHAR | 3 | Activity number | ||
.INCLUDE | VDBEPI_FIELDS | Include for VDBEPI | ||||
SBEWART | SBEWART | CHAR | 4 |
* | Flow Type | |
SREFBEW | SREFBEW | CHAR | 4 |
* | Reference flow type | |
SBEWZITI | SBEWZITI | CHAR | 4 |
* | Flow category | |
BNWHR | BNWHR | CURR | 13(2) | Nominal amount | ||
SNWHR | SNWHR | CUKY | 5 |
* | Currency of nominal amount | |
BBWHR | BBWHR | CURR | 13(2) | Amount in position currency | ||
SBWHR | SBWHR | CUKY | 5 |
* | Position Currency (Currency of Position Amount) | |
BCWHR | BCWHR | CURR | 13(2) | Settlement Amount | ||
SCWHR | SCWHR | CUKY | 5 |
* | Settlement Currency | |
BHWHR | BHWHR | CURR | 13(2) | Amount in local currency | ||
PKKURS | PKKURS | DEC | 10(7) | Purchase Price of Borrower's Note | ||
PRUCK | PRUCK | DEC | 10(7) | Repayment rate in percent | ||
KURS1 | VVKURSF | DEC | 9(5) | Exchange rate | EXCRT | |
KURS2 | VVKURSF | DEC | 9(5) | Exchange rate | EXCRT | |
DVALUT | DVALUT | DATS | 8 | Calculation Date | ||
DFAELL | DFAELL | DATS | 8 | Due date | ||
DDISPO | DDISPO | DATS | 8 | Payment Date | ||
DBESTAND | DBESTAND | DATS | 8 | Position value date | ||
DBERVON | DBERVON | DATS | 8 | Start of Calculation Period | ||
UMSKZ | UMSKZ | CHAR | 1 |
* | Special G/L Indicator | |
KOSTL | KOSTL | CHAR | 10 |
* | Cost Center | ALPHA |
SSPESEN | SSPESEN | CHAR | 1 | Expenses key | ||
SSOLHAB | VVSSOLHAB | CHAR | 1 | Debit/credit indicator | ||
RSOLL | RSOLL | CHAR | 10 |
* | Account for debit posting | ALPHA |
RHABEN | RHABEN | CHAR | 10 |
* | Account for credit posting | ALPHA |
RZKSOLL | RZKSOLL | CHAR | 10 |
* | Debit interim account | ALPHA |
RZKHABE | RZKHABE | CHAR | 10 |
* | Credit interim account | ALPHA |
SBSLSOLL | BSCHL | CHAR | 2 |
* | Posting Key | |
SBSLZKSO | BSCHL | CHAR | 2 |
* | Posting Key | |
SBSLZKHA | BSCHL | CHAR | 2 |
* | Posting Key | |
SHSLHABEN | BSCHL | CHAR | 2 |
* | Posting Key | |
BUCHTXT | SGTXT | CHAR | 50 | Item Text | ||
RBANKK | RBANKK | CHAR | 10 |
* | Bank account | ALPHA |
SFDLEV | FDLEV | CHAR | 2 |
* | Planning level | |
JFDUPD | JFDUPD | CHAR | 1 | Record transferred to cash management and forecast | ||
JONLAEN | JONLAEN | CHAR | 1 | Indicator for fixing a flow record | ||
JZINSBAS | JZINSBAS | CHAR | 1 | Flow in interest base | ||
JZINSZPT | JZINSZPT | CHAR | 1 | Interest date | ||
PKOND | PKOND | DEC | 10(7) | Percentage rate for condition items | ||
BBASIS | BBASIS | CURR | 13(2) | Calculation base amount | ||
SSORTZIT | SSORTZIT | CHAR | 1 | Sort indicator for interest/repayment schedule calculations | ||
SWOHER | SWOHER | CHAR | 1 | Source of flow record | ||
KUNNR | KUNNR | CHAR | 10 |
* | Customer Number | ALPHA |
BVTYP | BVTYP | CHAR | 4 | Partner Bank Type | ||
ZLSCH | DZLSCH | CHAR | 1 |
* | Payment Method | |
MABER | MABER | CHAR | 2 |
* | Dunning Area | |
ZAHLS | DZAHLS | CHAR | 1 |
* | Block Key for Payment | |
RPARTNR | BP_PARTNR_NEW | CHAR | 10 |
* | Business Partner Number | ALPHA |
SROLEXT | DUMMY_3 | CHAR | 3 | Dummy function | ||
JEINBEHALT | JEINBEHALT | CHAR | 1 | Indicator for Withholding of Amount During Disbursement | ||
JFIRUECK | JFIRUECK | CHAR | 1 | Confirmation From FI Not Necessary | ||
MWSKZ | MWSKZ | CHAR | 2 |
* | Tax on sales/purchases code | |
MWART | MWART | CHAR | 1 | Tax Type | ||
DBERBIS | DBERBIS | DATS | 8 | End of Calculation Period | ||
ATAGE | VVATAGE | NUMC | 6 | Number of days | ||
ABASTAGE | ABASTAGE | NUMC | 6 | Number of base days in a calculation period | ||
SZBMETH | SZBMETH | CHAR | 1 | Interest Calculation Method | ||
JSTOCK | VVJSTOCK | CHAR | 1 | Premium reserve fund-relevant indicator | ||
SBUST | VVSBUST | NUMC | 2 | Posting control key | ||
DTRANS | VVDTRANS | DATS | 8 | Flow data key: System date | ||
TTRANS | VVTTRANS | TIMS | 6 | Transaction data key: system time | ||
NTRANS | VVNTRANS | NUMC | 4 | Transaction data key: Consecutive number | ||
GSBER | GSBER | CHAR | 4 |
* | Business Area | |
SKOART | SKOART | NUMC | 4 |
* | Condition Type (Smallest Subdivision of Condition Records) | |
SEXCLVON | VVSEXCLVON | NUMC | 1 | Exclusive Indicator for the Start of a Calculation Period | ||
SULTVON | VVSULTVON | CHAR | 1 | Month-End Indicator for Start of a Calculation Period | ||
SINCLBIS | VVSINCLBIS | NUMC | 1 | Inclusive Indicator for the End of a Calculation Period | ||
SULTBIS | VVSULTBIS | CHAR | 1 | Month-End Indicator for the End of a Calculation Period | ||
SINCL | VVSINCL | NUMC | 1 | Inclusive indicator for beginning and end of a period | ||
DVERRECH | VVDVERRECH | DATS | 8 | Settlement date | ||
DPKOND | VVDPKOND | DATS | 8 | Determination date for percentage rate of condition items | ||
SBUCHA | VVSBUCHA | CHAR | 1 | Indicator for postings to accruals/deferrals accounts | ||
ZINKZ | DZINKZ | CHAR | 2 | Exempted from interest calculation | ||
SVULT | VVSVULT | CHAR | 1 | Month-End Indicator for Value Date | ||
JSOFVERR | JSOFVERR | CHAR | 1 | Immediate settlement | ||
SINCLVERR | VVSINCLVER | NUMC | 1 | Inclusive Indicator for Clearing Date | ||
SULTVERR | VVSULTVERR | CHAR | 1 | Month-End Indicator for Clearing Date | ||
SREFZITI | VVSREFZITI | CHAR | 4 |
* | Refer.flow category in accrual/deferral flow records | |
STGBASIS | VVSTGBASIS | NUMC | 1 | Base Days Method | ||
STGMETH | VVSTGMETH | NUMC | 1 | Daily Method | ||
SBASIS | VVSBASIS | CHAR | 4 |
* | Calculation base reference | |
SGTXT | SGTXT | CHAR | 50 | Item Text | ||
SBERFIMA | SBEWFIMA | CHAR | 4 |
* | Calculation category for cash flow calculator | |
SVORGKZ | VVSVORGKZ | NUMC | 2 | Activity indicator for debit/credit control | ||
MANSP | MANSP | CHAR | 1 |
* | Dunning block | |
DGUEL_KP | DGUEL_KP | DATS | 8 | Condition Item Valid From | ||
NSTUFE | NSTUFE | NUMC | 2 | Level number of condition item for recurring payments | ||
DBPERIOD | VVDBPERIOD | DATS | 8 | Period start | ||
SPAEXCL | TFMSPAEXCL | NUMC | 1 | Exclusive Indicator for Start Date of a Period | ||
SPAULT | TFMSPAULT | CHAR | 1 | Month-End Indicator for Start Date of a Period | ||
DEPERIOD | VVDEPERIOD | DATS | 8 | Period End | ||
SPEINCL | TFMSPEINCL | NUMC | 1 | Inclusive Indicator for End Date of a Period | ||
SPEULT | TFMSPEULT | CHAR | 1 | Month-End Indicator for End of a Period | ||
SSTCKKZ | SSTCKKZ | CHAR | 1 | Accrued interest method | ||
NORDER | NORDER | NUMC | 8 | Order Number | ||
RKONT | RKONT | NUMC | 6 | Quota number | ||
DAUSZ | VVDAUSZ | DATS | 8 | Lead date for withholding amounts for disbursement | ||
SSOLIST | SSOLIST | CHAR | 1 | Calculation using actual principle (or debit) | ||
RDARNEHM | RDARNEHM_NEW | CHAR | 10 |
* | Borrower/Applicant Number | ALPHA |
BKOND | BKOND | CURR | 13(2) | Condition item currency amount | ||
SBERECH | SBERECH | CHAR | 1 | Grace Period Interest Method | ||
BKARZINS | TFMBKAZINS | CURR | 13(2) | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | ||
BTITALK | TFMBTIKALK | CURR | 13(2) | Imputed annuity repayment amount (FiMa internal) | ||
RERF | RERF | CHAR | 12 | Entered by | ||
DERF | DERF | DATS | 8 | First Entered on | ||
TERF | TERF | TIMS | 6 | Time of Initial Entry | ||
REHER | REHER | CHAR | 10 | Source of initial entry | ||
RBEAR | RBEAR | CHAR | 12 | Employee ID | ||
DBEAR | DBEAR | DATS | 8 | Last Edited on | ||
TBEAR | TBEAR | TIMS | 6 | Last Edited at | ||
RBHER | RBHER | CHAR | 10 | Editing Source | ||
HDN_KUNNR | HDN_KUNNR | CHAR | 10 |
* | Main Borrower Customer Number | ALPHA |
SZART | TB_SZART | CHAR | 1 | Payment transaction | ||
RUZBEL | BELNR_D | CHAR | 10 | Accounting Document Number | ALPHA | |
REBZJ | REBZJ | NUMC | 4 | Fiscal Year of the Relevant Invoice (for Credit Memo) | GJAHR | |
REBZG | REBZG | CHAR | 10 | Number of the Invoice the Transaction Belongs to | ALPHA | |
REBZZ | REBZZ | NUMC | 3 | Line Item in the Relevant Invoice | ||
S_SSDREF | VVS_SSDREF | CHAR | 4 |
* | Reference flow category in borrower's note loan flow records | |
PWKURS | PWKURS | DEC | 10(7) | Security price for percentage quotation | ||
DZFEST | TB_DZFEST | DATS | 8 | Interest rate fixing date | ||
XPORE | PRQ_XPORE | CHAR | 1 | Indicator: Individual Payment? | ||
SPAYRQ | TB_SPAYRQK | CHAR | 1 | Generate payment request | ||
PRKEY | PRQ_KEYNO | CHAR | 10 |
* | Key Number for Payment Request | ALPHA |
HBKID | HBKID | CHAR | 5 |
* | Short Key for a House Bank | |
HKTID | HKTID | CHAR | 5 |
* | ID for account details | |
VORGTYP | VORGTYP_LO | CHAR | 4 | Activity Category (Posting Area) | ||
ACENV | ACENV_LO | NUMC | 4 | Source in TR-LO posting area | ||
SSIGN | TB_SSIGN | CHAR | 1 | Direction of flow | ||
SPRSNG | TB_SPRSNGK | CHAR | 1 | Individual payment | ||
UZAWE | UZAWE | CHAR | 2 |
* | Payment Method Supplement | |
SPRGRD | TB_SPRGRD | CHAR | 1 | Determine grouping definition | ||
SCSPAY | TB_SCSPAY | CHAR | 1 | Same direction necessary for joint payment? | ||
PAYGR | PAYGR | CHAR | 20 | Grouping Field for Automatic Payments | ||
JEXPOZINS | TB_JZINSRE | CHAR | 1 | Exponential Interest Calculation | ||
SREVALEXCL | VVSREVALEXCL | CHAR | 1 | Price gains w/o proportionate gains from deferral write-back | ||
SROUND | TFM_SROUND | CHAR | 1 | Rounding Category | ||
SKALIDWT | TFMSKALIDWT | CHAR | 2 |
* | Interest Calendar | |
JVERF | JVERF | CHAR | 1 | Indicator whether drawings exist for the disbursement | ||
PPAYMENT | TFM_PPAYMENT | DEC | 11(7) | Payment Rate | ||
AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | Interest Settlement Frequency for Exponential Interest Calc. | ||
LC_CAPITALS | TB_LC_CAPITALS | CHAR | 2 | Effect of the Flow on Capital Amounts Status | ||
LC_DISBURSE | TB_LC_DISBURSE | CHAR | 2 | Effect of the Flow on the Disbursement Status | ||
DFAELL_OLD_EXT | TB_EXTENS_DFAELL_OLD | DATS | 8 | Old Due Date | ||
DDISPO_OLD_EXT | TB_EXTENS_DDISPO_OLD | DATS | 8 | Old Payment Date | ||
RBO_EXT | RBO | CHAR | 15 | Business Operation Number (Loans) | ||
SBEWEGRP2 | TB_FLOW_REC_GRP | NUMC | 6 | Flow Record Group in Cash Flow Calculator (Incoming Payment) | ||
SUSP_REASON_TYPE | TB_SUSPREASON | NUMC | 3 |
* | Key for Overpayment Reason | |
BILL_NUMBER | TB_BILL_NUMBER | CHAR | 15 | Bill Number | ALPHA | |
BILL_DUE_DATE | TB_BILL_DUE_DATE | DATS | 8 | Due Date for Bill | ||
MNDID | SEPA_MNDID | CHAR | 35 | Unique Referene to Mandate per Payment Recipient | ||
.INCLUDE | RSEPA_INFO | Payment Notes Info | ||||
REMIT_INFO | TB_REMIT_INFO | CHAR | 140 | Payment Notes Info |
Key field | |
Non-key field |
VDBEPI_SHADOW - Shadow Table for VDBEPI (Restrictions) VDBEPI_KEY - Flow Data (Key Fields VDBEPI) VDBEPI_FIELDS - Include for VDBEPI VDBEPI_EU - Flow Data / Actual Position Before EURO Conversion VDBEPI_ADD - Extended VDBEPI for Display in Account Statement VDBEPI - Posted line items for document header